History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"heriot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
551 | 2025-06-30 16:25:30 | heriot | 3 | 112716 | 453 | 25.330 | 4449.9 |
550 | 2025-06-29 20:30:34 | heriot | 3 | 112716 | 453 | 22.266 | 5062.2 |
549 | 2025-06-28 05:53:45 | heriot | 3 | 112716 | 453 | 43.270 | 2604.9 |
548 | 2025-06-28 02:52:58 | heriot | 2 | 82551 | 32 | 6.406 | 12886.5 |
547 | 2025-06-26 20:22:11 | heriot | 1 | 48755 | 2 | 4.250 | 11471.8 |
546 | 2025-06-25 21:48:06 | heriot | 1 | 48755 | 2 | 4.780 | 10199.8 |
545 | 2025-06-24 23:30:08 | heriot | 1 | 48755 | 2 | 2.266 | 21515.9 |
544 | 2025-06-24 02:45:06 | heriot | 1 | 48755 | 2 | 4.250 | 11471.8 |
543 | 2025-06-23 22:45:24 | heriot | 1 | 48755 | 2 | 3.763 | 12956.4 |
542 | 2025-06-19 19:24:10 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
541 | 2025-06-14 17:50:27 | heriot | 1 | 48755 | 2 | 4.373 | 11149.1 |
540 | 2025-06-12 01:29:00 | heriot | 1 | 48755 | 2 | 2.300 | 21197.8 |
539 | 2025-06-10 09:40:40 | heriot | 1 | 48755 | 2 | 2.186 | 22303.3 |
538 | 2025-06-07 19:03:11 | heriot | 1 | 48755 | 2 | 1.970 | 24748.7 |
537 | 2025-06-02 02:59:51 | heriot | 1 | 48755 | 2 | 4.123 | 11825.1 |
536 | 2025-05-28 01:58:11 | heriot | 2 | 82551 | 32 | 2.390 | 34540.2 |
535 | 2025-05-27 23:06:02 | heriot | 3 | 112716 | 453 | 6.360 | 17722.6 |
534 | 2025-05-27 14:29:38 | heriot | 1 | 48755 | 2 | 2.626 | 18566.3 |
533 | 2025-05-22 02:46:10 | heriot | 1 | 48755 | 2 | 2.190 | 22262.6 |
532 | 2025-05-20 23:47:30 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
531 | 2025-05-17 22:48:37 | heriot | 1 | 48755 | 2 | 6.406 | 7610.8 |
530 | 2025-05-16 02:03:46 | heriot | 2 | 82551 | 32 | 17.563 | 4700.3 |
529 | 2025-05-15 05:56:17 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
528 | 2025-05-12 01:10:42 | heriot | 1 | 48755 | 2 | 3.766 | 12946.1 |
527 | 2025-05-11 15:49:14 | heriot | 1 | 48755 | 2 | 0.906 | 53813.5 |
526 | 2025-05-11 00:48:58 | heriot | 3 | 112716 | 453 | 26.983 | 4177.3 |
525 | 2025-05-11 00:37:58 | heriot | 3 | 112716 | 453 | 28.393 | 3969.9 |
524 | 2025-05-09 20:34:28 | heriot | 3 | 112716 | 453 | 28.876 | 3903.4 |
523 | 2025-05-08 22:41:26 | heriot | 2 | 82551 | 32 | 11.220 | 7357.5 |
522 | 2025-05-08 22:22:26 | heriot | 3 | 112716 | 453 | 6.013 | 18745.4 |
521 | 2025-05-07 09:50:54 | heriot | 1 | 48755 | 2 | 0.846 | 57630.0 |
520 | 2025-05-06 13:00:05 | heriot | 1 | 48755 | 2 | 3.640 | 13394.2 |
519 | 2025-05-02 02:42:45 | heriot | 1 | 48755 | 2 | 2.530 | 19270.8 |
518 | 2025-04-21 18:42:17 | heriot | 1 | 48755 | 2 | 2.203 | 22131.2 |
517 | 2025-04-20 01:35:27 | heriot | 1 | 48755 | 2 | 4.343 | 11226.1 |
516 | 2025-04-14 06:20:08 | heriot | 1 | 48755 | 2 | 3.936 | 12386.9 |
515 | 2025-04-09 03:04:13 | heriot | 2 | 82551 | 32 | 12.050 | 6850.7 |
514 | 2025-04-08 01:00:00 | heriot | 2 | 82551 | 32 | 11.300 | 7305.4 |
513 | 2025-04-08 00:46:26 | heriot | 3 | 112716 | 453 | 17.000 | 6630.4 |
512 | 2025-04-07 14:29:39 | heriot | 3 | 112716 | 453 | 9.126 | 12351.1 |
511 | 2025-04-06 12:27:54 | heriot | 1 | 48755 | 2 | 3.486 | 13985.9 |
510 | 2025-04-06 09:55:20 | heriot | 1 | 48755 | 2 | 4.033 | 12089.0 |
509 | 2025-04-06 00:55:04 | heriot | 1 | 48755 | 2 | 3.763 | 12956.4 |
508 | 2025-04-05 03:01:20 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
507 | 2025-04-03 22:31:25 | heriot | 3 | 112716 | 453 | 29.486 | 3822.7 |
506 | 2025-04-03 21:23:56 | heriot | 2 | 82551 | 32 | 16.186 | 5100.1 |
505 | 2025-04-03 02:13:32 | heriot | 2 | 82551 | 32 | 2.563 | 32208.7 |
504 | 2025-04-01 22:14:28 | heriot | 2 | 82551 | 32 | 18.706 | 4413.1 |
503 | 2025-04-01 20:51:04 | heriot | 3 | 112716 | 453 | 31.666 | 3559.5 |
502 | 2025-04-01 18:02:24 | heriot | 3 | 112716 | 453 | 5.156 | 21861.1 |
501 | 2025-04-01 03:41:06 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
500 | 2025-03-19 02:34:39 | heriot | 1 | 48755 | 2 | 0.813 | 59969.2 |
499 | 2025-03-15 12:01:04 | heriot | 1 | 48755 | 2 | 2.703 | 18037.4 |
498 | 2025-03-13 09:17:23 | heriot | 1 | 48755 | 2 | 4.186 | 11647.2 |
497 | 2025-03-11 02:27:08 | heriot | 3 | 112716 | 453 | 17.876 | 6305.4 |
496 | 2025-03-05 20:51:43 | heriot | 1 | 48755 | 2 | 4.216 | 11564.3 |
495 | 2025-03-05 20:18:42 | heriot | 3 | 112716 | 453 | 27.173 | 4148.1 |
494 | 2025-03-05 12:06:42 | heriot | 1 | 48755 | 2 | 4.186 | 11647.2 |
493 | 2025-03-05 03:25:14 | heriot | 3 | 112716 | 453 | 28.313 | 3981.1 |
492 | 2025-03-05 00:26:57 | heriot | 3 | 112716 | 453 | 16.953 | 6648.7 |
491 | 2025-03-04 19:48:49 | heriot | 1 | 48755 | 2 | 3.873 | 12588.4 |
490 | 2025-03-04 08:09:37 | heriot | 2 | 82551 | 32 | 12.233 | 6748.2 |
489 | 2025-03-03 16:16:22 | heriot | 3 | 112716 | 453 | 39.690 | 2839.9 |
488 | 2025-03-03 16:16:21 | heriot | 2 | 82551 | 32 | 9.563 | 8632.3 |
487 | 2025-03-03 16:16:20 | heriot | 1 | 48755 | 2 | 4.000 | 12188.8 |
486 | 2025-03-02 00:07:39 | heriot | 2 | 82551 | 32 | 11.533 | 7157.8 |
485 | 2025-02-27 22:27:07 | heriot | 3 | 112716 | 453 | 26.016 | 4332.6 |
484 | 2025-02-27 21:02:39 | heriot | 1 | 48755 | 2 | 4.186 | 11647.2 |
483 | 2025-02-27 20:26:04 | heriot | 3 | 112716 | 453 | 8.360 | 13482.8 |
482 | 2025-02-27 20:26:02 | heriot | 2 | 82551 | 32 | 2.986 | 27646.0 |
481 | 2025-02-18 14:12:23 | heriot | 3 | 112716 | 453 | 24.910 | 4524.9 |
480 | 2025-02-15 07:02:35 | heriot | 3 | 112716 | 453 | 18.860 | 5976.5 |
479 | 2025-02-06 13:50:41 | heriot | 1 | 48755 | 2 | 4.016 | 12140.2 |
478 | 2025-02-01 08:37:11 | heriot | 1 | 48755 | 2 | 2.190 | 22262.6 |
477 | 2025-01-30 13:48:05 | heriot | 3 | 112716 | 453 | 26.636 | 4231.7 |
476 | 2025-01-30 13:48:09 | heriot | 2 | 82551 | 32 | 6.170 | 13379.4 |
475 | 2025-01-30 13:47:29 | heriot | 1 | 48755 | 2 | 5.246 | 9293.7 |
474 | 2025-01-28 12:41:35 | heriot | 1 | 48755 | 2 | 2.686 | 18151.5 |
473 | 2025-01-27 15:29:57 | heriot | 1 | 48755 | 2 | 2.110 | 23106.6 |
472 | 2025-01-24 01:25:59 | heriot | 3 | 112716 | 453 | 25.156 | 4480.7 |
471 | 2025-01-24 01:26:12 | heriot | 2 | 82551 | 32 | 10.906 | 7569.3 |
470 | 2025-01-23 21:56:00 | heriot | 2 | 82551 | 32 | 17.203 | 4798.6 |
469 | 2025-01-23 21:20:39 | heriot | 3 | 112716 | 453 | 19.143 | 5888.1 |
468 | 2025-01-22 18:30:30 | heriot | 2 | 82551 | 32 | 18.093 | 4562.6 |
467 | 2025-01-22 18:30:23 | heriot | 3 | 112716 | 453 | 17.283 | 6521.8 |
466 | 2024-12-30 13:34:56 | heriot | 1 | 48755 | 2 | 4.033 | 12089.0 |
465 | 2024-11-30 05:41:57 | heriot | 1 | 48755 | 2 | 2.126 | 22932.7 |
464 | 2024-11-02 11:45:29 | heriot | 1 | 48755 | 2 | 3.920 | 12437.5 |
463 | 2024-10-30 11:52:24 | heriot | 1 | 48755 | 2 | 1.920 | 25393.2 |
462 | 2024-10-28 13:44:49 | heriot | 2 | 82551 | 32 | 9.846 | 8384.2 |
461 | 2024-10-28 07:53:07 | heriot | 2 | 82551 | 32 | 12.233 | 6748.2 |
460 | 2024-10-28 03:15:26 | heriot | 2 | 82551 | 32 | 8.266 | 9986.8 |
459 | 2024-10-27 12:51:49 | heriot | 2 | 82551 | 32 | 9.266 | 8909.0 |
458 | 2024-10-27 12:51:49 | heriot | 2 | 82551 | 32 | 6.296 | 13111.7 |
457 | 2024-10-27 12:51:34 | heriot | 1 | 48755 | 2 | 3.783 | 12887.9 |
456 | 2024-10-02 16:34:48 | heriot | 1 | 48755 | 2 | 3.563 | 13683.7 |
455 | 2024-09-28 14:48:36 | heriot | 1 | 48755 | 2 | 3.170 | 15380.1 |
454 | 2024-09-28 12:15:30 | heriot | 1 | 48755 | 2 | 3.750 | 13001.3 |
453 | 2024-09-12 21:14:03 | heriot | 1 | 48755 | 2 | 9.470 | 5148.4 |
452 | 2024-09-02 07:33:50 | heriot | 1 | 48755 | 2 | 2.953 | 16510.3 |