History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"amount"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
585 | 2024-04-13 17:35:56 | amount | 3 | 112716 | 313 | 10.016 | 11253.6 |
584 | 2024-04-13 08:00:13 | amount | 2 | 82551 | 26 | 2.640 | 31269.3 |
583 | 2024-04-13 08:00:09 | amount | 3 | 112716 | 313 | 5.780 | 19501.0 |
582 | 2024-04-13 08:00:08 | amount | 2 | 82551 | 26 | 3.703 | 22293.0 |
581 | 2024-04-13 08:00:05 | amount | 1 | 48755 | 3 | 0.893 | 54596.9 |
580 | 2024-04-13 07:59:52 | amount | 3 | 112716 | 313 | 5.530 | 20382.6 |
579 | 2024-04-10 21:06:03 | amount | 3 | 112716 | 313 | 14.126 | 7979.3 |
578 | 2024-04-10 13:31:07 | amount | 3 | 112716 | 313 | 8.546 | 13189.3 |
577 | 2024-04-10 11:55:32 | amount | 3 | 112716 | 313 | 7.800 | 14450.8 |
576 | 2024-03-29 10:56:35 | amount | 1 | 48755 | 3 | 0.876 | 55656.4 |
575 | 2024-03-25 23:07:16 | amount | 1 | 48755 | 3 | 0.890 | 54780.9 |
574 | 2024-03-06 15:33:44 | amount | 1 | 48755 | 3 | 1.300 | 37503.8 |
573 | 2024-02-28 10:24:09 | amount | 1 | 48755 | 3 | 0.953 | 51159.5 |
572 | 2024-01-28 11:25:48 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
571 | 2024-01-15 07:12:35 | amount | 3 | 112716 | 313 | 4.876 | 23116.5 |
570 | 2024-01-15 07:12:33 | amount | 2 | 82551 | 26 | 2.250 | 36689.3 |
569 | 2024-01-13 15:27:27 | amount | 2 | 82551 | 26 | 2.203 | 37472.1 |
568 | 2023-12-30 13:43:02 | amount | 3 | 112716 | 313 | 5.156 | 21861.1 |
567 | 2023-12-30 13:43:04 | amount | 2 | 82551 | 26 | 2.533 | 32590.2 |
566 | 2023-12-11 12:39:58 | amount | 3 | 112716 | 313 | 5.516 | 20434.4 |
565 | 2023-12-04 18:42:36 | amount | 1 | 48755 | 3 | 0.843 | 57835.1 |
564 | 2023-12-04 18:42:35 | amount | 1 | 48755 | 3 | 0.843 | 57835.1 |
563 | 2023-11-21 16:02:47 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
562 | 2023-11-17 10:28:23 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
561 | 2023-11-16 06:26:45 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
560 | 2023-11-14 02:41:24 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
559 | 2023-11-05 18:11:13 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
558 | 2023-10-24 15:18:35 | amount | 2 | 82551 | 26 | 2.623 | 31472.0 |
557 | 2023-10-22 19:19:41 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
556 | 2023-10-19 15:53:23 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
555 | 2023-10-14 09:15:46 | amount | 1 | 48755 | 3 | 1.576 | 30935.9 |
554 | 2023-09-25 16:41:53 | amount | 1 | 48755 | 3 | 0.796 | 61250.0 |
553 | 2023-09-25 02:07:18 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
552 | 2023-09-13 16:07:07 | amount | 1 | 48755 | 3 | 1.656 | 29441.4 |
551 | 2023-09-10 23:29:12 | amount | 3 | 112716 | 313 | 4.970 | 22679.3 |
550 | 2023-09-07 18:00:08 | amount | 1 | 48755 | 3 | 0.763 | 63899.1 |
549 | 2023-08-04 03:40:07 | amount | 1 | 48755 | 3 | 0.970 | 50262.9 |
548 | 2023-08-03 16:53:34 | amount | 2 | 82551 | 26 | 2.233 | 36968.7 |
547 | 2023-06-10 10:13:15 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
546 | 2023-06-04 17:29:58 | amount | 3 | 112716 | 313 | 4.873 | 23130.7 |
545 | 2023-04-26 16:10:49 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
544 | 2023-04-13 16:22:39 | amount | 2 | 82551 | 26 | 2.140 | 38575.2 |
543 | 2023-04-06 09:48:59 | amount | 3 | 112716 | 313 | 5.500 | 20493.8 |
542 | 2023-03-27 13:52:46 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
541 | 2023-03-12 09:17:04 | amount | 3 | 112716 | 313 | 4.703 | 23966.8 |
540 | 2023-01-19 20:35:35 | amount | 2 | 82551 | 26 | 2.140 | 38575.2 |
539 | 2023-01-14 07:53:05 | amount | 1 | 48755 | 3 | 0.736 | 66243.2 |
538 | 2023-01-10 20:44:09 | amount | 1 | 48755 | 3 | 0.733 | 66514.3 |
537 | 2022-12-18 07:20:15 | amount | 3 | 112716 | 313 | 4.626 | 24365.8 |
536 | 2022-10-30 03:07:08 | amount | 2 | 82551 | 26 | 2.126 | 38829.3 |
535 | 2022-10-10 05:26:00 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
534 | 2022-09-30 08:33:56 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
533 | 2022-09-26 18:11:54 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
532 | 2022-08-13 02:56:42 | amount | 3 | 112716 | 313 | 4.766 | 23650.0 |
531 | 2022-06-09 18:31:56 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
530 | 2022-06-06 03:55:07 | amount | 1 | 48755 | 3 | 0.736 | 66243.2 |
529 | 2022-05-26 04:29:38 | amount | 2 | 82551 | 26 | 2.156 | 38289.0 |
528 | 2022-05-25 02:54:52 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
527 | 2022-03-16 00:00:22 | amount | 3 | 112716 | 313 | 5.906 | 19085.0 |
526 | 2022-02-19 08:42:43 | amount | 1 | 48755 | 3 | 0.843 | 57835.1 |
525 | 2022-02-10 18:12:18 | amount | 1 | 48755 | 3 | 0.856 | 56956.8 |
524 | 2022-02-08 14:29:07 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
523 | 2021-12-02 09:41:34 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
522 | 2021-11-14 17:15:46 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
521 | 2021-10-11 20:21:15 | amount | 1 | 48755 | 3 | 0.863 | 56494.8 |
520 | 2021-10-09 19:20:07 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
519 | 2021-09-18 15:06:32 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
518 | 2021-09-04 00:16:37 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
517 | 2021-08-27 00:18:28 | amount | 1 | 48755 | 3 | 0.810 | 60191.4 |
516 | 2021-08-19 00:17:27 | amount | 1 | 48755 | 3 | 0.873 | 55847.7 |
515 | 2021-08-15 03:47:17 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
514 | 2021-08-11 19:34:32 | amount | 1 | 48755 | 3 | 0.763 | 63899.1 |
513 | 2021-07-23 23:46:50 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
512 | 2021-05-14 00:10:49 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
511 | 2021-05-11 02:09:29 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
510 | 2021-01-28 05:39:17 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
509 | 2021-01-26 18:08:34 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
508 | 2021-01-26 03:24:35 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
507 | 2020-11-29 04:50:44 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
506 | 2020-10-25 10:20:41 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |
505 | 2020-10-18 07:46:46 | amount | 1 | 48755 | 3 | 0.830 | 58741.0 |
504 | 2020-10-14 23:00:58 | amount | 1 | 48755 | 3 | 0.796 | 61250.0 |
503 | 2020-09-27 12:20:53 | amount | 1 | 48755 | 3 | 0.763 | 63899.1 |
502 | 2020-09-01 12:35:01 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
501 | 2020-08-29 14:57:10 | amount | 1 | 48755 | 3 | 0.890 | 54780.9 |
500 | 2020-08-29 01:53:59 | amount | 1 | 48755 | 3 | 0.796 | 61250.0 |
499 | 2020-08-28 10:15:40 | amount | 1 | 48755 | 3 | 0.906 | 53813.5 |
498 | 2020-08-27 08:29:17 | amount | 1 | 48755 | 3 | 0.796 | 61250.0 |
497 | 2020-08-03 18:48:48 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
496 | 2020-08-02 18:08:27 | amount | 1 | 48755 | 3 | 0.800 | 60943.8 |
495 | 2020-07-22 01:21:47 | amount | 1 | 48755 | 3 | 0.843 | 57835.1 |
494 | 2020-05-24 19:41:43 | amount | 1 | 48755 | 3 | 0.750 | 65006.7 |
493 | 2020-04-20 02:40:52 | amount | 1 | 48755 | 3 | 1.140 | 42767.5 |
492 | 2020-03-29 04:01:32 | amount | 1 | 48755 | 3 | 0.860 | 56691.9 |
491 | 2020-03-26 14:42:30 | amount | 1 | 48755 | 3 | 0.873 | 55847.7 |
490 | 2020-03-25 06:05:04 | amount | 1 | 48755 | 3 | 0.970 | 50262.9 |
489 | 2020-03-23 06:12:32 | amount | 1 | 48755 | 3 | 0.826 | 59025.4 |
488 | 2020-03-21 21:10:21 | amount | 1 | 48755 | 3 | 0.813 | 59969.2 |
487 | 2020-03-21 16:04:13 | amount | 1 | 48755 | 3 | 0.876 | 55656.4 |
486 | 2020-03-18 20:42:46 | amount | 1 | 48755 | 3 | 0.766 | 63648.8 |