History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loonies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
588 | 2024-03-30 09:04:53 | loonies | 1 | 69583 | 9 | 2.813 | 24736.2 |
587 | 2024-03-28 14:54:13 | loonies | 1 | 69583 | 9 | 1.110 | 62687.4 |
586 | 2024-03-19 17:02:11 | loonies | 2 | 107671 | 81 | 3.843 | 28017.4 |
585 | 2024-03-19 17:00:12 | loonies | 1 | 69583 | 9 | 1.280 | 54361.7 |
584 | 2024-03-19 16:59:34 | loonies | 3 | 134027 | 723 | 6.733 | 19906.0 |
583 | 2024-03-18 22:47:53 | loonies | 3 | 134027 | 723 | 8.236 | 16273.3 |
582 | 2024-03-18 11:42:18 | loonies | 3 | 134027 | 723 | 6.156 | 21771.8 |
581 | 2024-02-27 10:45:48 | loonies | 1 | 69583 | 9 | 1.173 | 59320.5 |
580 | 2024-02-06 07:50:13 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
579 | 2024-02-02 12:00:37 | loonies | 1 | 69583 | 9 | 1.046 | 66522.9 |
578 | 2023-12-22 04:13:18 | loonies | 1 | 69583 | 9 | 1.060 | 65644.3 |
577 | 2023-12-03 05:54:30 | loonies | 1 | 69583 | 9 | 1.046 | 66522.9 |
576 | 2023-11-30 05:41:51 | loonies | 3 | 134027 | 723 | 5.876 | 22809.2 |
575 | 2023-11-20 09:41:54 | loonies | 1 | 69583 | 9 | 1.220 | 57035.2 |
574 | 2023-11-05 21:12:31 | loonies | 1 | 69583 | 9 | 1.236 | 56296.9 |
573 | 2023-10-25 15:37:51 | loonies | 1 | 69583 | 9 | 1.186 | 58670.3 |
572 | 2023-10-22 01:22:34 | loonies | 1 | 69583 | 9 | 1.250 | 55666.4 |
571 | 2023-10-19 17:29:30 | loonies | 1 | 69583 | 9 | 1.813 | 38380.0 |
570 | 2023-10-12 08:50:17 | loonies | 1 | 69583 | 9 | 1.170 | 59472.6 |
569 | 2023-10-08 19:25:46 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
568 | 2023-09-29 09:57:46 | loonies | 1 | 69583 | 9 | 1.080 | 64428.7 |
567 | 2023-09-26 12:20:47 | loonies | 1 | 69583 | 9 | 1.076 | 64668.2 |
566 | 2023-09-12 04:38:33 | loonies | 3 | 134027 | 723 | 6.546 | 20474.6 |
565 | 2023-09-12 04:38:26 | loonies | 2 | 107671 | 81 | 2.906 | 37051.3 |
564 | 2023-09-10 12:38:05 | loonies | 1 | 69583 | 9 | 1.203 | 57841.2 |
563 | 2023-08-28 22:27:09 | loonies | 3 | 134027 | 723 | 5.610 | 23890.7 |
562 | 2023-08-25 23:39:34 | loonies | 1 | 69583 | 9 | 2.423 | 28717.7 |
561 | 2023-08-06 01:02:34 | loonies | 1 | 69583 | 9 | 1.046 | 66522.9 |
560 | 2023-07-12 17:39:47 | loonies | 1 | 69583 | 9 | 1.123 | 61961.7 |
559 | 2023-05-14 01:05:35 | loonies | 3 | 134027 | 723 | 5.953 | 22514.2 |
558 | 2023-04-30 15:19:03 | loonies | 1 | 69583 | 9 | 1.046 | 66522.9 |
557 | 2023-04-08 22:13:27 | loonies | 1 | 69583 | 9 | 1.173 | 59320.5 |
556 | 2023-02-20 11:48:35 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
555 | 2023-02-19 04:54:29 | loonies | 3 | 134027 | 723 | 6.283 | 21331.7 |
554 | 2022-12-30 22:39:41 | loonies | 1 | 69583 | 9 | 1.060 | 65644.3 |
553 | 2022-12-17 23:59:22 | loonies | 1 | 69583 | 9 | 1.046 | 66522.9 |
552 | 2022-12-01 10:20:25 | loonies | 3 | 134027 | 723 | 5.576 | 24036.4 |
551 | 2022-09-16 12:19:20 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
550 | 2022-08-25 04:59:58 | loonies | 1 | 69583 | 9 | 1.170 | 59472.6 |
549 | 2022-08-22 19:01:52 | loonies | 1 | 69583 | 9 | 1.110 | 62687.4 |
548 | 2022-07-09 12:04:44 | loonies | 3 | 134027 | 723 | 5.736 | 23365.9 |
547 | 2022-06-07 11:57:52 | loonies | 1 | 69583 | 9 | 1.216 | 57222.9 |
546 | 2022-05-31 02:36:37 | loonies | 1 | 69583 | 9 | 1.203 | 57841.2 |
545 | 2022-04-06 13:39:37 | loonies | 1 | 69583 | 9 | 1.220 | 57035.2 |
544 | 2022-02-16 13:05:59 | loonies | 1 | 69583 | 9 | 1.060 | 65644.3 |
543 | 2022-01-06 00:36:08 | loonies | 1 | 69583 | 9 | 1.266 | 54962.9 |
542 | 2022-01-03 20:47:19 | loonies | 1 | 69583 | 9 | 1.126 | 61796.6 |
541 | 2021-11-16 14:37:47 | loonies | 1 | 69583 | 9 | 1.093 | 63662.4 |
540 | 2021-11-15 04:38:26 | loonies | 1 | 69583 | 9 | 1.170 | 59472.6 |
539 | 2021-09-13 01:25:01 | loonies | 1 | 69583 | 9 | 1.140 | 61037.7 |
538 | 2021-08-24 06:57:22 | loonies | 1 | 69583 | 9 | 1.203 | 57841.2 |
537 | 2021-08-15 16:16:01 | loonies | 1 | 69583 | 9 | 1.093 | 63662.4 |
536 | 2021-05-15 00:30:43 | loonies | 1 | 69583 | 9 | 1.200 | 57985.8 |
535 | 2021-04-30 18:19:09 | loonies | 1 | 69583 | 9 | 1.406 | 49490.0 |
534 | 2021-04-30 06:05:34 | loonies | 1 | 69583 | 9 | 1.110 | 62687.4 |
533 | 2021-03-29 16:23:04 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
532 | 2021-02-12 05:42:16 | loonies | 1 | 69583 | 9 | 1.080 | 64428.7 |
531 | 2021-02-07 12:17:26 | loonies | 1 | 69583 | 9 | 1.200 | 57985.8 |
530 | 2021-01-26 16:36:48 | loonies | 1 | 69583 | 9 | 1.200 | 57985.8 |
529 | 2020-11-10 12:15:17 | loonies | 1 | 69583 | 9 | 1.110 | 62687.4 |
528 | 2020-10-26 21:20:11 | loonies | 1 | 69583 | 9 | 1.233 | 56433.9 |
527 | 2020-10-14 21:35:21 | loonies | 1 | 69583 | 9 | 1.080 | 64428.7 |
526 | 2020-10-12 04:08:29 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
525 | 2020-09-30 18:42:32 | loonies | 1 | 69583 | 9 | 1.060 | 65644.3 |
524 | 2020-09-28 04:04:18 | loonies | 1 | 69583 | 9 | 1.186 | 58670.3 |
523 | 2020-09-13 05:06:19 | loonies | 1 | 69583 | 9 | 1.080 | 64428.7 |
522 | 2020-09-04 00:28:26 | loonies | 1 | 69583 | 9 | 1.203 | 57841.2 |
521 | 2020-08-10 16:02:37 | loonies | 1 | 69583 | 9 | 1.093 | 63662.4 |
520 | 2020-08-10 15:46:10 | loonies | 1 | 69583 | 9 | 1.126 | 61796.6 |
519 | 2020-08-01 07:20:21 | loonies | 1 | 69583 | 9 | 1.110 | 62687.4 |
518 | 2020-07-25 02:24:20 | loonies | 1 | 69583 | 9 | 1.093 | 63662.4 |
517 | 2020-05-31 14:31:17 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
516 | 2020-05-30 13:52:02 | loonies | 1 | 69583 | 9 | 1.060 | 65644.3 |
515 | 2020-05-09 10:42:45 | loonies | 1 | 69583 | 9 | 1.076 | 64668.2 |
514 | 2020-03-29 14:48:54 | loonies | 1 | 69583 | 9 | 1.266 | 54962.9 |
513 | 2020-03-27 22:04:14 | loonies | 1 | 69583 | 9 | 1.220 | 57035.2 |
512 | 2020-03-26 20:02:21 | loonies | 1 | 69583 | 9 | 1.296 | 53690.6 |
511 | 2020-03-24 11:20:03 | loonies | 1 | 69583 | 9 | 1.280 | 54361.7 |
510 | 2020-03-22 02:55:57 | loonies | 1 | 69583 | 9 | 1.250 | 55666.4 |
509 | 2020-03-19 22:02:11 | loonies | 1 | 69583 | 9 | 1.156 | 60192.9 |
508 | 2020-02-29 02:42:01 | loonies | 1 | 69583 | 9 | 1.436 | 48456.1 |
507 | 2020-02-26 21:14:21 | loonies | 1 | 69583 | 9 | 1.906 | 36507.3 |
506 | 2020-02-26 18:56:34 | loonies | 1 | 69583 | 9 | 1.250 | 55666.4 |
505 | 2020-02-24 10:01:19 | loonies | 1 | 69583 | 9 | 1.296 | 53690.6 |
504 | 2020-02-20 16:07:05 | loonies | 1 | 69583 | 9 | 1.263 | 55093.4 |
503 | 2020-02-12 05:46:21 | loonies | 1 | 69583 | 9 | 4.013 | 17339.4 |
502 | 2020-02-06 21:36:19 | loonies | 1 | 69583 | 9 | 1.326 | 52475.9 |
501 | 2020-02-03 04:09:22 | loonies | 1 | 69583 | 9 | 1.436 | 48456.1 |
500 | 2020-02-01 04:19:22 | loonies | 1 | 69583 | 9 | 4.000 | 17395.8 |
499 | 2020-01-31 06:20:13 | loonies | 1 | 69583 | 9 | 2.826 | 24622.4 |
498 | 2020-01-30 20:35:58 | loonies | 1 | 69583 | 9 | 1.420 | 49002.1 |
497 | 2020-01-26 16:31:12 | loonies | 1 | 69583 | 9 | 1.326 | 52475.9 |
496 | 2020-01-23 00:16:00 | loonies | 1 | 69583 | 9 | 1.420 | 49002.1 |
495 | 2020-01-17 22:54:38 | loonies | 1 | 69583 | 9 | 1.156 | 60192.9 |
494 | 2020-01-14 00:04:26 | loonies | 1 | 69583 | 9 | 2.156 | 32274.1 |
493 | 2020-01-13 01:31:19 | loonies | 1 | 69583 | 9 | 2.906 | 23944.6 |
492 | 2020-01-10 23:37:04 | loonies | 1 | 69583 | 9 | 2.640 | 26357.2 |
491 | 2020-01-07 12:02:37 | loonies | 1 | 69583 | 9 | 2.436 | 28564.4 |
490 | 2020-01-04 09:31:58 | loonies | 1 | 69583 | 9 | 1.063 | 65459.1 |
489 | 2019-12-26 15:51:47 | loonies | 1 | 69583 | 9 | 1.343 | 51811.6 |