History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cities"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
588 | 2025-04-18 04:27:55 | cities | 1 | 48755 | 6 | 2.376 | 20519.8 |
587 | 2025-04-15 09:54:23 | cities | 1 | 48755 | 6 | 0.830 | 58741.0 |
586 | 2025-04-12 22:54:03 | cities | 1 | 48755 | 6 | 1.780 | 27390.4 |
585 | 2025-04-12 14:04:19 | cities | 2 | 82551 | 115 | 15.296 | 5396.9 |
584 | 2025-04-11 01:33:31 | cities | 1 | 48755 | 6 | 5.640 | 8644.5 |
583 | 2025-04-10 12:35:58 | cities | 1 | 48755 | 6 | 0.953 | 51159.5 |
582 | 2025-04-09 04:37:54 | cities | 1 | 48755 | 6 | 6.186 | 7881.5 |
581 | 2025-04-08 21:04:25 | cities | 1 | 48755 | 6 | 6.530 | 7466.3 |
580 | 2025-04-08 07:55:27 | cities | 1 | 48755 | 6 | 3.720 | 13106.2 |
579 | 2025-04-04 16:28:05 | cities | 1 | 48755 | 6 | 1.983 | 24586.5 |
578 | 2025-03-20 06:29:44 | cities | 1 | 48755 | 6 | 2.156 | 22613.6 |
577 | 2025-03-17 15:59:02 | cities | 1 | 48755 | 6 | 5.986 | 8144.8 |
576 | 2025-03-10 04:52:30 | cities | 1 | 48755 | 6 | 3.593 | 13569.4 |
575 | 2025-03-08 22:00:43 | cities | 1 | 48755 | 6 | 4.580 | 10645.2 |
574 | 2025-03-07 19:30:02 | cities | 1 | 48755 | 6 | 2.313 | 21078.7 |
573 | 2025-03-01 14:30:43 | cities | 1 | 48755 | 6 | 3.063 | 15917.4 |
572 | 2025-02-24 14:59:37 | cities | 1 | 48755 | 6 | 3.860 | 12630.8 |
571 | 2025-02-16 17:56:34 | cities | 1 | 48755 | 6 | 2.406 | 20263.9 |
570 | 2025-02-12 16:39:27 | cities | 2 | 82551 | 115 | 2.796 | 29524.7 |
569 | 2025-02-12 16:39:24 | cities | 1 | 48755 | 6 | 0.843 | 57835.1 |
568 | 2025-01-25 22:25:44 | cities | 2 | 82551 | 115 | 10.876 | 7590.2 |
567 | 2025-01-25 08:50:48 | cities | 2 | 82551 | 115 | 11.763 | 7017.9 |
566 | 2025-01-25 08:50:39 | cities | 1 | 48755 | 6 | 4.406 | 11065.6 |
565 | 2025-01-10 04:52:25 | cities | 2 | 82551 | 115 | 18.270 | 4518.4 |
564 | 2025-01-10 04:52:25 | cities | 1 | 48755 | 6 | 3.673 | 13273.9 |
563 | 2025-01-05 11:41:31 | cities | 1 | 48755 | 6 | 3.640 | 13394.2 |
562 | 2024-12-26 23:05:46 | cities | 1 | 48755 | 6 | 0.966 | 50471.0 |
561 | 2024-12-26 02:19:02 | cities | 1 | 48755 | 6 | 2.576 | 18926.6 |
560 | 2024-12-06 09:32:18 | cities | 1 | 48755 | 6 | 3.610 | 13505.5 |
559 | 2024-11-25 13:58:17 | cities | 2 | 82551 | 115 | 5.363 | 15392.7 |
558 | 2024-11-25 13:58:10 | cities | 1 | 48755 | 6 | 1.970 | 24748.7 |
557 | 2024-11-20 02:39:25 | cities | 2 | 82551 | 115 | 7.296 | 11314.6 |
556 | 2024-11-08 10:13:24 | cities | 2 | 82551 | 115 | 13.890 | 5943.2 |
555 | 2024-11-08 01:15:15 | cities | 2 | 82551 | 115 | 10.046 | 8217.3 |
554 | 2024-11-08 01:10:48 | cities | 1 | 48755 | 6 | 4.470 | 10907.2 |
553 | 2024-11-07 09:03:52 | cities | 2 | 82551 | 115 | 4.983 | 16566.5 |
552 | 2024-11-07 09:03:45 | cities | 1 | 48755 | 6 | 2.843 | 17149.1 |
551 | 2024-11-06 06:21:47 | cities | 1 | 48755 | 6 | 2.093 | 23294.3 |
550 | 2024-10-26 04:09:01 | cities | 2 | 82551 | 115 | 18.483 | 4466.3 |
549 | 2024-10-26 04:08:53 | cities | 1 | 48755 | 6 | 2.156 | 22613.6 |
548 | 2024-10-08 21:10:51 | cities | 1 | 48755 | 6 | 3.110 | 15676.8 |
547 | 2024-10-08 02:46:51 | cities | 1 | 48755 | 6 | 4.580 | 10645.2 |
546 | 2024-10-07 05:55:48 | cities | 2 | 82551 | 115 | 18.343 | 4500.4 |
545 | 2024-10-07 05:55:36 | cities | 1 | 48755 | 6 | 4.360 | 11182.3 |
544 | 2024-09-25 13:31:46 | cities | 1 | 48755 | 6 | 6.000 | 8125.8 |
543 | 2024-09-22 08:39:50 | cities | 1 | 48755 | 6 | 3.110 | 15676.8 |
542 | 2024-09-04 17:00:36 | cities | 1 | 48755 | 6 | 5.763 | 8460.0 |
541 | 2024-09-03 23:33:03 | cities | 1 | 48755 | 6 | 8.970 | 5435.3 |
540 | 2024-08-29 17:32:42 | cities | 1 | 48755 | 6 | 2.610 | 18680.1 |
539 | 2024-08-26 12:15:25 | cities | 1 | 48755 | 6 | 3.453 | 14119.6 |
538 | 2024-08-19 13:41:16 | cities | 1 | 48755 | 6 | 3.016 | 16165.5 |
537 | 2024-08-18 19:48:33 | cities | 1 | 48755 | 6 | 3.953 | 12333.7 |
536 | 2024-08-10 00:08:46 | cities | 2 | 82551 | 115 | 9.906 | 8333.4 |
535 | 2024-08-08 12:37:24 | cities | 2 | 82551 | 115 | 5.356 | 15412.8 |
534 | 2024-08-08 10:34:14 | cities | 2 | 82551 | 115 | 9.563 | 8632.3 |
533 | 2024-08-08 00:49:21 | cities | 1 | 48755 | 6 | 3.033 | 16074.8 |
532 | 2024-08-07 09:02:08 | cities | 1 | 48755 | 6 | 3.190 | 15283.7 |
531 | 2024-08-02 00:44:34 | cities | 1 | 48755 | 6 | 2.376 | 20519.8 |
530 | 2024-07-30 21:58:31 | cities | 1 | 48755 | 6 | 4.576 | 10654.5 |
529 | 2024-07-29 10:57:11 | cities | 2 | 82551 | 115 | 11.096 | 7439.7 |
528 | 2024-07-29 08:26:56 | cities | 2 | 82551 | 115 | 9.346 | 8832.8 |
527 | 2024-07-29 07:05:26 | cities | 2 | 82551 | 115 | 13.783 | 5989.3 |
526 | 2024-07-29 05:56:45 | cities | 2 | 82551 | 115 | 7.186 | 11487.8 |
525 | 2024-07-29 05:56:28 | cities | 1 | 48755 | 6 | 4.530 | 10762.7 |
524 | 2024-07-26 21:02:02 | cities | 1 | 48755 | 6 | 1.763 | 27654.6 |
523 | 2024-07-19 14:49:22 | cities | 1 | 48755 | 6 | 3.420 | 14255.8 |
522 | 2024-07-09 19:02:35 | cities | 1 | 48755 | 6 | 2.703 | 18037.4 |
521 | 2024-07-06 22:55:35 | cities | 1 | 48755 | 6 | 4.390 | 11105.9 |
520 | 2024-07-06 22:53:32 | cities | 1 | 48755 | 6 | 3.390 | 14382.0 |
519 | 2024-07-03 15:11:18 | cities | 1 | 48755 | 6 | 2.390 | 20399.6 |
518 | 2024-07-02 20:24:28 | cities | 1 | 48755 | 6 | 4.533 | 10755.6 |
517 | 2024-06-30 08:08:30 | cities | 1 | 48755 | 6 | 4.093 | 11911.8 |
516 | 2024-06-29 02:26:44 | cities | 1 | 48755 | 6 | 4.640 | 10507.5 |
515 | 2024-06-26 18:22:51 | cities | 1 | 48755 | 6 | 3.890 | 12533.4 |
514 | 2024-05-29 11:57:37 | cities | 1 | 48755 | 6 | 2.873 | 16970.1 |
513 | 2024-05-27 12:07:41 | cities | 1 | 48755 | 6 | 2.236 | 21804.6 |
512 | 2024-05-16 14:50:52 | cities | 1 | 48755 | 6 | 0.890 | 54780.9 |
511 | 2024-04-28 02:18:43 | cities | 1 | 48755 | 6 | 1.483 | 32875.9 |
510 | 2024-04-27 06:56:31 | cities | 1 | 48755 | 6 | 2.860 | 17047.2 |
509 | 2024-04-23 19:39:39 | cities | 1 | 48755 | 6 | 1.873 | 26030.4 |
508 | 2024-03-31 17:02:53 | cities | 1 | 48755 | 6 | 1.953 | 24964.2 |
507 | 2024-03-31 05:59:47 | cities | 1 | 48755 | 6 | 0.966 | 50471.0 |
506 | 2024-03-30 06:45:35 | cities | 2 | 82551 | 115 | 6.266 | 13174.4 |
505 | 2024-03-28 05:46:25 | cities | 1 | 48755 | 6 | 1.330 | 36657.9 |
504 | 2024-03-28 05:46:13 | cities | 2 | 82551 | 115 | 2.483 | 33246.5 |
503 | 2024-03-06 22:33:44 | cities | 1 | 48755 | 6 | 3.970 | 12280.9 |
502 | 2024-02-29 07:39:01 | cities | 1 | 48755 | 6 | 0.873 | 55847.7 |
501 | 2024-02-28 10:22:50 | cities | 1 | 48755 | 6 | 1.906 | 25579.7 |
500 | 2024-01-29 08:12:22 | cities | 1 | 48755 | 6 | 0.890 | 54780.9 |
499 | 2024-01-13 05:21:18 | cities | 2 | 82551 | 115 | 2.266 | 36430.3 |
498 | 2023-12-31 19:11:40 | cities | 2 | 82551 | 115 | 2.406 | 34310.5 |
497 | 2023-12-30 06:06:07 | cities | 1 | 48755 | 6 | 0.783 | 62266.9 |
496 | 2023-12-24 22:28:51 | cities | 2 | 82551 | 115 | 2.390 | 34540.2 |
495 | 2023-12-18 22:18:20 | cities | 1 | 48755 | 6 | 0.843 | 57835.1 |
494 | 2023-12-02 17:31:42 | cities | 2 | 82551 | 115 | 2.250 | 36689.3 |
493 | 2023-11-27 12:08:00 | cities | 1 | 48755 | 6 | 0.890 | 54780.9 |
492 | 2023-11-24 20:32:52 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
491 | 2023-11-17 00:37:41 | cities | 1 | 48755 | 6 | 0.860 | 56691.9 |
490 | 2023-11-13 21:32:21 | cities | 1 | 48755 | 6 | 0.830 | 58741.0 |
489 | 2023-11-11 09:01:46 | cities | 1 | 48755 | 6 | 0.780 | 62506.4 |