History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hallmarked"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
150 | 2024-03-31 03:56:47 | hallmarked | 1 | 67641 | 1 | 1.123 | 60232.4 |
149 | 2024-03-29 07:48:38 | hallmarked | 5 | 173545 | 561 | 59.036 | 2939.6 |
148 | 2024-03-21 18:59:03 | hallmarked | 4 | 161450 | 69 | 16.250 | 9935.4 |
147 | 2024-03-18 08:41:00 | hallmarked | 1 | 67641 | 1 | 1.093 | 61885.6 |
146 | 2024-03-17 21:21:33 | hallmarked | 5 | 173545 | 561 | 61.360 | 2828.3 |
145 | 2024-03-16 18:06:41 | hallmarked | 2 | 108824 | 3 | 11.033 | 9863.5 |
144 | 2024-03-16 18:06:44 | hallmarked | 3 | 140603 | 8 | 7.686 | 18293.4 |
143 | 2024-03-16 18:04:52 | hallmarked | 1 | 67641 | 1 | 2.470 | 27385.0 |
142 | 2024-03-16 10:28:57 | hallmarked | 4 | 161450 | 69 | 22.686 | 7116.7 |
141 | 2024-03-15 06:51:07 | hallmarked | 4 | 161450 | 69 | 41.520 | 3888.5 |
140 | 2024-03-15 06:51:12 | hallmarked | 3 | 140603 | 8 | 15.390 | 9136.0 |
139 | 2024-03-15 06:51:07 | hallmarked | 2 | 108824 | 3 | 10.876 | 10005.9 |
138 | 2024-03-15 06:46:41 | hallmarked | 1 | 67641 | 1 | 1.140 | 59334.2 |
137 | 2024-03-11 06:17:14 | hallmarked | 5 | 173545 | 561 | 57.986 | 2992.9 |
136 | 2024-03-10 14:59:54 | hallmarked | 5 | 173545 | 561 | 34.813 | 4985.1 |
135 | 2024-02-29 13:04:48 | hallmarked | 3 | 140603 | 8 | 12.716 | 11057.2 |
134 | 2024-02-29 13:04:45 | hallmarked | 2 | 108824 | 3 | 3.420 | 31819.9 |
133 | 2024-02-29 13:04:24 | hallmarked | 1 | 67641 | 1 | 1.063 | 63632.2 |
132 | 2024-02-29 10:28:44 | hallmarked | 1 | 67641 | 1 | 1.203 | 56226.9 |
131 | 2024-02-19 21:27:23 | hallmarked | 4 | 161450 | 69 | 19.533 | 8265.5 |
130 | 2024-02-16 14:04:56 | hallmarked | 3 | 140603 | 8 | 25.500 | 5513.8 |
129 | 2024-02-15 18:57:19 | hallmarked | 5 | 173545 | 561 | 60.113 | 2887.0 |
128 | 2024-02-14 17:54:55 | hallmarked | 4 | 161450 | 69 | 29.096 | 5548.9 |
127 | 2024-02-12 01:34:29 | hallmarked | 1 | 67641 | 1 | 5.110 | 13237.0 |
126 | 2024-02-11 07:00:13 | hallmarked | 4 | 161450 | 69 | 28.830 | 5600.1 |
125 | 2024-02-11 06:59:23 | hallmarked | 5 | 173545 | 561 | 31.860 | 5447.1 |
124 | 2024-02-11 03:01:08 | hallmarked | 5 | 173545 | 561 | 20.873 | 8314.3 |
123 | 2024-02-11 03:01:07 | hallmarked | 4 | 161450 | 69 | 13.546 | 11918.6 |
122 | 2024-02-11 03:01:06 | hallmarked | 3 | 140603 | 8 | 7.500 | 18747.1 |
121 | 2024-02-06 23:43:10 | hallmarked | 1 | 67641 | 1 | 1.123 | 60232.4 |
120 | 2024-02-06 13:15:51 | hallmarked | 1 | 67641 | 1 | 1.156 | 58513.0 |
119 | 2024-01-28 14:41:15 | hallmarked | 1 | 67641 | 1 | 1.093 | 61885.6 |
118 | 2024-01-15 06:52:24 | hallmarked | 1 | 67641 | 1 | 1.030 | 65670.9 |
117 | 2024-01-01 13:04:15 | hallmarked | 1 | 67641 | 1 | 1.030 | 65670.9 |
116 | 2023-12-22 01:22:39 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
115 | 2023-11-06 13:45:16 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
114 | 2023-08-28 06:25:26 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
113 | 2023-07-09 14:24:57 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
112 | 2023-05-29 07:48:31 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
111 | 2023-03-23 11:30:43 | hallmarked | 1 | 67641 | 1 | 0.970 | 69733.0 |
110 | 2023-02-09 20:43:09 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
109 | 2023-01-08 01:44:05 | hallmarked | 1 | 67641 | 1 | 0.970 | 69733.0 |
108 | 2022-10-07 10:16:42 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
107 | 2022-09-17 02:33:14 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
106 | 2022-05-22 01:27:35 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
105 | 2022-03-26 14:11:56 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
104 | 2022-02-05 14:30:55 | hallmarked | 1 | 67641 | 1 | 1.170 | 57812.8 |
103 | 2021-11-25 07:56:29 | hallmarked | 1 | 67641 | 1 | 1.110 | 60937.8 |
102 | 2021-11-09 02:56:03 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
101 | 2021-10-29 12:02:53 | hallmarked | 1 | 67641 | 1 | 1.063 | 63632.2 |
100 | 2021-08-26 12:04:43 | hallmarked | 1 | 67641 | 1 | 1.156 | 58513.0 |
99 | 2021-07-19 19:43:51 | hallmarked | 1 | 67641 | 1 | 1.000 | 67641.0 |
98 | 2021-05-12 15:47:46 | hallmarked | 1 | 67641 | 1 | 1.513 | 44706.5 |
97 | 2021-04-17 03:39:56 | hallmarked | 1 | 67641 | 1 | 1.140 | 59334.2 |
96 | 2021-01-25 17:22:28 | hallmarked | 1 | 67641 | 1 | 1.030 | 65670.9 |
95 | 2021-01-07 12:06:34 | hallmarked | 1 | 67641 | 1 | 1.110 | 60937.8 |
94 | 2020-11-06 03:17:52 | hallmarked | 1 | 67641 | 1 | 1.140 | 59334.2 |
93 | 2020-11-02 14:52:28 | hallmarked | 1 | 67641 | 1 | 2.153 | 31417.1 |
92 | 2020-10-01 18:01:02 | hallmarked | 1 | 67641 | 1 | 1.016 | 66575.8 |
91 | 2020-06-09 08:33:21 | hallmarked | 1 | 67641 | 1 | 1.126 | 60071.9 |
90 | 2020-06-06 10:25:20 | hallmarked | 1 | 67641 | 1 | 1.280 | 52844.5 |
89 | 2020-03-25 22:40:32 | hallmarked | 1 | 67641 | 1 | 1.186 | 57032.9 |
88 | 2020-03-05 22:40:13 | hallmarked | 1 | 67641 | 1 | 1.470 | 46014.3 |
87 | 2020-03-01 04:21:14 | hallmarked | 1 | 67641 | 1 | 3.953 | 17111.3 |
86 | 2020-02-28 12:43:18 | hallmarked | 1 | 67641 | 1 | 2.420 | 27950.8 |
85 | 2020-02-28 09:32:23 | hallmarked | 1 | 67641 | 1 | 2.453 | 27574.8 |
84 | 2020-02-18 04:39:14 | hallmarked | 1 | 67641 | 1 | 2.546 | 26567.6 |
83 | 2020-02-16 19:46:12 | hallmarked | 1 | 67641 | 1 | 1.656 | 40846.0 |
82 | 2020-02-10 19:40:29 | hallmarked | 1 | 67641 | 1 | 1.063 | 63632.2 |
81 | 2020-02-04 11:19:12 | hallmarked | 1 | 67641 | 1 | 2.313 | 29243.8 |
80 | 2020-01-21 20:20:33 | hallmarked | 1 | 67641 | 1 | 3.673 | 18415.7 |
79 | 2020-01-21 16:57:38 | hallmarked | 1 | 67641 | 1 | 1.546 | 43752.3 |
78 | 2020-01-13 10:37:16 | hallmarked | 1 | 67641 | 1 | 1.310 | 51634.4 |
77 | 2020-01-07 06:38:19 | hallmarked | 1 | 67641 | 1 | 1.250 | 54112.8 |
76 | 2019-12-06 01:08:05 | hallmarked | 1 | 67641 | 1 | 1.093 | 61885.6 |
75 | 2019-11-03 16:46:51 | hallmarked | 1 | 67641 | 1 | 1.173 | 57665.0 |
74 | 2019-07-14 13:19:09 | hallmarked | 1 | 67641 | 1 | 1.093 | 61885.6 |
73 | 2019-04-05 21:55:08 | hallmarked | 1 | 67641 | 1 | 0.990 | 68324.2 |
72 | 2019-03-27 12:35:48 | hallmarked | 1 | 67641 | 1 | 1.123 | 60232.4 |
71 | 2019-02-18 13:15:03 | hallmarked | 1 | 67641 | 1 | 1.126 | 60071.9 |
70 | 2018-09-30 05:25:22 | hallmarked | 1 | 67641 | 1 | 1.060 | 63812.3 |
69 | 2018-06-18 15:55:08 | hallmarked | 1 | 67641 | 1 | 1.236 | 54725.7 |
68 | 2018-05-01 00:29:41 | hallmarked | 1 | 67641 | 1 | 1.003 | 67438.7 |
67 | 2018-01-03 20:20:38 | hallmarked | 1 | 67641 | 1 | 1.386 | 48803.0 |
66 | 2017-11-24 08:26:56 | hallmarked | 1 | 67641 | 1 | 1.750 | 38652.0 |
65 | 2017-11-12 08:59:01 | hallmarked | 1 | 67641 | 1 | 1.363 | 49626.6 |
64 | 2017-07-30 18:15:03 | hallmarked | 1 | 67641 | 1 | 1.866 | 36249.2 |
63 | 2017-05-10 23:24:08 | hallmarked | 1 | 67641 | 1 | 1.303 | 51911.7 |
62 | 2016-12-28 20:51:37 | hallmarked | 1 | 67641 | 1 | 1.663 | 40674.1 |
61 | 2016-08-27 21:44:09 | hallmarked | 4 | 161450 | 69 | 16.026 | 10074.3 |
60 | 2016-08-17 19:06:39 | hallmarked | 1 | 67641 | 1 | 1.333 | 50743.4 |
59 | 2016-07-13 13:47:52 | hallmarked | 1 | 67641 | 1 | 1.746 | 38740.5 |
58 | 2016-07-01 14:35:45 | hallmarked | 3 | 140603 | 8 | 10.773 | 13051.4 |
57 | 2016-07-01 01:48:56 | hallmarked | 1 | 67641 | 1 | 1.340 | 50478.4 |
56 | 2016-06-30 17:46:31 | hallmarked | 1 | 67641 | 1 | 1.686 | 40119.2 |
55 | 2016-06-14 15:10:33 | hallmarked | 1 | 67641 | 1 | 1.676 | 40358.6 |
54 | 2016-04-05 11:33:20 | hallmarked | 2 | 108824 | 3 | 13.183 | 8254.9 |
53 | 2016-03-31 15:10:16 | hallmarked | 5 | 173545 | 561 | 20.316 | 8542.3 |
52 | 2016-03-25 06:39:39 | hallmarked | 2 | 108824 | 3 | 3.313 | 32847.6 |
51 | 2016-03-24 23:16:20 | hallmarked | 5 | 173545 | 561 | 39.473 | 4396.5 |