History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bannet"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
594 | 2024-04-27 22:50:16 | bannet | 1 | 48755 | 7 | 3.486 | 13985.9 |
593 | 2024-04-27 14:37:12 | bannet | 3 | 112716 | 838 | 13.330 | 8455.8 |
592 | 2024-04-23 07:12:29 | bannet | 1 | 48755 | 7 | 0.893 | 54596.9 |
591 | 2024-04-20 18:38:49 | bannet | 1 | 48755 | 7 | 1.110 | 43923.4 |
590 | 2024-04-03 12:58:58 | bannet | 3 | 112716 | 838 | 20.096 | 5608.9 |
589 | 2024-04-01 18:33:36 | bannet | 3 | 112716 | 838 | 8.783 | 12833.4 |
588 | 2024-03-31 20:20:43 | bannet | 3 | 112716 | 838 | 9.253 | 12181.6 |
587 | 2024-03-31 20:20:43 | bannet | 2 | 82551 | 81 | 6.686 | 12346.8 |
586 | 2024-03-31 20:20:37 | bannet | 1 | 48755 | 7 | 2.923 | 16679.8 |
585 | 2024-03-31 20:20:17 | bannet | 3 | 112716 | 838 | 9.906 | 11378.6 |
584 | 2024-03-31 20:20:24 | bannet | 2 | 82551 | 81 | 2.970 | 27794.9 |
583 | 2024-03-31 20:20:09 | bannet | 1 | 48755 | 7 | 0.940 | 51867.0 |
582 | 2024-03-28 05:10:53 | bannet | 1 | 48755 | 7 | 0.766 | 63648.8 |
581 | 2024-03-17 07:26:24 | bannet | 1 | 48755 | 7 | 1.920 | 25393.2 |
580 | 2024-02-22 09:14:57 | bannet | 2 | 82551 | 81 | 2.280 | 36206.6 |
579 | 2024-02-13 13:03:16 | bannet | 1 | 48755 | 7 | 0.983 | 49598.2 |
578 | 2024-02-05 19:58:22 | bannet | 3 | 112716 | 838 | 5.750 | 19602.8 |
577 | 2024-02-05 15:18:51 | bannet | 3 | 112716 | 838 | 19.203 | 5869.7 |
576 | 2024-02-05 06:13:02 | bannet | 3 | 112716 | 838 | 5.626 | 20034.8 |
575 | 2024-01-21 03:28:44 | bannet | 1 | 48755 | 7 | 0.843 | 57835.1 |
574 | 2024-01-19 18:32:06 | bannet | 3 | 112716 | 838 | 5.826 | 19347.1 |
573 | 2024-01-16 01:48:18 | bannet | 2 | 82551 | 81 | 2.500 | 33020.4 |
572 | 2024-01-11 01:45:40 | bannet | 1 | 48755 | 7 | 0.893 | 54596.9 |
571 | 2024-01-10 15:10:21 | bannet | 1 | 48755 | 7 | 0.800 | 60943.8 |
570 | 2023-12-28 19:09:36 | bannet | 2 | 82551 | 81 | 2.190 | 37694.5 |
569 | 2023-12-23 09:55:45 | bannet | 2 | 82551 | 81 | 2.233 | 36968.7 |
568 | 2023-12-21 01:50:19 | bannet | 3 | 112716 | 838 | 5.220 | 21593.1 |
567 | 2023-12-15 01:10:30 | bannet | 3 | 112716 | 838 | 5.203 | 21663.7 |
566 | 2023-12-12 21:02:47 | bannet | 3 | 112716 | 838 | 5.686 | 19823.4 |
565 | 2023-12-08 08:22:15 | bannet | 2 | 82551 | 81 | 2.486 | 33206.4 |
564 | 2023-12-08 08:22:12 | bannet | 2 | 82551 | 81 | 2.483 | 33246.5 |
563 | 2023-11-23 22:03:40 | bannet | 3 | 112716 | 838 | 5.906 | 19085.0 |
562 | 2023-11-17 03:51:32 | bannet | 1 | 48755 | 7 | 0.876 | 55656.4 |
561 | 2023-11-13 09:03:25 | bannet | 1 | 48755 | 7 | 0.873 | 55847.7 |
560 | 2023-11-11 17:26:34 | bannet | 3 | 112716 | 838 | 5.516 | 20434.4 |
559 | 2023-11-06 15:17:10 | bannet | 3 | 112716 | 838 | 5.703 | 19764.3 |
558 | 2023-11-05 18:11:52 | bannet | 1 | 48755 | 7 | 0.860 | 56691.9 |
557 | 2023-11-05 10:50:18 | bannet | 1 | 48755 | 7 | 1.000 | 48755.0 |
556 | 2023-11-02 11:42:11 | bannet | 3 | 112716 | 838 | 8.313 | 13559.0 |
555 | 2023-11-02 11:42:16 | bannet | 2 | 82551 | 81 | 3.206 | 25748.9 |
554 | 2023-10-20 22:22:30 | bannet | 1 | 48755 | 7 | 1.780 | 27390.4 |
553 | 2023-10-17 20:36:12 | bannet | 1 | 48755 | 7 | 0.873 | 55847.7 |
552 | 2023-10-14 00:18:09 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
551 | 2023-10-07 09:49:27 | bannet | 1 | 48755 | 7 | 0.860 | 56691.9 |
550 | 2023-10-03 12:20:22 | bannet | 1 | 48755 | 7 | 0.826 | 59025.4 |
549 | 2023-09-28 13:58:22 | bannet | 2 | 82551 | 81 | 2.623 | 31472.0 |
548 | 2023-09-26 02:37:45 | bannet | 1 | 48755 | 7 | 0.846 | 57630.0 |
547 | 2023-09-22 17:51:43 | bannet | 2 | 82551 | 81 | 2.156 | 38289.0 |
546 | 2023-09-15 12:18:32 | bannet | 1 | 48755 | 7 | 0.890 | 54780.9 |
545 | 2023-08-26 04:26:04 | bannet | 1 | 48755 | 7 | 0.843 | 57835.1 |
544 | 2023-08-12 18:53:54 | bannet | 3 | 112716 | 838 | 4.796 | 23502.1 |
543 | 2023-06-30 19:14:52 | bannet | 2 | 82551 | 81 | 2.203 | 37472.1 |
542 | 2023-06-26 15:20:48 | bannet | 1 | 48755 | 7 | 0.843 | 57835.1 |
541 | 2023-05-29 07:44:46 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
540 | 2023-04-25 21:03:42 | bannet | 3 | 112716 | 838 | 4.736 | 23799.8 |
539 | 2023-03-23 11:40:59 | bannet | 1 | 48755 | 7 | 0.766 | 63648.8 |
538 | 2023-03-23 01:04:46 | bannet | 2 | 82551 | 81 | 2.140 | 38575.2 |
537 | 2023-03-20 18:52:00 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
536 | 2023-02-03 03:20:49 | bannet | 3 | 112716 | 838 | 6.080 | 18538.8 |
535 | 2023-01-31 21:27:46 | bannet | 3 | 112716 | 838 | 5.203 | 21663.7 |
534 | 2023-01-12 06:05:15 | bannet | 2 | 82551 | 81 | 2.143 | 38521.2 |
533 | 2023-01-08 06:14:14 | bannet | 1 | 48755 | 7 | 0.890 | 54780.9 |
532 | 2022-12-31 07:27:04 | bannet | 2 | 82551 | 81 | 2.576 | 32046.2 |
531 | 2022-12-29 15:56:11 | bannet | 3 | 112716 | 838 | 5.080 | 22188.2 |
530 | 2022-12-25 20:00:31 | bannet | 3 | 112716 | 838 | 4.796 | 23502.1 |
529 | 2022-12-23 22:21:08 | bannet | 3 | 112716 | 838 | 5.343 | 21096.0 |
528 | 2022-12-23 17:32:29 | bannet | 3 | 112716 | 838 | 5.360 | 21029.1 |
527 | 2022-12-22 21:11:30 | bannet | 2 | 82551 | 81 | 2.140 | 38575.2 |
526 | 2022-12-12 12:17:22 | bannet | 1 | 48755 | 7 | 0.830 | 58741.0 |
525 | 2022-11-28 02:20:33 | bannet | 2 | 82551 | 81 | 2.186 | 37763.5 |
524 | 2022-11-13 16:35:31 | bannet | 3 | 112716 | 838 | 4.766 | 23650.0 |
523 | 2022-10-29 05:59:56 | bannet | 2 | 82551 | 81 | 2.123 | 38884.1 |
522 | 2022-10-12 17:23:21 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
521 | 2022-09-01 13:20:42 | bannet | 1 | 48755 | 7 | 0.783 | 62266.9 |
520 | 2022-08-27 18:31:43 | bannet | 1 | 48755 | 7 | 0.876 | 55656.4 |
519 | 2022-08-21 06:20:18 | bannet | 2 | 82551 | 81 | 2.156 | 38289.0 |
518 | 2022-06-26 17:45:23 | bannet | 3 | 112716 | 838 | 4.940 | 22817.0 |
517 | 2022-06-23 19:35:53 | bannet | 3 | 112716 | 838 | 4.906 | 22975.1 |
516 | 2022-06-17 01:27:55 | bannet | 3 | 112716 | 838 | 4.830 | 23336.6 |
515 | 2022-06-10 06:01:43 | bannet | 3 | 112716 | 838 | 4.906 | 22975.1 |
514 | 2022-06-03 06:17:03 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
513 | 2022-06-02 05:25:42 | bannet | 3 | 112716 | 838 | 4.780 | 23580.8 |
512 | 2022-05-16 16:18:38 | bannet | 1 | 48755 | 7 | 1.016 | 47987.2 |
511 | 2022-02-15 08:48:00 | bannet | 1 | 48755 | 7 | 0.783 | 62266.9 |
510 | 2022-02-13 02:10:07 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
509 | 2022-02-08 12:08:22 | bannet | 1 | 48755 | 7 | 0.936 | 52088.7 |
508 | 2022-02-02 22:52:15 | bannet | 3 | 112716 | 838 | 5.906 | 19085.0 |
507 | 2021-11-30 11:24:58 | bannet | 1 | 48755 | 7 | 0.906 | 53813.5 |
506 | 2021-11-07 13:39:01 | bannet | 1 | 48755 | 7 | 0.860 | 56691.9 |
505 | 2021-10-12 01:00:56 | bannet | 1 | 48755 | 7 | 0.800 | 60943.8 |
504 | 2021-09-03 14:58:16 | bannet | 1 | 48755 | 7 | 0.906 | 53813.5 |
503 | 2021-08-17 00:20:15 | bannet | 1 | 48755 | 7 | 0.763 | 63899.1 |
502 | 2021-08-04 11:18:54 | bannet | 1 | 48755 | 7 | 0.860 | 56691.9 |
501 | 2021-05-23 05:29:33 | bannet | 1 | 48755 | 7 | 0.890 | 54780.9 |
500 | 2021-05-03 18:49:08 | bannet | 1 | 48755 | 7 | 0.903 | 53992.2 |
499 | 2021-04-30 02:57:44 | bannet | 1 | 48755 | 7 | 0.783 | 62266.9 |
498 | 2021-04-24 10:31:18 | bannet | 1 | 48755 | 7 | 0.986 | 49447.3 |
497 | 2021-04-07 20:39:41 | bannet | 1 | 48755 | 7 | 0.860 | 56691.9 |
496 | 2021-02-28 12:14:35 | bannet | 1 | 48755 | 7 | 0.750 | 65006.7 |
495 | 2021-02-04 13:14:01 | bannet | 1 | 48755 | 7 | 0.843 | 57835.1 |