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 |
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 |
447 | 2023-12-02 04:25:19 | surname | 1 | 69583 | 4 | 1.123 | 61961.7 |
446 | 2023-11-27 04:07:28 | surname | 3 | 134027 | 153 | 5.936 | 22578.7 |
445 | 2023-11-19 10:09:47 | surname | 1 | 69583 | 4 | 1.250 | 55666.4 |
444 | 2023-11-12 13:49:13 | surname | 3 | 134027 | 153 | 5.893 | 22743.4 |
443 | 2023-11-06 11:54:52 | surname | 1 | 69583 | 4 | 1.233 | 56433.9 |
442 | 2023-11-05 13:43:44 | surname | 2 | 107671 | 9 | 3.186 | 33795.0 |
441 | 2023-11-05 13:38:20 | surname | 1 | 69583 | 4 | 1.216 | 57222.9 |
440 | 2023-10-26 10:47:31 | surname | 3 | 134027 | 153 | 8.986 | 14915.1 |
439 | 2023-10-21 14:45:57 | surname | 3 | 134027 | 153 | 6.016 | 22278.4 |
438 | 2023-10-19 18:39:54 | surname | 3 | 134027 | 153 | 12.560 | 10670.9 |
437 | 2023-10-17 23:59:39 | surname | 3 | 134027 | 153 | 6.140 | 21828.5 |
436 | 2023-10-16 21:45:32 | surname | 3 | 134027 | 153 | 7.046 | 19021.7 |
435 | 2023-10-14 19:46:25 | surname | 3 | 134027 | 153 | 7.343 | 18252.3 |
434 | 2023-10-14 14:55:22 | surname | 3 | 134027 | 153 | 5.970 | 22450.1 |
433 | 2023-10-14 02:05:59 | surname | 1 | 69583 | 4 | 1.140 | 61037.7 |
432 | 2023-10-10 01:10:44 | surname | 3 | 134027 | 153 | 6.500 | 20619.5 |
431 | 2023-09-26 09:37:19 | surname | 1 | 69583 | 4 | 1.203 | 57841.2 |
430 | 2023-09-23 06:39:12 | surname | 1 | 69583 | 4 | 1.096 | 63488.1 |
429 | 2023-09-23 04:29:42 | surname | 3 | 134027 | 153 | 6.876 | 19492.0 |
428 | 2023-09-17 05:08:54 | surname | 1 | 69583 | 4 | 1.220 | 57035.2 |
427 | 2023-08-27 16:49:06 | surname | 3 | 134027 | 153 | 5.813 | 23056.4 |
426 | 2023-08-26 14:40:12 | surname | 3 | 134027 | 153 | 6.873 | 19500.5 |
425 | 2023-07-07 03:42:22 | surname | 1 | 69583 | 4 | 1.173 | 59320.5 |
424 | 2023-05-14 12:48:42 | surname | 3 | 134027 | 153 | 6.500 | 20619.5 |
423 | 2023-05-13 15:56:44 | surname | 3 | 134027 | 153 | 5.876 | 22809.2 |
422 | 2023-04-11 19:00:43 | surname | 1 | 69583 | 4 | 1.250 | 55666.4 |
421 | 2023-04-04 14:22:42 | surname | 3 | 134027 | 153 | 6.940 | 19312.2 |
420 | 2023-02-19 23:11:58 | surname | 3 | 134027 | 153 | 6.186 | 21666.2 |
419 | 2023-02-01 12:14:37 | surname | 1 | 69583 | 4 | 1.266 | 54962.9 |