History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prison"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
605 | 2024-04-05 12:00:21 | prison | 1 | 48755 | 6 | 1.046 | 46610.9 |
604 | 2024-04-03 08:13:50 | prison | 1 | 48755 | 6 | 2.156 | 22613.6 |
603 | 2024-03-31 01:33:52 | prison | 1 | 48755 | 6 | 1.953 | 24964.2 |
602 | 2024-03-31 01:24:19 | prison | 3 | 112716 | 525 | 6.686 | 16858.5 |
601 | 2024-03-31 01:10:37 | prison | 3 | 112716 | 525 | 10.283 | 10961.4 |
600 | 2024-03-30 19:04:24 | prison | 3 | 112716 | 525 | 20.050 | 5621.7 |
599 | 2024-03-30 12:22:57 | prison | 2 | 82551 | 51 | 2.313 | 35690.0 |
598 | 2024-03-30 05:41:56 | prison | 3 | 112716 | 525 | 9.046 | 12460.3 |
597 | 2024-03-30 05:41:57 | prison | 2 | 82551 | 51 | 2.686 | 30733.8 |
596 | 2024-03-30 05:41:53 | prison | 1 | 48755 | 6 | 1.826 | 26700.4 |
595 | 2024-03-28 08:25:30 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
594 | 2024-03-17 06:23:56 | prison | 1 | 48755 | 6 | 0.860 | 56691.9 |
593 | 2024-03-04 09:42:06 | prison | 1 | 48755 | 6 | 2.186 | 22303.3 |
592 | 2024-03-02 21:08:48 | prison | 2 | 82551 | 51 | 4.280 | 19287.6 |
591 | 2024-02-29 09:35:23 | prison | 2 | 82551 | 51 | 5.076 | 16263.0 |
590 | 2024-02-29 09:35:04 | prison | 3 | 112716 | 525 | 6.500 | 17340.9 |
589 | 2024-02-29 04:13:29 | prison | 2 | 82551 | 51 | 2.796 | 29524.7 |
588 | 2024-02-29 04:13:09 | prison | 3 | 112716 | 525 | 6.016 | 18736.0 |
587 | 2024-02-29 03:54:42 | prison | 2 | 82551 | 51 | 2.626 | 31436.0 |
586 | 2024-02-29 03:54:19 | prison | 3 | 112716 | 525 | 5.653 | 19939.1 |
585 | 2024-02-29 02:42:32 | prison | 3 | 112716 | 525 | 5.563 | 20261.7 |
584 | 2024-02-29 02:42:29 | prison | 2 | 82551 | 51 | 2.563 | 32208.7 |
583 | 2024-01-16 09:06:55 | prison | 3 | 112716 | 525 | 5.156 | 21861.1 |
582 | 2024-01-16 09:06:53 | prison | 2 | 82551 | 51 | 2.703 | 30540.5 |
581 | 2023-12-24 01:31:45 | prison | 1 | 48755 | 6 | 0.813 | 59969.2 |
580 | 2023-12-20 00:28:51 | prison | 2 | 82551 | 51 | 2.263 | 36478.6 |
579 | 2023-12-17 02:58:34 | prison | 1 | 48755 | 6 | 0.876 | 55656.4 |
578 | 2023-11-18 19:13:47 | prison | 1 | 48755 | 6 | 0.860 | 56691.9 |
577 | 2023-11-17 20:05:56 | prison | 1 | 48755 | 6 | 0.876 | 55656.4 |
576 | 2023-11-13 22:23:45 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
575 | 2023-11-10 19:01:29 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
574 | 2023-10-31 21:40:17 | prison | 1 | 48755 | 6 | 0.890 | 54780.9 |
573 | 2023-10-17 16:39:16 | prison | 1 | 48755 | 6 | 1.720 | 28345.9 |
572 | 2023-10-12 02:08:47 | prison | 1 | 48755 | 6 | 0.873 | 55847.7 |
571 | 2023-10-05 10:27:18 | prison | 1 | 48755 | 6 | 0.780 | 62506.4 |
570 | 2023-10-05 04:27:06 | prison | 1 | 48755 | 6 | 0.753 | 64747.7 |
569 | 2023-09-25 02:03:57 | prison | 1 | 48755 | 6 | 0.843 | 57835.1 |
568 | 2023-09-20 23:08:41 | prison | 2 | 82551 | 51 | 2.486 | 33206.4 |
567 | 2023-09-14 19:48:39 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
566 | 2023-08-14 04:46:07 | prison | 1 | 48755 | 6 | 0.860 | 56691.9 |
565 | 2023-08-09 22:18:47 | prison | 1 | 48755 | 6 | 0.843 | 57835.1 |
564 | 2023-08-08 23:09:48 | prison | 1 | 48755 | 6 | 0.843 | 57835.1 |
563 | 2023-08-04 13:04:06 | prison | 1 | 48755 | 6 | 0.813 | 59969.2 |
562 | 2023-07-23 13:15:33 | prison | 1 | 48755 | 6 | 0.860 | 56691.9 |
561 | 2023-06-30 13:01:28 | prison | 2 | 82551 | 51 | 2.140 | 38575.2 |
560 | 2023-06-19 02:29:36 | prison | 1 | 48755 | 6 | 0.783 | 62266.9 |
559 | 2023-05-21 06:32:01 | prison | 1 | 48755 | 6 | 0.826 | 59025.4 |
558 | 2023-05-01 05:44:27 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
557 | 2023-04-04 09:47:57 | prison | 1 | 48755 | 6 | 1.500 | 32503.3 |
556 | 2023-03-31 19:58:57 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
555 | 2023-03-26 03:44:19 | prison | 2 | 82551 | 51 | 2.123 | 38884.1 |
554 | 2023-03-09 14:40:02 | prison | 1 | 48755 | 6 | 0.733 | 66514.3 |
553 | 2023-02-26 00:50:05 | prison | 1 | 48755 | 6 | 0.733 | 66514.3 |
552 | 2023-01-12 07:02:38 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
551 | 2022-12-24 04:43:19 | prison | 1 | 48755 | 6 | 0.733 | 66514.3 |
550 | 2022-12-23 23:23:04 | prison | 2 | 82551 | 51 | 2.140 | 38575.2 |
549 | 2022-12-12 19:03:44 | prison | 1 | 48755 | 6 | 0.830 | 58741.0 |
548 | 2022-12-02 10:21:17 | prison | 1 | 48755 | 6 | 0.846 | 57630.0 |
547 | 2022-11-28 03:31:06 | prison | 1 | 48755 | 6 | 0.843 | 57835.1 |
546 | 2022-10-16 10:58:57 | prison | 1 | 48755 | 6 | 1.483 | 32875.9 |
545 | 2022-10-12 20:31:51 | prison | 1 | 48755 | 6 | 0.860 | 56691.9 |
544 | 2022-10-11 21:34:01 | prison | 1 | 48755 | 6 | 0.813 | 59969.2 |
543 | 2022-09-11 00:02:44 | prison | 1 | 48755 | 6 | 0.936 | 52088.7 |
542 | 2022-09-09 13:20:29 | prison | 1 | 48755 | 6 | 0.783 | 62266.9 |
541 | 2022-09-08 23:48:56 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
540 | 2022-09-03 04:22:43 | prison | 1 | 48755 | 6 | 0.873 | 55847.7 |
539 | 2022-09-01 20:40:56 | prison | 2 | 82551 | 51 | 2.110 | 39123.7 |
538 | 2022-08-30 00:40:16 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
537 | 2022-08-24 16:42:22 | prison | 1 | 48755 | 6 | 0.846 | 57630.0 |
536 | 2022-08-24 07:29:52 | prison | 1 | 48755 | 6 | 0.733 | 66514.3 |
535 | 2022-08-21 19:40:30 | prison | 2 | 82551 | 51 | 2.140 | 38575.2 |
534 | 2022-08-12 13:52:27 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
533 | 2022-08-08 17:22:05 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
532 | 2022-07-31 01:52:54 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
531 | 2022-07-30 17:51:30 | prison | 1 | 48755 | 6 | 0.906 | 53813.5 |
530 | 2022-07-30 11:27:56 | prison | 1 | 48755 | 6 | 0.783 | 62266.9 |
529 | 2022-07-30 06:10:10 | prison | 1 | 48755 | 6 | 0.736 | 66243.2 |
528 | 2022-07-13 11:27:58 | prison | 1 | 48755 | 6 | 0.733 | 66514.3 |
527 | 2022-07-09 10:14:15 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
526 | 2022-05-26 07:31:35 | prison | 1 | 48755 | 6 | 0.736 | 66243.2 |
525 | 2022-05-21 22:28:08 | prison | 1 | 48755 | 6 | 0.813 | 59969.2 |
524 | 2022-04-17 22:37:56 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
523 | 2022-04-08 03:06:42 | prison | 1 | 48755 | 6 | 1.076 | 45311.3 |
522 | 2022-04-07 19:34:20 | prison | 1 | 48755 | 6 | 1.123 | 43415.0 |
521 | 2022-04-04 16:57:12 | prison | 1 | 48755 | 6 | 1.250 | 39004.0 |
520 | 2022-04-03 05:02:40 | prison | 1 | 48755 | 6 | 0.763 | 63899.1 |
519 | 2022-03-19 12:10:48 | prison | 2 | 82551 | 51 | 2.173 | 37989.4 |
518 | 2022-01-24 03:04:57 | prison | 3 | 112716 | 525 | 6.216 | 18133.2 |
517 | 2022-01-11 12:50:59 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
516 | 2022-01-09 09:16:07 | prison | 1 | 48755 | 6 | 0.893 | 54596.9 |
515 | 2021-12-20 21:32:46 | prison | 1 | 48755 | 6 | 0.890 | 54780.9 |
514 | 2021-11-13 17:26:22 | prison | 1 | 48755 | 6 | 0.936 | 52088.7 |
513 | 2021-11-12 07:05:16 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
512 | 2021-11-11 15:42:14 | prison | 1 | 48755 | 6 | 0.983 | 49598.2 |
511 | 2021-11-10 02:41:56 | prison | 1 | 48755 | 6 | 0.826 | 59025.4 |
510 | 2021-11-09 13:47:20 | prison | 1 | 48755 | 6 | 0.826 | 59025.4 |
509 | 2021-10-01 10:02:15 | prison | 1 | 48755 | 6 | 0.766 | 63648.8 |
508 | 2021-09-10 11:04:07 | prison | 1 | 48755 | 6 | 0.826 | 59025.4 |
507 | 2021-08-31 14:07:02 | prison | 1 | 48755 | 6 | 0.750 | 65006.7 |
506 | 2021-08-29 22:35:54 | prison | 1 | 48755 | 6 | 0.763 | 63899.1 |