← Back to branch summary

~vcs-imports/mammoth-replicator/trunk

« back to all changes in this revision

Viewing changes to contrib/pg_trgm/expected/pg_trgm.out

  • Committer: alvherre
  • Date: 2005-12-16 21:24:52 UTC
  • Revision ID: svn-v4:db760fc0-0f08-0410-9d63-cc6633f64896:trunk:1
Initial import of the REL8_0_3 sources from the Pgsql CVS repository.

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/pg_trgm/expected/pg_trgm.out
 
1
\set ECHO none
 
2
psql:pg_trgm.sql:43: NOTICE:  type "gtrgm" is not yet defined
 
3
DETAIL:  Creating a shell type definition.
 
4
psql:pg_trgm.sql:48: NOTICE:  argument type gtrgm is only a shell
 
5
select show_trgm('');
 
6
 show_trgm 
 
7
-----------
 
8
 {}
 
9
(1 row)
 
10
 
 
11
select show_trgm('(*&^$@%@');
 
12
 show_trgm 
 
13
-----------
 
14
 {}
 
15
(1 row)
 
16
 
 
17
select show_trgm('a b c');
 
18
               show_trgm               
 
19
---------------------------------------
 
20
 {"  a","  b","  c"," a "," b "," c "}
 
21
(1 row)
 
22
 
 
23
select show_trgm(' a b c ');
 
24
               show_trgm               
 
25
---------------------------------------
 
26
 {"  a","  b","  c"," a "," b "," c "}
 
27
(1 row)
 
28
 
 
29
select show_trgm('aA bB cC');
 
30
                        show_trgm                        
 
31
---------------------------------------------------------
 
32
 {"  a","  b","  c"," aa"," bb"," cc","aa ","bb ","cc "}
 
33
(1 row)
 
34
 
 
35
select show_trgm(' aA bB cC ');
 
36
                        show_trgm                        
 
37
---------------------------------------------------------
 
38
 {"  a","  b","  c"," aa"," bb"," cc","aa ","bb ","cc "}
 
39
(1 row)
 
40
 
 
41
select show_trgm('a b C0*%^');
 
42
                  show_trgm                  
 
43
---------------------------------------------
 
44
 {"  a","  b","  c"," a "," b "," c0","c0 "}
 
45
(1 row)
 
46
 
 
47
select similarity('wow','WOWa ');
 
48
 similarity 
 
49
------------
 
50
        0.5
 
51
(1 row)
 
52
 
 
53
select similarity('wow',' WOW ');
 
54
 similarity 
 
55
------------
 
56
          1
 
57
(1 row)
 
58
 
 
59
CREATE TABLE test_trgm(t text);
 
60
\copy test_trgm from 'data/trgm.data
 
61
select t,similarity(t,'qwertyu0988') as sml from test_trgm where t % 'qwertyu0988' order by sml desc, t;
 
62
      t      |   sml    
 
63
-------------+----------
 
64
 qwertyu0988 |        1
 
65
 qwertyu0980 | 0.714286
 
66
 qwertyu0981 | 0.714286
 
67
 qwertyu0982 | 0.714286
 
68
 qwertyu0983 | 0.714286
 
69
 qwertyu0984 | 0.714286
 
70
 qwertyu0985 | 0.714286
 
71
 qwertyu0986 | 0.714286
 
72
 qwertyu0987 | 0.714286
 
73
 qwertyu0989 | 0.714286
 
74
 qwertyu0088 |      0.6
 
75
 qwertyu0098 |      0.6
 
76
 qwertyu0188 |      0.6
 
77
 qwertyu0288 |      0.6
 
78
 qwertyu0388 |      0.6
 
79
 qwertyu0488 |      0.6
 
80
 qwertyu0588 |      0.6
 
81
 qwertyu0688 |      0.6
 
82
 qwertyu0788 |      0.6
 
83
 qwertyu0888 |      0.6
 
84
 qwertyu0900 |      0.6
 
85
 qwertyu0901 |      0.6
 
86
 qwertyu0902 |      0.6
 
87
 qwertyu0903 |      0.6
 
88
 qwertyu0904 |      0.6
 
89
 qwertyu0905 |      0.6
 
90
 qwertyu0906 |      0.6
 
91
 qwertyu0907 |      0.6
 
92
 qwertyu0908 |      0.6
 
93
 qwertyu0909 |      0.6
 
94
 qwertyu0910 |      0.6
 
95
 qwertyu0911 |      0.6
 
96
 qwertyu0912 |      0.6
 
97
 qwertyu0913 |      0.6
 
98
 qwertyu0914 |      0.6
 
99
 qwertyu0915 |      0.6
 
100
 qwertyu0916 |      0.6
 
101
 qwertyu0917 |      0.6
 
102
 qwertyu0918 |      0.6
 
103
 qwertyu0919 |      0.6
 
104
 qwertyu0920 |      0.6
 
105
 qwertyu0921 |      0.6
 
106
 qwertyu0922 |      0.6
 
107
 qwertyu0923 |      0.6
 
108
 qwertyu0924 |      0.6
 
109
 qwertyu0925 |      0.6
 
110
 qwertyu0926 |      0.6
 
111
 qwertyu0927 |      0.6
 
112
 qwertyu0928 |      0.6
 
113
 qwertyu0929 |      0.6
 
114
 qwertyu0930 |      0.6
 
115
 qwertyu0931 |      0.6
 
116
 qwertyu0932 |      0.6
 
117
 qwertyu0933 |      0.6
 
118
 qwertyu0934 |      0.6
 
119
 qwertyu0935 |      0.6
 
120
 qwertyu0936 |      0.6
 
121
 qwertyu0937 |      0.6
 
122
 qwertyu0938 |      0.6
 
123
 qwertyu0939 |      0.6
 
124
 qwertyu0940 |      0.6
 
125
 qwertyu0941 |      0.6
 
126
 qwertyu0942 |      0.6
 
127
 qwertyu0943 |      0.6
 
128
 qwertyu0944 |      0.6
 
129
 qwertyu0945 |      0.6
 
130
 qwertyu0946 |      0.6
 
131
 qwertyu0947 |      0.6
 
132
 qwertyu0948 |      0.6
 
133
 qwertyu0949 |      0.6
 
134
 qwertyu0950 |      0.6
 
135
 qwertyu0951 |      0.6
 
136
 qwertyu0952 |      0.6
 
137
 qwertyu0953 |      0.6
 
138
 qwertyu0954 |      0.6
 
139
 qwertyu0955 |      0.6
 
140
 qwertyu0956 |      0.6
 
141
 qwertyu0957 |      0.6
 
142
 qwertyu0958 |      0.6
 
143
 qwertyu0959 |      0.6
 
144
 qwertyu0960 |      0.6
 
145
 qwertyu0961 |      0.6
 
146
 qwertyu0962 |      0.6
 
147
 qwertyu0963 |      0.6
 
148
 qwertyu0964 |      0.6
 
149
 qwertyu0965 |      0.6
 
150
 qwertyu0966 |      0.6
 
151
 qwertyu0967 |      0.6
 
152
 qwertyu0968 |      0.6
 
153
 qwertyu0969 |      0.6
 
154
 qwertyu0970 |      0.6
 
155
 qwertyu0971 |      0.6
 
156
 qwertyu0972 |      0.6
 
157
 qwertyu0973 |      0.6
 
158
 qwertyu0974 |      0.6
 
159
 qwertyu0975 |      0.6
 
160
 qwertyu0976 |      0.6
 
161
 qwertyu0977 |      0.6
 
162
 qwertyu0978 |      0.6
 
163
 qwertyu0979 |      0.6
 
164
 qwertyu0990 |      0.6
 
165
 qwertyu0991 |      0.6
 
166
 qwertyu0992 |      0.6
 
167
 qwertyu0993 |      0.6
 
168
 qwertyu0994 |      0.6
 
169
 qwertyu0995 |      0.6
 
170
 qwertyu0996 |      0.6
 
171
 qwertyu0997 |      0.6
 
172
 qwertyu0998 |      0.6
 
173
 qwertyu0999 |      0.6
 
174
 qwertyu0001 |      0.5
 
175
 qwertyu0002 |      0.5
 
176
 qwertyu0003 |      0.5
 
177
 qwertyu0004 |      0.5
 
178
 qwertyu0005 |      0.5
 
179
 qwertyu0006 |      0.5
 
180
 qwertyu0007 |      0.5
 
181
 qwertyu0008 |      0.5
 
182
 qwertyu0009 |      0.5
 
183
 qwertyu0010 |      0.5
 
184
 qwertyu0011 |      0.5
 
185
 qwertyu0012 |      0.5
 
186
 qwertyu0013 |      0.5
 
187
 qwertyu0014 |      0.5
 
188
 qwertyu0015 |      0.5
 
189
 qwertyu0016 |      0.5
 
190
 qwertyu0017 |      0.5
 
191
 qwertyu0018 |      0.5
 
192
 qwertyu0019 |      0.5
 
193
 qwertyu0020 |      0.5
 
194
 qwertyu0021 |      0.5
 
195
 qwertyu0022 |      0.5
 
196
 qwertyu0023 |      0.5
 
197
 qwertyu0024 |      0.5
 
198
 qwertyu0025 |      0.5
 
199
 qwertyu0026 |      0.5
 
200
 qwertyu0027 |      0.5
 
201
 qwertyu0028 |      0.5
 
202
 qwertyu0029 |      0.5
 
203
 qwertyu0030 |      0.5
 
204
 qwertyu0031 |      0.5
 
205
 qwertyu0032 |      0.5
 
206
 qwertyu0033 |      0.5
 
207
 qwertyu0034 |      0.5
 
208
 qwertyu0035 |      0.5
 
209
 qwertyu0036 |      0.5
 
210
 qwertyu0037 |      0.5
 
211
 qwertyu0038 |      0.5
 
212
 qwertyu0039 |      0.5
 
213
 qwertyu0040 |      0.5
 
214
 qwertyu0041 |      0.5
 
215
 qwertyu0042 |      0.5
 
216
 qwertyu0043 |      0.5
 
217
 qwertyu0044 |      0.5
 
218
 qwertyu0045 |      0.5
 
219
 qwertyu0046 |      0.5
 
220
 qwertyu0047 |      0.5
 
221
 qwertyu0048 |      0.5
 
222
 qwertyu0049 |      0.5
 
223
 qwertyu0050 |      0.5
 
224
 qwertyu0051 |      0.5
 
225
 qwertyu0052 |      0.5
 
226
 qwertyu0053 |      0.5
 
227
 qwertyu0054 |      0.5
 
228
 qwertyu0055 |      0.5
 
229
 qwertyu0056 |      0.5
 
230
 qwertyu0057 |      0.5
 
231
 qwertyu0058 |      0.5
 
232
 qwertyu0059 |      0.5
 
233
 qwertyu0060 |      0.5
 
234
 qwertyu0061 |      0.5
 
235
 qwertyu0062 |      0.5
 
236
 qwertyu0063 |      0.5
 
237
 qwertyu0064 |      0.5
 
238
 qwertyu0065 |      0.5
 
239
 qwertyu0066 |      0.5
 
240
 qwertyu0067 |      0.5
 
241
 qwertyu0068 |      0.5
 
242
 qwertyu0069 |      0.5
 
243
 qwertyu0070 |      0.5
 
244
 qwertyu0071 |      0.5
 
245
 qwertyu0072 |      0.5
 
246
 qwertyu0073 |      0.5
 
247
 qwertyu0074 |      0.5
 
248
 qwertyu0075 |      0.5
 
249
 qwertyu0076 |      0.5
 
250
 qwertyu0077 |      0.5
 
251
 qwertyu0078 |      0.5
 
252
 qwertyu0079 |      0.5
 
253
 qwertyu0080 |      0.5
 
254
 qwertyu0081 |      0.5
 
255
 qwertyu0082 |      0.5
 
256
 qwertyu0083 |      0.5
 
257
 qwertyu0084 |      0.5
 
258
 qwertyu0085 |      0.5
 
259
 qwertyu0086 |      0.5
 
260
 qwertyu0087 |      0.5
 
261
 qwertyu0089 |      0.5
 
262
 qwertyu0090 |      0.5
 
263
 qwertyu0091 |      0.5
 
264
 qwertyu0092 |      0.5
 
265
 qwertyu0093 |      0.5
 
266
 qwertyu0094 |      0.5
 
267
 qwertyu0095 |      0.5
 
268
 qwertyu0096 |      0.5
 
269
 qwertyu0097 |      0.5
 
270
 qwertyu0099 |      0.5
 
271
 qwertyu0100 |      0.5
 
272
 qwertyu0101 |      0.5
 
273
 qwertyu0102 |      0.5
 
274
 qwertyu0103 |      0.5
 
275
 qwertyu0104 |      0.5
 
276
 qwertyu0105 |      0.5
 
277
 qwertyu0106 |      0.5
 
278
 qwertyu0107 |      0.5
 
279
 qwertyu0108 |      0.5
 
280
 qwertyu0109 |      0.5
 
281
 qwertyu0110 |      0.5
 
282
 qwertyu0111 |      0.5
 
283
 qwertyu0112 |      0.5
 
284
 qwertyu0113 |      0.5
 
285
 qwertyu0114 |      0.5
 
286
 qwertyu0115 |      0.5
 
287
 qwertyu0116 |      0.5
 
288
 qwertyu0117 |      0.5
 
289
 qwertyu0118 |      0.5
 
290
 qwertyu0119 |      0.5
 
291
 qwertyu0120 |      0.5
 
292
 qwertyu0121 |      0.5
 
293
 qwertyu0122 |      0.5
 
294
 qwertyu0123 |      0.5
 
295
 qwertyu0124 |      0.5
 
296
 qwertyu0125 |      0.5
 
297
 qwertyu0126 |      0.5
 
298
 qwertyu0127 |      0.5
 
299
 qwertyu0128 |      0.5
 
300
 qwertyu0129 |      0.5
 
301
 qwertyu0130 |      0.5
 
302
 qwertyu0131 |      0.5
 
303
 qwertyu0132 |      0.5
 
304
 qwertyu0133 |      0.5
 
305
 qwertyu0134 |      0.5
 
306
 qwertyu0135 |      0.5
 
307
 qwertyu0136 |      0.5
 
308
 qwertyu0137 |      0.5
 
309
 qwertyu0138 |      0.5
 
310
 qwertyu0139 |      0.5
 
311
 qwertyu0140 |      0.5
 
312
 qwertyu0141 |      0.5
 
313
 qwertyu0142 |      0.5
 
314
 qwertyu0143 |      0.5
 
315
 qwertyu0144 |      0.5
 
316
 qwertyu0145 |      0.5
 
317
 qwertyu0146 |      0.5
 
318
 qwertyu0147 |      0.5
 
319
 qwertyu0148 |      0.5
 
320
 qwertyu0149 |      0.5
 
321
 qwertyu0150 |      0.5
 
322
 qwertyu0151 |      0.5
 
323
 qwertyu0152 |      0.5
 
324
 qwertyu0153 |      0.5
 
325
 qwertyu0154 |      0.5
 
326
 qwertyu0155 |      0.5
 
327
 qwertyu0156 |      0.5
 
328
 qwertyu0157 |      0.5
 
329
 qwertyu0158 |      0.5
 
330
 qwertyu0159 |      0.5
 
331
 qwertyu0160 |      0.5
 
332
 qwertyu0161 |      0.5
 
333
 qwertyu0162 |      0.5
 
334
 qwertyu0163 |      0.5
 
335
 qwertyu0164 |      0.5
 
336
 qwertyu0165 |      0.5
 
337
 qwertyu0166 |      0.5
 
338
 qwertyu0167 |      0.5
 
339
 qwertyu0168 |      0.5
 
340
 qwertyu0169 |      0.5
 
341
 qwertyu0170 |      0.5
 
342
 qwertyu0171 |      0.5
 
343
 qwertyu0172 |      0.5
 
344
 qwertyu0173 |      0.5
 
345
 qwertyu0174 |      0.5
 
346
 qwertyu0175 |      0.5
 
347
 qwertyu0176 |      0.5
 
348
 qwertyu0177 |      0.5
 
349
 qwertyu0178 |      0.5
 
350
 qwertyu0179 |      0.5
 
351
 qwertyu0180 |      0.5
 
352
 qwertyu0181 |      0.5
 
353
 qwertyu0182 |      0.5
 
354
 qwertyu0183 |      0.5
 
355
 qwertyu0184 |      0.5
 
356
 qwertyu0185 |      0.5
 
357
 qwertyu0186 |      0.5
 
358
 qwertyu0187 |      0.5
 
359
 qwertyu0189 |      0.5
 
360
 qwertyu0190 |      0.5
 
361
 qwertyu0191 |      0.5
 
362
 qwertyu0192 |      0.5
 
363
 qwertyu0193 |      0.5
 
364
 qwertyu0194 |      0.5
 
365
 qwertyu0195 |      0.5
 
366
 qwertyu0196 |      0.5
 
367
 qwertyu0197 |      0.5
 
368
 qwertyu0198 |      0.5
 
369
 qwertyu0199 |      0.5
 
370
 qwertyu0200 |      0.5
 
371
 qwertyu0201 |      0.5
 
372
 qwertyu0202 |      0.5
 
373
 qwertyu0203 |      0.5
 
374
 qwertyu0204 |      0.5
 
375
 qwertyu0205 |      0.5
 
376
 qwertyu0206 |      0.5
 
377
 qwertyu0207 |      0.5
 
378
 qwertyu0208 |      0.5
 
379
 qwertyu0209 |      0.5
 
380
 qwertyu0210 |      0.5
 
381
 qwertyu0211 |      0.5
 
382
 qwertyu0212 |      0.5
 
383
 qwertyu0213 |      0.5
 
384
 qwertyu0214 |      0.5
 
385
 qwertyu0215 |      0.5
 
386
 qwertyu0216 |      0.5
 
387
 qwertyu0217 |      0.5
 
388
 qwertyu0218 |      0.5
 
389
 qwertyu0219 |      0.5
 
390
 qwertyu0220 |      0.5
 
391
 qwertyu0221 |      0.5
 
392
 qwertyu0222 |      0.5
 
393
 qwertyu0223 |      0.5
 
394
 qwertyu0224 |      0.5
 
395
 qwertyu0225 |      0.5
 
396
 qwertyu0226 |      0.5
 
397
 qwertyu0227 |      0.5
 
398
 qwertyu0228 |      0.5
 
399
 qwertyu0229 |      0.5
 
400
 qwertyu0230 |      0.5
 
401
 qwertyu0231 |      0.5
 
402
 qwertyu0232 |      0.5
 
403
 qwertyu0233 |      0.5
 
404
 qwertyu0234 |      0.5
 
405
 qwertyu0235 |      0.5
 
406
 qwertyu0236 |      0.5
 
407
 qwertyu0237 |      0.5
 
408
 qwertyu0238 |      0.5
 
409
 qwertyu0239 |      0.5
 
410
 qwertyu0240 |      0.5
 
411
 qwertyu0241 |      0.5
 
412
 qwertyu0242 |      0.5
 
413
 qwertyu0243 |      0.5
 
414
 qwertyu0244 |      0.5
 
415
 qwertyu0245 |      0.5
 
416
 qwertyu0246 |      0.5
 
417
 qwertyu0247 |      0.5
 
418
 qwertyu0248 |      0.5
 
419
 qwertyu0249 |      0.5
 
420
 qwertyu0250 |      0.5
 
421
 qwertyu0251 |      0.5
 
422
 qwertyu0252 |      0.5
 
423
 qwertyu0253 |      0.5
 
424
 qwertyu0254 |      0.5
 
425
 qwertyu0255 |      0.5
 
426
 qwertyu0256 |      0.5
 
427
 qwertyu0257 |      0.5
 
428
 qwertyu0258 |      0.5
 
429
 qwertyu0259 |      0.5
 
430
 qwertyu0260 |      0.5
 
431
 qwertyu0261 |      0.5
 
432
 qwertyu0262 |      0.5
 
433
 qwertyu0263 |      0.5
 
434
 qwertyu0264 |      0.5
 
435
 qwertyu0265 |      0.5
 
436
 qwertyu0266 |      0.5
 
437
 qwertyu0267 |      0.5
 
438
 qwertyu0268 |      0.5
 
439
 qwertyu0269 |      0.5
 
440
 qwertyu0270 |      0.5
 
441
 qwertyu0271 |      0.5
 
442
 qwertyu0272 |      0.5
 
443
 qwertyu0273 |      0.5
 
444
 qwertyu0274 |      0.5
 
445
 qwertyu0275 |      0.5
 
446
 qwertyu0276 |      0.5
 
447
 qwertyu0277 |      0.5
 
448
 qwertyu0278 |      0.5
 
449
 qwertyu0279 |      0.5
 
450
 qwertyu0280 |      0.5
 
451
 qwertyu0281 |      0.5
 
452
 qwertyu0282 |      0.5
 
453
 qwertyu0283 |      0.5
 
454
 qwertyu0284 |      0.5
 
455
 qwertyu0285 |      0.5
 
456
 qwertyu0286 |      0.5
 
457
 qwertyu0287 |      0.5
 
458
 qwertyu0289 |      0.5
 
459
 qwertyu0290 |      0.5
 
460
 qwertyu0291 |      0.5
 
461
 qwertyu0292 |      0.5
 
462
 qwertyu0293 |      0.5
 
463
 qwertyu0294 |      0.5
 
464
 qwertyu0295 |      0.5
 
465
 qwertyu0296 |      0.5
 
466
 qwertyu0297 |      0.5
 
467
 qwertyu0298 |      0.5
 
468
 qwertyu0299 |      0.5
 
469
 qwertyu0300 |      0.5
 
470
 qwertyu0301 |      0.5
 
471
 qwertyu0302 |      0.5
 
472
 qwertyu0303 |      0.5
 
473
 qwertyu0304 |      0.5
 
474
 qwertyu0305 |      0.5
 
475
 qwertyu0306 |      0.5
 
476
 qwertyu0307 |      0.5
 
477
 qwertyu0308 |      0.5
 
478
 qwertyu0309 |      0.5
 
479
 qwertyu0310 |      0.5
 
480
 qwertyu0311 |      0.5
 
481
 qwertyu0312 |      0.5
 
482
 qwertyu0313 |      0.5
 
483
 qwertyu0314 |      0.5
 
484
 qwertyu0315 |      0.5
 
485
 qwertyu0316 |      0.5
 
486
 qwertyu0317 |      0.5
 
487
 qwertyu0318 |      0.5
 
488
 qwertyu0319 |      0.5
 
489
 qwertyu0320 |      0.5
 
490
 qwertyu0321 |      0.5
 
491
 qwertyu0322 |      0.5
 
492
 qwertyu0323 |      0.5
 
493
 qwertyu0324 |      0.5
 
494
 qwertyu0325 |      0.5
 
495
 qwertyu0326 |      0.5
 
496
 qwertyu0327 |      0.5
 
497
 qwertyu0328 |      0.5
 
498
 qwertyu0329 |      0.5
 
499
 qwertyu0330 |      0.5
 
500
 qwertyu0331 |      0.5
 
501
 qwertyu0332 |      0.5
 
502
 qwertyu0333 |      0.5
 
503
 qwertyu0334 |      0.5
 
504
 qwertyu0335 |      0.5
 
505
 qwertyu0336 |      0.5
 
506
 qwertyu0337 |      0.5
 
507
 qwertyu0338 |      0.5
 
508
 qwertyu0339 |      0.5
 
509
 qwertyu0340 |      0.5
 
510
 qwertyu0341 |      0.5
 
511
 qwertyu0342 |      0.5
 
512
 qwertyu0343 |      0.5
 
513
 qwertyu0344 |      0.5
 
514
 qwertyu0345 |      0.5
 
515
 qwertyu0346 |      0.5
 
516
 qwertyu0347 |      0.5
 
517
 qwertyu0348 |      0.5
 
518
 qwertyu0349 |      0.5
 
519
 qwertyu0350 |      0.5
 
520
 qwertyu0351 |      0.5
 
521
 qwertyu0352 |      0.5
 
522
 qwertyu0353 |      0.5
 
523
 qwertyu0354 |      0.5
 
524
 qwertyu0355 |      0.5
 
525
 qwertyu0356 |      0.5
 
526
 qwertyu0357 |      0.5
 
527
 qwertyu0358 |      0.5
 
528
 qwertyu0359 |      0.5
 
529
 qwertyu0360 |      0.5
 
530
 qwertyu0361 |      0.5
 
531
 qwertyu0362 |      0.5
 
532
 qwertyu0363 |      0.5
 
533
 qwertyu0364 |      0.5
 
534
 qwertyu0365 |      0.5
 
535
 qwertyu0366 |      0.5
 
536
 qwertyu0367 |      0.5
 
537
 qwertyu0368 |      0.5
 
538
 qwertyu0369 |      0.5
 
539
 qwertyu0370 |      0.5
 
540
 qwertyu0371 |      0.5
 
541
 qwertyu0372 |      0.5
 
542
 qwertyu0373 |      0.5
 
543
 qwertyu0374 |      0.5
 
544
 qwertyu0375 |      0.5
 
545
 qwertyu0376 |      0.5
 
546
 qwertyu0377 |      0.5
 
547
 qwertyu0378 |      0.5
 
548
 qwertyu0379 |      0.5
 
549
 qwertyu0380 |      0.5
 
550
 qwertyu0381 |      0.5
 
551
 qwertyu0382 |      0.5
 
552
 qwertyu0383 |      0.5
 
553
 qwertyu0384 |      0.5
 
554
 qwertyu0385 |      0.5
 
555
 qwertyu0386 |      0.5
 
556
 qwertyu0387 |      0.5
 
557
 qwertyu0389 |      0.5
 
558
 qwertyu0390 |      0.5
 
559
 qwertyu0391 |      0.5
 
560
 qwertyu0392 |      0.5
 
561
 qwertyu0393 |      0.5
 
562
 qwertyu0394 |      0.5
 
563
 qwertyu0395 |      0.5
 
564
 qwertyu0396 |      0.5
 
565
 qwertyu0397 |      0.5
 
566
 qwertyu0398 |      0.5
 
567
 qwertyu0399 |      0.5
 
568
 qwertyu0400 |      0.5
 
569
 qwertyu0401 |      0.5
 
570
 qwertyu0402 |      0.5
 
571
 qwertyu0403 |      0.5
 
572
 qwertyu0404 |      0.5
 
573
 qwertyu0405 |      0.5
 
574
 qwertyu0406 |      0.5
 
575
 qwertyu0407 |      0.5
 
576
 qwertyu0408 |      0.5
 
577
 qwertyu0409 |      0.5
 
578
 qwertyu0410 |      0.5
 
579
 qwertyu0411 |      0.5
 
580
 qwertyu0412 |      0.5
 
581
 qwertyu0413 |      0.5
 
582
 qwertyu0414 |      0.5
 
583
 qwertyu0415 |      0.5
 
584
 qwertyu0416 |      0.5
 
585
 qwertyu0417 |      0.5
 
586
 qwertyu0418 |      0.5
 
587
 qwertyu0419 |      0.5
 
588
 qwertyu0420 |      0.5
 
589
 qwertyu0421 |      0.5
 
590
 qwertyu0422 |      0.5
 
591
 qwertyu0423 |      0.5
 
592
 qwertyu0424 |      0.5
 
593
 qwertyu0425 |      0.5
 
594
 qwertyu0426 |      0.5
 
595
 qwertyu0427 |      0.5
 
596
 qwertyu0428 |      0.5
 
597
 qwertyu0429 |      0.5
 
598
 qwertyu0430 |      0.5
 
599
 qwertyu0431 |      0.5
 
600
 qwertyu0432 |      0.5
 
601
 qwertyu0433 |      0.5
 
602
 qwertyu0434 |      0.5
 
603
 qwertyu0435 |      0.5
 
604
 qwertyu0436 |      0.5
 
605
 qwertyu0437 |      0.5
 
606
 qwertyu0438 |      0.5
 
607
 qwertyu0439 |      0.5
 
608
 qwertyu0440 |      0.5
 
609
 qwertyu0441 |      0.5
 
610
 qwertyu0442 |      0.5
 
611
 qwertyu0443 |      0.5
 
612
 qwertyu0444 |      0.5
 
613
 qwertyu0445 |      0.5
 
614
 qwertyu0446 |      0.5
 
615
 qwertyu0447 |      0.5
 
616
 qwertyu0448 |      0.5
 
617
 qwertyu0449 |      0.5
 
618
 qwertyu0450 |      0.5
 
619
 qwertyu0451 |      0.5
 
620
 qwertyu0452 |      0.5
 
621
 qwertyu0453 |      0.5
 
622
 qwertyu0454 |      0.5
 
623
 qwertyu0455 |      0.5
 
624
 qwertyu0456 |      0.5
 
625
 qwertyu0457 |      0.5
 
626
 qwertyu0458 |      0.5
 
627
 qwertyu0459 |      0.5
 
628
 qwertyu0460 |      0.5
 
629
 qwertyu0461 |      0.5
 
630
 qwertyu0462 |      0.5
 
631
 qwertyu0463 |      0.5
 
632
 qwertyu0464 |      0.5
 
633
 qwertyu0465 |      0.5
 
634
 qwertyu0466 |      0.5
 
635
 qwertyu0467 |      0.5
 
636
 qwertyu0468 |      0.5
 
637
 qwertyu0469 |      0.5
 
638
 qwertyu0470 |      0.5
 
639
 qwertyu0471 |      0.5
 
640
 qwertyu0472 |      0.5
 
641
 qwertyu0473 |      0.5
 
642
 qwertyu0474 |      0.5
 
643
 qwertyu0475 |      0.5
 
644
 qwertyu0476 |      0.5
 
645
 qwertyu0477 |      0.5
 
646
 qwertyu0478 |      0.5
 
647
 qwertyu0479 |      0.5
 
648
 qwertyu0480 |      0.5
 
649
 qwertyu0481 |      0.5
 
650
 qwertyu0482 |      0.5
 
651
 qwertyu0483 |      0.5
 
652
 qwertyu0484 |      0.5
 
653
 qwertyu0485 |      0.5
 
654
 qwertyu0486 |      0.5
 
655
 qwertyu0487 |      0.5
 
656
 qwertyu0489 |      0.5
 
657
 qwertyu0490 |      0.5
 
658
 qwertyu0491 |      0.5
 
659
 qwertyu0492 |      0.5
 
660
 qwertyu0493 |      0.5
 
661
 qwertyu0494 |      0.5
 
662
 qwertyu0495 |      0.5
 
663
 qwertyu0496 |      0.5
 
664
 qwertyu0497 |      0.5
 
665
 qwertyu0498 |      0.5
 
666
 qwertyu0499 |      0.5
 
667
 qwertyu0500 |      0.5
 
668
 qwertyu0501 |      0.5
 
669
 qwertyu0502 |      0.5
 
670
 qwertyu0503 |      0.5
 
671
 qwertyu0504 |      0.5
 
672
 qwertyu0505 |      0.5
 
673
 qwertyu0506 |      0.5
 
674
 qwertyu0507 |      0.5
 
675
 qwertyu0508 |      0.5
 
676
 qwertyu0509 |      0.5
 
677
 qwertyu0510 |      0.5
 
678
 qwertyu0511 |      0.5
 
679
 qwertyu0512 |      0.5
 
680
 qwertyu0513 |      0.5
 
681
 qwertyu0514 |      0.5
 
682
 qwertyu0515 |      0.5
 
683
 qwertyu0516 |      0.5
 
684
 qwertyu0517 |      0.5
 
685
 qwertyu0518 |      0.5
 
686
 qwertyu0519 |      0.5
 
687
 qwertyu0520 |      0.5
 
688
 qwertyu0521 |      0.5
 
689
 qwertyu0522 |      0.5
 
690
 qwertyu0523 |      0.5
 
691
 qwertyu0524 |      0.5
 
692
 qwertyu0525 |      0.5
 
693
 qwertyu0526 |      0.5
 
694
 qwertyu0527 |      0.5
 
695
 qwertyu0528 |      0.5
 
696
 qwertyu0529 |      0.5
 
697
 qwertyu0530 |      0.5
 
698
 qwertyu0531 |      0.5
 
699
 qwertyu0532 |      0.5
 
700
 qwertyu0533 |      0.5
 
701
 qwertyu0534 |      0.5
 
702
 qwertyu0535 |      0.5
 
703
 qwertyu0536 |      0.5
 
704
 qwertyu0537 |      0.5
 
705
 qwertyu0538 |      0.5
 
706
 qwertyu0539 |      0.5
 
707
 qwertyu0540 |      0.5
 
708
 qwertyu0541 |      0.5
 
709
 qwertyu0542 |      0.5
 
710
 qwertyu0543 |      0.5
 
711
 qwertyu0544 |      0.5
 
712
 qwertyu0545 |      0.5
 
713
 qwertyu0546 |      0.5
 
714
 qwertyu0547 |      0.5
 
715
 qwertyu0548 |      0.5
 
716
 qwertyu0549 |      0.5
 
717
 qwertyu0550 |      0.5
 
718
 qwertyu0551 |      0.5
 
719
 qwertyu0552 |      0.5
 
720
 qwertyu0553 |      0.5
 
721
 qwertyu0554 |      0.5
 
722
 qwertyu0555 |      0.5
 
723
 qwertyu0556 |      0.5
 
724
 qwertyu0557 |      0.5
 
725
 qwertyu0558 |      0.5
 
726
 qwertyu0559 |      0.5
 
727
 qwertyu0560 |      0.5
 
728
 qwertyu0561 |      0.5
 
729
 qwertyu0562 |      0.5
 
730
 qwertyu0563 |      0.5
 
731
 qwertyu0564 |      0.5
 
732
 qwertyu0565 |      0.5
 
733
 qwertyu0566 |      0.5
 
734
 qwertyu0567 |      0.5
 
735
 qwertyu0568 |      0.5
 
736
 qwertyu0569 |      0.5
 
737
 qwertyu0570 |      0.5
 
738
 qwertyu0571 |      0.5
 
739
 qwertyu0572 |      0.5
 
740
 qwertyu0573 |      0.5
 
741
 qwertyu0574 |      0.5
 
742
 qwertyu0575 |      0.5
 
743
 qwertyu0576 |      0.5
 
744
 qwertyu0577 |      0.5
 
745
 qwertyu0578 |      0.5
 
746
 qwertyu0579 |      0.5
 
747
 qwertyu0580 |      0.5
 
748
 qwertyu0581 |      0.5
 
749
 qwertyu0582 |      0.5
 
750
 qwertyu0583 |      0.5
 
751
 qwertyu0584 |      0.5
 
752
 qwertyu0585 |      0.5
 
753
 qwertyu0586 |      0.5
 
754
 qwertyu0587 |      0.5
 
755
 qwertyu0589 |      0.5
 
756
 qwertyu0590 |      0.5
 
757
 qwertyu0591 |      0.5
 
758
 qwertyu0592 |      0.5
 
759
 qwertyu0593 |      0.5
 
760
 qwertyu0594 |      0.5
 
761
 qwertyu0595 |      0.5
 
762
 qwertyu0596 |      0.5
 
763
 qwertyu0597 |      0.5
 
764
 qwertyu0598 |      0.5
 
765
 qwertyu0599 |      0.5
 
766
 qwertyu0600 |      0.5
 
767
 qwertyu0601 |      0.5
 
768
 qwertyu0602 |      0.5
 
769
 qwertyu0603 |      0.5
 
770
 qwertyu0604 |      0.5
 
771
 qwertyu0605 |      0.5
 
772
 qwertyu0606 |      0.5
 
773
 qwertyu0607 |      0.5
 
774
 qwertyu0608 |      0.5
 
775
 qwertyu0609 |      0.5
 
776
 qwertyu0610 |      0.5
 
777
 qwertyu0611 |      0.5
 
778
 qwertyu0612 |      0.5
 
779
 qwertyu0613 |      0.5
 
780
 qwertyu0614 |      0.5
 
781
 qwertyu0615 |      0.5
 
782
 qwertyu0616 |      0.5
 
783
 qwertyu0617 |      0.5
 
784
 qwertyu0618 |      0.5
 
785
 qwertyu0619 |      0.5
 
786
 qwertyu0620 |      0.5
 
787
 qwertyu0621 |      0.5
 
788
 qwertyu0622 |      0.5
 
789
 qwertyu0623 |      0.5
 
790
 qwertyu0624 |      0.5
 
791
 qwertyu0625 |      0.5
 
792
 qwertyu0626 |      0.5
 
793
 qwertyu0627 |      0.5
 
794
 qwertyu0628 |      0.5
 
795
 qwertyu0629 |      0.5
 
796
 qwertyu0630 |      0.5
 
797
 qwertyu0631 |      0.5
 
798
 qwertyu0632 |      0.5
 
799
 qwertyu0633 |      0.5
 
800
 qwertyu0634 |      0.5
 
801
 qwertyu0635 |      0.5
 
802
 qwertyu0636 |      0.5
 
803
 qwertyu0637 |      0.5
 
804
 qwertyu0638 |      0.5
 
805
 qwertyu0639 |      0.5
 
806
 qwertyu0640 |      0.5
 
807
 qwertyu0641 |      0.5
 
808
 qwertyu0642 |      0.5
 
809
 qwertyu0643 |      0.5
 
810
 qwertyu0644 |      0.5
 
811
 qwertyu0645 |      0.5
 
812
 qwertyu0646 |      0.5
 
813
 qwertyu0647 |      0.5
 
814
 qwertyu0648 |      0.5
 
815
 qwertyu0649 |      0.5
 
816
 qwertyu0650 |      0.5
 
817
 qwertyu0651 |      0.5
 
818
 qwertyu0652 |      0.5
 
819
 qwertyu0653 |      0.5
 
820
 qwertyu0654 |      0.5
 
821
 qwertyu0655 |      0.5
 
822
 qwertyu0656 |      0.5
 
823
 qwertyu0657 |      0.5
 
824
 qwertyu0658 |      0.5
 
825
 qwertyu0659 |      0.5
 
826
 qwertyu0660 |      0.5
 
827
 qwertyu0661 |      0.5
 
828
 qwertyu0662 |      0.5
 
829
 qwertyu0663 |      0.5
 
830
 qwertyu0664 |      0.5
 
831
 qwertyu0665 |      0.5
 
832
 qwertyu0666 |      0.5
 
833
 qwertyu0667 |      0.5
 
834
 qwertyu0668 |      0.5
 
835
 qwertyu0669 |      0.5
 
836
 qwertyu0670 |      0.5
 
837
 qwertyu0671 |      0.5
 
838
 qwertyu0672 |      0.5
 
839
 qwertyu0673 |      0.5
 
840
 qwertyu0674 |      0.5
 
841
 qwertyu0675 |      0.5
 
842
 qwertyu0676 |      0.5
 
843
 qwertyu0677 |      0.5
 
844
 qwertyu0678 |      0.5
 
845
 qwertyu0679 |      0.5
 
846
 qwertyu0680 |      0.5
 
847
 qwertyu0681 |      0.5
 
848
 qwertyu0682 |      0.5
 
849
 qwertyu0683 |      0.5
 
850
 qwertyu0684 |      0.5
 
851
 qwertyu0685 |      0.5
 
852
 qwertyu0686 |      0.5
 
853
 qwertyu0687 |      0.5
 
854
 qwertyu0689 |      0.5
 
855
 qwertyu0690 |      0.5
 
856
 qwertyu0691 |      0.5
 
857
 qwertyu0692 |      0.5
 
858
 qwertyu0693 |      0.5
 
859
 qwertyu0694 |      0.5
 
860
 qwertyu0695 |      0.5
 
861
 qwertyu0696 |      0.5
 
862
 qwertyu0697 |      0.5
 
863
 qwertyu0698 |      0.5
 
864
 qwertyu0699 |      0.5
 
865
 qwertyu0700 |      0.5
 
866
 qwertyu0701 |      0.5
 
867
 qwertyu0702 |      0.5
 
868
 qwertyu0703 |      0.5
 
869
 qwertyu0704 |      0.5
 
870
 qwertyu0705 |      0.5
 
871
 qwertyu0706 |      0.5
 
872
 qwertyu0707 |      0.5
 
873
 qwertyu0708 |      0.5
 
874
 qwertyu0709 |      0.5
 
875
 qwertyu0710 |      0.5
 
876
 qwertyu0711 |      0.5
 
877
 qwertyu0712 |      0.5
 
878
 qwertyu0713 |      0.5
 
879
 qwertyu0714 |      0.5
 
880
 qwertyu0715 |      0.5
 
881
 qwertyu0716 |      0.5
 
882
 qwertyu0717 |      0.5
 
883
 qwertyu0718 |      0.5
 
884
 qwertyu0719 |      0.5
 
885
 qwertyu0720 |      0.5
 
886
 qwertyu0721 |      0.5
 
887
 qwertyu0722 |      0.5
 
888
 qwertyu0723 |      0.5
 
889
 qwertyu0724 |      0.5
 
890
 qwertyu0725 |      0.5
 
891
 qwertyu0726 |      0.5
 
892
 qwertyu0727 |      0.5
 
893
 qwertyu0728 |      0.5
 
894
 qwertyu0729 |      0.5
 
895
 qwertyu0730 |      0.5
 
896
 qwertyu0731 |      0.5
 
897
 qwertyu0732 |      0.5
 
898
 qwertyu0733 |      0.5
 
899
 qwertyu0734 |      0.5
 
900
 qwertyu0735 |      0.5
 
901
 qwertyu0736 |      0.5
 
902
 qwertyu0737 |      0.5
 
903
 qwertyu0738 |      0.5
 
904
 qwertyu0739 |      0.5
 
905
 qwertyu0740 |      0.5
 
906
 qwertyu0741 |      0.5
 
907
 qwertyu0742 |      0.5
 
908
 qwertyu0743 |      0.5
 
909
 qwertyu0744 |      0.5
 
910
 qwertyu0745 |      0.5
 
911
 qwertyu0746 |      0.5
 
912
 qwertyu0747 |      0.5
 
913
 qwertyu0748 |      0.5
 
914
 qwertyu0749 |      0.5
 
915
 qwertyu0750 |      0.5
 
916
 qwertyu0751 |      0.5
 
917
 qwertyu0752 |      0.5
 
918
 qwertyu0753 |      0.5
 
919
 qwertyu0754 |      0.5
 
920
 qwertyu0755 |      0.5
 
921
 qwertyu0756 |      0.5
 
922
 qwertyu0757 |      0.5
 
923
 qwertyu0758 |      0.5
 
924
 qwertyu0759 |      0.5
 
925
 qwertyu0760 |      0.5
 
926
 qwertyu0761 |      0.5
 
927
 qwertyu0762 |      0.5
 
928
 qwertyu0763 |      0.5
 
929
 qwertyu0764 |      0.5
 
930
 qwertyu0765 |      0.5
 
931
 qwertyu0766 |      0.5
 
932
 qwertyu0767 |      0.5
 
933
 qwertyu0768 |      0.5
 
934
 qwertyu0769 |      0.5
 
935
 qwertyu0770 |      0.5
 
936
 qwertyu0771 |      0.5
 
937
 qwertyu0772 |      0.5
 
938
 qwertyu0773 |      0.5
 
939
 qwertyu0774 |      0.5
 
940
 qwertyu0775 |      0.5
 
941
 qwertyu0776 |      0.5
 
942
 qwertyu0777 |      0.5
 
943
 qwertyu0778 |      0.5
 
944
 qwertyu0779 |      0.5
 
945
 qwertyu0780 |      0.5
 
946
 qwertyu0781 |      0.5
 
947
 qwertyu0782 |      0.5
 
948
 qwertyu0783 |      0.5
 
949
 qwertyu0784 |      0.5
 
950
 qwertyu0785 |      0.5
 
951
 qwertyu0786 |      0.5
 
952
 qwertyu0787 |      0.5
 
953
 qwertyu0789 |      0.5
 
954
 qwertyu0790 |      0.5
 
955
 qwertyu0791 |      0.5
 
956
 qwertyu0792 |      0.5
 
957
 qwertyu0793 |      0.5
 
958
 qwertyu0794 |      0.5
 
959
 qwertyu0795 |      0.5
 
960
 qwertyu0796 |      0.5
 
961
 qwertyu0797 |      0.5
 
962
 qwertyu0798 |      0.5
 
963
 qwertyu0799 |      0.5
 
964
 qwertyu0800 |      0.5
 
965
 qwertyu0801 |      0.5
 
966
 qwertyu0802 |      0.5
 
967
 qwertyu0803 |      0.5
 
968
 qwertyu0804 |      0.5
 
969
 qwertyu0805 |      0.5
 
970
 qwertyu0806 |      0.5
 
971
 qwertyu0807 |      0.5
 
972
 qwertyu0808 |      0.5
 
973
 qwertyu0809 |      0.5
 
974
 qwertyu0810 |      0.5
 
975
 qwertyu0811 |      0.5
 
976
 qwertyu0812 |      0.5
 
977
 qwertyu0813 |      0.5
 
978
 qwertyu0814 |      0.5
 
979
 qwertyu0815 |      0.5
 
980
 qwertyu0816 |      0.5
 
981
 qwertyu0817 |      0.5
 
982
 qwertyu0818 |      0.5
 
983
 qwertyu0819 |      0.5
 
984
 qwertyu0820 |      0.5
 
985
 qwertyu0821 |      0.5
 
986
 qwertyu0822 |      0.5
 
987
 qwertyu0823 |      0.5
 
988
 qwertyu0824 |      0.5
 
989
 qwertyu0825 |      0.5
 
990
 qwertyu0826 |      0.5
 
991
 qwertyu0827 |      0.5
 
992
 qwertyu0828 |      0.5
 
993
 qwertyu0829 |      0.5
 
994
 qwertyu0830 |      0.5
 
995
 qwertyu0831 |      0.5
 
996
 qwertyu0832 |      0.5
 
997
 qwertyu0833 |      0.5
 
998
 qwertyu0834 |      0.5
 
999
 qwertyu0835 |      0.5
 
1000
 qwertyu0836 |      0.5
 
1001
 qwertyu0837 |      0.5
 
1002
 qwertyu0838 |      0.5
 
1003
 qwertyu0839 |      0.5
 
1004
 qwertyu0840 |      0.5
 
1005
 qwertyu0841 |      0.5
 
1006
 qwertyu0842 |      0.5
 
1007
 qwertyu0843 |      0.5
 
1008
 qwertyu0844 |      0.5
 
1009
 qwertyu0845 |      0.5
 
1010
 qwertyu0846 |      0.5
 
1011
 qwertyu0847 |      0.5
 
1012
 qwertyu0848 |      0.5
 
1013
 qwertyu0849 |      0.5
 
1014
 qwertyu0850 |      0.5
 
1015
 qwertyu0851 |      0.5
 
1016
 qwertyu0852 |      0.5
 
1017
 qwertyu0853 |      0.5
 
1018
 qwertyu0854 |      0.5
 
1019
 qwertyu0855 |      0.5
 
1020
 qwertyu0856 |      0.5
 
1021
 qwertyu0857 |      0.5
 
1022
 qwertyu0858 |      0.5
 
1023
 qwertyu0859 |      0.5
 
1024
 qwertyu0860 |      0.5
 
1025
 qwertyu0861 |      0.5
 
1026
 qwertyu0862 |      0.5
 
1027
 qwertyu0863 |      0.5
 
1028
 qwertyu0864 |      0.5
 
1029
 qwertyu0865 |      0.5
 
1030
 qwertyu0866 |      0.5
 
1031
 qwertyu0867 |      0.5
 
1032
 qwertyu0868 |      0.5
 
1033
 qwertyu0869 |      0.5
 
1034
 qwertyu0870 |      0.5
 
1035
 qwertyu0871 |      0.5
 
1036
 qwertyu0872 |      0.5
 
1037
 qwertyu0873 |      0.5
 
1038
 qwertyu0874 |      0.5
 
1039
 qwertyu0875 |      0.5
 
1040
 qwertyu0876 |      0.5
 
1041
 qwertyu0877 |      0.5
 
1042
 qwertyu0878 |      0.5
 
1043
 qwertyu0879 |      0.5
 
1044
 qwertyu0880 |      0.5
 
1045
 qwertyu0881 |      0.5
 
1046
 qwertyu0882 |      0.5
 
1047
 qwertyu0883 |      0.5
 
1048
 qwertyu0884 |      0.5
 
1049
 qwertyu0885 |      0.5
 
1050
 qwertyu0886 |      0.5
 
1051
 qwertyu0887 |      0.5
 
1052
 qwertyu0889 |      0.5
 
1053
 qwertyu0890 |      0.5
 
1054
 qwertyu0891 |      0.5
 
1055
 qwertyu0892 |      0.5
 
1056
 qwertyu0893 |      0.5
 
1057
 qwertyu0894 |      0.5
 
1058
 qwertyu0895 |      0.5
 
1059
 qwertyu0896 |      0.5
 
1060
 qwertyu0897 |      0.5
 
1061
 qwertyu0898 |      0.5
 
1062
 qwertyu0899 |      0.5
 
1063
 qwertyu1000 | 0.411765
 
1064
(1000 rows)
 
1065
 
 
1066
select t,similarity(t,'gwertyu0988') as sml from test_trgm where t % 'gwertyu0988' order by sml desc, t;
 
1067
      t      |   sml    
 
1068
-------------+----------
 
1069
 qwertyu0988 |      0.6
 
1070
 qwertyu0980 | 0.411765
 
1071
 qwertyu0981 | 0.411765
 
1072
 qwertyu0982 | 0.411765
 
1073
 qwertyu0983 | 0.411765
 
1074
 qwertyu0984 | 0.411765
 
1075
 qwertyu0985 | 0.411765
 
1076
 qwertyu0986 | 0.411765
 
1077
 qwertyu0987 | 0.411765
 
1078
 qwertyu0989 | 0.411765
 
1079
 qwertyu0088 | 0.333333
 
1080
 qwertyu0098 | 0.333333
 
1081
 qwertyu0188 | 0.333333
 
1082
 qwertyu0288 | 0.333333
 
1083
 qwertyu0388 | 0.333333
 
1084
 qwertyu0488 | 0.333333
 
1085
 qwertyu0588 | 0.333333
 
1086
 qwertyu0688 | 0.333333
 
1087
 qwertyu0788 | 0.333333
 
1088
 qwertyu0888 | 0.333333
 
1089
 qwertyu0900 | 0.333333
 
1090
 qwertyu0901 | 0.333333
 
1091
 qwertyu0902 | 0.333333
 
1092
 qwertyu0903 | 0.333333
 
1093
 qwertyu0904 | 0.333333
 
1094
 qwertyu0905 | 0.333333
 
1095
 qwertyu0906 | 0.333333
 
1096
 qwertyu0907 | 0.333333
 
1097
 qwertyu0908 | 0.333333
 
1098
 qwertyu0909 | 0.333333
 
1099
 qwertyu0910 | 0.333333
 
1100
 qwertyu0911 | 0.333333
 
1101
 qwertyu0912 | 0.333333
 
1102
 qwertyu0913 | 0.333333
 
1103
 qwertyu0914 | 0.333333
 
1104
 qwertyu0915 | 0.333333
 
1105
 qwertyu0916 | 0.333333
 
1106
 qwertyu0917 | 0.333333
 
1107
 qwertyu0918 | 0.333333
 
1108
 qwertyu0919 | 0.333333
 
1109
 qwertyu0920 | 0.333333
 
1110
 qwertyu0921 | 0.333333
 
1111
 qwertyu0922 | 0.333333
 
1112
 qwertyu0923 | 0.333333
 
1113
 qwertyu0924 | 0.333333
 
1114
 qwertyu0925 | 0.333333
 
1115
 qwertyu0926 | 0.333333
 
1116
 qwertyu0927 | 0.333333
 
1117
 qwertyu0928 | 0.333333
 
1118
 qwertyu0929 | 0.333333
 
1119
 qwertyu0930 | 0.333333
 
1120
 qwertyu0931 | 0.333333
 
1121
 qwertyu0932 | 0.333333
 
1122
 qwertyu0933 | 0.333333
 
1123
 qwertyu0934 | 0.333333
 
1124
 qwertyu0935 | 0.333333
 
1125
 qwertyu0936 | 0.333333
 
1126
 qwertyu0937 | 0.333333
 
1127
 qwertyu0938 | 0.333333
 
1128
 qwertyu0939 | 0.333333
 
1129
 qwertyu0940 | 0.333333
 
1130
 qwertyu0941 | 0.333333
 
1131
 qwertyu0942 | 0.333333
 
1132
 qwertyu0943 | 0.333333
 
1133
 qwertyu0944 | 0.333333
 
1134
 qwertyu0945 | 0.333333
 
1135
 qwertyu0946 | 0.333333
 
1136
 qwertyu0947 | 0.333333
 
1137
 qwertyu0948 | 0.333333
 
1138
 qwertyu0949 | 0.333333
 
1139
 qwertyu0950 | 0.333333
 
1140
 qwertyu0951 | 0.333333
 
1141
 qwertyu0952 | 0.333333
 
1142
 qwertyu0953 | 0.333333
 
1143
 qwertyu0954 | 0.333333
 
1144
 qwertyu0955 | 0.333333
 
1145
 qwertyu0956 | 0.333333
 
1146
 qwertyu0957 | 0.333333
 
1147
 qwertyu0958 | 0.333333
 
1148
 qwertyu0959 | 0.333333
 
1149
 qwertyu0960 | 0.333333
 
1150
 qwertyu0961 | 0.333333
 
1151
 qwertyu0962 | 0.333333
 
1152
 qwertyu0963 | 0.333333
 
1153
 qwertyu0964 | 0.333333
 
1154
 qwertyu0965 | 0.333333
 
1155
 qwertyu0966 | 0.333333
 
1156
 qwertyu0967 | 0.333333
 
1157
 qwertyu0968 | 0.333333
 
1158
 qwertyu0969 | 0.333333
 
1159
 qwertyu0970 | 0.333333
 
1160
 qwertyu0971 | 0.333333
 
1161
 qwertyu0972 | 0.333333
 
1162
 qwertyu0973 | 0.333333
 
1163
 qwertyu0974 | 0.333333
 
1164
 qwertyu0975 | 0.333333
 
1165
 qwertyu0976 | 0.333333
 
1166
 qwertyu0977 | 0.333333
 
1167
 qwertyu0978 | 0.333333
 
1168
 qwertyu0979 | 0.333333
 
1169
 qwertyu0990 | 0.333333
 
1170
 qwertyu0991 | 0.333333
 
1171
 qwertyu0992 | 0.333333
 
1172
 qwertyu0993 | 0.333333
 
1173
 qwertyu0994 | 0.333333
 
1174
 qwertyu0995 | 0.333333
 
1175
 qwertyu0996 | 0.333333
 
1176
 qwertyu0997 | 0.333333
 
1177
 qwertyu0998 | 0.333333
 
1178
 qwertyu0999 | 0.333333
 
1179
(110 rows)
 
1180
 
 
1181
select t,similarity(t,'gwertyu1988') as sml from test_trgm where t % 'gwertyu1988' order by sml desc, t;
 
1182
      t      |   sml    
 
1183
-------------+----------
 
1184
 qwertyu0988 | 0.333333
 
1185
(1 row)
 
1186
 
 
1187
create index trgm_idx on test_trgm using gist (t gist_trgm_ops);
 
1188
set enable_seqscan=off;
 
1189
select t,similarity(t,'qwertyu0988') as sml from test_trgm where t % 'qwertyu0988' order by sml desc, t;
 
1190
      t      |   sml    
 
1191
-------------+----------
 
1192
 qwertyu0988 |        1
 
1193
 qwertyu0980 | 0.714286
 
1194
 qwertyu0981 | 0.714286
 
1195
 qwertyu0982 | 0.714286
 
1196
 qwertyu0983 | 0.714286
 
1197
 qwertyu0984 | 0.714286
 
1198
 qwertyu0985 | 0.714286
 
1199
 qwertyu0986 | 0.714286
 
1200
 qwertyu0987 | 0.714286
 
1201
 qwertyu0989 | 0.714286
 
1202
 qwertyu0088 |      0.6
 
1203
 qwertyu0098 |      0.6
 
1204
 qwertyu0188 |      0.6
 
1205
 qwertyu0288 |      0.6
 
1206
 qwertyu0388 |      0.6
 
1207
 qwertyu0488 |      0.6
 
1208
 qwertyu0588 |      0.6
 
1209
 qwertyu0688 |      0.6
 
1210
 qwertyu0788 |      0.6
 
1211
 qwertyu0888 |      0.6
 
1212
 qwertyu0900 |      0.6
 
1213
 qwertyu0901 |      0.6
 
1214
 qwertyu0902 |      0.6
 
1215
 qwertyu0903 |      0.6
 
1216
 qwertyu0904 |      0.6
 
1217
 qwertyu0905 |      0.6
 
1218
 qwertyu0906 |      0.6
 
1219
 qwertyu0907 |      0.6
 
1220
 qwertyu0908 |      0.6
 
1221
 qwertyu0909 |      0.6
 
1222
 qwertyu0910 |      0.6
 
1223
 qwertyu0911 |      0.6
 
1224
 qwertyu0912 |      0.6
 
1225
 qwertyu0913 |      0.6
 
1226
 qwertyu0914 |      0.6
 
1227
 qwertyu0915 |      0.6
 
1228
 qwertyu0916 |      0.6
 
1229
 qwertyu0917 |      0.6
 
1230
 qwertyu0918 |      0.6
 
1231
 qwertyu0919 |      0.6
 
1232
 qwertyu0920 |      0.6
 
1233
 qwertyu0921 |      0.6
 
1234
 qwertyu0922 |      0.6
 
1235
 qwertyu0923 |      0.6
 
1236
 qwertyu0924 |      0.6
 
1237
 qwertyu0925 |      0.6
 
1238
 qwertyu0926 |      0.6
 
1239
 qwertyu0927 |      0.6
 
1240
 qwertyu0928 |      0.6
 
1241
 qwertyu0929 |      0.6
 
1242
 qwertyu0930 |      0.6
 
1243
 qwertyu0931 |      0.6
 
1244
 qwertyu0932 |      0.6
 
1245
 qwertyu0933 |      0.6
 
1246
 qwertyu0934 |      0.6
 
1247
 qwertyu0935 |      0.6
 
1248
 qwertyu0936 |      0.6
 
1249
 qwertyu0937 |      0.6
 
1250
 qwertyu0938 |      0.6
 
1251
 qwertyu0939 |      0.6
 
1252
 qwertyu0940 |      0.6
 
1253
 qwertyu0941 |      0.6
 
1254
 qwertyu0942 |      0.6
 
1255
 qwertyu0943 |      0.6
 
1256
 qwertyu0944 |      0.6
 
1257
 qwertyu0945 |      0.6
 
1258
 qwertyu0946 |      0.6
 
1259
 qwertyu0947 |      0.6
 
1260
 qwertyu0948 |      0.6
 
1261
 qwertyu0949 |      0.6
 
1262
 qwertyu0950 |      0.6
 
1263
 qwertyu0951 |      0.6
 
1264
 qwertyu0952 |      0.6
 
1265
 qwertyu0953 |      0.6
 
1266
 qwertyu0954 |      0.6
 
1267
 qwertyu0955 |      0.6
 
1268
 qwertyu0956 |      0.6
 
1269
 qwertyu0957 |      0.6
 
1270
 qwertyu0958 |      0.6
 
1271
 qwertyu0959 |      0.6
 
1272
 qwertyu0960 |      0.6
 
1273
 qwertyu0961 |      0.6
 
1274
 qwertyu0962 |      0.6
 
1275
 qwertyu0963 |      0.6
 
1276
 qwertyu0964 |      0.6
 
1277
 qwertyu0965 |      0.6
 
1278
 qwertyu0966 |      0.6
 
1279
 qwertyu0967 |      0.6
 
1280
 qwertyu0968 |      0.6
 
1281
 qwertyu0969 |      0.6
 
1282
 qwertyu0970 |      0.6
 
1283
 qwertyu0971 |      0.6
 
1284
 qwertyu0972 |      0.6
 
1285
 qwertyu0973 |      0.6
 
1286
 qwertyu0974 |      0.6
 
1287
 qwertyu0975 |      0.6
 
1288
 qwertyu0976 |      0.6
 
1289
 qwertyu0977 |      0.6
 
1290
 qwertyu0978 |      0.6
 
1291
 qwertyu0979 |      0.6
 
1292
 qwertyu0990 |      0.6
 
1293
 qwertyu0991 |      0.6
 
1294
 qwertyu0992 |      0.6
 
1295
 qwertyu0993 |      0.6
 
1296
 qwertyu0994 |      0.6
 
1297
 qwertyu0995 |      0.6
 
1298
 qwertyu0996 |      0.6
 
1299
 qwertyu0997 |      0.6
 
1300
 qwertyu0998 |      0.6
 
1301
 qwertyu0999 |      0.6
 
1302
 qwertyu0001 |      0.5
 
1303
 qwertyu0002 |      0.5
 
1304
 qwertyu0003 |      0.5
 
1305
 qwertyu0004 |      0.5
 
1306
 qwertyu0005 |      0.5
 
1307
 qwertyu0006 |      0.5
 
1308
 qwertyu0007 |      0.5
 
1309
 qwertyu0008 |      0.5
 
1310
 qwertyu0009 |      0.5
 
1311
 qwertyu0010 |      0.5
 
1312
 qwertyu0011 |      0.5
 
1313
 qwertyu0012 |      0.5
 
1314
 qwertyu0013 |      0.5
 
1315
 qwertyu0014 |      0.5
 
1316
 qwertyu0015 |      0.5
 
1317
 qwertyu0016 |      0.5
 
1318
 qwertyu0017 |      0.5
 
1319
 qwertyu0018 |      0.5
 
1320
 qwertyu0019 |      0.5
 
1321
 qwertyu0020 |      0.5
 
1322
 qwertyu0021 |      0.5
 
1323
 qwertyu0022 |      0.5
 
1324
 qwertyu0023 |      0.5
 
1325
 qwertyu0024 |      0.5
 
1326
 qwertyu0025 |      0.5
 
1327
 qwertyu0026 |      0.5
 
1328
 qwertyu0027 |      0.5
 
1329
 qwertyu0028 |      0.5
 
1330
 qwertyu0029 |      0.5
 
1331
 qwertyu0030 |      0.5
 
1332
 qwertyu0031 |      0.5
 
1333
 qwertyu0032 |      0.5
 
1334
 qwertyu0033 |      0.5
 
1335
 qwertyu0034 |      0.5
 
1336
 qwertyu0035 |      0.5
 
1337
 qwertyu0036 |      0.5
 
1338
 qwertyu0037 |      0.5
 
1339
 qwertyu0038 |      0.5
 
1340
 qwertyu0039 |      0.5
 
1341
 qwertyu0040 |      0.5
 
1342
 qwertyu0041 |      0.5
 
1343
 qwertyu0042 |      0.5
 
1344
 qwertyu0043 |      0.5
 
1345
 qwertyu0044 |      0.5
 
1346
 qwertyu0045 |      0.5
 
1347
 qwertyu0046 |      0.5
 
1348
 qwertyu0047 |      0.5
 
1349
 qwertyu0048 |      0.5
 
1350
 qwertyu0049 |      0.5
 
1351
 qwertyu0050 |      0.5
 
1352
 qwertyu0051 |      0.5
 
1353
 qwertyu0052 |      0.5
 
1354
 qwertyu0053 |      0.5
 
1355
 qwertyu0054 |      0.5
 
1356
 qwertyu0055 |      0.5
 
1357
 qwertyu0056 |      0.5
 
1358
 qwertyu0057 |      0.5
 
1359
 qwertyu0058 |      0.5
 
1360
 qwertyu0059 |      0.5
 
1361
 qwertyu0060 |      0.5
 
1362
 qwertyu0061 |      0.5
 
1363
 qwertyu0062 |      0.5
 
1364
 qwertyu0063 |      0.5
 
1365
 qwertyu0064 |      0.5
 
1366
 qwertyu0065 |      0.5
 
1367
 qwertyu0066 |      0.5
 
1368
 qwertyu0067 |      0.5
 
1369
 qwertyu0068 |      0.5
 
1370
 qwertyu0069 |      0.5
 
1371
 qwertyu0070 |      0.5
 
1372
 qwertyu0071 |      0.5
 
1373
 qwertyu0072 |      0.5
 
1374
 qwertyu0073 |      0.5
 
1375
 qwertyu0074 |      0.5
 
1376
 qwertyu0075 |      0.5
 
1377
 qwertyu0076 |      0.5
 
1378
 qwertyu0077 |      0.5
 
1379
 qwertyu0078 |      0.5
 
1380
 qwertyu0079 |      0.5
 
1381
 qwertyu0080 |      0.5
 
1382
 qwertyu0081 |      0.5
 
1383
 qwertyu0082 |      0.5
 
1384
 qwertyu0083 |      0.5
 
1385
 qwertyu0084 |      0.5
 
1386
 qwertyu0085 |      0.5
 
1387
 qwertyu0086 |      0.5
 
1388
 qwertyu0087 |      0.5
 
1389
 qwertyu0089 |      0.5
 
1390
 qwertyu0090 |      0.5
 
1391
 qwertyu0091 |      0.5
 
1392
 qwertyu0092 |      0.5
 
1393
 qwertyu0093 |      0.5
 
1394
 qwertyu0094 |      0.5
 
1395
 qwertyu0095 |      0.5
 
1396
 qwertyu0096 |      0.5
 
1397
 qwertyu0097 |      0.5
 
1398
 qwertyu0099 |      0.5
 
1399
 qwertyu0100 |      0.5
 
1400
 qwertyu0101 |      0.5
 
1401
 qwertyu0102 |      0.5
 
1402
 qwertyu0103 |      0.5
 
1403
 qwertyu0104 |      0.5
 
1404
 qwertyu0105 |      0.5
 
1405
 qwertyu0106 |      0.5
 
1406
 qwertyu0107 |      0.5
 
1407
 qwertyu0108 |      0.5
 
1408
 qwertyu0109 |      0.5
 
1409
 qwertyu0110 |      0.5
 
1410
 qwertyu0111 |      0.5
 
1411
 qwertyu0112 |      0.5
 
1412
 qwertyu0113 |      0.5
 
1413
 qwertyu0114 |      0.5
 
1414
 qwertyu0115 |      0.5
 
1415
 qwertyu0116 |      0.5
 
1416
 qwertyu0117 |      0.5
 
1417
 qwertyu0118 |      0.5
 
1418
 qwertyu0119 |      0.5
 
1419
 qwertyu0120 |      0.5
 
1420
 qwertyu0121 |      0.5
 
1421
 qwertyu0122 |      0.5
 
1422
 qwertyu0123 |      0.5
 
1423
 qwertyu0124 |      0.5
 
1424
 qwertyu0125 |      0.5
 
1425
 qwertyu0126 |      0.5
 
1426
 qwertyu0127 |      0.5
 
1427
 qwertyu0128 |      0.5
 
1428
 qwertyu0129 |      0.5
 
1429
 qwertyu0130 |      0.5
 
1430
 qwertyu0131 |      0.5
 
1431
 qwertyu0132 |      0.5
 
1432
 qwertyu0133 |      0.5
 
1433
 qwertyu0134 |      0.5
 
1434
 qwertyu0135 |      0.5
 
1435
 qwertyu0136 |      0.5
 
1436
 qwertyu0137 |      0.5
 
1437
 qwertyu0138 |      0.5
 
1438
 qwertyu0139 |      0.5
 
1439
 qwertyu0140 |      0.5
 
1440
 qwertyu0141 |      0.5
 
1441
 qwertyu0142 |      0.5
 
1442
 qwertyu0143 |      0.5
 
1443
 qwertyu0144 |      0.5
 
1444
 qwertyu0145 |      0.5
 
1445
 qwertyu0146 |      0.5
 
1446
 qwertyu0147 |      0.5
 
1447
 qwertyu0148 |      0.5
 
1448
 qwertyu0149 |      0.5
 
1449
 qwertyu0150 |      0.5
 
1450
 qwertyu0151 |      0.5
 
1451
 qwertyu0152 |      0.5
 
1452
 qwertyu0153 |      0.5
 
1453
 qwertyu0154 |      0.5
 
1454
 qwertyu0155 |      0.5
 
1455
 qwertyu0156 |      0.5
 
1456
 qwertyu0157 |      0.5
 
1457
 qwertyu0158 |      0.5
 
1458
 qwertyu0159 |      0.5
 
1459
 qwertyu0160 |      0.5
 
1460
 qwertyu0161 |      0.5
 
1461
 qwertyu0162 |      0.5
 
1462
 qwertyu0163 |      0.5
 
1463
 qwertyu0164 |      0.5
 
1464
 qwertyu0165 |      0.5
 
1465
 qwertyu0166 |      0.5
 
1466
 qwertyu0167 |      0.5
 
1467
 qwertyu0168 |      0.5
 
1468
 qwertyu0169 |      0.5
 
1469
 qwertyu0170 |      0.5
 
1470
 qwertyu0171 |      0.5
 
1471
 qwertyu0172 |      0.5
 
1472
 qwertyu0173 |      0.5
 
1473
 qwertyu0174 |      0.5
 
1474
 qwertyu0175 |      0.5
 
1475
 qwertyu0176 |      0.5
 
1476
 qwertyu0177 |      0.5
 
1477
 qwertyu0178 |      0.5
 
1478
 qwertyu0179 |      0.5
 
1479
 qwertyu0180 |      0.5
 
1480
 qwertyu0181 |      0.5
 
1481
 qwertyu0182 |      0.5
 
1482
 qwertyu0183 |      0.5
 
1483
 qwertyu0184 |      0.5
 
1484
 qwertyu0185 |      0.5
 
1485
 qwertyu0186 |      0.5
 
1486
 qwertyu0187 |      0.5
 
1487
 qwertyu0189 |      0.5
 
1488
 qwertyu0190 |      0.5
 
1489
 qwertyu0191 |      0.5
 
1490
 qwertyu0192 |      0.5
 
1491
 qwertyu0193 |      0.5
 
1492
 qwertyu0194 |      0.5
 
1493
 qwertyu0195 |      0.5
 
1494
 qwertyu0196 |      0.5
 
1495
 qwertyu0197 |      0.5
 
1496
 qwertyu0198 |      0.5
 
1497
 qwertyu0199 |      0.5
 
1498
 qwertyu0200 |      0.5
 
1499
 qwertyu0201 |      0.5
 
1500
 qwertyu0202 |      0.5
 
1501
 qwertyu0203 |      0.5
 
1502
 qwertyu0204 |      0.5
 
1503
 qwertyu0205 |      0.5
 
1504
 qwertyu0206 |      0.5
 
1505
 qwertyu0207 |      0.5
 
1506
 qwertyu0208 |      0.5
 
1507
 qwertyu0209 |      0.5
 
1508
 qwertyu0210 |      0.5
 
1509
 qwertyu0211 |      0.5
 
1510
 qwertyu0212 |      0.5
 
1511
 qwertyu0213 |      0.5
 
1512
 qwertyu0214 |      0.5
 
1513
 qwertyu0215 |      0.5
 
1514
 qwertyu0216 |      0.5
 
1515
 qwertyu0217 |      0.5
 
1516
 qwertyu0218 |      0.5
 
1517
 qwertyu0219 |      0.5
 
1518
 qwertyu0220 |      0.5
 
1519
 qwertyu0221 |      0.5
 
1520
 qwertyu0222 |      0.5
 
1521
 qwertyu0223 |      0.5
 
1522
 qwertyu0224 |      0.5
 
1523
 qwertyu0225 |      0.5
 
1524
 qwertyu0226 |      0.5
 
1525
 qwertyu0227 |      0.5
 
1526
 qwertyu0228 |      0.5
 
1527
 qwertyu0229 |      0.5
 
1528
 qwertyu0230 |      0.5
 
1529
 qwertyu0231 |      0.5
 
1530
 qwertyu0232 |      0.5
 
1531
 qwertyu0233 |      0.5
 
1532
 qwertyu0234 |      0.5
 
1533
 qwertyu0235 |      0.5
 
1534
 qwertyu0236 |      0.5
 
1535
 qwertyu0237 |      0.5
 
1536
 qwertyu0238 |      0.5
 
1537
 qwertyu0239 |      0.5
 
1538
 qwertyu0240 |      0.5
 
1539
 qwertyu0241 |      0.5
 
1540
 qwertyu0242 |      0.5
 
1541
 qwertyu0243 |      0.5
 
1542
 qwertyu0244 |      0.5
 
1543
 qwertyu0245 |      0.5
 
1544
 qwertyu0246 |      0.5
 
1545
 qwertyu0247 |      0.5
 
1546
 qwertyu0248 |      0.5
 
1547
 qwertyu0249 |      0.5
 
1548
 qwertyu0250 |      0.5
 
1549
 qwertyu0251 |      0.5
 
1550
 qwertyu0252 |      0.5
 
1551
 qwertyu0253 |      0.5
 
1552
 qwertyu0254 |      0.5
 
1553
 qwertyu0255 |      0.5
 
1554
 qwertyu0256 |      0.5
 
1555
 qwertyu0257 |      0.5
 
1556
 qwertyu0258 |      0.5
 
1557
 qwertyu0259 |      0.5
 
1558
 qwertyu0260 |      0.5
 
1559
 qwertyu0261 |      0.5
 
1560
 qwertyu0262 |      0.5
 
1561
 qwertyu0263 |      0.5
 
1562
 qwertyu0264 |      0.5
 
1563
 qwertyu0265 |      0.5
 
1564
 qwertyu0266 |      0.5
 
1565
 qwertyu0267 |      0.5
 
1566
 qwertyu0268 |      0.5
 
1567
 qwertyu0269 |      0.5
 
1568
 qwertyu0270 |      0.5
 
1569
 qwertyu0271 |      0.5
 
1570
 qwertyu0272 |      0.5
 
1571
 qwertyu0273 |      0.5
 
1572
 qwertyu0274 |      0.5
 
1573
 qwertyu0275 |      0.5
 
1574
 qwertyu0276 |      0.5
 
1575
 qwertyu0277 |      0.5
 
1576
 qwertyu0278 |      0.5
 
1577
 qwertyu0279 |      0.5
 
1578
 qwertyu0280 |      0.5
 
1579
 qwertyu0281 |      0.5
 
1580
 qwertyu0282 |      0.5
 
1581
 qwertyu0283 |      0.5
 
1582
 qwertyu0284 |      0.5
 
1583
 qwertyu0285 |      0.5
 
1584
 qwertyu0286 |      0.5
 
1585
 qwertyu0287 |      0.5
 
1586
 qwertyu0289 |      0.5
 
1587
 qwertyu0290 |      0.5
 
1588
 qwertyu0291 |      0.5
 
1589
 qwertyu0292 |      0.5
 
1590
 qwertyu0293 |      0.5
 
1591
 qwertyu0294 |      0.5
 
1592
 qwertyu0295 |      0.5
 
1593
 qwertyu0296 |      0.5
 
1594
 qwertyu0297 |      0.5
 
1595
 qwertyu0298 |      0.5
 
1596
 qwertyu0299 |      0.5
 
1597
 qwertyu0300 |      0.5
 
1598
 qwertyu0301 |      0.5
 
1599
 qwertyu0302 |      0.5
 
1600
 qwertyu0303 |      0.5
 
1601
 qwertyu0304 |      0.5
 
1602
 qwertyu0305 |      0.5
 
1603
 qwertyu0306 |      0.5
 
1604
 qwertyu0307 |      0.5
 
1605
 qwertyu0308 |      0.5
 
1606
 qwertyu0309 |      0.5
 
1607
 qwertyu0310 |      0.5
 
1608
 qwertyu0311 |      0.5
 
1609
 qwertyu0312 |      0.5
 
1610
 qwertyu0313 |      0.5
 
1611
 qwertyu0314 |      0.5
 
1612
 qwertyu0315 |      0.5
 
1613
 qwertyu0316 |      0.5
 
1614
 qwertyu0317 |      0.5
 
1615
 qwertyu0318 |      0.5
 
1616
 qwertyu0319 |      0.5
 
1617
 qwertyu0320 |      0.5
 
1618
 qwertyu0321 |      0.5
 
1619
 qwertyu0322 |      0.5
 
1620
 qwertyu0323 |      0.5
 
1621
 qwertyu0324 |      0.5
 
1622
 qwertyu0325 |      0.5
 
1623
 qwertyu0326 |      0.5
 
1624
 qwertyu0327 |      0.5
 
1625
 qwertyu0328 |      0.5
 
1626
 qwertyu0329 |      0.5
 
1627
 qwertyu0330 |      0.5
 
1628
 qwertyu0331 |      0.5
 
1629
 qwertyu0332 |      0.5
 
1630
 qwertyu0333 |      0.5
 
1631
 qwertyu0334 |      0.5
 
1632
 qwertyu0335 |      0.5
 
1633
 qwertyu0336 |      0.5
 
1634
 qwertyu0337 |      0.5
 
1635
 qwertyu0338 |      0.5
 
1636
 qwertyu0339 |      0.5
 
1637
 qwertyu0340 |      0.5
 
1638
 qwertyu0341 |      0.5
 
1639
 qwertyu0342 |      0.5
 
1640
 qwertyu0343 |      0.5
 
1641
 qwertyu0344 |      0.5
 
1642
 qwertyu0345 |      0.5
 
1643
 qwertyu0346 |      0.5
 
1644
 qwertyu0347 |      0.5
 
1645
 qwertyu0348 |      0.5
 
1646
 qwertyu0349 |      0.5
 
1647
 qwertyu0350 |      0.5
 
1648
 qwertyu0351 |      0.5
 
1649
 qwertyu0352 |      0.5
 
1650
 qwertyu0353 |      0.5
 
1651
 qwertyu0354 |      0.5
 
1652
 qwertyu0355 |      0.5
 
1653
 qwertyu0356 |      0.5
 
1654
 qwertyu0357 |      0.5
 
1655
 qwertyu0358 |      0.5
 
1656
 qwertyu0359 |      0.5
 
1657
 qwertyu0360 |      0.5
 
1658
 qwertyu0361 |      0.5
 
1659
 qwertyu0362 |      0.5
 
1660
 qwertyu0363 |      0.5
 
1661
 qwertyu0364 |      0.5
 
1662
 qwertyu0365 |      0.5
 
1663
 qwertyu0366 |      0.5
 
1664
 qwertyu0367 |      0.5
 
1665
 qwertyu0368 |      0.5
 
1666
 qwertyu0369 |      0.5
 
1667
 qwertyu0370 |      0.5
 
1668
 qwertyu0371 |      0.5
 
1669
 qwertyu0372 |      0.5
 
1670
 qwertyu0373 |      0.5
 
1671
 qwertyu0374 |      0.5
 
1672
 qwertyu0375 |      0.5
 
1673
 qwertyu0376 |      0.5
 
1674
 qwertyu0377 |      0.5
 
1675
 qwertyu0378 |      0.5
 
1676
 qwertyu0379 |      0.5
 
1677
 qwertyu0380 |      0.5
 
1678
 qwertyu0381 |      0.5
 
1679
 qwertyu0382 |      0.5
 
1680
 qwertyu0383 |      0.5
 
1681
 qwertyu0384 |      0.5
 
1682
 qwertyu0385 |      0.5
 
1683
 qwertyu0386 |      0.5
 
1684
 qwertyu0387 |      0.5
 
1685
 qwertyu0389 |      0.5
 
1686
 qwertyu0390 |      0.5
 
1687
 qwertyu0391 |      0.5
 
1688
 qwertyu0392 |      0.5
 
1689
 qwertyu0393 |      0.5
 
1690
 qwertyu0394 |      0.5
 
1691
 qwertyu0395 |      0.5
 
1692
 qwertyu0396 |      0.5
 
1693
 qwertyu0397 |      0.5
 
1694
 qwertyu0398 |      0.5
 
1695
 qwertyu0399 |      0.5
 
1696
 qwertyu0400 |      0.5
 
1697
 qwertyu0401 |      0.5
 
1698
 qwertyu0402 |      0.5
 
1699
 qwertyu0403 |      0.5
 
1700
 qwertyu0404 |      0.5
 
1701
 qwertyu0405 |      0.5
 
1702
 qwertyu0406 |      0.5
 
1703
 qwertyu0407 |      0.5
 
1704
 qwertyu0408 |      0.5
 
1705
 qwertyu0409 |      0.5
 
1706
 qwertyu0410 |      0.5
 
1707
 qwertyu0411 |      0.5
 
1708
 qwertyu0412 |      0.5
 
1709
 qwertyu0413 |      0.5
 
1710
 qwertyu0414 |      0.5
 
1711
 qwertyu0415 |      0.5
 
1712
 qwertyu0416 |      0.5
 
1713
 qwertyu0417 |      0.5
 
1714
 qwertyu0418 |      0.5
 
1715
 qwertyu0419 |      0.5
 
1716
 qwertyu0420 |      0.5
 
1717
 qwertyu0421 |      0.5
 
1718
 qwertyu0422 |      0.5
 
1719
 qwertyu0423 |      0.5
 
1720
 qwertyu0424 |      0.5
 
1721
 qwertyu0425 |      0.5
 
1722
 qwertyu0426 |      0.5
 
1723
 qwertyu0427 |      0.5
 
1724
 qwertyu0428 |      0.5
 
1725
 qwertyu0429 |      0.5
 
1726
 qwertyu0430 |      0.5
 
1727
 qwertyu0431 |      0.5
 
1728
 qwertyu0432 |      0.5
 
1729
 qwertyu0433 |      0.5
 
1730
 qwertyu0434 |      0.5
 
1731
 qwertyu0435 |      0.5
 
1732
 qwertyu0436 |      0.5
 
1733
 qwertyu0437 |      0.5
 
1734
 qwertyu0438 |      0.5
 
1735
 qwertyu0439 |      0.5
 
1736
 qwertyu0440 |      0.5
 
1737
 qwertyu0441 |      0.5
 
1738
 qwertyu0442 |      0.5
 
1739
 qwertyu0443 |      0.5
 
1740
 qwertyu0444 |      0.5
 
1741
 qwertyu0445 |      0.5
 
1742
 qwertyu0446 |      0.5
 
1743
 qwertyu0447 |      0.5
 
1744
 qwertyu0448 |      0.5
 
1745
 qwertyu0449 |      0.5
 
1746
 qwertyu0450 |      0.5
 
1747
 qwertyu0451 |      0.5
 
1748
 qwertyu0452 |      0.5
 
1749
 qwertyu0453 |      0.5
 
1750
 qwertyu0454 |      0.5
 
1751
 qwertyu0455 |      0.5
 
1752
 qwertyu0456 |      0.5
 
1753
 qwertyu0457 |      0.5
 
1754
 qwertyu0458 |      0.5
 
1755
 qwertyu0459 |      0.5
 
1756
 qwertyu0460 |      0.5
 
1757
 qwertyu0461 |      0.5
 
1758
 qwertyu0462 |      0.5
 
1759
 qwertyu0463 |      0.5
 
1760
 qwertyu0464 |      0.5
 
1761
 qwertyu0465 |      0.5
 
1762
 qwertyu0466 |      0.5
 
1763
 qwertyu0467 |      0.5
 
1764
 qwertyu0468 |      0.5
 
1765
 qwertyu0469 |      0.5
 
1766
 qwertyu0470 |      0.5
 
1767
 qwertyu0471 |      0.5
 
1768
 qwertyu0472 |      0.5
 
1769
 qwertyu0473 |      0.5
 
1770
 qwertyu0474 |      0.5
 
1771
 qwertyu0475 |      0.5
 
1772
 qwertyu0476 |      0.5
 
1773
 qwertyu0477 |      0.5
 
1774
 qwertyu0478 |      0.5
 
1775
 qwertyu0479 |      0.5
 
1776
 qwertyu0480 |      0.5
 
1777
 qwertyu0481 |      0.5
 
1778
 qwertyu0482 |      0.5
 
1779
 qwertyu0483 |      0.5
 
1780
 qwertyu0484 |      0.5
 
1781
 qwertyu0485 |      0.5
 
1782
 qwertyu0486 |      0.5
 
1783
 qwertyu0487 |      0.5
 
1784
 qwertyu0489 |      0.5
 
1785
 qwertyu0490 |      0.5
 
1786
 qwertyu0491 |      0.5
 
1787
 qwertyu0492 |      0.5
 
1788
 qwertyu0493 |      0.5
 
1789
 qwertyu0494 |      0.5
 
1790
 qwertyu0495 |      0.5
 
1791
 qwertyu0496 |      0.5
 
1792
 qwertyu0497 |      0.5
 
1793
 qwertyu0498 |      0.5
 
1794
 qwertyu0499 |      0.5
 
1795
 qwertyu0500 |      0.5
 
1796
 qwertyu0501 |      0.5
 
1797
 qwertyu0502 |      0.5
 
1798
 qwertyu0503 |      0.5
 
1799
 qwertyu0504 |      0.5
 
1800
 qwertyu0505 |      0.5
 
1801
 qwertyu0506 |      0.5
 
1802
 qwertyu0507 |      0.5
 
1803
 qwertyu0508 |      0.5
 
1804
 qwertyu0509 |      0.5
 
1805
 qwertyu0510 |      0.5
 
1806
 qwertyu0511 |      0.5
 
1807
 qwertyu0512 |      0.5
 
1808
 qwertyu0513 |      0.5
 
1809
 qwertyu0514 |      0.5
 
1810
 qwertyu0515 |      0.5
 
1811
 qwertyu0516 |      0.5
 
1812
 qwertyu0517 |      0.5
 
1813
 qwertyu0518 |      0.5
 
1814
 qwertyu0519 |      0.5
 
1815
 qwertyu0520 |      0.5
 
1816
 qwertyu0521 |      0.5
 
1817
 qwertyu0522 |      0.5
 
1818
 qwertyu0523 |      0.5
 
1819
 qwertyu0524 |      0.5
 
1820
 qwertyu0525 |      0.5
 
1821
 qwertyu0526 |      0.5
 
1822
 qwertyu0527 |      0.5
 
1823
 qwertyu0528 |      0.5
 
1824
 qwertyu0529 |      0.5
 
1825
 qwertyu0530 |      0.5
 
1826
 qwertyu0531 |      0.5
 
1827
 qwertyu0532 |      0.5
 
1828
 qwertyu0533 |      0.5
 
1829
 qwertyu0534 |      0.5
 
1830
 qwertyu0535 |      0.5
 
1831
 qwertyu0536 |      0.5
 
1832
 qwertyu0537 |      0.5
 
1833
 qwertyu0538 |      0.5
 
1834
 qwertyu0539 |      0.5
 
1835
 qwertyu0540 |      0.5
 
1836
 qwertyu0541 |      0.5
 
1837
 qwertyu0542 |      0.5
 
1838
 qwertyu0543 |      0.5
 
1839
 qwertyu0544 |      0.5
 
1840
 qwertyu0545 |      0.5
 
1841
 qwertyu0546 |      0.5
 
1842
 qwertyu0547 |      0.5
 
1843
 qwertyu0548 |      0.5
 
1844
 qwertyu0549 |      0.5
 
1845
 qwertyu0550 |      0.5
 
1846
 qwertyu0551 |      0.5
 
1847
 qwertyu0552 |      0.5
 
1848
 qwertyu0553 |      0.5
 
1849
 qwertyu0554 |      0.5
 
1850
 qwertyu0555 |      0.5
 
1851
 qwertyu0556 |      0.5
 
1852
 qwertyu0557 |      0.5
 
1853
 qwertyu0558 |      0.5
 
1854
 qwertyu0559 |      0.5
 
1855
 qwertyu0560 |      0.5
 
1856
 qwertyu0561 |      0.5
 
1857
 qwertyu0562 |      0.5
 
1858
 qwertyu0563 |      0.5
 
1859
 qwertyu0564 |      0.5
 
1860
 qwertyu0565 |      0.5
 
1861
 qwertyu0566 |      0.5
 
1862
 qwertyu0567 |      0.5
 
1863
 qwertyu0568 |      0.5
 
1864
 qwertyu0569 |      0.5
 
1865
 qwertyu0570 |      0.5
 
1866
 qwertyu0571 |      0.5
 
1867
 qwertyu0572 |      0.5
 
1868
 qwertyu0573 |      0.5
 
1869
 qwertyu0574 |      0.5
 
1870
 qwertyu0575 |      0.5
 
1871
 qwertyu0576 |      0.5
 
1872
 qwertyu0577 |      0.5
 
1873
 qwertyu0578 |      0.5
 
1874
 qwertyu0579 |      0.5
 
1875
 qwertyu0580 |      0.5
 
1876
 qwertyu0581 |      0.5
 
1877
 qwertyu0582 |      0.5
 
1878
 qwertyu0583 |      0.5
 
1879
 qwertyu0584 |      0.5
 
1880
 qwertyu0585 |      0.5
 
1881
 qwertyu0586 |      0.5
 
1882
 qwertyu0587 |      0.5
 
1883
 qwertyu0589 |      0.5
 
1884
 qwertyu0590 |      0.5
 
1885
 qwertyu0591 |      0.5
 
1886
 qwertyu0592 |      0.5
 
1887
 qwertyu0593 |      0.5
 
1888
 qwertyu0594 |      0.5
 
1889
 qwertyu0595 |      0.5
 
1890
 qwertyu0596 |      0.5
 
1891
 qwertyu0597 |      0.5
 
1892
 qwertyu0598 |      0.5
 
1893
 qwertyu0599 |      0.5
 
1894
 qwertyu0600 |      0.5
 
1895
 qwertyu0601 |      0.5
 
1896
 qwertyu0602 |      0.5
 
1897
 qwertyu0603 |      0.5
 
1898
 qwertyu0604 |      0.5
 
1899
 qwertyu0605 |      0.5
 
1900
 qwertyu0606 |      0.5
 
1901
 qwertyu0607 |      0.5
 
1902
 qwertyu0608 |      0.5
 
1903
 qwertyu0609 |      0.5
 
1904
 qwertyu0610 |      0.5
 
1905
 qwertyu0611 |      0.5
 
1906
 qwertyu0612 |      0.5
 
1907
 qwertyu0613 |      0.5
 
1908
 qwertyu0614 |      0.5
 
1909
 qwertyu0615 |      0.5
 
1910
 qwertyu0616 |      0.5
 
1911
 qwertyu0617 |      0.5
 
1912
 qwertyu0618 |      0.5
 
1913
 qwertyu0619 |      0.5
 
1914
 qwertyu0620 |      0.5
 
1915
 qwertyu0621 |      0.5
 
1916
 qwertyu0622 |      0.5
 
1917
 qwertyu0623 |      0.5
 
1918
 qwertyu0624 |      0.5
 
1919
 qwertyu0625 |      0.5
 
1920
 qwertyu0626 |      0.5
 
1921
 qwertyu0627 |      0.5
 
1922
 qwertyu0628 |      0.5
 
1923
 qwertyu0629 |      0.5
 
1924
 qwertyu0630 |      0.5
 
1925
 qwertyu0631 |      0.5
 
1926
 qwertyu0632 |      0.5
 
1927
 qwertyu0633 |      0.5
 
1928
 qwertyu0634 |      0.5
 
1929
 qwertyu0635 |      0.5
 
1930
 qwertyu0636 |      0.5
 
1931
 qwertyu0637 |      0.5
 
1932
 qwertyu0638 |      0.5
 
1933
 qwertyu0639 |      0.5
 
1934
 qwertyu0640 |      0.5
 
1935
 qwertyu0641 |      0.5
 
1936
 qwertyu0642 |      0.5
 
1937
 qwertyu0643 |      0.5
 
1938
 qwertyu0644 |      0.5
 
1939
 qwertyu0645 |      0.5
 
1940
 qwertyu0646 |      0.5
 
1941
 qwertyu0647 |      0.5
 
1942
 qwertyu0648 |      0.5
 
1943
 qwertyu0649 |      0.5
 
1944
 qwertyu0650 |      0.5
 
1945
 qwertyu0651 |      0.5
 
1946
 qwertyu0652 |      0.5
 
1947
 qwertyu0653 |      0.5
 
1948
 qwertyu0654 |      0.5
 
1949
 qwertyu0655 |      0.5
 
1950
 qwertyu0656 |      0.5
 
1951
 qwertyu0657 |      0.5
 
1952
 qwertyu0658 |      0.5
 
1953
 qwertyu0659 |      0.5
 
1954
 qwertyu0660 |      0.5
 
1955
 qwertyu0661 |      0.5
 
1956
 qwertyu0662 |      0.5
 
1957
 qwertyu0663 |      0.5
 
1958
 qwertyu0664 |      0.5
 
1959
 qwertyu0665 |      0.5
 
1960
 qwertyu0666 |      0.5
 
1961
 qwertyu0667 |      0.5
 
1962
 qwertyu0668 |      0.5
 
1963
 qwertyu0669 |      0.5
 
1964
 qwertyu0670 |      0.5
 
1965
 qwertyu0671 |      0.5
 
1966
 qwertyu0672 |      0.5
 
1967
 qwertyu0673 |      0.5
 
1968
 qwertyu0674 |      0.5
 
1969
 qwertyu0675 |      0.5
 
1970
 qwertyu0676 |      0.5
 
1971
 qwertyu0677 |      0.5
 
1972
 qwertyu0678 |      0.5
 
1973
 qwertyu0679 |      0.5
 
1974
 qwertyu0680 |      0.5
 
1975
 qwertyu0681 |      0.5
 
1976
 qwertyu0682 |      0.5
 
1977
 qwertyu0683 |      0.5
 
1978
 qwertyu0684 |      0.5
 
1979
 qwertyu0685 |      0.5
 
1980
 qwertyu0686 |      0.5
 
1981
 qwertyu0687 |      0.5
 
1982
 qwertyu0689 |      0.5
 
1983
 qwertyu0690 |      0.5
 
1984
 qwertyu0691 |      0.5
 
1985
 qwertyu0692 |      0.5
 
1986
 qwertyu0693 |      0.5
 
1987
 qwertyu0694 |      0.5
 
1988
 qwertyu0695 |      0.5
 
1989
 qwertyu0696 |      0.5
 
1990
 qwertyu0697 |      0.5
 
1991
 qwertyu0698 |      0.5
 
1992
 qwertyu0699 |      0.5
 
1993
 qwertyu0700 |      0.5
 
1994
 qwertyu0701 |      0.5
 
1995
 qwertyu0702 |      0.5
 
1996
 qwertyu0703 |      0.5
 
1997
 qwertyu0704 |      0.5
 
1998
 qwertyu0705 |      0.5
 
1999
 qwertyu0706 |      0.5
 
2000
 qwertyu0707 |      0.5
 
2001
 qwertyu0708 |      0.5
 
2002
 qwertyu0709 |      0.5
 
2003
 qwertyu0710 |      0.5
 
2004
 qwertyu0711 |      0.5
 
2005
 qwertyu0712 |      0.5
 
2006
 qwertyu0713 |      0.5
 
2007
 qwertyu0714 |      0.5
 
2008
 qwertyu0715 |      0.5
 
2009
 qwertyu0716 |      0.5
 
2010
 qwertyu0717 |      0.5
 
2011
 qwertyu0718 |      0.5
 
2012
 qwertyu0719 |      0.5
 
2013
 qwertyu0720 |      0.5
 
2014
 qwertyu0721 |      0.5
 
2015
 qwertyu0722 |      0.5
 
2016
 qwertyu0723 |      0.5
 
2017
 qwertyu0724 |      0.5
 
2018
 qwertyu0725 |      0.5
 
2019
 qwertyu0726 |      0.5
 
2020
 qwertyu0727 |      0.5
 
2021
 qwertyu0728 |      0.5
 
2022
 qwertyu0729 |      0.5
 
2023
 qwertyu0730 |      0.5
 
2024
 qwertyu0731 |      0.5
 
2025
 qwertyu0732 |      0.5
 
2026
 qwertyu0733 |      0.5
 
2027
 qwertyu0734 |      0.5
 
2028
 qwertyu0735 |      0.5
 
2029
 qwertyu0736 |      0.5
 
2030
 qwertyu0737 |      0.5
 
2031
 qwertyu0738 |      0.5
 
2032
 qwertyu0739 |      0.5
 
2033
 qwertyu0740 |      0.5
 
2034
 qwertyu0741 |      0.5
 
2035
 qwertyu0742 |      0.5
 
2036
 qwertyu0743 |      0.5
 
2037
 qwertyu0744 |      0.5
 
2038
 qwertyu0745 |      0.5
 
2039
 qwertyu0746 |      0.5
 
2040
 qwertyu0747 |      0.5
 
2041
 qwertyu0748 |      0.5
 
2042
 qwertyu0749 |      0.5
 
2043
 qwertyu0750 |      0.5
 
2044
 qwertyu0751 |      0.5
 
2045
 qwertyu0752 |      0.5
 
2046
 qwertyu0753 |      0.5
 
2047
 qwertyu0754 |      0.5
 
2048
 qwertyu0755 |      0.5
 
2049
 qwertyu0756 |      0.5
 
2050
 qwertyu0757 |      0.5
 
2051
 qwertyu0758 |      0.5
 
2052
 qwertyu0759 |      0.5
 
2053
 qwertyu0760 |      0.5
 
2054
 qwertyu0761 |      0.5
 
2055
 qwertyu0762 |      0.5
 
2056
 qwertyu0763 |      0.5
 
2057
 qwertyu0764 |      0.5
 
2058
 qwertyu0765 |      0.5
 
2059
 qwertyu0766 |      0.5
 
2060
 qwertyu0767 |      0.5
 
2061
 qwertyu0768 |      0.5
 
2062
 qwertyu0769 |      0.5
 
2063
 qwertyu0770 |      0.5
 
2064
 qwertyu0771 |      0.5
 
2065
 qwertyu0772 |      0.5
 
2066
 qwertyu0773 |      0.5
 
2067
 qwertyu0774 |      0.5
 
2068
 qwertyu0775 |      0.5
 
2069
 qwertyu0776 |      0.5
 
2070
 qwertyu0777 |      0.5
 
2071
 qwertyu0778 |      0.5
 
2072
 qwertyu0779 |      0.5
 
2073
 qwertyu0780 |      0.5
 
2074
 qwertyu0781 |      0.5
 
2075
 qwertyu0782 |      0.5
 
2076
 qwertyu0783 |      0.5
 
2077
 qwertyu0784 |      0.5
 
2078
 qwertyu0785 |      0.5
 
2079
 qwertyu0786 |      0.5
 
2080
 qwertyu0787 |      0.5
 
2081
 qwertyu0789 |      0.5
 
2082
 qwertyu0790 |      0.5
 
2083
 qwertyu0791 |      0.5
 
2084
 qwertyu0792 |      0.5
 
2085
 qwertyu0793 |      0.5
 
2086
 qwertyu0794 |      0.5
 
2087
 qwertyu0795 |      0.5
 
2088
 qwertyu0796 |      0.5
 
2089
 qwertyu0797 |      0.5
 
2090
 qwertyu0798 |      0.5
 
2091
 qwertyu0799 |      0.5
 
2092
 qwertyu0800 |      0.5
 
2093
 qwertyu0801 |      0.5
 
2094
 qwertyu0802 |      0.5
 
2095
 qwertyu0803 |      0.5
 
2096
 qwertyu0804 |      0.5
 
2097
 qwertyu0805 |      0.5
 
2098
 qwertyu0806 |      0.5
 
2099
 qwertyu0807 |      0.5
 
2100
 qwertyu0808 |      0.5
 
2101
 qwertyu0809 |      0.5
 
2102
 qwertyu0810 |      0.5
 
2103
 qwertyu0811 |      0.5
 
2104
 qwertyu0812 |      0.5
 
2105
 qwertyu0813 |      0.5
 
2106
 qwertyu0814 |      0.5
 
2107
 qwertyu0815 |      0.5
 
2108
 qwertyu0816 |      0.5
 
2109
 qwertyu0817 |      0.5
 
2110
 qwertyu0818 |      0.5
 
2111
 qwertyu0819 |      0.5
 
2112
 qwertyu0820 |      0.5
 
2113
 qwertyu0821 |      0.5
 
2114
 qwertyu0822 |      0.5
 
2115
 qwertyu0823 |      0.5
 
2116
 qwertyu0824 |      0.5
 
2117
 qwertyu0825 |      0.5
 
2118
 qwertyu0826 |      0.5
 
2119
 qwertyu0827 |      0.5
 
2120
 qwertyu0828 |      0.5
 
2121
 qwertyu0829 |      0.5
 
2122
 qwertyu0830 |      0.5
 
2123
 qwertyu0831 |      0.5
 
2124
 qwertyu0832 |      0.5
 
2125
 qwertyu0833 |      0.5
 
2126
 qwertyu0834 |      0.5
 
2127
 qwertyu0835 |      0.5
 
2128
 qwertyu0836 |      0.5
 
2129
 qwertyu0837 |      0.5
 
2130
 qwertyu0838 |      0.5
 
2131
 qwertyu0839 |      0.5
 
2132
 qwertyu0840 |      0.5
 
2133
 qwertyu0841 |      0.5
 
2134
 qwertyu0842 |      0.5
 
2135
 qwertyu0843 |      0.5
 
2136
 qwertyu0844 |      0.5
 
2137
 qwertyu0845 |      0.5
 
2138
 qwertyu0846 |      0.5
 
2139
 qwertyu0847 |      0.5
 
2140
 qwertyu0848 |      0.5
 
2141
 qwertyu0849 |      0.5
 
2142
 qwertyu0850 |      0.5
 
2143
 qwertyu0851 |      0.5
 
2144
 qwertyu0852 |      0.5
 
2145
 qwertyu0853 |      0.5
 
2146
 qwertyu0854 |      0.5
 
2147
 qwertyu0855 |      0.5
 
2148
 qwertyu0856 |      0.5
 
2149
 qwertyu0857 |      0.5
 
2150
 qwertyu0858 |      0.5
 
2151
 qwertyu0859 |      0.5
 
2152
 qwertyu0860 |      0.5
 
2153
 qwertyu0861 |      0.5
 
2154
 qwertyu0862 |      0.5
 
2155
 qwertyu0863 |      0.5
 
2156
 qwertyu0864 |      0.5
 
2157
 qwertyu0865 |      0.5
 
2158
 qwertyu0866 |      0.5
 
2159
 qwertyu0867 |      0.5
 
2160
 qwertyu0868 |      0.5
 
2161
 qwertyu0869 |      0.5
 
2162
 qwertyu0870 |      0.5
 
2163
 qwertyu0871 |      0.5
 
2164
 qwertyu0872 |      0.5
 
2165
 qwertyu0873 |      0.5
 
2166
 qwertyu0874 |      0.5
 
2167
 qwertyu0875 |      0.5
 
2168
 qwertyu0876 |      0.5
 
2169
 qwertyu0877 |      0.5
 
2170
 qwertyu0878 |      0.5
 
2171
 qwertyu0879 |      0.5
 
2172
 qwertyu0880 |      0.5
 
2173
 qwertyu0881 |      0.5
 
2174
 qwertyu0882 |      0.5
 
2175
 qwertyu0883 |      0.5
 
2176
 qwertyu0884 |      0.5
 
2177
 qwertyu0885 |      0.5
 
2178
 qwertyu0886 |      0.5
 
2179
 qwertyu0887 |      0.5
 
2180
 qwertyu0889 |      0.5
 
2181
 qwertyu0890 |      0.5
 
2182
 qwertyu0891 |      0.5
 
2183
 qwertyu0892 |      0.5
 
2184
 qwertyu0893 |      0.5
 
2185
 qwertyu0894 |      0.5
 
2186
 qwertyu0895 |      0.5
 
2187
 qwertyu0896 |      0.5
 
2188
 qwertyu0897 |      0.5
 
2189
 qwertyu0898 |      0.5
 
2190
 qwertyu0899 |      0.5
 
2191
 qwertyu1000 | 0.411765
 
2192
(1000 rows)
 
2193
 
 
2194
select t,similarity(t,'gwertyu0988') as sml from test_trgm where t % 'gwertyu0988' order by sml desc, t;
 
2195
      t      |   sml    
 
2196
-------------+----------
 
2197
 qwertyu0988 |      0.6
 
2198
 qwertyu0980 | 0.411765
 
2199
 qwertyu0981 | 0.411765
 
2200
 qwertyu0982 | 0.411765
 
2201
 qwertyu0983 | 0.411765
 
2202
 qwertyu0984 | 0.411765
 
2203
 qwertyu0985 | 0.411765
 
2204
 qwertyu0986 | 0.411765
 
2205
 qwertyu0987 | 0.411765
 
2206
 qwertyu0989 | 0.411765
 
2207
 qwertyu0088 | 0.333333
 
2208
 qwertyu0098 | 0.333333
 
2209
 qwertyu0188 | 0.333333
 
2210
 qwertyu0288 | 0.333333
 
2211
 qwertyu0388 | 0.333333
 
2212
 qwertyu0488 | 0.333333
 
2213
 qwertyu0588 | 0.333333
 
2214
 qwertyu0688 | 0.333333
 
2215
 qwertyu0788 | 0.333333
 
2216
 qwertyu0888 | 0.333333
 
2217
 qwertyu0900 | 0.333333
 
2218
 qwertyu0901 | 0.333333
 
2219
 qwertyu0902 | 0.333333
 
2220
 qwertyu0903 | 0.333333
 
2221
 qwertyu0904 | 0.333333
 
2222
 qwertyu0905 | 0.333333
 
2223
 qwertyu0906 | 0.333333
 
2224
 qwertyu0907 | 0.333333
 
2225
 qwertyu0908 | 0.333333
 
2226
 qwertyu0909 | 0.333333
 
2227
 qwertyu0910 | 0.333333
 
2228
 qwertyu0911 | 0.333333
 
2229
 qwertyu0912 | 0.333333
 
2230
 qwertyu0913 | 0.333333
 
2231
 qwertyu0914 | 0.333333
 
2232
 qwertyu0915 | 0.333333
 
2233
 qwertyu0916 | 0.333333
 
2234
 qwertyu0917 | 0.333333
 
2235
 qwertyu0918 | 0.333333
 
2236
 qwertyu0919 | 0.333333
 
2237
 qwertyu0920 | 0.333333
 
2238
 qwertyu0921 | 0.333333
 
2239
 qwertyu0922 | 0.333333
 
2240
 qwertyu0923 | 0.333333
 
2241
 qwertyu0924 | 0.333333
 
2242
 qwertyu0925 | 0.333333
 
2243
 qwertyu0926 | 0.333333
 
2244
 qwertyu0927 | 0.333333
 
2245
 qwertyu0928 | 0.333333
 
2246
 qwertyu0929 | 0.333333
 
2247
 qwertyu0930 | 0.333333
 
2248
 qwertyu0931 | 0.333333
 
2249
 qwertyu0932 | 0.333333
 
2250
 qwertyu0933 | 0.333333
 
2251
 qwertyu0934 | 0.333333
 
2252
 qwertyu0935 | 0.333333
 
2253
 qwertyu0936 | 0.333333
 
2254
 qwertyu0937 | 0.333333
 
2255
 qwertyu0938 | 0.333333
 
2256
 qwertyu0939 | 0.333333
 
2257
 qwertyu0940 | 0.333333
 
2258
 qwertyu0941 | 0.333333
 
2259
 qwertyu0942 | 0.333333
 
2260
 qwertyu0943 | 0.333333
 
2261
 qwertyu0944 | 0.333333
 
2262
 qwertyu0945 | 0.333333
 
2263
 qwertyu0946 | 0.333333
 
2264
 qwertyu0947 | 0.333333
 
2265
 qwertyu0948 | 0.333333
 
2266
 qwertyu0949 | 0.333333
 
2267
 qwertyu0950 | 0.333333
 
2268
 qwertyu0951 | 0.333333
 
2269
 qwertyu0952 | 0.333333
 
2270
 qwertyu0953 | 0.333333
 
2271
 qwertyu0954 | 0.333333
 
2272
 qwertyu0955 | 0.333333
 
2273
 qwertyu0956 | 0.333333
 
2274
 qwertyu0957 | 0.333333
 
2275
 qwertyu0958 | 0.333333
 
2276
 qwertyu0959 | 0.333333
 
2277
 qwertyu0960 | 0.333333
 
2278
 qwertyu0961 | 0.333333
 
2279
 qwertyu0962 | 0.333333
 
2280
 qwertyu0963 | 0.333333
 
2281
 qwertyu0964 | 0.333333
 
2282
 qwertyu0965 | 0.333333
 
2283
 qwertyu0966 | 0.333333
 
2284
 qwertyu0967 | 0.333333
 
2285
 qwertyu0968 | 0.333333
 
2286
 qwertyu0969 | 0.333333
 
2287
 qwertyu0970 | 0.333333
 
2288
 qwertyu0971 | 0.333333
 
2289
 qwertyu0972 | 0.333333
 
2290
 qwertyu0973 | 0.333333
 
2291
 qwertyu0974 | 0.333333
 
2292
 qwertyu0975 | 0.333333
 
2293
 qwertyu0976 | 0.333333
 
2294
 qwertyu0977 | 0.333333
 
2295
 qwertyu0978 | 0.333333
 
2296
 qwertyu0979 | 0.333333
 
2297
 qwertyu0990 | 0.333333
 
2298
 qwertyu0991 | 0.333333
 
2299
 qwertyu0992 | 0.333333
 
2300
 qwertyu0993 | 0.333333
 
2301
 qwertyu0994 | 0.333333
 
2302
 qwertyu0995 | 0.333333
 
2303
 qwertyu0996 | 0.333333
 
2304
 qwertyu0997 | 0.333333
 
2305
 qwertyu0998 | 0.333333
 
2306
 qwertyu0999 | 0.333333
 
2307
(110 rows)
 
2308
 
 
2309
select t,similarity(t,'gwertyu1988') as sml from test_trgm where t % 'gwertyu1988' order by sml desc, t;
 
2310
      t      |   sml    
 
2311
-------------+----------
 
2312
 qwertyu0988 | 0.333333
 
2313
(1 row)
 
2314