History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
567 | 2024-04-13 14:45:17 | parish | 1 | 48755 | 7 | 0.953 | 51159.5 |
566 | 2024-04-09 20:35:48 | parish | 1 | 48755 | 7 | 1.813 | 26891.9 |
565 | 2024-04-06 06:43:33 | parish | 1 | 48755 | 7 | 2.140 | 22782.7 |
564 | 2024-04-05 00:11:14 | parish | 2 | 82551 | 90 | 6.563 | 12578.2 |
563 | 2024-04-04 07:59:31 | parish | 2 | 82551 | 90 | 5.236 | 15766.0 |
562 | 2024-04-04 07:19:12 | parish | 3 | 112716 | 935 | 5.750 | 19602.8 |
561 | 2024-04-03 15:40:41 | parish | 3 | 112716 | 935 | 16.016 | 7037.7 |
560 | 2024-04-03 13:12:18 | parish | 3 | 112716 | 935 | 16.580 | 6798.3 |
559 | 2024-04-03 10:09:29 | parish | 2 | 82551 | 90 | 9.093 | 9078.5 |
558 | 2024-04-03 08:28:22 | parish | 1 | 48755 | 7 | 0.923 | 52822.3 |
557 | 2024-04-03 08:28:14 | parish | 3 | 112716 | 935 | 5.873 | 19192.2 |
556 | 2024-04-03 08:28:15 | parish | 2 | 82551 | 90 | 2.780 | 29694.6 |
555 | 2024-03-28 21:36:39 | parish | 1 | 48755 | 7 | 2.970 | 16415.8 |
554 | 2024-03-12 09:18:30 | parish | 1 | 48755 | 7 | 1.076 | 45311.3 |
553 | 2024-03-04 16:42:52 | parish | 3 | 112716 | 935 | 18.250 | 6176.2 |
552 | 2024-03-04 14:49:11 | parish | 3 | 112716 | 935 | 11.656 | 9670.2 |
551 | 2024-03-04 08:50:35 | parish | 2 | 82551 | 90 | 5.920 | 13944.4 |
550 | 2024-03-04 07:42:10 | parish | 3 | 112716 | 935 | 6.220 | 18121.5 |
549 | 2024-03-04 07:06:02 | parish | 3 | 112716 | 935 | 16.580 | 6798.3 |
548 | 2024-03-04 07:06:03 | parish | 2 | 82551 | 90 | 3.876 | 21298.0 |
547 | 2024-03-01 12:47:05 | parish | 1 | 48755 | 7 | 0.953 | 51159.5 |
546 | 2024-02-10 13:29:09 | parish | 1 | 48755 | 7 | 0.796 | 61250.0 |
545 | 2024-02-02 23:25:44 | parish | 2 | 82551 | 90 | 2.780 | 29694.6 |
544 | 2024-02-02 23:24:04 | parish | 3 | 112716 | 935 | 6.233 | 18083.7 |
543 | 2024-02-02 07:40:55 | parish | 2 | 82551 | 90 | 2.203 | 37472.1 |
542 | 2024-02-02 07:40:03 | parish | 3 | 112716 | 935 | 5.920 | 19039.9 |
541 | 2024-02-02 01:06:11 | parish | 2 | 82551 | 90 | 2.673 | 30883.3 |
540 | 2024-02-02 01:06:07 | parish | 3 | 112716 | 935 | 5.690 | 19809.5 |
539 | 2024-01-30 05:10:43 | parish | 1 | 48755 | 7 | 0.936 | 52088.7 |
538 | 2024-01-29 06:15:17 | parish | 1 | 48755 | 7 | 1.546 | 31536.2 |
537 | 2023-12-28 06:38:14 | parish | 1 | 48755 | 7 | 0.780 | 62506.4 |
536 | 2023-12-26 00:35:36 | parish | 1 | 48755 | 7 | 0.873 | 55847.7 |
535 | 2023-12-25 04:32:29 | parish | 2 | 82551 | 90 | 2.216 | 37252.3 |
534 | 2023-12-22 14:52:38 | parish | 2 | 82551 | 90 | 2.203 | 37472.1 |
533 | 2023-12-22 04:00:55 | parish | 3 | 112716 | 935 | 5.080 | 22188.2 |
532 | 2023-12-05 08:47:06 | parish | 2 | 82551 | 90 | 2.720 | 30349.6 |
531 | 2023-12-05 08:47:01 | parish | 3 | 112716 | 935 | 6.080 | 18538.8 |
530 | 2023-11-30 08:18:58 | parish | 1 | 48755 | 7 | 0.873 | 55847.7 |
529 | 2023-11-19 08:52:28 | parish | 2 | 82551 | 90 | 2.280 | 36206.6 |
528 | 2023-11-18 06:14:42 | parish | 1 | 48755 | 7 | 0.843 | 57835.1 |
527 | 2023-11-14 14:32:22 | parish | 3 | 112716 | 935 | 5.626 | 20034.8 |
526 | 2023-11-13 01:42:34 | parish | 1 | 48755 | 7 | 1.703 | 28628.9 |
525 | 2023-11-12 18:06:40 | parish | 3 | 112716 | 935 | 5.373 | 20978.2 |
524 | 2023-11-10 11:13:44 | parish | 3 | 112716 | 935 | 4.873 | 23130.7 |
523 | 2023-11-08 17:59:44 | parish | 1 | 48755 | 7 | 0.890 | 54780.9 |
522 | 2023-11-04 16:20:50 | parish | 3 | 112716 | 935 | 4.906 | 22975.1 |
521 | 2023-11-03 05:51:26 | parish | 1 | 48755 | 7 | 0.763 | 63899.1 |
520 | 2023-10-23 05:56:06 | parish | 1 | 48755 | 7 | 0.830 | 58741.0 |
519 | 2023-10-22 11:06:08 | parish | 1 | 48755 | 7 | 0.766 | 63648.8 |
518 | 2023-10-11 06:32:35 | parish | 1 | 48755 | 7 | 0.826 | 59025.4 |
517 | 2023-10-07 19:57:18 | parish | 1 | 48755 | 7 | 0.843 | 57835.1 |
516 | 2023-10-03 23:41:55 | parish | 3 | 112716 | 935 | 10.560 | 10673.9 |
515 | 2023-09-30 00:53:48 | parish | 3 | 112716 | 935 | 9.313 | 12103.1 |
514 | 2023-09-26 09:45:58 | parish | 1 | 48755 | 7 | 1.000 | 48755.0 |
513 | 2023-09-22 14:30:54 | parish | 2 | 82551 | 90 | 2.250 | 36689.3 |
512 | 2023-09-22 12:05:59 | parish | 3 | 112716 | 935 | 5.063 | 22262.7 |
511 | 2023-09-14 17:57:49 | parish | 1 | 48755 | 7 | 0.750 | 65006.7 |
510 | 2023-09-13 16:46:20 | parish | 1 | 48755 | 7 | 0.860 | 56691.9 |
509 | 2023-08-29 12:48:08 | parish | 1 | 48755 | 7 | 0.860 | 56691.9 |
508 | 2023-08-25 23:03:01 | parish | 1 | 48755 | 7 | 1.013 | 48129.3 |
507 | 2023-08-21 06:53:25 | parish | 3 | 112716 | 935 | 4.876 | 23116.5 |
506 | 2023-08-12 06:53:14 | parish | 1 | 48755 | 7 | 0.766 | 63648.8 |
505 | 2023-07-03 11:37:04 | parish | 3 | 112716 | 935 | 5.143 | 21916.4 |
504 | 2023-07-02 04:48:49 | parish | 1 | 48755 | 7 | 0.843 | 57835.1 |
503 | 2023-06-30 19:32:50 | parish | 2 | 82551 | 90 | 2.343 | 35233.0 |
502 | 2023-06-30 07:16:05 | parish | 3 | 112716 | 935 | 5.860 | 19234.8 |
501 | 2023-05-31 06:03:54 | parish | 3 | 112716 | 935 | 4.893 | 23036.2 |
500 | 2023-05-08 19:23:06 | parish | 1 | 48755 | 7 | 0.766 | 63648.8 |
499 | 2023-05-08 10:27:27 | parish | 3 | 112716 | 935 | 4.826 | 23356.0 |
498 | 2023-05-02 17:37:45 | parish | 1 | 48755 | 7 | 0.813 | 59969.2 |
497 | 2023-04-11 07:25:04 | parish | 1 | 48755 | 7 | 0.750 | 65006.7 |
496 | 2023-04-09 05:53:32 | parish | 3 | 112716 | 935 | 5.346 | 21084.2 |
495 | 2023-03-27 13:59:21 | parish | 3 | 112716 | 935 | 6.576 | 17140.5 |
494 | 2023-03-22 13:18:13 | parish | 3 | 112716 | 935 | 4.843 | 23274.0 |
493 | 2023-03-21 18:49:31 | parish | 2 | 82551 | 90 | 2.233 | 36968.7 |
492 | 2023-03-20 14:56:35 | parish | 1 | 48755 | 7 | 0.766 | 63648.8 |
491 | 2023-02-02 18:05:55 | parish | 1 | 48755 | 7 | 0.763 | 63899.1 |
490 | 2023-01-26 12:09:30 | parish | 1 | 48755 | 7 | 0.846 | 57630.0 |
489 | 2022-12-22 13:58:28 | parish | 3 | 112716 | 935 | 4.876 | 23116.5 |
488 | 2022-12-21 12:59:26 | parish | 2 | 82551 | 90 | 2.186 | 37763.5 |
487 | 2022-12-01 00:28:25 | parish | 1 | 48755 | 7 | 0.843 | 57835.1 |
486 | 2022-10-26 06:53:09 | parish | 3 | 112716 | 935 | 4.940 | 22817.0 |
485 | 2022-10-12 04:38:58 | parish | 1 | 48755 | 7 | 0.780 | 62506.4 |
484 | 2022-08-26 15:06:38 | parish | 1 | 48755 | 7 | 0.780 | 62506.4 |
483 | 2022-08-19 22:04:17 | parish | 2 | 82551 | 90 | 2.390 | 34540.2 |
482 | 2022-08-19 04:47:46 | parish | 3 | 112716 | 935 | 4.890 | 23050.3 |
481 | 2022-08-17 12:05:13 | parish | 2 | 82551 | 90 | 2.216 | 37252.3 |
480 | 2022-08-01 04:44:27 | parish | 1 | 48755 | 7 | 0.810 | 60191.4 |
479 | 2022-07-26 05:38:00 | parish | 1 | 48755 | 7 | 0.766 | 63648.8 |
478 | 2022-07-21 17:52:15 | parish | 1 | 48755 | 7 | 0.860 | 56691.9 |
477 | 2022-07-05 18:14:59 | parish | 1 | 48755 | 7 | 0.906 | 53813.5 |
476 | 2022-06-18 02:47:32 | parish | 1 | 48755 | 7 | 0.796 | 61250.0 |
475 | 2022-03-23 04:28:12 | parish | 1 | 48755 | 7 | 1.126 | 43299.3 |
474 | 2022-03-17 05:00:10 | parish | 3 | 112716 | 935 | 5.080 | 22188.2 |
473 | 2022-03-15 19:05:23 | parish | 3 | 112716 | 935 | 4.983 | 22620.1 |
472 | 2022-03-15 15:34:24 | parish | 2 | 82551 | 90 | 2.890 | 28564.4 |
471 | 2022-02-23 18:33:45 | parish | 1 | 48755 | 7 | 0.953 | 51159.5 |
470 | 2022-01-04 12:43:20 | parish | 1 | 48755 | 7 | 1.000 | 48755.0 |
469 | 2022-01-02 08:51:15 | parish | 1 | 48755 | 7 | 0.796 | 61250.0 |
468 | 2022-01-02 04:26:40 | parish | 1 | 48755 | 7 | 0.890 | 54780.9 |