History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surname"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
547 | 2025-09-28 14:06:52 | surname | 1 | 69583 | 4 | 1.203 | 57841.2 |
546 | 2025-09-28 02:29:38 | surname | 1 | 69583 | 4 | 1.110 | 62687.4 |
545 | 2025-09-27 05:36:32 | surname | 1 | 69583 | 4 | 1.343 | 51811.6 |
544 | 2025-09-26 06:57:33 | surname | 1 | 69583 | 4 | 1.190 | 58473.1 |
543 | 2025-09-07 20:57:44 | surname | 1 | 69583 | 4 | 1.203 | 57841.2 |
542 | 2025-08-28 02:02:06 | surname | 1 | 69583 | 4 | 1.970 | 35321.3 |
541 | 2025-08-27 21:38:09 | surname | 1 | 69583 | 4 | 1.233 | 56433.9 |
540 | 2025-08-27 06:58:39 | surname | 1 | 69583 | 4 | 1.436 | 48456.1 |
539 | 2025-08-24 00:59:18 | surname | 1 | 69583 | 4 | 1.266 | 54962.9 |
538 | 2025-08-24 00:55:30 | surname | 1 | 69583 | 4 | 1.360 | 51164.0 |
537 | 2025-08-22 04:00:05 | surname | 1 | 69583 | 4 | 1.126 | 61796.6 |
536 | 2025-08-12 21:46:22 | surname | 1 | 69583 | 4 | 6.220 | 11187.0 |
535 | 2025-08-03 20:41:17 | surname | 3 | 134027 | 153 | 40.596 | 3301.5 |
534 | 2025-08-03 16:18:04 | surname | 2 | 107671 | 9 | 10.876 | 9899.9 |
533 | 2025-08-03 16:17:11 | surname | 2 | 107671 | 9 | 10.720 | 10043.9 |
532 | 2025-07-31 08:33:00 | surname | 1 | 69583 | 4 | 6.326 | 10999.5 |
531 | 2025-07-31 07:26:34 | surname | 2 | 107671 | 9 | 3.280 | 32826.5 |
530 | 2025-07-30 18:42:40 | surname | 3 | 134027 | 153 | 7.500 | 17870.3 |
529 | 2025-07-30 13:45:03 | surname | 3 | 134027 | 153 | 6.653 | 20145.3 |
528 | 2025-07-25 17:52:56 | surname | 1 | 69583 | 4 | 4.236 | 16426.6 |
527 | 2025-07-25 11:41:41 | surname | 3 | 134027 | 153 | 28.656 | 4677.1 |
526 | 2025-07-22 23:23:44 | surname | 1 | 69583 | 4 | 2.983 | 23326.5 |
525 | 2025-07-20 22:41:42 | surname | 1 | 69583 | 4 | 1.406 | 49490.0 |
524 | 2025-07-19 08:46:36 | surname | 1 | 69583 | 4 | 1.266 | 54962.9 |
523 | 2025-06-20 04:34:23 | surname | 1 | 69583 | 4 | 5.836 | 11923.1 |
522 | 2025-06-06 17:26:49 | surname | 3 | 134027 | 153 | 16.013 | 8369.9 |
521 | 2025-06-06 13:53:25 | surname | 2 | 107671 | 9 | 9.906 | 10869.3 |
520 | 2025-06-05 10:15:05 | surname | 1 | 69583 | 4 | 7.843 | 8872.0 |
519 | 2025-05-31 20:25:04 | surname | 1 | 69583 | 4 | 6.050 | 11501.3 |
518 | 2025-05-04 22:14:37 | surname | 1 | 69583 | 4 | 5.906 | 11781.7 |
517 | 2025-04-26 10:41:35 | surname | 2 | 107671 | 9 | 8.686 | 12395.9 |
516 | 2025-04-25 02:47:20 | surname | 1 | 69583 | 4 | 1.236 | 56296.9 |
515 | 2025-04-23 03:37:23 | surname | 1 | 69583 | 4 | 3.080 | 22591.9 |
514 | 2025-04-13 03:28:09 | surname | 1 | 69583 | 4 | 1.313 | 52995.4 |
513 | 2025-03-29 21:05:15 | surname | 1 | 69583 | 4 | 3.686 | 18877.6 |
512 | 2025-03-20 12:39:29 | surname | 1 | 69583 | 4 | 5.873 | 11847.9 |
511 | 2025-03-20 05:03:24 | surname | 1 | 69583 | 4 | 5.076 | 13708.2 |
510 | 2025-03-07 09:48:42 | surname | 1 | 69583 | 4 | 6.530 | 10655.9 |
509 | 2025-03-05 23:21:13 | surname | 1 | 69583 | 4 | 2.843 | 24475.2 |
508 | 2025-03-02 01:02:51 | surname | 1 | 69583 | 4 | 3.000 | 23194.3 |
507 | 2025-02-19 18:35:48 | surname | 1 | 69583 | 4 | 5.503 | 12644.6 |
506 | 2025-01-25 23:42:47 | surname | 1 | 69583 | 4 | 2.906 | 23944.6 |
505 | 2025-01-25 03:05:00 | surname | 1 | 69583 | 4 | 1.203 | 57841.2 |
504 | 2025-01-18 08:48:44 | surname | 1 | 69583 | 4 | 4.470 | 15566.7 |
503 | 2024-12-29 03:59:28 | surname | 1 | 69583 | 4 | 3.500 | 19880.9 |
502 | 2024-12-26 08:19:54 | surname | 1 | 69583 | 4 | 6.296 | 11051.9 |
501 | 2024-12-13 14:39:31 | surname | 1 | 69583 | 4 | 2.563 | 27149.0 |
500 | 2024-12-13 14:23:17 | surname | 1 | 69583 | 4 | 6.166 | 11284.9 |
499 | 2024-11-28 15:22:32 | surname | 1 | 69583 | 4 | 8.016 | 8680.5 |
498 | 2024-11-17 06:18:29 | surname | 1 | 69583 | 4 | 3.780 | 18408.2 |
497 | 2024-11-11 10:51:18 | surname | 1 | 69583 | 4 | 1.313 | 52995.4 |
496 | 2024-10-25 10:48:35 | surname | 1 | 69583 | 4 | 6.030 | 11539.5 |
495 | 2024-10-17 04:12:46 | surname | 1 | 69583 | 4 | 6.970 | 9983.2 |
494 | 2024-10-12 07:07:49 | surname | 1 | 69583 | 4 | 5.576 | 12479.0 |
493 | 2024-09-21 19:22:21 | surname | 1 | 69583 | 4 | 4.470 | 15566.7 |
492 | 2024-09-21 00:46:36 | surname | 1 | 69583 | 4 | 12.810 | 5431.9 |
491 | 2024-09-03 16:09:58 | surname | 3 | 134027 | 153 | 57.770 | 2320.0 |
490 | 2024-09-01 00:46:22 | surname | 3 | 134027 | 153 | 65.973 | 2031.5 |
489 | 2024-08-31 16:47:42 | surname | 3 | 134027 | 153 | 79.286 | 1690.4 |
488 | 2024-08-31 07:40:04 | surname | 2 | 107671 | 9 | 17.203 | 6258.9 |
487 | 2024-08-31 06:10:35 | surname | 3 | 134027 | 153 | 67.363 | 1989.6 |
486 | 2024-08-31 06:10:34 | surname | 2 | 107671 | 9 | 31.096 | 3462.5 |
485 | 2024-08-28 12:28:59 | surname | 1 | 69583 | 4 | 9.623 | 7230.9 |
484 | 2024-08-14 05:25:44 | surname | 1 | 69583 | 4 | 4.250 | 16372.5 |
483 | 2024-08-12 06:08:13 | surname | 1 | 69583 | 4 | 8.343 | 8340.3 |
482 | 2024-07-31 04:48:22 | surname | 1 | 69583 | 4 | 5.546 | 12546.5 |
481 | 2024-07-30 15:13:09 | surname | 1 | 69583 | 4 | 4.030 | 17266.3 |
480 | 2024-07-30 02:43:33 | surname | 1 | 69583 | 4 | 3.490 | 19937.8 |
479 | 2024-07-20 13:30:59 | surname | 1 | 69583 | 4 | 4.643 | 14986.6 |
478 | 2024-07-17 00:21:17 | surname | 1 | 69583 | 4 | 4.000 | 17395.8 |
477 | 2024-07-16 13:23:56 | surname | 1 | 69583 | 4 | 3.263 | 21324.9 |
476 | 2024-07-11 21:52:36 | surname | 3 | 134027 | 153 | 35.766 | 3747.3 |
475 | 2024-07-11 07:24:38 | surname | 3 | 134027 | 153 | 32.596 | 4111.8 |
474 | 2024-07-11 01:57:56 | surname | 3 | 134027 | 153 | 31.986 | 4190.2 |
473 | 2024-07-11 01:57:57 | surname | 2 | 107671 | 9 | 18.266 | 5894.6 |
472 | 2024-07-11 01:57:24 | surname | 1 | 69583 | 4 | 2.593 | 26834.9 |
471 | 2024-07-06 09:09:14 | surname | 1 | 69583 | 4 | 5.906 | 11781.7 |
470 | 2024-06-29 05:38:32 | surname | 1 | 69583 | 4 | 5.876 | 11841.9 |
469 | 2024-06-14 05:44:25 | surname | 1 | 69583 | 4 | 6.343 | 10970.0 |
468 | 2024-06-11 10:24:00 | surname | 1 | 69583 | 4 | 2.470 | 28171.3 |
467 | 2024-06-08 08:56:12 | surname | 1 | 69583 | 4 | 5.186 | 13417.5 |
466 | 2024-06-03 00:48:17 | surname | 1 | 69583 | 4 | 4.173 | 16674.6 |
465 | 2024-05-29 16:14:29 | surname | 1 | 69583 | 4 | 6.046 | 11508.9 |
464 | 2024-05-29 05:57:17 | surname | 1 | 69583 | 4 | 5.233 | 13297.0 |
463 | 2024-05-06 21:14:13 | surname | 2 | 107671 | 9 | 7.763 | 13869.8 |
462 | 2024-05-06 21:14:08 | surname | 1 | 69583 | 4 | 2.720 | 25582.0 |
461 | 2024-05-06 21:13:52 | surname | 3 | 134027 | 153 | 8.876 | 15099.9 |
460 | 2024-05-06 15:16:21 | surname | 3 | 134027 | 153 | 12.530 | 10696.5 |
459 | 2024-05-06 15:12:33 | surname | 3 | 134027 | 153 | 16.003 | 8375.1 |
458 | 2024-05-06 05:55:08 | surname | 3 | 134027 | 153 | 7.660 | 17497.0 |
457 | 2024-05-04 21:47:44 | surname | 1 | 69583 | 4 | 1.546 | 45008.4 |
456 | 2024-04-26 05:35:28 | surname | 1 | 69583 | 4 | 1.470 | 47335.4 |
455 | 2024-03-15 05:54:19 | surname | 2 | 107671 | 9 | 3.483 | 30913.3 |
454 | 2024-03-15 05:54:08 | surname | 3 | 134027 | 153 | 7.516 | 17832.2 |
453 | 2024-03-13 17:40:56 | surname | 3 | 134027 | 153 | 16.546 | 8100.3 |
452 | 2024-03-11 18:28:58 | surname | 3 | 134027 | 153 | 6.660 | 20124.2 |
451 | 2024-02-17 08:41:17 | surname | 1 | 69583 | 4 | 1.126 | 61796.6 |
450 | 2023-12-27 23:16:04 | surname | 3 | 134027 | 153 | 6.580 | 20368.8 |
449 | 2023-12-22 16:51:39 | surname | 3 | 134027 | 153 | 7.173 | 18684.9 |
448 | 2023-12-12 16:49:03 | surname | 1 | 69583 | 4 | 1.343 | 51811.6 |