History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guitar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
585 | 2024-05-03 18:43:26 | guitar | 2 | 82551 | 15 | 2.623 | 31472.0 |
584 | 2024-04-20 22:20:47 | guitar | 2 | 82551 | 15 | 6.720 | 12284.4 |
583 | 2024-04-20 22:20:10 | guitar | 1 | 48755 | 2 | 1.843 | 26454.2 |
582 | 2024-04-20 22:05:31 | guitar | 3 | 112716 | 309 | 18.186 | 6198.0 |
581 | 2024-04-20 14:58:31 | guitar | 3 | 112716 | 309 | 7.000 | 16102.3 |
580 | 2024-04-20 14:58:14 | guitar | 1 | 48755 | 2 | 0.966 | 50471.0 |
579 | 2024-04-15 23:12:31 | guitar | 1 | 48755 | 2 | 1.063 | 45865.5 |
578 | 2024-04-06 06:19:44 | guitar | 2 | 82551 | 15 | 2.626 | 31436.0 |
577 | 2024-04-06 06:19:42 | guitar | 1 | 48755 | 2 | 0.843 | 57835.1 |
576 | 2024-03-30 01:18:29 | guitar | 3 | 112716 | 309 | 16.156 | 6976.7 |
575 | 2024-03-29 05:24:46 | guitar | 3 | 112716 | 309 | 6.140 | 18357.7 |
574 | 2024-03-29 05:24:43 | guitar | 2 | 82551 | 15 | 3.376 | 24452.3 |
573 | 2024-03-29 05:24:37 | guitar | 1 | 48755 | 2 | 1.076 | 45311.3 |
572 | 2024-03-21 22:42:27 | guitar | 3 | 112716 | 309 | 5.266 | 21404.5 |
571 | 2024-03-18 21:24:29 | guitar | 1 | 48755 | 2 | 0.843 | 57835.1 |
570 | 2024-03-18 21:24:11 | guitar | 3 | 112716 | 309 | 5.843 | 19290.8 |
569 | 2024-03-18 11:44:15 | guitar | 3 | 112716 | 309 | 12.156 | 9272.5 |
568 | 2024-03-18 04:35:15 | guitar | 3 | 112716 | 309 | 5.533 | 20371.6 |
567 | 2024-03-18 04:35:16 | guitar | 2 | 82551 | 15 | 2.610 | 31628.7 |
566 | 2024-03-18 04:35:12 | guitar | 1 | 48755 | 2 | 0.890 | 54780.9 |
565 | 2024-03-06 00:00:41 | guitar | 1 | 48755 | 2 | 1.970 | 24748.7 |
564 | 2024-02-18 00:50:46 | guitar | 2 | 82551 | 15 | 3.673 | 22475.1 |
563 | 2024-02-17 17:38:20 | guitar | 1 | 48755 | 2 | 0.923 | 52822.3 |
562 | 2024-02-14 23:37:58 | guitar | 1 | 48755 | 2 | 0.920 | 52994.6 |
561 | 2024-01-31 21:28:57 | guitar | 1 | 48755 | 2 | 0.796 | 61250.0 |
560 | 2024-01-25 04:30:03 | guitar | 1 | 48755 | 2 | 0.720 | 67715.3 |
559 | 2024-01-23 10:54:44 | guitar | 3 | 112716 | 309 | 18.466 | 6104.0 |
558 | 2024-01-22 18:41:47 | guitar | 3 | 112716 | 309 | 6.623 | 17018.9 |
557 | 2024-01-21 05:12:59 | guitar | 3 | 112716 | 309 | 4.843 | 23274.0 |
556 | 2024-01-21 05:13:00 | guitar | 2 | 82551 | 15 | 2.390 | 34540.2 |
555 | 2024-01-09 03:11:28 | guitar | 1 | 48755 | 2 | 0.810 | 60191.4 |
554 | 2024-01-07 16:11:41 | guitar | 1 | 48755 | 2 | 0.766 | 63648.8 |
553 | 2023-12-18 13:14:47 | guitar | 2 | 82551 | 15 | 2.453 | 33653.1 |
552 | 2023-12-13 20:51:17 | guitar | 1 | 48755 | 2 | 0.796 | 61250.0 |
551 | 2023-12-03 15:45:14 | guitar | 1 | 48755 | 2 | 0.763 | 63899.1 |
550 | 2023-12-03 15:45:13 | guitar | 1 | 48755 | 2 | 0.813 | 59969.2 |
549 | 2023-11-21 07:38:45 | guitar | 1 | 48755 | 2 | 0.736 | 66243.2 |
548 | 2023-11-18 14:16:19 | guitar | 1 | 48755 | 2 | 1.716 | 28412.0 |
547 | 2023-11-15 03:42:30 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
546 | 2023-11-11 19:56:48 | guitar | 1 | 48755 | 2 | 0.873 | 55847.7 |
545 | 2023-10-15 02:13:32 | guitar | 1 | 48755 | 2 | 1.016 | 47987.2 |
544 | 2023-09-24 23:04:25 | guitar | 1 | 48755 | 2 | 0.826 | 59025.4 |
543 | 2023-09-17 19:15:09 | guitar | 2 | 82551 | 15 | 2.030 | 40665.5 |
542 | 2023-09-14 11:19:32 | guitar | 1 | 48755 | 2 | 0.796 | 61250.0 |
541 | 2023-09-08 02:43:45 | guitar | 1 | 48755 | 2 | 0.800 | 60943.8 |
540 | 2023-07-21 03:05:24 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
539 | 2023-07-01 03:56:20 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
538 | 2023-06-20 20:33:21 | guitar | 2 | 82551 | 15 | 2.686 | 30733.8 |
537 | 2023-06-11 03:47:54 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
536 | 2023-04-02 02:43:12 | guitar | 1 | 48755 | 2 | 0.716 | 68093.6 |
535 | 2023-03-29 21:30:13 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
534 | 2023-03-15 20:59:55 | guitar | 2 | 82551 | 15 | 2.060 | 40073.3 |
533 | 2023-01-11 00:55:43 | guitar | 1 | 48755 | 2 | 0.703 | 69352.8 |
532 | 2022-12-17 19:48:08 | guitar | 2 | 82551 | 15 | 2.046 | 40347.5 |
531 | 2022-12-17 04:17:59 | guitar | 1 | 48755 | 2 | 0.703 | 69352.8 |
530 | 2022-10-18 20:14:16 | guitar | 1 | 48755 | 2 | 0.716 | 68093.6 |
529 | 2022-09-19 20:22:51 | guitar | 1 | 48755 | 2 | 0.720 | 67715.3 |
528 | 2022-09-03 12:52:45 | guitar | 1 | 48755 | 2 | 0.800 | 60943.8 |
527 | 2022-08-26 09:18:47 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
526 | 2022-08-13 19:48:39 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
525 | 2022-08-07 11:50:27 | guitar | 2 | 82551 | 15 | 2.096 | 39385.0 |
524 | 2022-07-26 21:11:29 | guitar | 3 | 112716 | 309 | 4.610 | 24450.3 |
523 | 2022-07-16 06:23:00 | guitar | 3 | 112716 | 309 | 4.626 | 24365.8 |
522 | 2022-06-09 00:00:21 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
521 | 2022-04-06 00:29:35 | guitar | 1 | 48755 | 2 | 0.920 | 52994.6 |
520 | 2021-12-18 21:22:37 | guitar | 1 | 48755 | 2 | 0.893 | 54596.9 |
519 | 2021-12-15 16:02:38 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
518 | 2021-09-05 04:46:10 | guitar | 1 | 48755 | 2 | 0.720 | 67715.3 |
517 | 2021-09-01 21:17:59 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
516 | 2021-06-01 04:27:30 | guitar | 1 | 48755 | 2 | 0.906 | 53813.5 |
515 | 2021-05-21 03:39:55 | guitar | 1 | 48755 | 2 | 0.766 | 63648.8 |
514 | 2021-04-02 20:41:19 | guitar | 1 | 48755 | 2 | 1.153 | 42285.3 |
513 | 2021-03-01 23:57:07 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
512 | 2021-02-02 11:05:19 | guitar | 1 | 48755 | 2 | 1.500 | 32503.3 |
511 | 2021-01-06 17:29:02 | guitar | 1 | 48755 | 2 | 0.766 | 63648.8 |
510 | 2020-12-08 20:37:15 | guitar | 1 | 48755 | 2 | 0.783 | 62266.9 |
509 | 2020-11-30 11:19:45 | guitar | 1 | 48755 | 2 | 0.983 | 49598.2 |
508 | 2020-11-18 07:10:59 | guitar | 1 | 48755 | 2 | 0.733 | 66514.3 |
507 | 2020-11-01 11:50:44 | guitar | 1 | 48755 | 2 | 0.876 | 55656.4 |
506 | 2020-10-13 00:33:33 | guitar | 1 | 48755 | 2 | 0.826 | 59025.4 |
505 | 2020-10-07 20:27:59 | guitar | 1 | 48755 | 2 | 0.750 | 65006.7 |
504 | 2020-09-05 01:02:56 | guitar | 1 | 48755 | 2 | 1.453 | 33554.7 |
503 | 2020-08-29 23:45:25 | guitar | 1 | 48755 | 2 | 0.813 | 59969.2 |
502 | 2020-07-31 20:00:53 | guitar | 1 | 48755 | 2 | 0.796 | 61250.0 |
501 | 2020-07-20 22:46:12 | guitar | 1 | 48755 | 2 | 0.796 | 61250.0 |
500 | 2020-05-16 00:24:01 | guitar | 1 | 48755 | 2 | 0.720 | 67715.3 |
499 | 2020-05-13 00:13:21 | guitar | 1 | 48755 | 2 | 0.766 | 63648.8 |
498 | 2020-03-28 20:52:00 | guitar | 1 | 48755 | 2 | 0.846 | 57630.0 |
497 | 2020-03-28 06:45:46 | guitar | 1 | 48755 | 2 | 0.890 | 54780.9 |
496 | 2020-03-28 05:08:48 | guitar | 1 | 48755 | 2 | 0.826 | 59025.4 |
495 | 2020-03-27 22:02:27 | guitar | 1 | 48755 | 2 | 0.810 | 60191.4 |
494 | 2020-03-23 13:17:29 | guitar | 1 | 48755 | 2 | 0.830 | 58741.0 |
493 | 2020-03-22 16:01:03 | guitar | 1 | 48755 | 2 | 0.830 | 58741.0 |
492 | 2020-03-18 08:12:23 | guitar | 1 | 48755 | 2 | 1.843 | 26454.2 |
491 | 2020-02-27 20:37:40 | guitar | 1 | 48755 | 2 | 1.826 | 26700.4 |
490 | 2020-02-27 19:43:50 | guitar | 1 | 48755 | 2 | 1.860 | 26212.4 |
489 | 2020-02-14 22:40:45 | guitar | 1 | 48755 | 2 | 0.813 | 59969.2 |
488 | 2020-02-10 09:17:19 | guitar | 1 | 48755 | 2 | 1.890 | 25796.3 |
487 | 2020-02-06 09:24:44 | guitar | 1 | 48755 | 2 | 0.940 | 51867.0 |
486 | 2020-02-05 20:35:35 | guitar | 1 | 48755 | 2 | 0.826 | 59025.4 |