History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gatings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
605 | 2024-04-27 14:28:12 | gatings | 1 | 69583 | 7 | 3.516 | 19790.4 |
604 | 2024-04-11 05:41:08 | gatings | 1 | 69583 | 7 | 1.343 | 51811.6 |
603 | 2024-03-30 04:58:56 | gatings | 1 | 69583 | 7 | 2.750 | 25302.9 |
602 | 2024-03-14 07:06:44 | gatings | 1 | 69583 | 7 | 1.186 | 58670.3 |
601 | 2024-02-26 16:38:33 | gatings | 1 | 69583 | 7 | 2.703 | 25742.9 |
600 | 2024-01-26 20:43:09 | gatings | 1 | 69583 | 7 | 1.220 | 57035.2 |
599 | 2024-01-26 16:03:19 | gatings | 2 | 107671 | 100 | 3.406 | 31612.2 |
598 | 2024-01-08 01:20:52 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
597 | 2023-12-18 17:53:05 | gatings | 3 | 134027 | 826 | 7.313 | 18327.2 |
596 | 2023-12-18 17:53:04 | gatings | 2 | 107671 | 100 | 3.546 | 30364.1 |
595 | 2023-12-15 09:35:33 | gatings | 1 | 69583 | 7 | 1.313 | 52995.4 |
594 | 2023-12-03 21:43:43 | gatings | 1 | 69583 | 7 | 1.343 | 51811.6 |
593 | 2023-11-19 10:31:09 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
592 | 2023-11-17 20:34:43 | gatings | 1 | 69583 | 7 | 1.233 | 56433.9 |
591 | 2023-11-06 20:17:05 | gatings | 1 | 69583 | 7 | 1.060 | 65644.3 |
590 | 2023-11-06 10:07:04 | gatings | 1 | 69583 | 7 | 1.076 | 64668.2 |
589 | 2023-11-02 12:05:33 | gatings | 2 | 107671 | 100 | 3.253 | 33099.0 |
588 | 2023-10-29 10:07:04 | gatings | 1 | 69583 | 7 | 1.093 | 63662.4 |
587 | 2023-10-23 15:37:09 | gatings | 1 | 69583 | 7 | 1.250 | 55666.4 |
586 | 2023-10-22 22:05:13 | gatings | 1 | 69583 | 7 | 1.186 | 58670.3 |
585 | 2023-10-16 05:09:13 | gatings | 1 | 69583 | 7 | 1.140 | 61037.7 |
584 | 2023-10-01 03:41:25 | gatings | 1 | 69583 | 7 | 1.110 | 62687.4 |
583 | 2023-09-29 15:26:56 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
582 | 2023-09-25 18:14:28 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
581 | 2023-09-25 10:15:25 | gatings | 1 | 69583 | 7 | 1.236 | 56296.9 |
580 | 2023-08-08 15:12:14 | gatings | 2 | 107671 | 100 | 3.253 | 33099.0 |
579 | 2023-07-28 17:56:38 | gatings | 1 | 69583 | 7 | 1.220 | 57035.2 |
578 | 2023-07-09 19:29:04 | gatings | 1 | 69583 | 7 | 1.110 | 62687.4 |
577 | 2023-04-26 13:45:08 | gatings | 1 | 69583 | 7 | 1.080 | 64428.7 |
576 | 2023-04-21 12:33:53 | gatings | 2 | 107671 | 100 | 2.830 | 38046.3 |
575 | 2023-04-02 07:05:46 | gatings | 1 | 69583 | 7 | 1.220 | 57035.2 |
574 | 2023-02-16 07:50:58 | gatings | 1 | 69583 | 7 | 1.050 | 66269.5 |
573 | 2023-01-25 01:18:14 | gatings | 2 | 107671 | 100 | 3.190 | 33752.7 |
572 | 2022-12-20 18:23:22 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
571 | 2022-12-15 08:56:42 | gatings | 1 | 69583 | 7 | 1.173 | 59320.5 |
570 | 2022-11-06 16:36:36 | gatings | 2 | 107671 | 100 | 2.796 | 38508.9 |
569 | 2022-09-11 17:38:35 | gatings | 2 | 107671 | 100 | 2.860 | 37647.2 |
568 | 2022-09-06 13:44:15 | gatings | 1 | 69583 | 7 | 1.060 | 65644.3 |
567 | 2022-09-03 05:19:34 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
566 | 2022-08-19 12:39:06 | gatings | 1 | 69583 | 7 | 1.110 | 62687.4 |
565 | 2022-08-17 03:32:45 | gatings | 1 | 69583 | 7 | 1.080 | 64428.7 |
564 | 2022-08-01 21:50:10 | gatings | 2 | 107671 | 100 | 2.920 | 36873.6 |
563 | 2022-06-07 13:37:01 | gatings | 2 | 107671 | 100 | 2.953 | 36461.6 |
562 | 2022-05-15 00:54:32 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
561 | 2022-04-03 15:29:09 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
560 | 2022-04-01 11:49:23 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
559 | 2022-02-06 20:02:32 | gatings | 1 | 69583 | 7 | 1.296 | 53690.6 |
558 | 2022-01-01 00:17:13 | gatings | 1 | 69583 | 7 | 1.220 | 57035.2 |
557 | 2021-12-29 20:16:52 | gatings | 1 | 69583 | 7 | 1.140 | 61037.7 |
556 | 2021-11-05 23:11:54 | gatings | 1 | 69583 | 7 | 1.220 | 57035.2 |
555 | 2021-10-30 18:54:57 | gatings | 1 | 69583 | 7 | 1.203 | 57841.2 |
554 | 2021-10-29 17:35:01 | gatings | 1 | 69583 | 7 | 1.546 | 45008.4 |
553 | 2021-10-28 08:46:29 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
552 | 2021-09-22 16:00:18 | gatings | 1 | 69583 | 7 | 1.060 | 65644.3 |
551 | 2021-09-22 00:04:12 | gatings | 1 | 69583 | 7 | 1.186 | 58670.3 |
550 | 2021-09-21 20:10:32 | gatings | 1 | 69583 | 7 | 1.156 | 60192.9 |
549 | 2021-09-21 02:41:53 | gatings | 1 | 69583 | 7 | 1.140 | 61037.7 |
548 | 2021-09-14 23:45:34 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
547 | 2021-09-14 10:28:40 | gatings | 1 | 69583 | 7 | 1.280 | 54361.7 |
546 | 2021-08-27 20:44:31 | gatings | 1 | 69583 | 7 | 1.080 | 64428.7 |
545 | 2021-08-06 06:12:00 | gatings | 1 | 69583 | 7 | 1.046 | 66522.9 |
544 | 2021-08-02 18:24:09 | gatings | 1 | 69583 | 7 | 1.156 | 60192.9 |
543 | 2021-06-13 18:18:53 | gatings | 2 | 107671 | 100 | 2.890 | 37256.4 |
542 | 2021-04-24 18:27:41 | gatings | 1 | 69583 | 7 | 1.203 | 57841.2 |
541 | 2021-03-23 21:21:10 | gatings | 2 | 107671 | 100 | 2.843 | 37872.3 |
540 | 2021-02-02 05:24:45 | gatings | 2 | 107671 | 100 | 2.860 | 37647.2 |
539 | 2021-01-23 21:25:12 | gatings | 1 | 69583 | 7 | 1.063 | 65459.1 |
538 | 2020-10-27 06:20:17 | gatings | 1 | 69583 | 7 | 1.266 | 54962.9 |
537 | 2020-10-25 00:25:50 | gatings | 1 | 69583 | 7 | 1.123 | 61961.7 |
536 | 2020-10-22 03:18:18 | gatings | 1 | 69583 | 7 | 1.296 | 53690.6 |
535 | 2020-10-13 22:03:42 | gatings | 1 | 69583 | 7 | 1.096 | 63488.1 |
534 | 2020-10-06 18:59:06 | gatings | 1 | 69583 | 7 | 1.060 | 65644.3 |
533 | 2020-09-08 09:52:21 | gatings | 1 | 69583 | 7 | 1.076 | 64668.2 |
532 | 2020-08-11 09:28:30 | gatings | 1 | 69583 | 7 | 1.093 | 63662.4 |
531 | 2020-08-05 06:12:07 | gatings | 1 | 69583 | 7 | 1.093 | 63662.4 |
530 | 2020-07-30 21:51:47 | gatings | 1 | 69583 | 7 | 1.173 | 59320.5 |
529 | 2020-07-20 15:35:22 | gatings | 1 | 69583 | 7 | 1.110 | 62687.4 |
528 | 2020-07-20 00:55:34 | gatings | 1 | 69583 | 7 | 1.203 | 57841.2 |
527 | 2020-04-18 01:55:48 | gatings | 1 | 69583 | 7 | 1.200 | 57985.8 |
526 | 2020-04-16 20:25:19 | gatings | 1 | 69583 | 7 | 1.140 | 61037.7 |
525 | 2020-03-28 20:03:23 | gatings | 1 | 69583 | 7 | 1.236 | 56296.9 |
524 | 2020-03-24 16:03:43 | gatings | 1 | 69583 | 7 | 2.733 | 25460.3 |
523 | 2020-03-22 12:20:23 | gatings | 1 | 69583 | 7 | 1.560 | 44604.5 |
522 | 2020-03-20 17:04:53 | gatings | 1 | 69583 | 7 | 1.140 | 61037.7 |
521 | 2020-02-26 20:20:46 | gatings | 1 | 69583 | 7 | 1.250 | 55666.4 |
520 | 2020-02-23 11:44:02 | gatings | 1 | 69583 | 7 | 1.330 | 52318.0 |
519 | 2020-02-17 02:46:54 | gatings | 1 | 69583 | 7 | 3.173 | 21929.7 |
518 | 2020-02-05 13:25:57 | gatings | 1 | 69583 | 7 | 1.283 | 54234.6 |
517 | 2020-02-05 04:38:15 | gatings | 1 | 69583 | 7 | 2.593 | 26834.9 |
516 | 2020-02-04 05:05:17 | gatings | 1 | 69583 | 7 | 2.436 | 28564.4 |
515 | 2020-02-04 04:02:23 | gatings | 1 | 69583 | 7 | 1.266 | 54962.9 |
514 | 2020-02-02 02:23:11 | gatings | 1 | 69583 | 7 | 1.233 | 56433.9 |
513 | 2020-01-28 15:48:24 | gatings | 1 | 69583 | 7 | 1.263 | 55093.4 |
512 | 2020-01-24 16:00:31 | gatings | 1 | 69583 | 7 | 1.470 | 47335.4 |
511 | 2020-01-15 18:01:26 | gatings | 1 | 69583 | 7 | 2.766 | 25156.5 |
510 | 2020-01-15 08:08:06 | gatings | 1 | 69583 | 7 | 2.626 | 26497.7 |
509 | 2020-01-14 18:11:08 | gatings | 1 | 69583 | 7 | 1.530 | 45479.1 |
508 | 2020-01-12 05:00:44 | gatings | 1 | 69583 | 7 | 1.300 | 53525.4 |
507 | 2020-01-12 03:50:24 | gatings | 1 | 69583 | 7 | 1.390 | 50059.7 |
506 | 2020-01-07 22:34:18 | gatings | 1 | 69583 | 7 | 2.593 | 26834.9 |