History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shanghai"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2025-08-27 04:34:59 | shanghai | 1 | 82945 | 2 | 1.376 | 60279.8 |
412 | 2025-08-09 17:57:59 | shanghai | 1 | 82945 | 2 | 6.186 | 13408.5 |
411 | 2025-08-09 08:15:03 | shanghai | 1 | 82945 | 2 | 8.670 | 9566.9 |
410 | 2025-08-05 11:04:32 | shanghai | 2 | 121059 | 4 | 9.436 | 12829.5 |
409 | 2025-08-04 04:22:35 | shanghai | 1 | 82945 | 2 | 2.796 | 29665.6 |
408 | 2025-07-27 03:23:17 | shanghai | 1 | 82945 | 2 | 3.953 | 20982.8 |
407 | 2025-07-02 04:12:59 | shanghai | 1 | 82945 | 2 | 5.690 | 14577.3 |
406 | 2025-07-01 22:15:46 | shanghai | 1 | 82945 | 2 | 7.940 | 10446.5 |
405 | 2025-06-25 03:20:46 | shanghai | 1 | 82945 | 2 | 4.593 | 18059.0 |
404 | 2025-06-24 16:46:32 | shanghai | 1 | 82945 | 2 | 9.766 | 8493.2 |
403 | 2025-06-16 11:10:27 | shanghai | 1 | 82945 | 2 | 4.906 | 16906.8 |
402 | 2025-06-05 13:35:03 | shanghai | 1 | 82945 | 2 | 2.516 | 32967.0 |
401 | 2025-05-30 14:40:41 | shanghai | 1 | 82945 | 2 | 8.146 | 10182.3 |
400 | 2025-05-27 20:16:59 | shanghai | 1 | 82945 | 2 | 1.500 | 55296.7 |
399 | 2025-05-22 04:32:50 | shanghai | 1 | 82945 | 2 | 9.800 | 8463.8 |
398 | 2025-05-10 18:15:57 | shanghai | 1 | 82945 | 2 | 5.903 | 14051.3 |
397 | 2025-05-07 07:09:38 | shanghai | 1 | 82945 | 2 | 1.516 | 54713.1 |
396 | 2025-04-23 22:20:59 | shanghai | 3 | 146162 | 24 | 40.876 | 3575.7 |
395 | 2025-04-23 20:00:52 | shanghai | 2 | 121059 | 4 | 15.843 | 7641.2 |
394 | 2025-04-23 16:12:31 | shanghai | 3 | 146162 | 24 | 33.376 | 4379.3 |
393 | 2025-04-22 02:37:00 | shanghai | 1 | 82945 | 2 | 4.893 | 16951.8 |
392 | 2025-04-11 16:02:39 | shanghai | 3 | 146162 | 24 | 28.473 | 5133.4 |
391 | 2025-04-11 11:46:20 | shanghai | 3 | 146162 | 24 | 35.640 | 4101.1 |
390 | 2025-03-29 05:16:34 | shanghai | 1 | 82945 | 2 | 12.890 | 6434.8 |
389 | 2025-03-20 04:35:02 | shanghai | 1 | 82945 | 2 | 5.686 | 14587.6 |
388 | 2025-03-18 06:26:31 | shanghai | 1 | 82945 | 2 | 6.843 | 12121.1 |
387 | 2025-02-15 14:04:09 | shanghai | 3 | 146162 | 24 | 32.956 | 4435.1 |
386 | 2025-02-11 15:00:25 | shanghai | 3 | 146162 | 24 | 31.906 | 4581.0 |
385 | 2025-02-11 13:27:16 | shanghai | 3 | 146162 | 24 | 41.143 | 3552.5 |
384 | 2025-02-11 13:27:08 | shanghai | 2 | 121059 | 4 | 11.250 | 10760.8 |
383 | 2025-02-11 13:26:28 | shanghai | 1 | 82945 | 2 | 5.686 | 14587.6 |
382 | 2025-02-11 12:42:34 | shanghai | 4 | 161609 | 250 | 49.556 | 3261.1 |
381 | 2025-02-09 17:56:04 | shanghai | 4 | 161609 | 250 | 103.476 | 1561.8 |
380 | 2025-02-09 17:56:04 | shanghai | 3 | 146162 | 24 | 26.753 | 5463.4 |
379 | 2025-02-09 17:56:01 | shanghai | 2 | 121059 | 4 | 12.126 | 9983.4 |
378 | 2025-02-09 17:55:52 | shanghai | 1 | 82945 | 2 | 4.826 | 17187.1 |
377 | 2025-01-14 04:14:16 | shanghai | 2 | 121059 | 4 | 4.000 | 30264.8 |
376 | 2025-01-14 04:14:12 | shanghai | 1 | 82945 | 2 | 1.546 | 53651.4 |
375 | 2025-01-10 08:31:18 | shanghai | 1 | 82945 | 2 | 7.016 | 11822.3 |
374 | 2025-01-09 12:24:35 | shanghai | 3 | 146162 | 24 | 13.373 | 10929.6 |
373 | 2025-01-08 21:32:28 | shanghai | 3 | 146162 | 24 | 49.126 | 2975.2 |
372 | 2025-01-08 21:32:16 | shanghai | 2 | 121059 | 4 | 14.216 | 8515.7 |
371 | 2025-01-02 01:44:23 | shanghai | 1 | 82945 | 2 | 10.750 | 7715.8 |
370 | 2025-01-01 11:12:20 | shanghai | 3 | 146162 | 24 | 36.410 | 4014.3 |
369 | 2024-12-31 07:05:58 | shanghai | 3 | 146162 | 24 | 37.503 | 3897.3 |
368 | 2024-12-31 07:05:52 | shanghai | 2 | 121059 | 4 | 27.486 | 4404.4 |
367 | 2024-12-28 23:20:38 | shanghai | 3 | 146162 | 24 | 12.736 | 11476.3 |
366 | 2024-12-24 00:29:51 | shanghai | 3 | 146162 | 24 | 38.156 | 3830.6 |
365 | 2024-12-24 00:29:42 | shanghai | 3 | 146162 | 24 | 37.440 | 3903.9 |
364 | 2024-12-08 17:22:36 | shanghai | 3 | 146162 | 24 | 37.986 | 3847.8 |
363 | 2024-12-08 17:21:56 | shanghai | 2 | 121059 | 4 | 19.923 | 6076.3 |
362 | 2024-12-08 17:21:42 | shanghai | 1 | 82945 | 2 | 7.376 | 11245.3 |
361 | 2024-12-03 13:35:01 | shanghai | 2 | 121059 | 4 | 4.033 | 30017.1 |
360 | 2024-12-03 13:35:00 | shanghai | 1 | 82945 | 2 | 1.483 | 55930.5 |
359 | 2024-12-01 09:25:19 | shanghai | 1 | 82945 | 2 | 2.936 | 28251.0 |
358 | 2024-11-26 16:43:32 | shanghai | 3 | 146162 | 24 | 7.343 | 19904.9 |
357 | 2024-11-25 13:29:09 | shanghai | 1 | 82945 | 2 | 3.593 | 23085.2 |
356 | 2024-11-25 12:57:34 | shanghai | 3 | 146162 | 24 | 9.063 | 16127.3 |
355 | 2024-11-25 12:57:32 | shanghai | 2 | 121059 | 4 | 4.110 | 29454.7 |
354 | 2024-11-24 18:54:46 | shanghai | 4 | 161609 | 250 | 71.253 | 2268.1 |
353 | 2024-11-23 11:07:30 | shanghai | 4 | 161609 | 250 | 58.960 | 2741.0 |
352 | 2024-11-18 17:12:31 | shanghai | 3 | 146162 | 24 | 21.606 | 6764.9 |
351 | 2024-11-18 12:20:15 | shanghai | 3 | 146162 | 24 | 45.593 | 3205.8 |
350 | 2024-11-07 15:57:36 | shanghai | 2 | 121059 | 4 | 14.640 | 8269.1 |
349 | 2024-11-05 01:08:02 | shanghai | 4 | 161609 | 250 | 91.943 | 1757.7 |
348 | 2024-11-04 01:16:51 | shanghai | 1 | 82945 | 2 | 1.280 | 64800.8 |
347 | 2024-10-30 05:35:19 | shanghai | 1 | 82945 | 2 | 4.236 | 19581.0 |
346 | 2024-10-28 17:24:19 | shanghai | 2 | 121059 | 4 | 20.656 | 5860.7 |
345 | 2024-10-22 08:02:23 | shanghai | 1 | 82945 | 2 | 6.220 | 13335.2 |
344 | 2024-10-21 00:12:51 | shanghai | 4 | 161609 | 250 | 90.020 | 1795.3 |
343 | 2024-10-20 14:26:52 | shanghai | 4 | 161609 | 250 | 45.266 | 3570.2 |
342 | 2024-10-20 04:56:48 | shanghai | 2 | 121059 | 4 | 18.360 | 6593.6 |
341 | 2024-10-20 04:55:42 | shanghai | 1 | 82945 | 2 | 4.923 | 16848.5 |
340 | 2024-10-19 00:18:35 | shanghai | 3 | 146162 | 24 | 29.346 | 4980.6 |
339 | 2024-10-15 11:38:57 | shanghai | 3 | 146162 | 24 | 55.143 | 2650.6 |
338 | 2024-10-14 16:59:35 | shanghai | 3 | 146162 | 24 | 36.453 | 4009.6 |
337 | 2024-10-05 04:11:52 | shanghai | 3 | 146162 | 24 | 71.786 | 2036.1 |
336 | 2024-09-24 05:17:17 | shanghai | 2 | 121059 | 4 | 16.906 | 7160.7 |
335 | 2024-09-24 05:17:16 | shanghai | 2 | 121059 | 4 | 11.953 | 10127.9 |
334 | 2024-09-23 05:38:39 | shanghai | 1 | 82945 | 2 | 10.266 | 8079.6 |
333 | 2024-09-22 12:43:31 | shanghai | 3 | 146162 | 24 | 57.490 | 2542.4 |
332 | 2024-09-22 12:43:28 | shanghai | 2 | 121059 | 4 | 29.516 | 4101.5 |
331 | 2024-09-19 19:48:54 | shanghai | 4 | 161609 | 250 | 133.646 | 1209.2 |
330 | 2024-09-11 20:43:56 | shanghai | 4 | 161609 | 250 | 129.396 | 1248.9 |
329 | 2024-09-10 10:44:05 | shanghai | 1 | 82945 | 2 | 5.406 | 15343.1 |
328 | 2024-08-31 17:46:18 | shanghai | 4 | 161609 | 250 | 95.940 | 1684.5 |
327 | 2024-08-31 13:41:42 | shanghai | 4 | 161609 | 250 | 72.290 | 2235.6 |
326 | 2024-08-23 00:05:29 | shanghai | 1 | 82945 | 2 | 5.423 | 15295.0 |
325 | 2024-08-15 13:02:21 | shanghai | 4 | 161609 | 250 | 110.926 | 1456.9 |
324 | 2024-08-08 01:08:13 | shanghai | 4 | 161609 | 250 | 26.110 | 6189.5 |
323 | 2024-08-08 01:06:40 | shanghai | 3 | 146162 | 24 | 16.906 | 8645.6 |
322 | 2024-08-06 16:31:31 | shanghai | 2 | 121059 | 4 | 20.123 | 6016.0 |
321 | 2024-08-06 16:31:33 | shanghai | 3 | 146162 | 24 | 17.220 | 8487.9 |
320 | 2024-08-06 07:06:57 | shanghai | 4 | 161609 | 250 | 68.866 | 2346.7 |
319 | 2024-08-05 05:27:02 | shanghai | 4 | 161609 | 250 | 78.300 | 2064.0 |
318 | 2024-08-05 05:27:11 | shanghai | 3 | 146162 | 24 | 17.936 | 8149.1 |
317 | 2024-08-05 05:26:57 | shanghai | 2 | 121059 | 4 | 14.483 | 8358.7 |
316 | 2024-07-31 23:09:29 | shanghai | 1 | 82945 | 2 | 3.550 | 23364.8 |
315 | 2024-07-31 02:40:39 | shanghai | 3 | 146162 | 24 | 20.270 | 7210.8 |
314 | 2024-07-31 01:02:31 | shanghai | 4 | 161609 | 250 | 47.410 | 3408.8 |