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 |
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 |
488 | 2023-10-29 23:52:00 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
487 | 2023-10-22 06:16:21 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
486 | 2023-10-18 11:39:58 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
485 | 2023-10-11 23:39:21 | cities | 1 | 48755 | 6 | 0.766 | 63648.8 |
484 | 2023-10-07 01:21:24 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
483 | 2023-09-29 23:49:24 | cities | 2 | 82551 | 115 | 4.953 | 16666.9 |
482 | 2023-09-24 21:32:04 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
481 | 2023-09-12 20:01:03 | cities | 1 | 48755 | 6 | 0.813 | 59969.2 |
480 | 2023-09-09 08:06:15 | cities | 1 | 48755 | 6 | 0.813 | 59969.2 |
479 | 2023-08-25 02:01:23 | cities | 1 | 48755 | 6 | 0.860 | 56691.9 |
478 | 2023-06-19 04:06:05 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
477 | 2023-05-25 06:02:33 | cities | 1 | 48755 | 6 | 0.830 | 58741.0 |
476 | 2023-05-21 21:59:28 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
475 | 2023-04-02 15:20:41 | cities | 1 | 48755 | 6 | 0.736 | 66243.2 |
474 | 2023-02-15 19:00:18 | cities | 1 | 48755 | 6 | 0.826 | 59025.4 |
473 | 2023-01-16 17:38:11 | cities | 1 | 48755 | 6 | 0.796 | 61250.0 |
472 | 2022-11-16 07:45:43 | cities | 1 | 48755 | 6 | 0.860 | 56691.9 |
471 | 2022-11-13 07:18:15 | cities | 1 | 48755 | 6 | 0.750 | 65006.7 |
470 | 2022-09-11 23:26:53 | cities | 1 | 48755 | 6 | 0.766 | 63648.8 |
469 | 2022-09-03 15:21:23 | cities | 1 | 48755 | 6 | 0.780 | 62506.4 |