History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"provinces"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
609 | 2025-08-29 19:58:42 | provinces | 1 | 81242 | 2 | 1.390 | 58447.5 |
608 | 2025-08-29 17:18:20 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
607 | 2025-08-25 02:36:32 | provinces | 1 | 81242 | 2 | 3.373 | 24086.0 |
606 | 2025-08-18 21:05:05 | provinces | 1 | 81242 | 2 | 3.280 | 24768.9 |
605 | 2025-08-02 15:29:59 | provinces | 1 | 81242 | 2 | 2.736 | 29693.7 |
604 | 2025-08-01 19:05:00 | provinces | 1 | 81242 | 2 | 6.440 | 12615.2 |
603 | 2025-07-31 00:41:21 | provinces | 1 | 81242 | 2 | 7.796 | 10421.0 |
602 | 2025-07-27 10:42:34 | provinces | 3 | 148641 | 82 | 19.236 | 7727.2 |
601 | 2025-07-27 09:54:15 | provinces | 3 | 148641 | 82 | 26.360 | 5638.9 |
600 | 2025-07-26 23:06:33 | provinces | 2 | 121436 | 9 | 15.140 | 8020.9 |
599 | 2025-07-26 21:22:01 | provinces | 3 | 148641 | 82 | 25.986 | 5720.0 |
598 | 2025-07-25 05:58:29 | provinces | 2 | 121436 | 9 | 9.470 | 12823.2 |
597 | 2025-07-25 03:49:01 | provinces | 3 | 148641 | 82 | 23.890 | 6221.9 |
596 | 2025-07-25 03:39:14 | provinces | 1 | 81242 | 2 | 2.920 | 27822.6 |
595 | 2025-07-25 02:13:15 | provinces | 3 | 148641 | 82 | 29.440 | 5048.9 |
594 | 2025-07-25 00:11:59 | provinces | 1 | 81242 | 2 | 6.173 | 13160.9 |
593 | 2025-07-23 11:43:24 | provinces | 1 | 81242 | 2 | 6.750 | 12035.9 |
592 | 2025-07-23 00:48:02 | provinces | 1 | 81242 | 2 | 5.906 | 13755.8 |
591 | 2025-07-22 09:52:41 | provinces | 1 | 81242 | 2 | 1.420 | 57212.7 |
590 | 2025-07-21 16:32:46 | provinces | 1 | 81242 | 2 | 1.466 | 55417.5 |
589 | 2025-07-07 17:10:15 | provinces | 1 | 81242 | 2 | 3.406 | 23852.6 |
588 | 2025-07-07 16:41:32 | provinces | 1 | 81242 | 2 | 4.360 | 18633.5 |
587 | 2025-07-04 19:48:29 | provinces | 2 | 121436 | 9 | 15.300 | 7937.0 |
586 | 2025-07-03 20:43:18 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
585 | 2025-06-25 23:47:18 | provinces | 1 | 81242 | 2 | 8.483 | 9577.0 |
584 | 2025-06-21 20:59:51 | provinces | 3 | 148641 | 82 | 26.156 | 5682.9 |
583 | 2025-06-20 20:57:42 | provinces | 3 | 148641 | 82 | 37.940 | 3917.8 |
582 | 2025-06-20 09:25:05 | provinces | 2 | 121436 | 9 | 17.296 | 7021.0 |
581 | 2025-06-20 02:28:05 | provinces | 3 | 148641 | 82 | 38.690 | 3841.8 |
580 | 2025-06-18 23:14:23 | provinces | 1 | 81242 | 2 | 1.580 | 51419.0 |
579 | 2025-06-02 16:03:41 | provinces | 1 | 81242 | 2 | 7.500 | 10832.3 |
578 | 2025-05-28 21:37:53 | provinces | 1 | 81242 | 2 | 3.436 | 23644.4 |
577 | 2025-05-24 03:08:39 | provinces | 1 | 81242 | 2 | 7.673 | 10588.0 |
576 | 2025-05-15 03:36:54 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
575 | 2025-05-14 02:09:53 | provinces | 3 | 148641 | 82 | 22.050 | 6741.1 |
574 | 2025-05-12 10:47:00 | provinces | 3 | 148641 | 82 | 21.140 | 7031.3 |
573 | 2025-05-09 20:40:42 | provinces | 1 | 81242 | 2 | 6.970 | 11656.0 |
572 | 2025-05-06 09:50:26 | provinces | 3 | 148641 | 82 | 39.476 | 3765.4 |
571 | 2025-05-05 22:05:34 | provinces | 2 | 121436 | 9 | 18.936 | 6413.0 |
570 | 2025-05-04 22:52:42 | provinces | 1 | 81242 | 2 | 1.486 | 54671.6 |
569 | 2025-04-25 12:44:21 | provinces | 3 | 148641 | 82 | 36.236 | 4102.0 |
568 | 2025-04-24 15:09:48 | provinces | 1 | 81242 | 2 | 10.186 | 7975.8 |
567 | 2025-04-23 02:43:40 | provinces | 1 | 81242 | 2 | 5.563 | 14604.0 |
566 | 2025-04-22 22:52:05 | provinces | 1 | 81242 | 2 | 10.156 | 7999.4 |
565 | 2025-04-11 23:17:10 | provinces | 1 | 81242 | 2 | 6.766 | 12007.4 |
564 | 2025-04-11 06:19:30 | provinces | 2 | 121436 | 9 | 12.406 | 9788.5 |
563 | 2025-04-11 01:26:06 | provinces | 3 | 148641 | 82 | 30.123 | 4934.5 |
562 | 2025-04-10 20:57:19 | provinces | 3 | 148641 | 82 | 30.863 | 4816.2 |
561 | 2025-04-09 10:40:54 | provinces | 3 | 148641 | 82 | 30.673 | 4846.0 |
560 | 2025-04-08 19:54:13 | provinces | 2 | 121436 | 9 | 23.876 | 5086.1 |
559 | 2025-04-07 20:19:46 | provinces | 1 | 81242 | 2 | 1.313 | 61875.1 |
558 | 2025-03-23 09:02:40 | provinces | 1 | 81242 | 2 | 6.250 | 12998.7 |
557 | 2025-03-23 04:31:03 | provinces | 1 | 81242 | 2 | 7.406 | 10969.8 |
556 | 2025-03-22 23:46:45 | provinces | 1 | 81242 | 2 | 10.173 | 7986.0 |
555 | 2025-03-19 23:50:00 | provinces | 1 | 81242 | 2 | 7.280 | 11159.6 |
554 | 2025-03-10 01:19:56 | provinces | 3 | 148641 | 82 | 36.330 | 4091.4 |
553 | 2025-03-09 10:24:30 | provinces | 2 | 121436 | 9 | 17.893 | 6786.8 |
552 | 2025-03-03 04:40:58 | provinces | 2 | 121436 | 9 | 16.783 | 7235.7 |
551 | 2025-02-25 03:39:00 | provinces | 3 | 148641 | 82 | 32.003 | 4644.6 |
550 | 2025-02-24 17:33:57 | provinces | 1 | 81242 | 2 | 3.440 | 23616.9 |
549 | 2025-02-23 07:54:34 | provinces | 3 | 148641 | 82 | 36.346 | 4089.6 |
548 | 2025-02-20 08:53:19 | provinces | 3 | 148641 | 82 | 35.313 | 4209.2 |
547 | 2025-02-19 14:58:13 | provinces | 1 | 81242 | 2 | 6.750 | 12035.9 |
546 | 2025-02-19 14:54:35 | provinces | 3 | 148641 | 82 | 66.063 | 2250.0 |
545 | 2025-02-18 19:49:17 | provinces | 3 | 148641 | 82 | 36.346 | 4089.6 |
544 | 2025-02-13 20:14:58 | provinces | 1 | 81242 | 2 | 3.610 | 22504.7 |
543 | 2025-02-12 11:38:01 | provinces | 3 | 148641 | 82 | 30.330 | 4900.8 |
542 | 2025-02-11 06:05:18 | provinces | 3 | 148641 | 82 | 38.046 | 3906.9 |
541 | 2025-02-06 14:30:57 | provinces | 4 | 165329 | 678 | 75.910 | 2178.0 |
540 | 2025-02-05 11:55:23 | provinces | 4 | 165329 | 678 | 78.160 | 2115.3 |
539 | 2025-02-03 13:42:09 | provinces | 4 | 165329 | 678 | 49.300 | 3353.5 |
538 | 2025-02-03 13:42:00 | provinces | 2 | 121436 | 9 | 16.690 | 7276.0 |
537 | 2025-01-17 19:37:13 | provinces | 3 | 148641 | 82 | 19.656 | 7562.1 |
536 | 2025-01-17 08:08:01 | provinces | 3 | 148641 | 82 | 37.440 | 3970.1 |
535 | 2025-01-15 19:30:24 | provinces | 3 | 148641 | 82 | 37.233 | 3992.2 |
534 | 2025-01-15 19:27:19 | provinces | 1 | 81242 | 2 | 3.700 | 21957.3 |
533 | 2025-01-14 23:26:56 | provinces | 1 | 81242 | 2 | 1.453 | 55913.3 |
532 | 2025-01-07 21:14:21 | provinces | 4 | 165329 | 678 | 66.720 | 2478.0 |
531 | 2025-01-07 13:28:39 | provinces | 4 | 165329 | 678 | 62.160 | 2659.7 |
530 | 2025-01-06 08:30:19 | provinces | 4 | 165329 | 678 | 87.903 | 1880.8 |
529 | 2025-01-06 07:24:51 | provinces | 1 | 81242 | 2 | 1.436 | 56575.2 |
528 | 2025-01-04 05:29:12 | provinces | 2 | 121436 | 9 | 18.436 | 6586.9 |
527 | 2025-01-04 05:28:47 | provinces | 3 | 148641 | 82 | 22.453 | 6620.1 |
526 | 2024-12-24 10:09:10 | provinces | 3 | 148641 | 82 | 32.546 | 4567.1 |
525 | 2024-12-23 04:35:56 | provinces | 1 | 81242 | 2 | 5.373 | 15120.4 |
524 | 2024-12-18 22:03:02 | provinces | 3 | 148641 | 82 | 29.233 | 5084.7 |
523 | 2024-12-17 23:57:40 | provinces | 3 | 148641 | 82 | 40.236 | 3694.2 |
522 | 2024-12-17 18:28:10 | provinces | 3 | 148641 | 82 | 35.580 | 4177.7 |
521 | 2024-12-17 13:29:26 | provinces | 3 | 148641 | 82 | 33.736 | 4406.0 |
520 | 2024-12-15 16:43:06 | provinces | 1 | 81242 | 2 | 1.453 | 55913.3 |
519 | 2024-12-10 04:27:48 | provinces | 1 | 81242 | 2 | 6.483 | 12531.5 |
518 | 2024-12-03 15:50:04 | provinces | 2 | 121436 | 9 | 18.470 | 6574.8 |
517 | 2024-12-02 12:39:20 | provinces | 3 | 148641 | 82 | 37.503 | 3963.4 |
516 | 2024-12-02 12:39:18 | provinces | 2 | 121436 | 9 | 27.596 | 4400.5 |
515 | 2024-11-22 14:31:14 | provinces | 1 | 81242 | 2 | 7.516 | 10809.2 |
514 | 2024-11-12 16:56:59 | provinces | 3 | 148641 | 82 | 33.656 | 4416.5 |
513 | 2024-11-10 21:23:01 | provinces | 3 | 148641 | 82 | 52.516 | 2830.4 |
512 | 2024-11-10 08:03:18 | provinces | 3 | 148641 | 82 | 43.566 | 3411.9 |
511 | 2024-11-10 08:03:16 | provinces | 4 | 165329 | 678 | 31.363 | 5271.5 |
510 | 2024-11-10 08:03:28 | provinces | 2 | 121436 | 9 | 15.283 | 7945.8 |