History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gaffer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
575 | 2025-07-15 21:52:42 | gaffer | 1 | 48755 | 8 | 1.966 | 24799.1 |
574 | 2025-07-11 08:24:19 | gaffer | 2 | 82551 | 78 | 16.750 | 4928.4 |
573 | 2025-07-10 09:28:37 | gaffer | 1 | 48755 | 8 | 3.220 | 15141.3 |
572 | 2025-07-05 11:56:40 | gaffer | 2 | 82551 | 78 | 7.220 | 11433.7 |
571 | 2025-07-02 00:00:16 | gaffer | 1 | 48755 | 8 | 4.936 | 9877.4 |
570 | 2025-06-30 09:47:51 | gaffer | 3 | 112716 | 849 | 40.240 | 2801.1 |
569 | 2025-06-29 16:53:14 | gaffer | 2 | 82551 | 78 | 2.296 | 35954.3 |
568 | 2025-06-29 13:10:50 | gaffer | 3 | 112716 | 849 | 4.610 | 24450.3 |
567 | 2025-06-28 01:05:11 | gaffer | 3 | 112716 | 849 | 31.773 | 3547.5 |
566 | 2025-06-27 20:44:38 | gaffer | 3 | 112716 | 849 | 7.313 | 15413.1 |
565 | 2025-06-27 01:10:06 | gaffer | 3 | 112716 | 849 | 27.723 | 4065.8 |
564 | 2025-06-26 00:56:44 | gaffer | 3 | 112716 | 849 | 18.173 | 6202.4 |
563 | 2025-06-25 14:57:00 | gaffer | 3 | 112716 | 849 | 12.016 | 9380.5 |
562 | 2025-06-24 10:28:18 | gaffer | 3 | 112716 | 849 | 28.703 | 3927.0 |
561 | 2025-06-22 22:12:34 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
560 | 2025-06-18 19:54:00 | gaffer | 1 | 48755 | 8 | 0.890 | 54780.9 |
559 | 2025-06-10 00:58:48 | gaffer | 1 | 48755 | 8 | 4.046 | 12050.2 |
558 | 2025-06-07 09:21:20 | gaffer | 1 | 48755 | 8 | 0.766 | 63648.8 |
557 | 2025-06-05 14:58:10 | gaffer | 1 | 48755 | 8 | 6.423 | 7590.7 |
556 | 2025-05-27 11:34:02 | gaffer | 1 | 48755 | 8 | 5.893 | 8273.4 |
555 | 2025-05-26 01:49:22 | gaffer | 3 | 112716 | 849 | 21.143 | 5331.1 |
554 | 2025-05-25 21:30:42 | gaffer | 3 | 112716 | 849 | 19.796 | 5693.9 |
553 | 2025-05-25 16:51:37 | gaffer | 2 | 82551 | 78 | 2.576 | 32046.2 |
552 | 2025-05-24 15:05:27 | gaffer | 3 | 112716 | 849 | 28.813 | 3912.0 |
551 | 2025-05-24 11:30:48 | gaffer | 2 | 82551 | 78 | 11.610 | 7110.3 |
550 | 2025-05-22 22:26:41 | gaffer | 1 | 48755 | 8 | 0.923 | 52822.3 |
549 | 2025-05-22 10:28:43 | gaffer | 3 | 112716 | 849 | 17.346 | 6498.1 |
548 | 2025-05-20 07:23:09 | gaffer | 1 | 48755 | 8 | 2.500 | 19502.0 |
547 | 2025-05-20 01:06:22 | gaffer | 3 | 112716 | 849 | 30.080 | 3747.2 |
546 | 2025-05-19 07:44:05 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
545 | 2025-05-19 07:43:48 | gaffer | 3 | 112716 | 849 | 5.200 | 21676.2 |
544 | 2025-05-18 13:46:42 | gaffer | 1 | 48755 | 8 | 4.296 | 11348.9 |
543 | 2025-05-17 05:08:02 | gaffer | 1 | 48755 | 8 | 3.140 | 15527.1 |
542 | 2025-05-17 04:36:29 | gaffer | 1 | 48755 | 8 | 5.923 | 8231.5 |
541 | 2025-05-16 05:28:21 | gaffer | 1 | 48755 | 8 | 5.483 | 8892.0 |
540 | 2025-05-10 01:30:11 | gaffer | 1 | 48755 | 8 | 2.470 | 19738.9 |
539 | 2025-05-04 07:54:24 | gaffer | 1 | 48755 | 8 | 2.000 | 24377.5 |
538 | 2025-04-29 08:18:45 | gaffer | 1 | 48755 | 8 | 0.846 | 57630.0 |
537 | 2025-04-26 00:16:36 | gaffer | 3 | 112716 | 849 | 27.316 | 4126.4 |
536 | 2025-04-24 14:05:01 | gaffer | 3 | 112716 | 849 | 20.403 | 5524.5 |
535 | 2025-04-23 20:45:39 | gaffer | 3 | 112716 | 849 | 27.596 | 4084.5 |
534 | 2025-04-22 21:39:15 | gaffer | 1 | 48755 | 8 | 4.796 | 10165.8 |
533 | 2025-04-22 18:14:30 | gaffer | 3 | 112716 | 849 | 5.326 | 21163.3 |
532 | 2025-04-22 15:04:07 | gaffer | 1 | 48755 | 8 | 0.813 | 59969.2 |
531 | 2025-04-16 02:43:04 | gaffer | 1 | 48755 | 8 | 2.236 | 21804.6 |
530 | 2025-04-13 18:10:13 | gaffer | 1 | 48755 | 8 | 0.826 | 59025.4 |
529 | 2025-04-09 01:18:09 | gaffer | 1 | 48755 | 8 | 4.143 | 11768.0 |
528 | 2025-03-31 05:54:52 | gaffer | 1 | 48755 | 8 | 3.970 | 12280.9 |
527 | 2025-03-29 09:42:23 | gaffer | 1 | 48755 | 8 | 2.983 | 16344.3 |
526 | 2025-03-19 06:49:23 | gaffer | 1 | 48755 | 8 | 0.860 | 56691.9 |
525 | 2025-03-16 05:04:31 | gaffer | 1 | 48755 | 8 | 2.563 | 19022.6 |
524 | 2025-03-15 14:06:12 | gaffer | 1 | 48755 | 8 | 3.690 | 13212.7 |
523 | 2025-03-15 08:30:10 | gaffer | 1 | 48755 | 8 | 3.656 | 13335.6 |
522 | 2025-03-09 05:10:35 | gaffer | 1 | 48755 | 8 | 6.080 | 8018.9 |
521 | 2025-02-28 13:07:12 | gaffer | 3 | 112716 | 849 | 26.280 | 4289.0 |
520 | 2025-02-28 09:11:25 | gaffer | 3 | 112716 | 849 | 18.280 | 6166.1 |
519 | 2025-02-28 08:43:59 | gaffer | 3 | 112716 | 849 | 21.020 | 5362.3 |
518 | 2025-02-28 08:43:58 | gaffer | 2 | 82551 | 78 | 10.890 | 7580.4 |
517 | 2025-02-28 08:44:00 | gaffer | 1 | 48755 | 8 | 3.643 | 13383.2 |
516 | 2025-02-25 07:14:33 | gaffer | 1 | 48755 | 8 | 3.843 | 12686.7 |
515 | 2025-02-11 14:14:50 | gaffer | 1 | 48755 | 8 | 3.873 | 12588.4 |
514 | 2025-02-10 06:46:36 | gaffer | 2 | 82551 | 78 | 18.190 | 4538.3 |
513 | 2025-02-09 07:44:26 | gaffer | 3 | 112716 | 849 | 4.983 | 22620.1 |
512 | 2025-02-09 07:44:25 | gaffer | 2 | 82551 | 78 | 2.280 | 36206.6 |
511 | 2025-02-09 07:43:56 | gaffer | 1 | 48755 | 8 | 0.813 | 59969.2 |
510 | 2025-02-04 11:45:21 | gaffer | 1 | 48755 | 8 | 3.123 | 15611.6 |
509 | 2025-01-29 20:09:43 | gaffer | 2 | 82551 | 78 | 9.110 | 9061.6 |
508 | 2025-01-28 11:51:29 | gaffer | 3 | 112716 | 849 | 25.516 | 4417.5 |
507 | 2025-01-28 11:45:21 | gaffer | 3 | 112716 | 849 | 14.140 | 7971.4 |
506 | 2025-01-28 10:47:37 | gaffer | 3 | 112716 | 849 | 21.596 | 5219.3 |
505 | 2025-01-28 10:47:33 | gaffer | 2 | 82551 | 78 | 12.156 | 6791.0 |
504 | 2025-01-28 10:47:19 | gaffer | 1 | 48755 | 8 | 2.406 | 20263.9 |
503 | 2025-01-25 13:46:39 | gaffer | 1 | 48755 | 8 | 4.046 | 12050.2 |
502 | 2025-01-09 15:21:04 | gaffer | 1 | 48755 | 8 | 2.063 | 23633.1 |
501 | 2025-01-05 06:35:44 | gaffer | 1 | 48755 | 8 | 2.500 | 19502.0 |
500 | 2024-12-28 05:12:36 | gaffer | 1 | 48755 | 8 | 4.000 | 12188.8 |
499 | 2024-12-13 03:46:59 | gaffer | 3 | 112716 | 849 | 15.330 | 7352.6 |
498 | 2024-12-06 15:20:14 | gaffer | 2 | 82551 | 78 | 16.296 | 5065.7 |
497 | 2024-12-06 06:01:49 | gaffer | 2 | 82551 | 78 | 5.763 | 14324.3 |
496 | 2024-12-06 06:01:43 | gaffer | 1 | 48755 | 8 | 3.686 | 13227.1 |
495 | 2024-11-27 11:44:32 | gaffer | 1 | 48755 | 8 | 2.783 | 17518.9 |
494 | 2024-11-26 20:19:22 | gaffer | 3 | 112716 | 849 | 41.146 | 2739.4 |
493 | 2024-11-26 09:40:39 | gaffer | 2 | 82551 | 78 | 15.296 | 5396.9 |
492 | 2024-11-25 18:43:29 | gaffer | 3 | 112716 | 849 | 22.360 | 5041.0 |
491 | 2024-11-25 11:24:11 | gaffer | 3 | 112716 | 849 | 25.986 | 4337.6 |
490 | 2024-11-25 11:04:03 | gaffer | 3 | 112716 | 849 | 22.970 | 4907.1 |
489 | 2024-11-25 11:04:03 | gaffer | 2 | 82551 | 78 | 17.796 | 4638.7 |
488 | 2024-11-25 11:03:53 | gaffer | 1 | 48755 | 8 | 2.263 | 21544.4 |
487 | 2024-11-09 07:13:30 | gaffer | 1 | 48755 | 8 | 4.170 | 11691.8 |
486 | 2024-11-07 16:49:12 | gaffer | 1 | 48755 | 8 | 1.716 | 28412.0 |
485 | 2024-11-06 06:03:00 | gaffer | 1 | 48755 | 8 | 6.140 | 7940.6 |
484 | 2024-10-28 08:33:14 | gaffer | 1 | 48755 | 8 | 3.140 | 15527.1 |
483 | 2024-10-25 13:18:25 | gaffer | 1 | 48755 | 8 | 4.300 | 11338.4 |
482 | 2024-10-11 15:09:31 | gaffer | 2 | 82551 | 78 | 8.393 | 9835.7 |
481 | 2024-10-11 12:18:37 | gaffer | 3 | 112716 | 849 | 27.406 | 4112.8 |
480 | 2024-10-10 18:54:12 | gaffer | 3 | 112716 | 849 | 32.563 | 3461.5 |
479 | 2024-10-10 15:15:44 | gaffer | 2 | 82551 | 78 | 7.360 | 11216.2 |
478 | 2024-10-10 13:43:06 | gaffer | 3 | 112716 | 849 | 5.673 | 19868.9 |
477 | 2024-10-10 04:34:45 | gaffer | 3 | 112716 | 849 | 28.266 | 3987.7 |
476 | 2024-10-10 04:34:41 | gaffer | 2 | 82551 | 78 | 15.280 | 5402.6 |