History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scotia"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 803 | 2025-01-28 15:13:03 | scotia | 3 | 112716 | 361 | 35.436 | 3180.8 |
| 802 | 2025-01-28 14:38:10 | scotia | 3 | 112716 | 361 | 25.486 | 4422.7 |
| 801 | 2025-01-28 12:56:23 | scotia | 3 | 112716 | 361 | 16.440 | 6856.2 |
| 800 | 2025-01-28 12:14:23 | scotia | 3 | 112716 | 361 | 25.186 | 4475.3 |
| 799 | 2025-01-27 11:28:54 | scotia | 1 | 48755 | 3 | 4.343 | 11226.1 |
| 798 | 2025-01-25 19:33:44 | scotia | 1 | 48755 | 3 | 2.313 | 21078.7 |
| 797 | 2025-01-15 08:58:32 | scotia | 2 | 82551 | 21 | 11.923 | 6923.7 |
| 796 | 2025-01-15 08:58:34 | scotia | 1 | 48755 | 3 | 1.856 | 26268.9 |
| 795 | 2025-01-04 22:26:20 | scotia | 1 | 48755 | 3 | 4.813 | 10129.9 |
| 794 | 2025-01-03 23:08:46 | scotia | 1 | 48755 | 3 | 2.470 | 19738.9 |
| 793 | 2024-12-29 17:02:44 | scotia | 2 | 82551 | 21 | 2.483 | 33246.5 |
| 792 | 2024-12-29 11:01:14 | scotia | 2 | 82551 | 21 | 13.233 | 6238.3 |
| 791 | 2024-12-29 11:01:09 | scotia | 1 | 48755 | 3 | 4.516 | 10796.1 |
| 790 | 2024-12-28 07:40:50 | scotia | 3 | 112716 | 361 | 25.373 | 4442.4 |
| 789 | 2024-12-26 17:28:24 | scotia | 3 | 112716 | 361 | 28.970 | 3890.8 |
| 788 | 2024-12-26 14:41:16 | scotia | 3 | 112716 | 361 | 25.470 | 4425.4 |
| 787 | 2024-12-26 14:41:22 | scotia | 2 | 82551 | 21 | 7.250 | 11386.3 |
| 786 | 2024-12-26 14:41:06 | scotia | 1 | 48755 | 3 | 3.936 | 12386.9 |
| 785 | 2024-12-21 19:47:29 | scotia | 1 | 48755 | 3 | 3.970 | 12280.9 |
| 784 | 2024-12-15 20:25:25 | scotia | 1 | 48755 | 3 | 2.186 | 22303.3 |
| 783 | 2024-11-29 09:11:53 | scotia | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 782 | 2024-11-26 11:58:35 | scotia | 1 | 48755 | 3 | 2.766 | 17626.5 |
| 781 | 2024-11-16 20:39:32 | scotia | 3 | 112716 | 361 | 32.593 | 3458.3 |
| 780 | 2024-11-15 18:11:34 | scotia | 3 | 112716 | 361 | 28.473 | 3958.7 |
| 779 | 2024-11-15 10:20:12 | scotia | 2 | 82551 | 21 | 2.516 | 32810.4 |
| 778 | 2024-11-15 10:20:04 | scotia | 3 | 112716 | 361 | 6.046 | 18643.1 |
| 777 | 2024-11-15 10:19:31 | scotia | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 776 | 2024-10-29 19:34:13 | scotia | 1 | 48755 | 3 | 4.063 | 11999.8 |
| 775 | 2024-10-26 11:30:17 | scotia | 1 | 48755 | 3 | 4.110 | 11862.5 |
| 774 | 2024-10-13 14:01:56 | scotia | 3 | 112716 | 361 | 42.190 | 2671.6 |
| 773 | 2024-10-12 09:58:53 | scotia | 3 | 112716 | 361 | 28.360 | 3974.5 |
| 772 | 2024-10-12 07:52:07 | scotia | 3 | 112716 | 361 | 25.813 | 4366.6 |
| 771 | 2024-10-11 18:16:49 | scotia | 3 | 112716 | 361 | 31.410 | 3588.5 |
| 770 | 2024-10-11 18:16:45 | scotia | 2 | 82551 | 21 | 9.733 | 8481.6 |
| 769 | 2024-10-11 18:16:30 | scotia | 1 | 48755 | 3 | 3.873 | 12588.4 |
| 768 | 2024-10-10 09:59:47 | scotia | 1 | 48755 | 3 | 2.610 | 18680.1 |
| 767 | 2024-09-28 11:18:41 | scotia | 1 | 48755 | 3 | 6.173 | 7898.1 |
| 766 | 2024-09-23 09:50:47 | scotia | 1 | 48755 | 3 | 6.156 | 7919.9 |
| 765 | 2024-09-08 18:23:19 | scotia | 1 | 48755 | 3 | 8.466 | 5758.9 |
| 764 | 2024-08-31 01:42:29 | scotia | 1 | 48755 | 3 | 9.143 | 5332.5 |
| 763 | 2024-08-29 17:16:47 | scotia | 1 | 48755 | 3 | 2.876 | 16952.4 |
| 762 | 2024-08-18 05:02:43 | scotia | 1 | 48755 | 3 | 5.486 | 8887.2 |
| 761 | 2024-08-18 04:11:01 | scotia | 1 | 48755 | 3 | 6.906 | 7059.8 |
| 760 | 2024-08-11 02:09:03 | scotia | 1 | 48755 | 3 | 2.000 | 24377.5 |
| 759 | 2024-08-08 10:18:16 | scotia | 1 | 48755 | 3 | 4.436 | 10990.8 |
| 758 | 2024-07-30 22:09:39 | scotia | 1 | 48755 | 3 | 3.326 | 14658.7 |
| 757 | 2024-07-28 14:14:48 | scotia | 1 | 48755 | 3 | 3.453 | 14119.6 |
| 756 | 2024-07-18 07:15:49 | scotia | 1 | 48755 | 3 | 2.096 | 23261.0 |
| 755 | 2024-07-12 18:17:28 | scotia | 1 | 48755 | 3 | 3.423 | 14243.4 |
| 754 | 2024-07-11 21:54:12 | scotia | 1 | 48755 | 3 | 4.516 | 10796.1 |
| 753 | 2024-07-06 23:40:17 | scotia | 1 | 48755 | 3 | 2.310 | 21106.1 |
| 752 | 2024-07-06 23:37:49 | scotia | 1 | 48755 | 3 | 6.173 | 7898.1 |
| 751 | 2024-06-30 22:35:50 | scotia | 1 | 48755 | 3 | 3.076 | 15850.1 |
| 750 | 2024-06-29 09:06:32 | scotia | 1 | 48755 | 3 | 2.390 | 20399.6 |
| 749 | 2024-06-28 05:00:22 | scotia | 1 | 48755 | 3 | 4.236 | 11509.7 |
| 748 | 2024-06-22 06:52:01 | scotia | 1 | 48755 | 3 | 1.403 | 34750.5 |
| 747 | 2024-06-18 16:36:52 | scotia | 1 | 48755 | 3 | 2.170 | 22467.7 |
| 746 | 2024-06-10 02:31:07 | scotia | 3 | 112716 | 361 | 21.000 | 5367.4 |
| 745 | 2024-06-08 21:09:17 | scotia | 3 | 112716 | 361 | 15.720 | 7170.2 |
| 744 | 2024-06-08 17:42:58 | scotia | 3 | 112716 | 361 | 20.296 | 5553.6 |
| 743 | 2024-06-08 08:20:22 | scotia | 3 | 112716 | 361 | 26.720 | 4218.4 |
| 742 | 2024-06-07 06:04:07 | scotia | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 741 | 2024-06-06 20:16:13 | scotia | 3 | 112716 | 361 | 5.440 | 20719.9 |
| 740 | 2024-06-03 19:57:32 | scotia | 1 | 48755 | 3 | 4.080 | 11949.8 |
| 739 | 2024-06-01 12:54:28 | scotia | 1 | 48755 | 3 | 1.873 | 26030.4 |
| 738 | 2024-05-29 00:56:21 | scotia | 1 | 48755 | 3 | 3.000 | 16251.7 |
| 737 | 2024-05-22 16:26:16 | scotia | 1 | 48755 | 3 | 1.923 | 25353.6 |
| 736 | 2024-05-15 05:00:09 | scotia | 1 | 48755 | 3 | 0.903 | 53992.2 |
| 735 | 2024-05-09 20:21:57 | scotia | 2 | 82551 | 21 | 4.530 | 18223.2 |
| 734 | 2024-05-08 14:58:27 | scotia | 3 | 112716 | 361 | 16.233 | 6943.6 |
| 733 | 2024-05-06 19:58:12 | scotia | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 732 | 2024-05-06 11:24:12 | scotia | 2 | 82551 | 21 | 5.156 | 16010.7 |
| 731 | 2024-05-06 01:58:30 | scotia | 2 | 82551 | 21 | 3.500 | 23586.0 |
| 730 | 2024-05-05 01:17:43 | scotia | 2 | 82551 | 21 | 2.970 | 27794.9 |
| 729 | 2024-05-05 01:17:23 | scotia | 3 | 112716 | 361 | 8.986 | 12543.5 |
| 728 | 2024-05-04 15:01:43 | scotia | 3 | 112716 | 361 | 5.716 | 19719.4 |
| 727 | 2024-05-04 14:16:41 | scotia | 3 | 112716 | 361 | 22.580 | 4991.9 |
| 726 | 2024-05-04 11:34:40 | scotia | 2 | 82551 | 21 | 5.376 | 15355.5 |
| 725 | 2024-05-04 11:34:36 | scotia | 3 | 112716 | 361 | 6.170 | 18268.4 |
| 724 | 2024-05-04 11:34:32 | scotia | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 723 | 2024-05-04 11:34:27 | scotia | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 722 | 2024-05-04 11:34:20 | scotia | 2 | 82551 | 21 | 5.546 | 14884.8 |
| 721 | 2024-05-04 11:34:15 | scotia | 3 | 112716 | 361 | 6.000 | 18786.0 |
| 720 | 2024-04-27 03:25:58 | scotia | 2 | 82551 | 21 | 2.643 | 31233.8 |
| 719 | 2024-04-26 20:01:01 | scotia | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 718 | 2024-04-26 11:05:58 | scotia | 1 | 48755 | 3 | 1.763 | 27654.6 |
| 717 | 2024-04-05 11:52:24 | scotia | 2 | 82551 | 21 | 4.516 | 18279.7 |
| 716 | 2024-04-04 06:51:23 | scotia | 3 | 112716 | 361 | 10.830 | 10407.8 |
| 715 | 2024-04-04 06:51:26 | scotia | 2 | 82551 | 21 | 5.970 | 13827.6 |
| 714 | 2024-04-04 06:51:01 | scotia | 3 | 112716 | 361 | 20.156 | 5592.2 |
| 713 | 2024-04-04 06:51:16 | scotia | 1 | 48755 | 3 | 2.920 | 16696.9 |
| 712 | 2024-04-04 06:51:01 | scotia | 2 | 82551 | 21 | 3.000 | 27517.0 |
| 711 | 2024-04-04 06:50:55 | scotia | 1 | 48755 | 3 | 3.033 | 16074.8 |
| 710 | 2024-03-30 00:55:12 | scotia | 1 | 48755 | 3 | 2.093 | 23294.3 |
| 709 | 2024-03-05 11:52:38 | scotia | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 708 | 2024-01-30 16:40:27 | scotia | 3 | 112716 | 361 | 5.343 | 21096.0 |
| 707 | 2024-01-29 23:49:46 | scotia | 2 | 82551 | 21 | 2.533 | 32590.2 |
| 706 | 2024-01-29 23:49:18 | scotia | 3 | 112716 | 361 | 5.360 | 21029.1 |
| 705 | 2024-01-29 14:51:55 | scotia | 3 | 112716 | 361 | 5.483 | 20557.4 |
| 704 | 2024-01-26 23:12:20 | scotia | 1 | 48755 | 3 | 0.906 | 53813.5 |