History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"longhair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
231 | 2024-04-14 12:47:06 | longhair | 3 | 146162 | 20 | 18.563 | 7873.8 |
230 | 2024-04-12 16:13:50 | longhair | 3 | 146162 | 20 | 36.910 | 3960.0 |
229 | 2024-04-11 08:34:44 | longhair | 4 | 161609 | 240 | 13.313 | 12139.2 |
228 | 2024-04-11 08:34:36 | longhair | 2 | 121059 | 4 | 5.376 | 22518.4 |
227 | 2024-04-11 03:22:24 | longhair | 3 | 146162 | 20 | 8.440 | 17317.8 |
226 | 2024-04-11 03:22:22 | longhair | 1 | 82945 | 2 | 2.843 | 29175.2 |
225 | 2024-04-09 23:12:10 | longhair | 2 | 121059 | 4 | 12.280 | 9858.2 |
224 | 2024-04-09 23:02:51 | longhair | 1 | 82945 | 2 | 3.736 | 22201.6 |
223 | 2024-04-08 08:17:52 | longhair | 1 | 82945 | 2 | 1.686 | 49196.3 |
222 | 2024-04-08 04:03:21 | longhair | 2 | 121059 | 4 | 5.343 | 22657.5 |
221 | 2024-04-08 04:03:15 | longhair | 1 | 82945 | 2 | 1.546 | 53651.4 |
220 | 2024-04-04 01:51:04 | longhair | 3 | 146162 | 20 | 20.766 | 7038.5 |
219 | 2024-04-03 15:43:43 | longhair | 1 | 82945 | 2 | 3.423 | 24231.7 |
218 | 2024-03-31 21:37:43 | longhair | 4 | 161609 | 240 | 16.470 | 9812.3 |
217 | 2024-03-31 07:02:07 | longhair | 3 | 146162 | 20 | 16.796 | 8702.2 |
216 | 2024-03-30 07:41:18 | longhair | 4 | 161609 | 240 | 37.380 | 4323.4 |
215 | 2024-03-29 00:30:20 | longhair | 4 | 161609 | 240 | 37.846 | 4270.2 |
214 | 2024-03-28 23:42:13 | longhair | 1 | 82945 | 2 | 1.610 | 51518.6 |
213 | 2024-03-28 23:26:38 | longhair | 4 | 161609 | 240 | 22.800 | 7088.1 |
212 | 2024-03-28 23:26:38 | longhair | 2 | 121059 | 4 | 8.813 | 13736.4 |
211 | 2024-03-28 23:26:36 | longhair | 3 | 146162 | 20 | 10.126 | 14434.3 |
210 | 2024-03-14 19:48:56 | longhair | 4 | 161609 | 240 | 15.656 | 10322.5 |
209 | 2024-03-12 04:42:47 | longhair | 4 | 161609 | 240 | 16.390 | 9860.2 |
208 | 2024-03-12 04:42:58 | longhair | 1 | 82945 | 2 | 3.250 | 25521.5 |
207 | 2024-03-12 04:42:48 | longhair | 2 | 121059 | 4 | 7.796 | 15528.3 |
206 | 2024-03-12 04:38:54 | longhair | 1 | 82945 | 2 | 3.733 | 22219.4 |
205 | 2024-03-11 16:07:23 | longhair | 3 | 146162 | 20 | 9.000 | 16240.2 |
204 | 2024-03-11 02:22:30 | longhair | 3 | 146162 | 20 | 17.406 | 8397.2 |
203 | 2024-03-08 19:15:43 | longhair | 3 | 146162 | 20 | 16.923 | 8636.9 |
202 | 2024-03-08 19:15:43 | longhair | 2 | 121059 | 4 | 12.736 | 9505.3 |
201 | 2024-03-08 18:54:58 | longhair | 1 | 82945 | 2 | 3.220 | 25759.3 |
200 | 2024-03-03 09:03:42 | longhair | 2 | 121059 | 4 | 3.876 | 31233.0 |
199 | 2024-03-03 09:03:40 | longhair | 1 | 82945 | 2 | 1.390 | 59672.7 |
198 | 2024-03-02 11:22:01 | longhair | 3 | 146162 | 20 | 15.796 | 9253.1 |
197 | 2024-03-01 00:46:03 | longhair | 1 | 82945 | 2 | 2.653 | 31264.6 |
196 | 2024-03-01 00:32:31 | longhair | 3 | 146162 | 20 | 7.423 | 19690.4 |
195 | 2024-03-01 00:32:29 | longhair | 2 | 121059 | 4 | 3.763 | 32170.9 |
194 | 2024-02-27 23:05:01 | longhair | 4 | 161609 | 240 | 25.500 | 6337.6 |
193 | 2024-02-27 20:18:58 | longhair | 4 | 161609 | 240 | 12.360 | 13075.2 |
192 | 2024-02-27 20:19:03 | longhair | 3 | 146162 | 20 | 7.796 | 18748.3 |
191 | 2024-02-27 20:19:02 | longhair | 2 | 121059 | 4 | 3.860 | 31362.4 |
190 | 2024-02-27 20:18:54 | longhair | 1 | 82945 | 2 | 1.423 | 58288.8 |
189 | 2024-02-08 00:51:14 | longhair | 3 | 146162 | 20 | 8.890 | 16441.2 |
188 | 2024-02-08 00:51:04 | longhair | 2 | 121059 | 4 | 4.266 | 28377.6 |
187 | 2024-02-06 16:08:09 | longhair | 1 | 82945 | 2 | 3.203 | 25896.0 |
186 | 2024-02-06 15:18:18 | longhair | 2 | 121059 | 4 | 3.796 | 31891.2 |
185 | 2024-02-06 11:08:38 | longhair | 4 | 161609 | 240 | 12.486 | 12943.2 |
184 | 2024-02-06 11:08:22 | longhair | 3 | 146162 | 20 | 15.923 | 9179.3 |
183 | 2024-02-05 08:28:15 | longhair | 1 | 82945 | 2 | 2.966 | 27965.3 |
182 | 2024-02-01 12:22:28 | longhair | 1 | 82945 | 2 | 1.250 | 66356.0 |
181 | 2024-01-31 20:18:57 | longhair | 1 | 82945 | 2 | 1.423 | 58288.8 |
180 | 2024-01-30 19:35:50 | longhair | 1 | 82945 | 2 | 1.483 | 55930.5 |
179 | 2024-01-30 19:29:55 | longhair | 3 | 146162 | 20 | 7.690 | 19006.8 |
178 | 2024-01-30 17:54:03 | longhair | 2 | 121059 | 4 | 3.846 | 31476.6 |
177 | 2024-01-26 08:44:47 | longhair | 4 | 161609 | 240 | 13.733 | 11767.9 |
176 | 2024-01-26 08:44:43 | longhair | 3 | 146162 | 20 | 9.593 | 15236.3 |
175 | 2024-01-26 08:44:39 | longhair | 2 | 121059 | 4 | 3.796 | 31891.2 |
174 | 2024-01-26 08:43:27 | longhair | 3 | 146162 | 20 | 8.470 | 17256.4 |
173 | 2024-01-26 08:43:23 | longhair | 2 | 121059 | 4 | 3.986 | 30371.0 |
172 | 2024-01-26 08:43:11 | longhair | 1 | 82945 | 2 | 1.313 | 63172.1 |
171 | 2024-01-20 01:27:32 | longhair | 1 | 82945 | 2 | 1.250 | 66356.0 |
170 | 2023-11-15 14:36:01 | longhair | 1 | 82945 | 2 | 1.420 | 58412.0 |
169 | 2023-09-03 13:22:06 | longhair | 1 | 82945 | 2 | 1.263 | 65673.0 |
168 | 2023-08-30 23:00:54 | longhair | 1 | 82945 | 2 | 1.330 | 62364.7 |
167 | 2023-04-10 22:20:36 | longhair | 1 | 82945 | 2 | 1.250 | 66356.0 |
166 | 2023-02-13 18:24:19 | longhair | 1 | 82945 | 2 | 1.233 | 67270.9 |
165 | 2022-12-10 13:05:27 | longhair | 1 | 82945 | 2 | 1.250 | 66356.0 |
164 | 2022-11-22 04:03:50 | longhair | 1 | 82945 | 2 | 1.420 | 58412.0 |
163 | 2022-08-12 12:16:21 | longhair | 1 | 82945 | 2 | 1.283 | 64649.3 |
162 | 2022-08-10 01:45:44 | longhair | 1 | 82945 | 2 | 1.296 | 64000.8 |
161 | 2022-06-27 07:06:48 | longhair | 1 | 82945 | 2 | 1.373 | 60411.5 |
160 | 2022-01-21 07:52:47 | longhair | 1 | 82945 | 2 | 1.500 | 55296.7 |
159 | 2022-01-18 01:30:46 | longhair | 1 | 82945 | 2 | 1.326 | 62552.8 |
158 | 2022-01-14 18:42:25 | longhair | 1 | 82945 | 2 | 1.360 | 60989.0 |
157 | 2021-09-09 16:50:29 | longhair | 1 | 82945 | 2 | 1.436 | 57761.1 |
156 | 2021-05-16 21:26:09 | longhair | 1 | 82945 | 2 | 1.330 | 62364.7 |
155 | 2021-05-10 03:23:40 | longhair | 1 | 82945 | 2 | 1.296 | 64000.8 |
154 | 2021-04-25 16:52:08 | longhair | 1 | 82945 | 2 | 1.330 | 62364.7 |
153 | 2021-04-24 12:12:04 | longhair | 1 | 82945 | 2 | 1.296 | 64000.8 |
152 | 2021-04-23 02:30:52 | longhair | 1 | 82945 | 2 | 1.250 | 66356.0 |
151 | 2021-04-22 07:49:32 | longhair | 1 | 82945 | 2 | 1.343 | 61761.0 |
150 | 2021-04-08 19:45:20 | longhair | 1 | 82945 | 2 | 2.580 | 32149.2 |
149 | 2021-03-28 07:42:48 | longhair | 1 | 82945 | 2 | 1.300 | 63803.8 |
148 | 2021-03-27 15:34:05 | longhair | 1 | 82945 | 2 | 1.486 | 55817.6 |
147 | 2021-03-21 02:26:34 | longhair | 1 | 82945 | 2 | 1.330 | 62364.7 |
146 | 2021-03-20 13:48:08 | longhair | 1 | 82945 | 2 | 1.516 | 54713.1 |
145 | 2021-03-19 22:39:02 | longhair | 1 | 82945 | 2 | 1.550 | 53512.9 |
144 | 2021-03-19 04:03:54 | longhair | 1 | 82945 | 2 | 1.503 | 55186.3 |
143 | 2021-03-16 04:00:38 | longhair | 1 | 82945 | 2 | 1.390 | 59672.7 |
142 | 2021-03-08 06:02:08 | longhair | 1 | 82945 | 2 | 1.360 | 60989.0 |
141 | 2021-03-06 04:01:55 | longhair | 1 | 82945 | 2 | 1.263 | 65673.0 |
140 | 2021-03-03 01:32:31 | longhair | 1 | 82945 | 2 | 1.283 | 64649.3 |
139 | 2021-02-22 01:12:04 | longhair | 1 | 82945 | 2 | 1.266 | 65517.4 |
138 | 2021-02-21 01:52:30 | longhair | 1 | 82945 | 2 | 1.263 | 65673.0 |
137 | 2021-02-20 01:51:40 | longhair | 1 | 82945 | 2 | 1.296 | 64000.8 |
136 | 2021-02-16 09:30:36 | longhair | 1 | 82945 | 2 | 1.283 | 64649.3 |
135 | 2021-02-12 01:29:51 | longhair | 1 | 82945 | 2 | 1.436 | 57761.1 |
134 | 2021-02-11 04:21:23 | longhair | 1 | 82945 | 2 | 1.373 | 60411.5 |
133 | 2021-02-10 08:51:23 | longhair | 1 | 82945 | 2 | 1.266 | 65517.4 |
132 | 2021-02-06 07:03:23 | longhair | 1 | 82945 | 2 | 1.406 | 58993.6 |