History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"desired"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
583 | 2024-02-29 23:13:40 | desired | 1 | 69583 | 5 | 2.313 | 30083.4 |
582 | 2024-01-27 15:42:49 | desired | 1 | 69583 | 5 | 1.190 | 58473.1 |
581 | 2024-01-19 02:07:25 | desired | 3 | 134027 | 530 | 7.140 | 18771.3 |
580 | 2024-01-19 02:07:22 | desired | 2 | 107671 | 47 | 3.466 | 31064.9 |
579 | 2023-11-28 04:05:37 | desired | 1 | 69583 | 5 | 1.250 | 55666.4 |
578 | 2023-11-24 07:54:26 | desired | 1 | 69583 | 5 | 1.250 | 55666.4 |
577 | 2023-11-23 03:36:26 | desired | 1 | 69583 | 5 | 1.076 | 64668.2 |
576 | 2023-11-19 23:22:25 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
575 | 2023-11-19 01:17:29 | desired | 1 | 69583 | 5 | 1.123 | 61961.7 |
574 | 2023-11-02 13:13:30 | desired | 1 | 69583 | 5 | 1.203 | 57841.2 |
573 | 2023-10-16 17:19:20 | desired | 1 | 69583 | 5 | 1.156 | 60192.9 |
572 | 2023-10-05 15:41:41 | desired | 1 | 69583 | 5 | 1.173 | 59320.5 |
571 | 2023-09-26 10:09:39 | desired | 1 | 69583 | 5 | 1.220 | 57035.2 |
570 | 2023-09-25 02:40:59 | desired | 1 | 69583 | 5 | 2.436 | 28564.4 |
569 | 2023-09-09 07:29:54 | desired | 1 | 69583 | 5 | 1.170 | 59472.6 |
568 | 2023-08-08 20:30:13 | desired | 1 | 69583 | 5 | 1.500 | 46388.7 |
567 | 2023-06-22 05:36:16 | desired | 1 | 69583 | 5 | 1.076 | 64668.2 |
566 | 2023-05-01 06:06:54 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
565 | 2023-04-05 19:06:53 | desired | 1 | 69583 | 5 | 1.063 | 65459.1 |
564 | 2023-01-26 09:30:28 | desired | 1 | 69583 | 5 | 1.063 | 65459.1 |
563 | 2023-01-19 09:39:12 | desired | 1 | 69583 | 5 | 1.250 | 55666.4 |
562 | 2022-11-17 00:47:15 | desired | 1 | 69583 | 5 | 1.173 | 59320.5 |
561 | 2022-10-12 02:06:29 | desired | 1 | 69583 | 5 | 1.140 | 61037.7 |
560 | 2022-07-08 16:40:18 | desired | 1 | 69583 | 5 | 1.063 | 65459.1 |
559 | 2022-06-25 15:15:07 | desired | 1 | 69583 | 5 | 1.063 | 65459.1 |
558 | 2022-06-21 18:16:22 | desired | 1 | 69583 | 5 | 1.076 | 64668.2 |
557 | 2022-06-08 07:11:43 | desired | 1 | 69583 | 5 | 1.123 | 61961.7 |
556 | 2022-05-05 01:46:43 | desired | 1 | 69583 | 5 | 1.093 | 63662.4 |
555 | 2022-03-09 03:13:19 | desired | 1 | 69583 | 5 | 1.830 | 38023.5 |
554 | 2022-03-06 23:00:54 | desired | 1 | 69583 | 5 | 1.093 | 63662.4 |
553 | 2022-03-05 22:28:35 | desired | 1 | 69583 | 5 | 1.250 | 55666.4 |
552 | 2021-12-19 13:11:49 | desired | 1 | 69583 | 5 | 1.423 | 48898.8 |
551 | 2021-11-22 04:38:01 | desired | 1 | 69583 | 5 | 3.750 | 18555.5 |
550 | 2021-11-09 23:15:02 | desired | 1 | 69583 | 5 | 1.076 | 64668.2 |
549 | 2021-08-24 12:30:27 | desired | 1 | 69583 | 5 | 1.236 | 56296.9 |
548 | 2021-08-19 07:25:54 | desired | 1 | 69583 | 5 | 1.060 | 65644.3 |
547 | 2021-07-10 07:14:31 | desired | 1 | 69583 | 5 | 1.280 | 54361.7 |
546 | 2021-07-02 13:22:20 | desired | 1 | 69583 | 5 | 1.313 | 52995.4 |
545 | 2021-05-24 15:35:29 | desired | 1 | 69583 | 5 | 1.220 | 57035.2 |
544 | 2021-05-18 14:26:24 | desired | 1 | 69583 | 5 | 1.093 | 63662.4 |
543 | 2021-05-13 22:16:05 | desired | 1 | 69583 | 5 | 1.233 | 56433.9 |
542 | 2021-05-03 08:47:12 | desired | 1 | 69583 | 5 | 1.236 | 56296.9 |
541 | 2021-04-27 23:13:19 | desired | 1 | 69583 | 5 | 2.530 | 27503.2 |
540 | 2021-03-27 21:36:19 | desired | 1 | 69583 | 5 | 1.080 | 64428.7 |
539 | 2021-02-19 15:37:36 | desired | 1 | 69583 | 5 | 1.080 | 64428.7 |
538 | 2021-02-15 09:35:06 | desired | 1 | 69583 | 5 | 1.153 | 60349.5 |
537 | 2021-01-26 17:05:25 | desired | 1 | 69583 | 5 | 1.170 | 59472.6 |
536 | 2020-12-12 22:10:41 | desired | 1 | 69583 | 5 | 1.080 | 64428.7 |
535 | 2020-11-11 01:07:47 | desired | 1 | 69583 | 5 | 1.063 | 65459.1 |
534 | 2020-10-31 22:22:13 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
533 | 2020-10-16 13:06:07 | desired | 1 | 69583 | 5 | 1.156 | 60192.9 |
532 | 2020-10-14 21:28:53 | desired | 1 | 69583 | 5 | 1.173 | 59320.5 |
531 | 2020-09-02 17:48:46 | desired | 1 | 69583 | 5 | 1.203 | 57841.2 |
530 | 2020-08-29 02:19:41 | desired | 1 | 69583 | 5 | 1.406 | 49490.0 |
529 | 2020-08-24 12:23:55 | desired | 1 | 69583 | 5 | 1.266 | 54962.9 |
528 | 2020-08-10 22:54:25 | desired | 1 | 69583 | 5 | 1.173 | 59320.5 |
527 | 2020-07-24 00:22:17 | desired | 1 | 69583 | 5 | 1.126 | 61796.6 |
526 | 2020-05-06 16:48:46 | desired | 1 | 69583 | 5 | 1.076 | 64668.2 |
525 | 2020-04-11 11:20:58 | desired | 1 | 69583 | 5 | 1.110 | 62687.4 |
524 | 2020-03-28 15:19:46 | desired | 1 | 69583 | 5 | 1.263 | 55093.4 |
523 | 2020-03-28 10:53:04 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
522 | 2020-03-27 22:03:26 | desired | 1 | 69583 | 5 | 2.080 | 33453.4 |
521 | 2020-03-26 14:34:49 | desired | 1 | 69583 | 5 | 1.093 | 63662.4 |
520 | 2020-03-24 05:07:06 | desired | 1 | 69583 | 5 | 1.330 | 52318.0 |
519 | 2020-03-21 06:37:26 | desired | 1 | 69583 | 5 | 2.436 | 28564.4 |
518 | 2020-02-27 18:37:54 | desired | 1 | 69583 | 5 | 2.690 | 25867.3 |
517 | 2020-02-25 22:38:57 | desired | 1 | 69583 | 5 | 1.406 | 49490.0 |
516 | 2020-02-24 10:30:40 | desired | 1 | 69583 | 5 | 1.283 | 54234.6 |
515 | 2020-02-06 19:53:24 | desired | 1 | 69583 | 5 | 1.406 | 49490.0 |
514 | 2020-02-05 21:17:19 | desired | 1 | 69583 | 5 | 1.216 | 57222.9 |
513 | 2020-02-04 16:34:44 | desired | 1 | 69583 | 5 | 2.750 | 25302.9 |
512 | 2020-02-04 05:55:16 | desired | 1 | 69583 | 5 | 1.236 | 56296.9 |
511 | 2020-02-01 10:59:35 | desired | 1 | 69583 | 5 | 1.296 | 53690.6 |
510 | 2020-02-01 07:26:48 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
509 | 2020-01-31 05:09:37 | desired | 1 | 69583 | 5 | 1.343 | 51811.6 |
508 | 2020-01-30 18:58:12 | desired | 1 | 69583 | 5 | 1.093 | 63662.4 |
507 | 2020-01-25 18:43:26 | desired | 1 | 69583 | 5 | 3.563 | 19529.3 |
506 | 2020-01-15 23:49:44 | desired | 1 | 69583 | 5 | 1.920 | 36241.1 |
505 | 2020-01-15 22:39:58 | desired | 1 | 69583 | 5 | 1.356 | 51314.9 |
504 | 2020-01-13 02:06:52 | desired | 1 | 69583 | 5 | 1.250 | 55666.4 |
503 | 2020-01-09 00:56:00 | desired | 1 | 69583 | 5 | 1.283 | 54234.6 |
502 | 2019-12-31 14:33:13 | desired | 1 | 69583 | 5 | 1.266 | 54962.9 |
501 | 2019-12-27 21:54:13 | desired | 1 | 69583 | 5 | 1.186 | 58670.3 |
500 | 2019-12-27 19:26:16 | desired | 1 | 69583 | 5 | 1.220 | 57035.2 |
499 | 2019-12-26 22:29:53 | desired | 1 | 69583 | 5 | 3.186 | 21840.2 |
498 | 2019-10-31 07:17:35 | desired | 1 | 69583 | 5 | 2.393 | 29077.7 |
497 | 2019-07-30 04:31:20 | desired | 1 | 69583 | 5 | 1.110 | 62687.4 |
496 | 2019-04-29 05:41:18 | desired | 1 | 69583 | 5 | 1.116 | 62350.4 |
495 | 2019-03-28 12:04:12 | desired | 1 | 69583 | 5 | 1.060 | 65644.3 |
494 | 2019-03-02 17:26:53 | desired | 1 | 69583 | 5 | 1.040 | 66906.7 |
493 | 2019-02-27 10:25:13 | desired | 1 | 69583 | 5 | 1.020 | 68218.6 |
492 | 2019-01-20 18:21:33 | desired | 1 | 69583 | 5 | 1.180 | 58968.6 |
491 | 2019-01-10 16:20:28 | desired | 1 | 69583 | 5 | 1.166 | 59676.7 |
490 | 2018-12-29 23:36:26 | desired | 1 | 69583 | 5 | 1.066 | 65274.9 |
489 | 2018-12-28 02:19:15 | desired | 1 | 69583 | 5 | 1.016 | 68487.2 |
488 | 2018-12-22 08:02:25 | desired | 1 | 69583 | 5 | 1.036 | 67165.1 |
487 | 2018-12-20 09:31:52 | desired | 1 | 69583 | 5 | 1.160 | 59985.3 |
486 | 2018-12-18 10:51:17 | desired | 1 | 69583 | 5 | 1.033 | 67360.1 |
485 | 2018-12-03 12:10:10 | desired | 1 | 69583 | 5 | 1.036 | 67165.1 |
484 | 2018-11-12 16:16:25 | desired | 1 | 69583 | 5 | 1.136 | 61252.6 |