History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"blotter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
587 | 2024-05-04 19:03:19 | blotter | 1 | 69583 | 9 | 2.470 | 28171.3 |
586 | 2024-04-22 15:09:29 | blotter | 1 | 69583 | 9 | 1.326 | 52475.9 |
585 | 2024-04-08 02:45:15 | blotter | 3 | 134027 | 636 | 7.860 | 17051.8 |
584 | 2024-04-08 00:11:09 | blotter | 3 | 134027 | 636 | 16.393 | 8175.9 |
583 | 2024-04-07 16:53:27 | blotter | 3 | 134027 | 636 | 19.703 | 6802.4 |
582 | 2024-04-06 10:29:04 | blotter | 1 | 69583 | 9 | 3.910 | 17796.2 |
581 | 2024-04-06 02:24:11 | blotter | 3 | 134027 | 636 | 28.360 | 4725.9 |
580 | 2024-04-05 19:29:49 | blotter | 2 | 107671 | 85 | 3.483 | 30913.3 |
579 | 2024-04-05 12:51:42 | blotter | 3 | 134027 | 636 | 7.640 | 17542.8 |
578 | 2024-04-05 11:53:21 | blotter | 1 | 69583 | 9 | 1.500 | 46388.7 |
577 | 2024-04-05 11:52:54 | blotter | 2 | 107671 | 85 | 6.283 | 17136.9 |
576 | 2024-04-05 11:52:49 | blotter | 3 | 134027 | 636 | 10.783 | 12429.5 |
575 | 2024-04-05 11:52:14 | blotter | 1 | 69583 | 9 | 2.610 | 26660.2 |
574 | 2024-03-30 13:09:10 | blotter | 1 | 69583 | 9 | 2.736 | 25432.4 |
573 | 2024-03-09 00:06:47 | blotter | 3 | 134027 | 636 | 18.283 | 7330.7 |
572 | 2024-03-07 23:24:33 | blotter | 3 | 134027 | 636 | 16.686 | 8032.3 |
571 | 2024-03-07 16:42:24 | blotter | 3 | 134027 | 636 | 6.860 | 19537.5 |
570 | 2024-03-07 03:15:52 | blotter | 2 | 107671 | 85 | 7.673 | 14032.5 |
569 | 2024-03-06 23:20:38 | blotter | 3 | 134027 | 636 | 24.393 | 5494.5 |
568 | 2024-03-06 16:09:31 | blotter | 2 | 107671 | 85 | 10.860 | 9914.5 |
567 | 2024-03-06 11:04:13 | blotter | 3 | 134027 | 636 | 23.063 | 5811.3 |
566 | 2024-03-06 04:33:53 | blotter | 1 | 69583 | 9 | 4.500 | 15462.9 |
565 | 2024-03-06 04:33:38 | blotter | 3 | 134027 | 636 | 12.503 | 10719.6 |
564 | 2024-03-06 04:33:39 | blotter | 2 | 107671 | 85 | 5.330 | 20200.9 |
563 | 2024-03-06 04:33:30 | blotter | 1 | 69583 | 9 | 2.686 | 25905.8 |
562 | 2024-02-29 02:20:41 | blotter | 1 | 69583 | 9 | 1.296 | 53690.6 |
561 | 2024-02-04 15:06:34 | blotter | 2 | 107671 | 85 | 6.800 | 15834.0 |
560 | 2024-02-04 15:04:03 | blotter | 1 | 69583 | 9 | 3.466 | 20075.9 |
559 | 2024-02-04 14:29:49 | blotter | 3 | 134027 | 636 | 7.860 | 17051.8 |
558 | 2024-01-31 20:02:28 | blotter | 2 | 107671 | 85 | 5.763 | 18683.2 |
557 | 2024-01-31 20:00:24 | blotter | 3 | 134027 | 636 | 6.376 | 21020.5 |
556 | 2024-01-30 20:42:55 | blotter | 3 | 134027 | 636 | 6.953 | 19276.1 |
555 | 2024-01-30 13:26:45 | blotter | 3 | 134027 | 636 | 8.266 | 16214.3 |
554 | 2024-01-17 17:23:30 | blotter | 2 | 107671 | 85 | 3.220 | 33438.2 |
553 | 2024-01-15 00:35:48 | blotter | 1 | 69583 | 9 | 1.153 | 60349.5 |
552 | 2024-01-05 13:39:16 | blotter | 1 | 69583 | 9 | 1.203 | 57841.2 |
551 | 2023-12-01 01:01:31 | blotter | 3 | 134027 | 636 | 6.470 | 20715.1 |
550 | 2023-11-21 21:41:21 | blotter | 3 | 134027 | 636 | 6.673 | 20085.0 |
549 | 2023-11-20 11:26:39 | blotter | 1 | 69583 | 9 | 1.156 | 60192.9 |
548 | 2023-11-17 09:08:53 | blotter | 1 | 69583 | 9 | 1.203 | 57841.2 |
547 | 2023-11-16 23:47:41 | blotter | 1 | 69583 | 9 | 1.220 | 57035.2 |
546 | 2023-11-14 02:17:53 | blotter | 3 | 134027 | 636 | 5.626 | 23822.8 |
545 | 2023-11-11 10:24:02 | blotter | 1 | 69583 | 9 | 1.076 | 64668.2 |
544 | 2023-11-10 20:34:41 | blotter | 1 | 69583 | 9 | 1.296 | 53690.6 |
543 | 2023-11-09 07:11:57 | blotter | 3 | 134027 | 636 | 6.343 | 21129.9 |
542 | 2023-10-23 00:11:17 | blotter | 1 | 69583 | 9 | 1.046 | 66522.9 |
541 | 2023-10-19 17:40:08 | blotter | 1 | 69583 | 9 | 1.250 | 55666.4 |
540 | 2023-10-12 21:07:37 | blotter | 1 | 69583 | 9 | 1.186 | 58670.3 |
539 | 2023-09-25 08:46:24 | blotter | 1 | 69583 | 9 | 1.140 | 61037.7 |
538 | 2023-09-11 12:22:32 | blotter | 1 | 69583 | 9 | 1.033 | 67360.1 |
537 | 2023-08-29 15:35:18 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
536 | 2023-08-12 18:09:48 | blotter | 1 | 69583 | 9 | 1.093 | 63662.4 |
535 | 2023-08-12 13:24:49 | blotter | 3 | 134027 | 636 | 5.906 | 22693.4 |
534 | 2023-08-04 01:47:49 | blotter | 1 | 69583 | 9 | 1.216 | 57222.9 |
533 | 2023-06-02 10:19:00 | blotter | 1 | 69583 | 9 | 1.016 | 68487.2 |
532 | 2023-05-02 00:23:32 | blotter | 1 | 69583 | 9 | 1.030 | 67556.3 |
531 | 2023-04-28 00:20:04 | blotter | 3 | 134027 | 636 | 5.610 | 23890.7 |
530 | 2023-04-26 14:41:01 | blotter | 1 | 69583 | 9 | 1.076 | 64668.2 |
529 | 2023-03-26 03:56:05 | blotter | 1 | 69583 | 9 | 1.030 | 67556.3 |
528 | 2023-03-21 03:33:06 | blotter | 1 | 69583 | 9 | 1.233 | 56433.9 |
527 | 2023-02-22 11:01:09 | blotter | 3 | 134027 | 636 | 6.220 | 21547.7 |
526 | 2023-02-04 10:49:10 | blotter | 3 | 134027 | 636 | 5.923 | 22628.2 |
525 | 2023-01-10 12:20:13 | blotter | 1 | 69583 | 9 | 1.046 | 66522.9 |
524 | 2023-01-09 22:13:27 | blotter | 1 | 69583 | 9 | 1.033 | 67360.1 |
523 | 2022-11-16 04:58:32 | blotter | 3 | 134027 | 636 | 5.610 | 23890.7 |
522 | 2022-10-12 03:02:17 | blotter | 1 | 69583 | 9 | 1.080 | 64428.7 |
521 | 2022-09-26 16:24:59 | blotter | 1 | 69583 | 9 | 1.156 | 60192.9 |
520 | 2022-07-19 14:59:43 | blotter | 2 | 107671 | 85 | 2.873 | 37476.9 |
519 | 2022-06-28 08:22:50 | blotter | 3 | 134027 | 636 | 5.686 | 23571.4 |
518 | 2022-06-20 14:47:04 | blotter | 3 | 134027 | 636 | 5.690 | 23554.8 |
517 | 2022-06-09 16:46:08 | blotter | 1 | 69583 | 9 | 1.233 | 56433.9 |
516 | 2022-06-06 02:03:25 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
515 | 2022-06-02 16:57:30 | blotter | 1 | 69583 | 9 | 1.030 | 67556.3 |
514 | 2022-06-01 04:46:14 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
513 | 2022-05-29 22:59:40 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
512 | 2022-02-19 07:12:06 | blotter | 1 | 69583 | 9 | 1.236 | 56296.9 |
511 | 2022-02-08 23:48:34 | blotter | 1 | 69583 | 9 | 1.140 | 61037.7 |
510 | 2021-12-30 23:48:59 | blotter | 1 | 69583 | 9 | 1.110 | 62687.4 |
509 | 2021-12-11 04:13:55 | blotter | 1 | 69583 | 9 | 1.186 | 58670.3 |
508 | 2021-11-22 03:34:11 | blotter | 1 | 69583 | 9 | 1.156 | 60192.9 |
507 | 2021-11-17 22:36:57 | blotter | 1 | 69583 | 9 | 2.390 | 29114.2 |
506 | 2021-10-20 10:45:54 | blotter | 1 | 69583 | 9 | 1.046 | 66522.9 |
505 | 2021-09-29 21:02:04 | blotter | 3 | 134027 | 636 | 5.580 | 24019.2 |
504 | 2021-09-22 18:03:02 | blotter | 1 | 69583 | 9 | 2.110 | 32977.7 |
503 | 2021-09-22 01:49:57 | blotter | 1 | 69583 | 9 | 1.046 | 66522.9 |
502 | 2021-09-21 07:03:33 | blotter | 1 | 69583 | 9 | 2.436 | 28564.4 |
501 | 2021-09-15 00:34:42 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
500 | 2021-09-08 05:01:21 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
499 | 2021-08-21 13:44:21 | blotter | 1 | 69583 | 9 | 1.173 | 59320.5 |
498 | 2021-08-18 09:50:47 | blotter | 1 | 69583 | 9 | 1.110 | 62687.4 |
497 | 2021-08-15 02:31:38 | blotter | 1 | 69583 | 9 | 1.106 | 62914.1 |
496 | 2021-07-15 17:04:44 | blotter | 2 | 107671 | 85 | 6.656 | 16176.5 |
495 | 2021-06-02 06:42:25 | blotter | 1 | 69583 | 9 | 1.080 | 64428.7 |
494 | 2021-05-14 10:49:48 | blotter | 1 | 69583 | 9 | 1.123 | 61961.7 |
493 | 2021-05-08 01:46:49 | blotter | 1 | 69583 | 9 | 1.206 | 57697.3 |
492 | 2021-05-05 00:58:39 | blotter | 2 | 107671 | 85 | 3.436 | 31336.1 |
491 | 2021-04-06 09:15:05 | blotter | 1 | 69583 | 9 | 1.190 | 58473.1 |
490 | 2021-02-18 23:26:13 | blotter | 1 | 69583 | 9 | 1.093 | 63662.4 |
489 | 2021-02-16 11:53:56 | blotter | 1 | 69583 | 9 | 1.063 | 65459.1 |
488 | 2021-02-11 13:05:33 | blotter | 2 | 107671 | 85 | 2.800 | 38453.9 |