History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"campsites"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
592 | 2025-05-07 22:52:11 | campsites | 1 | 81242 | 2 | 6.263 | 12971.7 |
591 | 2025-04-28 17:13:24 | campsites | 3 | 148641 | 82 | 32.220 | 4613.3 |
590 | 2025-04-23 09:58:10 | campsites | 2 | 121436 | 9 | 19.750 | 6148.7 |
589 | 2025-04-22 10:59:21 | campsites | 1 | 81242 | 2 | 1.580 | 51419.0 |
588 | 2025-04-22 08:05:57 | campsites | 3 | 148641 | 82 | 7.580 | 19609.6 |
587 | 2025-04-21 01:18:10 | campsites | 3 | 148641 | 82 | 31.436 | 4728.4 |
586 | 2025-04-20 13:50:53 | campsites | 3 | 148641 | 82 | 28.783 | 5164.2 |
585 | 2025-04-18 00:32:25 | campsites | 1 | 81242 | 2 | 7.376 | 11014.4 |
584 | 2025-04-16 14:20:34 | campsites | 1 | 81242 | 2 | 5.970 | 13608.4 |
583 | 2025-04-15 02:26:00 | campsites | 3 | 148641 | 82 | 11.313 | 13139.0 |
582 | 2025-04-13 15:13:30 | campsites | 3 | 148641 | 82 | 7.546 | 19698.0 |
581 | 2025-03-22 12:52:27 | campsites | 1 | 81242 | 2 | 6.470 | 12556.7 |
580 | 2025-03-20 18:30:06 | campsites | 3 | 148641 | 82 | 50.796 | 2926.2 |
579 | 2025-03-20 18:19:15 | campsites | 1 | 81242 | 2 | 3.563 | 22801.6 |
578 | 2025-03-20 12:28:17 | campsites | 3 | 148641 | 82 | 35.970 | 4132.4 |
577 | 2025-03-15 02:31:40 | campsites | 1 | 81242 | 2 | 3.640 | 22319.2 |
576 | 2025-03-14 17:09:02 | campsites | 3 | 148641 | 82 | 42.580 | 3490.9 |
575 | 2025-03-14 01:37:19 | campsites | 3 | 148641 | 82 | 25.300 | 5875.1 |
574 | 2025-03-12 20:58:45 | campsites | 3 | 148641 | 82 | 46.113 | 3223.4 |
573 | 2025-03-11 19:45:47 | campsites | 3 | 148641 | 82 | 48.426 | 3069.4 |
572 | 2025-03-11 13:03:38 | campsites | 4 | 165329 | 723 | 64.080 | 2580.0 |
571 | 2025-03-11 13:02:01 | campsites | 3 | 148641 | 82 | 19.236 | 7727.2 |
570 | 2025-03-11 11:14:18 | campsites | 3 | 148641 | 82 | 37.533 | 3960.3 |
569 | 2025-03-11 11:04:55 | campsites | 3 | 148641 | 82 | 37.160 | 4000.0 |
568 | 2025-03-11 07:15:47 | campsites | 4 | 165329 | 723 | 72.923 | 2267.2 |
567 | 2025-03-11 07:15:41 | campsites | 3 | 148641 | 82 | 35.876 | 4143.2 |
566 | 2025-03-11 07:15:40 | campsites | 2 | 121436 | 9 | 17.530 | 6927.3 |
565 | 2025-03-10 15:10:10 | campsites | 1 | 81242 | 2 | 5.093 | 15951.7 |
564 | 2025-02-25 17:44:27 | campsites | 1 | 81242 | 2 | 3.046 | 26671.7 |
563 | 2025-02-21 13:12:29 | campsites | 1 | 81242 | 2 | 3.766 | 21572.5 |
562 | 2025-02-19 12:06:30 | campsites | 1 | 81242 | 2 | 5.766 | 14089.8 |
561 | 2025-02-06 18:20:59 | campsites | 1 | 81242 | 2 | 7.530 | 10789.1 |
560 | 2025-02-04 08:18:58 | campsites | 1 | 81242 | 2 | 2.563 | 31698.0 |
559 | 2025-01-29 00:21:05 | campsites | 3 | 148641 | 82 | 27.830 | 5341.0 |
558 | 2025-01-29 00:21:05 | campsites | 2 | 121436 | 9 | 22.050 | 5507.3 |
557 | 2025-01-22 02:33:54 | campsites | 1 | 81242 | 2 | 7.233 | 11232.1 |
556 | 2025-01-19 16:29:33 | campsites | 3 | 148641 | 82 | 44.923 | 3308.8 |
555 | 2025-01-18 07:42:05 | campsites | 3 | 148641 | 82 | 35.866 | 4144.3 |
554 | 2025-01-18 07:42:05 | campsites | 2 | 121436 | 9 | 10.876 | 11165.5 |
553 | 2025-01-18 07:41:12 | campsites | 3 | 148641 | 82 | 37.610 | 3952.2 |
552 | 2025-01-18 07:40:45 | campsites | 1 | 81242 | 2 | 7.096 | 11449.0 |
551 | 2024-12-27 21:57:00 | campsites | 1 | 81242 | 2 | 4.546 | 17871.1 |
550 | 2024-12-20 17:06:50 | campsites | 2 | 121436 | 9 | 21.436 | 5665.0 |
549 | 2024-12-20 17:04:49 | campsites | 1 | 81242 | 2 | 5.950 | 13654.1 |
548 | 2024-12-10 16:51:07 | campsites | 1 | 81242 | 2 | 6.643 | 12229.7 |
547 | 2024-10-27 12:40:00 | campsites | 1 | 81242 | 2 | 10.733 | 7569.4 |
546 | 2024-10-26 13:50:53 | campsites | 1 | 81242 | 2 | 5.856 | 13873.3 |
545 | 2024-10-06 11:06:18 | campsites | 1 | 81242 | 2 | 10.063 | 8073.3 |
544 | 2024-09-24 02:27:50 | campsites | 1 | 81242 | 2 | 11.656 | 6970.0 |
543 | 2024-09-23 23:56:15 | campsites | 1 | 81242 | 2 | 9.970 | 8148.6 |
542 | 2024-09-04 18:29:25 | campsites | 2 | 121436 | 9 | 36.593 | 3318.6 |
541 | 2024-09-04 18:28:33 | campsites | 1 | 81242 | 2 | 5.203 | 15614.5 |
540 | 2024-08-26 06:31:45 | campsites | 1 | 81242 | 2 | 7.860 | 10336.1 |
539 | 2024-08-23 11:35:37 | campsites | 1 | 81242 | 2 | 12.186 | 6666.8 |
538 | 2024-08-14 11:23:43 | campsites | 3 | 148641 | 82 | 68.223 | 2178.8 |
537 | 2024-08-12 17:00:02 | campsites | 3 | 148641 | 82 | 77.083 | 1928.3 |
536 | 2024-08-06 19:49:42 | campsites | 2 | 121436 | 9 | 7.983 | 15211.8 |
535 | 2024-08-06 00:25:02 | campsites | 2 | 121436 | 9 | 20.406 | 5951.0 |
534 | 2024-08-06 00:24:11 | campsites | 1 | 81242 | 2 | 3.906 | 20799.3 |
533 | 2024-07-27 09:26:06 | campsites | 3 | 148641 | 82 | 21.050 | 7061.3 |
532 | 2024-07-26 02:20:31 | campsites | 3 | 148641 | 82 | 39.473 | 3765.6 |
531 | 2024-07-26 02:20:34 | campsites | 2 | 121436 | 9 | 11.923 | 10185.0 |
530 | 2024-07-26 02:17:01 | campsites | 1 | 81242 | 2 | 4.783 | 16985.6 |
529 | 2024-07-23 05:48:30 | campsites | 1 | 81242 | 2 | 6.156 | 13197.2 |
528 | 2024-07-18 04:22:33 | campsites | 1 | 81242 | 2 | 5.720 | 14203.1 |
527 | 2024-07-11 14:35:57 | campsites | 1 | 81242 | 2 | 4.233 | 19192.5 |
526 | 2024-07-10 01:36:35 | campsites | 4 | 165329 | 723 | 49.266 | 3355.8 |
525 | 2024-07-09 18:59:57 | campsites | 4 | 165329 | 723 | 52.946 | 3122.6 |
524 | 2024-07-08 20:53:06 | campsites | 4 | 165329 | 723 | 37.610 | 4395.9 |
523 | 2024-07-08 05:00:07 | campsites | 4 | 165329 | 723 | 24.940 | 6629.1 |
522 | 2024-07-07 23:31:55 | campsites | 4 | 165329 | 723 | 44.393 | 3724.2 |
521 | 2024-07-07 23:32:10 | campsites | 3 | 148641 | 82 | 28.223 | 5266.7 |
520 | 2024-07-07 23:32:14 | campsites | 2 | 121436 | 9 | 18.410 | 6596.2 |
519 | 2024-07-07 23:30:44 | campsites | 1 | 81242 | 2 | 2.453 | 33119.4 |
518 | 2024-06-30 13:51:51 | campsites | 1 | 81242 | 2 | 3.656 | 22221.6 |
517 | 2024-06-12 02:16:21 | campsites | 1 | 81242 | 2 | 4.046 | 20079.6 |
516 | 2024-06-07 15:39:08 | campsites | 1 | 81242 | 2 | 4.750 | 17103.6 |
515 | 2024-06-04 18:07:28 | campsites | 2 | 121436 | 9 | 5.516 | 22015.2 |
514 | 2024-06-03 15:25:06 | campsites | 1 | 81242 | 2 | 1.640 | 49537.8 |
513 | 2024-06-01 08:49:59 | campsites | 1 | 81242 | 2 | 2.733 | 29726.3 |
512 | 2024-05-31 14:19:29 | campsites | 1 | 81242 | 2 | 1.500 | 54161.3 |
511 | 2024-05-31 01:46:03 | campsites | 1 | 81242 | 2 | 1.466 | 55417.5 |
510 | 2024-05-14 00:53:00 | campsites | 1 | 81242 | 2 | 1.516 | 53589.7 |
509 | 2024-05-11 09:51:24 | campsites | 1 | 81242 | 2 | 5.766 | 14089.8 |
508 | 2024-05-06 08:15:29 | campsites | 1 | 81242 | 2 | 1.376 | 59042.2 |
507 | 2024-04-30 14:22:37 | campsites | 1 | 81242 | 2 | 1.500 | 54161.3 |
506 | 2024-04-29 04:13:50 | campsites | 3 | 148641 | 82 | 14.686 | 10121.3 |
505 | 2024-04-28 11:21:34 | campsites | 3 | 148641 | 82 | 15.780 | 9419.6 |
504 | 2024-04-27 19:55:30 | campsites | 1 | 81242 | 2 | 1.253 | 64838.0 |
503 | 2024-04-27 17:35:45 | campsites | 4 | 165329 | 723 | 19.390 | 8526.5 |
502 | 2024-04-25 03:11:30 | campsites | 3 | 148641 | 82 | 15.766 | 9427.9 |
501 | 2024-04-23 22:17:05 | campsites | 1 | 81242 | 2 | 2.690 | 30201.5 |
500 | 2024-04-23 04:26:54 | campsites | 3 | 148641 | 82 | 18.893 | 7867.5 |
499 | 2024-04-23 04:26:56 | campsites | 2 | 121436 | 9 | 4.686 | 25914.6 |
498 | 2024-04-23 01:51:08 | campsites | 1 | 81242 | 2 | 1.453 | 55913.3 |
497 | 2024-04-10 18:17:53 | campsites | 4 | 165329 | 723 | 27.206 | 6076.9 |
496 | 2024-04-10 15:25:49 | campsites | 4 | 165329 | 723 | 51.126 | 3233.8 |
495 | 2024-04-10 15:25:45 | campsites | 2 | 121436 | 9 | 12.936 | 9387.4 |
494 | 2024-04-10 14:47:43 | campsites | 1 | 81242 | 2 | 1.593 | 50999.4 |
493 | 2024-04-08 15:23:26 | campsites | 1 | 81242 | 2 | 3.326 | 24426.3 |