History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"merches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
487 | 2024-04-27 18:58:36 | merches | 1 | 69583 | 5 | 1.233 | 56433.9 |
486 | 2024-04-06 10:55:34 | merches | 1 | 69583 | 5 | 4.733 | 14701.7 |
485 | 2024-03-25 02:13:29 | merches | 1 | 69583 | 5 | 2.593 | 26834.9 |
484 | 2024-02-07 08:39:10 | merches | 2 | 107671 | 75 | 3.296 | 32667.2 |
483 | 2024-02-07 08:38:46 | merches | 3 | 134027 | 520 | 7.236 | 18522.2 |
482 | 2024-02-03 23:34:23 | merches | 2 | 107671 | 75 | 3.436 | 31336.1 |
481 | 2024-01-30 03:38:25 | merches | 3 | 134027 | 520 | 7.203 | 18607.1 |
480 | 2024-01-29 13:47:42 | merches | 3 | 134027 | 520 | 6.466 | 20728.0 |
479 | 2024-01-06 20:59:30 | merches | 1 | 69583 | 5 | 1.140 | 61037.7 |
478 | 2023-12-21 02:10:27 | merches | 3 | 134027 | 520 | 6.110 | 21935.7 |
477 | 2023-12-20 06:36:18 | merches | 1 | 69583 | 5 | 1.236 | 56296.9 |
476 | 2023-12-18 06:55:12 | merches | 2 | 107671 | 75 | 2.830 | 38046.3 |
475 | 2023-12-17 11:18:44 | merches | 3 | 134027 | 520 | 6.763 | 19817.7 |
474 | 2023-12-05 15:41:17 | merches | 3 | 134027 | 520 | 6.186 | 21666.2 |
473 | 2023-12-04 08:53:45 | merches | 2 | 107671 | 75 | 6.533 | 16481.1 |
472 | 2023-11-22 09:29:12 | merches | 3 | 134027 | 520 | 6.906 | 19407.3 |
471 | 2023-11-22 09:29:10 | merches | 2 | 107671 | 75 | 3.160 | 34073.1 |
470 | 2023-11-19 10:25:41 | merches | 3 | 134027 | 520 | 7.013 | 19111.2 |
469 | 2023-11-17 22:33:32 | merches | 1 | 69583 | 5 | 1.216 | 57222.9 |
468 | 2023-11-14 23:14:02 | merches | 1 | 69583 | 5 | 1.030 | 67556.3 |
467 | 2023-11-14 11:49:01 | merches | 1 | 69583 | 5 | 1.233 | 56433.9 |
466 | 2023-11-11 19:53:58 | merches | 3 | 134027 | 520 | 8.986 | 14915.1 |
465 | 2023-11-10 02:44:25 | merches | 2 | 107671 | 75 | 2.800 | 38453.9 |
464 | 2023-11-09 03:02:37 | merches | 3 | 134027 | 520 | 7.470 | 17942.0 |
463 | 2023-11-07 10:28:56 | merches | 3 | 134027 | 520 | 5.920 | 22639.7 |
462 | 2023-11-02 16:41:48 | merches | 1 | 69583 | 5 | 1.296 | 53690.6 |
461 | 2023-10-28 12:24:16 | merches | 1 | 69583 | 5 | 1.140 | 61037.7 |
460 | 2023-10-21 19:21:25 | merches | 1 | 69583 | 5 | 1.106 | 62914.1 |
459 | 2023-09-25 10:02:42 | merches | 1 | 69583 | 5 | 1.250 | 55666.4 |
458 | 2023-09-24 12:51:27 | merches | 1 | 69583 | 5 | 1.093 | 63662.4 |
457 | 2023-08-31 03:14:52 | merches | 1 | 69583 | 5 | 1.063 | 65459.1 |
456 | 2023-08-24 10:11:16 | merches | 1 | 69583 | 5 | 1.080 | 64428.7 |
455 | 2023-08-13 00:21:34 | merches | 2 | 107671 | 75 | 2.923 | 36835.8 |
454 | 2023-08-12 02:59:47 | merches | 3 | 134027 | 520 | 6.550 | 20462.1 |
453 | 2023-05-20 19:56:44 | merches | 1 | 69583 | 5 | 1.063 | 65459.1 |
452 | 2023-05-14 04:41:12 | merches | 1 | 69583 | 5 | 1.063 | 65459.1 |
451 | 2023-04-25 22:50:58 | merches | 3 | 134027 | 520 | 6.640 | 20184.8 |
450 | 2023-04-24 07:04:27 | merches | 2 | 107671 | 75 | 2.843 | 37872.3 |
449 | 2023-03-16 08:33:07 | merches | 1 | 69583 | 5 | 2.203 | 31585.6 |
448 | 2023-02-02 12:28:37 | merches | 3 | 134027 | 520 | 6.050 | 22153.2 |
447 | 2023-01-28 22:47:50 | merches | 2 | 107671 | 75 | 2.796 | 38508.9 |
446 | 2023-01-28 07:13:23 | merches | 1 | 69583 | 5 | 1.046 | 66522.9 |
445 | 2023-01-24 16:04:43 | merches | 1 | 69583 | 5 | 1.233 | 56433.9 |
444 | 2023-01-17 09:00:28 | merches | 1 | 69583 | 5 | 1.216 | 57222.9 |
443 | 2023-01-06 02:59:32 | merches | 1 | 69583 | 5 | 1.186 | 58670.3 |
442 | 2022-11-14 06:00:34 | merches | 3 | 134027 | 520 | 5.720 | 23431.3 |
441 | 2022-11-10 20:03:17 | merches | 2 | 107671 | 75 | 2.813 | 38276.2 |
440 | 2022-10-14 00:36:21 | merches | 1 | 69583 | 5 | 1.080 | 64428.7 |
439 | 2022-09-26 23:02:24 | merches | 1 | 69583 | 5 | 1.060 | 65644.3 |
438 | 2022-09-18 17:40:55 | merches | 1 | 69583 | 5 | 1.080 | 64428.7 |
437 | 2022-08-23 21:40:36 | merches | 1 | 69583 | 5 | 1.296 | 53690.6 |
436 | 2022-07-01 09:09:26 | merches | 1 | 69583 | 5 | 2.420 | 28753.3 |
435 | 2022-06-17 14:56:08 | merches | 3 | 134027 | 520 | 6.076 | 22058.4 |
434 | 2022-06-12 15:27:23 | merches | 2 | 107671 | 75 | 2.843 | 37872.3 |
433 | 2022-05-09 19:50:06 | merches | 1 | 69583 | 5 | 1.060 | 65644.3 |
432 | 2022-03-24 18:17:41 | merches | 1 | 69583 | 5 | 1.266 | 54962.9 |
431 | 2022-02-02 04:25:46 | merches | 1 | 69583 | 5 | 1.186 | 58670.3 |
430 | 2021-12-18 16:40:25 | merches | 1 | 69583 | 5 | 1.203 | 57841.2 |
429 | 2021-12-10 16:48:38 | merches | 1 | 69583 | 5 | 1.156 | 60192.9 |
428 | 2021-11-24 03:47:31 | merches | 1 | 69583 | 5 | 1.236 | 56296.9 |
427 | 2021-11-22 07:46:54 | merches | 1 | 69583 | 5 | 1.203 | 57841.2 |
426 | 2021-10-09 20:11:26 | merches | 1 | 69583 | 5 | 1.076 | 64668.2 |
425 | 2021-10-07 18:19:06 | merches | 1 | 69583 | 5 | 1.203 | 57841.2 |
424 | 2021-09-06 15:24:32 | merches | 1 | 69583 | 5 | 1.093 | 63662.4 |
423 | 2021-08-29 23:14:34 | merches | 1 | 69583 | 5 | 1.203 | 57841.2 |
422 | 2021-08-27 18:44:09 | merches | 1 | 69583 | 5 | 1.076 | 64668.2 |
421 | 2021-07-19 08:25:11 | merches | 2 | 107671 | 75 | 3.236 | 33272.9 |
420 | 2021-06-05 15:17:56 | merches | 1 | 69583 | 5 | 1.170 | 59472.6 |
419 | 2021-05-08 16:11:40 | merches | 2 | 107671 | 75 | 3.033 | 35499.8 |
418 | 2021-04-21 22:15:03 | merches | 1 | 69583 | 5 | 2.186 | 31831.2 |
417 | 2021-04-07 03:49:54 | merches | 2 | 107671 | 75 | 6.673 | 16135.3 |
416 | 2021-03-11 09:15:49 | merches | 2 | 107671 | 75 | 2.970 | 36252.9 |
415 | 2021-03-03 12:07:36 | merches | 1 | 69583 | 5 | 1.126 | 61796.6 |
414 | 2021-02-14 23:37:52 | merches | 2 | 107671 | 75 | 2.906 | 37051.3 |
413 | 2021-01-31 02:58:06 | merches | 1 | 69583 | 5 | 1.200 | 57985.8 |
412 | 2021-01-07 00:29:40 | merches | 1 | 69583 | 5 | 1.076 | 64668.2 |
411 | 2020-11-27 22:50:24 | merches | 1 | 69583 | 5 | 1.220 | 57035.2 |
410 | 2020-11-14 07:25:52 | merches | 1 | 69583 | 5 | 1.360 | 51164.0 |
409 | 2020-11-02 03:53:35 | merches | 2 | 107671 | 75 | 3.296 | 32667.2 |
408 | 2020-10-29 08:06:28 | merches | 1 | 69583 | 5 | 1.110 | 62687.4 |
407 | 2020-10-26 01:48:49 | merches | 3 | 134027 | 520 | 7.050 | 19010.9 |
406 | 2020-10-05 10:28:24 | merches | 1 | 69583 | 5 | 1.220 | 57035.2 |
405 | 2020-08-21 20:14:08 | merches | 1 | 69583 | 5 | 1.093 | 63662.4 |
404 | 2020-07-30 03:18:40 | merches | 1 | 69583 | 5 | 1.220 | 57035.2 |
403 | 2020-07-27 00:59:27 | merches | 1 | 69583 | 5 | 1.123 | 61961.7 |
402 | 2020-07-23 18:40:59 | merches | 1 | 69583 | 5 | 1.123 | 61961.7 |
401 | 2020-05-20 12:39:30 | merches | 1 | 69583 | 5 | 1.216 | 57222.9 |
400 | 2020-03-28 08:52:46 | merches | 1 | 69583 | 5 | 1.093 | 63662.4 |
399 | 2020-03-28 07:44:50 | merches | 1 | 69583 | 5 | 2.470 | 28171.3 |
398 | 2020-03-24 00:52:46 | merches | 1 | 69583 | 5 | 1.296 | 53690.6 |
397 | 2020-03-23 14:33:35 | merches | 1 | 69583 | 5 | 1.330 | 52318.0 |
396 | 2020-03-19 21:53:03 | merches | 1 | 69583 | 5 | 1.093 | 63662.4 |
395 | 2020-02-23 05:42:07 | merches | 1 | 69583 | 5 | 1.236 | 56296.9 |
394 | 2020-02-19 12:15:43 | merches | 1 | 69583 | 5 | 4.236 | 16426.6 |
393 | 2020-02-17 18:38:29 | merches | 1 | 69583 | 5 | 1.873 | 37150.6 |
392 | 2020-02-17 13:01:06 | merches | 1 | 69583 | 5 | 1.060 | 65644.3 |
391 | 2020-02-09 23:10:53 | merches | 1 | 69583 | 5 | 1.360 | 51164.0 |
390 | 2020-02-05 20:45:44 | merches | 1 | 69583 | 5 | 2.673 | 26031.8 |
389 | 2020-02-01 09:16:10 | merches | 1 | 69583 | 5 | 2.936 | 23699.9 |
388 | 2020-01-30 17:05:06 | merches | 1 | 69583 | 5 | 2.580 | 26970.2 |