History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"carcel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
584 | 2024-04-24 18:47:42 | carcel | 2 | 82551 | 93 | 3.500 | 23586.0 |
583 | 2024-04-24 18:47:04 | carcel | 3 | 112716 | 980 | 8.563 | 13163.1 |
582 | 2024-04-20 21:45:15 | carcel | 3 | 112716 | 980 | 18.733 | 6017.0 |
581 | 2024-04-20 21:45:16 | carcel | 2 | 82551 | 93 | 10.346 | 7979.0 |
580 | 2024-04-20 21:45:02 | carcel | 1 | 48755 | 9 | 3.093 | 15763.0 |
579 | 2024-03-28 09:51:23 | carcel | 1 | 48755 | 9 | 3.000 | 16251.7 |
578 | 2024-03-21 22:43:38 | carcel | 1 | 48755 | 9 | 0.890 | 54780.9 |
577 | 2024-03-20 19:06:38 | carcel | 1 | 48755 | 9 | 2.483 | 19635.5 |
576 | 2024-03-01 03:09:22 | carcel | 1 | 48755 | 9 | 0.890 | 54780.9 |
575 | 2024-02-29 02:21:03 | carcel | 2 | 82551 | 93 | 2.530 | 32628.9 |
574 | 2024-02-29 02:20:38 | carcel | 3 | 112716 | 980 | 6.110 | 18447.8 |
573 | 2024-02-28 10:23:00 | carcel | 1 | 48755 | 9 | 1.563 | 31193.2 |
572 | 2024-02-26 01:53:42 | carcel | 3 | 112716 | 980 | 15.420 | 7309.7 |
571 | 2024-02-26 01:53:42 | carcel | 2 | 82551 | 93 | 3.093 | 26689.6 |
570 | 2024-02-26 01:40:44 | carcel | 1 | 48755 | 9 | 0.936 | 52088.7 |
569 | 2024-02-22 03:23:33 | carcel | 2 | 82551 | 93 | 2.813 | 29346.2 |
568 | 2024-02-22 03:22:41 | carcel | 3 | 112716 | 980 | 5.783 | 19490.9 |
567 | 2024-02-21 19:40:16 | carcel | 2 | 82551 | 93 | 2.936 | 28116.8 |
566 | 2024-02-21 19:39:35 | carcel | 3 | 112716 | 980 | 9.156 | 12310.6 |
565 | 2024-02-19 21:26:33 | carcel | 3 | 112716 | 980 | 9.970 | 11305.5 |
564 | 2024-02-19 21:26:30 | carcel | 2 | 82551 | 93 | 2.860 | 28864.0 |
563 | 2024-02-19 10:49:46 | carcel | 1 | 48755 | 9 | 0.890 | 54780.9 |
562 | 2024-02-04 10:02:03 | carcel | 1 | 48755 | 9 | 2.890 | 16870.2 |
561 | 2024-01-19 09:32:55 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
560 | 2024-01-14 11:59:06 | carcel | 2 | 82551 | 93 | 2.563 | 32208.7 |
559 | 2023-12-21 18:57:50 | carcel | 3 | 112716 | 980 | 9.750 | 11560.6 |
558 | 2023-12-21 18:57:49 | carcel | 2 | 82551 | 93 | 3.330 | 24790.1 |
557 | 2023-12-15 04:24:39 | carcel | 1 | 48755 | 9 | 0.923 | 52822.3 |
556 | 2023-11-24 19:22:38 | carcel | 3 | 112716 | 980 | 5.060 | 22275.9 |
555 | 2023-11-24 19:22:28 | carcel | 2 | 82551 | 93 | 2.420 | 34112.0 |
554 | 2023-11-21 07:08:00 | carcel | 1 | 48755 | 9 | 0.796 | 61250.0 |
553 | 2023-11-12 01:56:24 | carcel | 1 | 48755 | 9 | 0.856 | 56956.8 |
552 | 2023-11-01 19:13:40 | carcel | 1 | 48755 | 9 | 0.763 | 63899.1 |
551 | 2023-10-27 08:32:46 | carcel | 1 | 48755 | 9 | 0.750 | 65006.7 |
550 | 2023-10-26 08:27:36 | carcel | 1 | 48755 | 9 | 1.670 | 29194.6 |
549 | 2023-10-24 00:31:06 | carcel | 2 | 82551 | 93 | 2.716 | 30394.3 |
548 | 2023-10-22 13:29:19 | carcel | 1 | 48755 | 9 | 1.080 | 45143.5 |
547 | 2023-10-18 21:13:20 | carcel | 1 | 48755 | 9 | 0.860 | 56691.9 |
546 | 2023-10-11 10:16:24 | carcel | 1 | 48755 | 9 | 0.826 | 59025.4 |
545 | 2023-10-08 13:39:24 | carcel | 1 | 48755 | 9 | 0.936 | 52088.7 |
544 | 2023-10-01 03:14:54 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
543 | 2023-09-23 23:53:45 | carcel | 1 | 48755 | 9 | 0.860 | 56691.9 |
542 | 2023-09-18 18:04:34 | carcel | 1 | 48755 | 9 | 0.936 | 52088.7 |
541 | 2023-09-12 20:29:30 | carcel | 1 | 48755 | 9 | 0.766 | 63648.8 |
540 | 2023-08-10 16:05:45 | carcel | 1 | 48755 | 9 | 0.876 | 55656.4 |
539 | 2023-08-03 16:22:06 | carcel | 2 | 82551 | 93 | 2.313 | 35690.0 |
538 | 2023-07-28 14:43:27 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
537 | 2023-07-17 04:17:00 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
536 | 2023-04-25 01:50:57 | carcel | 1 | 48755 | 9 | 0.876 | 55656.4 |
535 | 2023-04-11 06:17:00 | carcel | 2 | 82551 | 93 | 2.440 | 33832.4 |
534 | 2023-04-01 23:36:14 | carcel | 1 | 48755 | 9 | 0.826 | 59025.4 |
533 | 2023-02-13 11:05:42 | carcel | 1 | 48755 | 9 | 0.796 | 61250.0 |
532 | 2023-01-17 20:22:32 | carcel | 2 | 82551 | 93 | 2.203 | 37472.1 |
531 | 2022-12-24 02:51:54 | carcel | 1 | 48755 | 9 | 0.813 | 59969.2 |
530 | 2022-12-10 15:46:57 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
529 | 2022-10-28 03:31:01 | carcel | 2 | 82551 | 93 | 2.546 | 32423.8 |
528 | 2022-09-09 20:16:54 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
527 | 2022-09-01 23:32:06 | carcel | 1 | 48755 | 9 | 0.920 | 52994.6 |
526 | 2022-08-31 16:09:52 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
525 | 2022-08-15 17:35:32 | carcel | 1 | 48755 | 9 | 1.533 | 31803.7 |
524 | 2022-08-14 16:22:11 | carcel | 1 | 48755 | 9 | 0.966 | 50471.0 |
523 | 2022-08-13 06:47:21 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
522 | 2022-08-10 20:55:49 | carcel | 1 | 48755 | 9 | 0.750 | 65006.7 |
521 | 2022-08-06 06:18:26 | carcel | 1 | 48755 | 9 | 0.813 | 59969.2 |
520 | 2022-07-29 06:54:29 | carcel | 1 | 48755 | 9 | 1.063 | 45865.5 |
519 | 2022-05-28 03:51:35 | carcel | 2 | 82551 | 93 | 2.203 | 37472.1 |
518 | 2022-05-21 15:36:48 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
517 | 2022-05-18 05:38:02 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
516 | 2022-03-31 03:03:03 | carcel | 1 | 48755 | 9 | 1.143 | 42655.3 |
515 | 2022-02-09 23:02:57 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
514 | 2022-01-23 01:34:28 | carcel | 2 | 82551 | 93 | 2.500 | 33020.4 |
513 | 2022-01-20 21:20:06 | carcel | 2 | 82551 | 93 | 2.530 | 32628.9 |
512 | 2022-01-03 21:08:48 | carcel | 1 | 48755 | 9 | 1.763 | 27654.6 |
511 | 2022-01-01 18:17:08 | carcel | 1 | 48755 | 9 | 0.890 | 54780.9 |
510 | 2021-11-09 01:05:52 | carcel | 1 | 48755 | 9 | 0.750 | 65006.7 |
509 | 2021-11-02 04:27:17 | carcel | 1 | 48755 | 9 | 0.763 | 63899.1 |
508 | 2021-10-20 19:51:07 | carcel | 2 | 82551 | 93 | 2.280 | 36206.6 |
507 | 2021-09-19 12:19:17 | carcel | 1 | 48755 | 9 | 0.873 | 55847.7 |
506 | 2021-08-26 09:57:09 | carcel | 2 | 82551 | 93 | 2.686 | 30733.8 |
505 | 2021-08-19 23:15:07 | carcel | 1 | 48755 | 9 | 0.876 | 55656.4 |
504 | 2021-08-17 18:09:43 | carcel | 1 | 48755 | 9 | 0.873 | 55847.7 |
503 | 2021-08-09 10:53:48 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
502 | 2021-06-12 02:18:54 | carcel | 1 | 48755 | 9 | 0.906 | 53813.5 |
501 | 2021-04-28 03:50:57 | carcel | 1 | 48755 | 9 | 0.893 | 54596.9 |
500 | 2021-03-21 14:08:10 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
499 | 2021-03-19 05:13:17 | carcel | 3 | 112716 | 980 | 4.923 | 22895.8 |
498 | 2021-03-08 21:59:10 | carcel | 3 | 112716 | 980 | 4.986 | 22606.5 |
497 | 2021-02-22 13:12:00 | carcel | 1 | 48755 | 9 | 0.846 | 57630.0 |
496 | 2021-02-22 01:01:43 | carcel | 3 | 112716 | 980 | 5.140 | 21929.2 |
495 | 2021-02-04 12:38:55 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
494 | 2021-01-31 05:58:46 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
493 | 2021-01-23 13:08:45 | carcel | 1 | 48755 | 9 | 0.843 | 57835.1 |
492 | 2021-01-03 08:20:25 | carcel | 1 | 48755 | 9 | 0.783 | 62266.9 |
491 | 2020-10-29 15:51:18 | carcel | 1 | 48755 | 9 | 1.813 | 26891.9 |
490 | 2020-10-21 16:50:10 | carcel | 1 | 48755 | 9 | 0.780 | 62506.4 |
489 | 2020-09-03 03:40:49 | carcel | 1 | 48755 | 9 | 0.830 | 58741.0 |
488 | 2020-07-25 02:07:18 | carcel | 1 | 48755 | 9 | 1.673 | 29142.3 |
487 | 2020-07-19 18:06:47 | carcel | 1 | 48755 | 9 | 0.810 | 60191.4 |
486 | 2020-07-17 14:36:10 | carcel | 1 | 48755 | 9 | 0.920 | 52994.6 |
485 | 2020-04-17 19:42:08 | carcel | 1 | 48755 | 9 | 1.000 | 48755.0 |