History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"eyeglass"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
275 | 2024-04-26 08:31:00 | eyeglass | 2 | 121059 | 5 | 3.843 | 31501.2 |
274 | 2024-04-16 14:03:19 | eyeglass | 4 | 161609 | 323 | 44.033 | 3670.2 |
273 | 2024-04-16 14:03:23 | eyeglass | 2 | 121059 | 5 | 13.783 | 8783.2 |
272 | 2024-04-16 13:49:08 | eyeglass | 1 | 82945 | 1 | 1.423 | 58288.8 |
271 | 2024-04-12 23:12:40 | eyeglass | 3 | 146162 | 31 | 13.876 | 10533.4 |
270 | 2024-04-11 09:25:44 | eyeglass | 2 | 121059 | 5 | 8.046 | 15045.9 |
269 | 2024-04-11 09:25:27 | eyeglass | 1 | 82945 | 1 | 1.483 | 55930.5 |
268 | 2024-04-10 21:12:53 | eyeglass | 3 | 146162 | 31 | 8.516 | 17163.2 |
267 | 2024-04-09 19:20:21 | eyeglass | 3 | 146162 | 31 | 9.096 | 16068.8 |
266 | 2024-04-09 19:20:20 | eyeglass | 2 | 121059 | 5 | 4.720 | 25648.1 |
265 | 2024-04-09 19:20:08 | eyeglass | 1 | 82945 | 1 | 1.466 | 56579.1 |
264 | 2024-04-03 12:00:57 | eyeglass | 4 | 161609 | 323 | 34.050 | 4746.2 |
263 | 2024-04-02 22:45:29 | eyeglass | 4 | 161609 | 323 | 41.910 | 3856.1 |
262 | 2024-04-02 08:26:45 | eyeglass | 3 | 146162 | 31 | 8.500 | 17195.5 |
261 | 2024-04-01 18:28:40 | eyeglass | 4 | 161609 | 323 | 26.770 | 6036.9 |
260 | 2024-04-01 17:01:49 | eyeglass | 4 | 161609 | 323 | 23.156 | 6979.1 |
259 | 2024-04-01 16:31:34 | eyeglass | 4 | 161609 | 323 | 21.673 | 7456.7 |
258 | 2024-04-01 16:31:36 | eyeglass | 3 | 146162 | 31 | 18.876 | 7743.3 |
257 | 2024-04-01 16:31:35 | eyeglass | 2 | 121059 | 5 | 11.513 | 10515.0 |
256 | 2024-04-01 16:31:33 | eyeglass | 1 | 82945 | 1 | 1.750 | 47397.1 |
255 | 2024-03-29 02:15:16 | eyeglass | 1 | 82945 | 1 | 4.046 | 20500.5 |
254 | 2024-03-18 10:50:54 | eyeglass | 3 | 146162 | 31 | 15.190 | 9622.3 |
253 | 2024-03-12 04:55:44 | eyeglass | 2 | 121059 | 5 | 7.860 | 15401.9 |
252 | 2024-03-12 04:53:41 | eyeglass | 1 | 82945 | 1 | 3.046 | 27230.8 |
251 | 2024-03-09 01:25:22 | eyeglass | 2 | 121059 | 5 | 4.343 | 27874.5 |
250 | 2024-03-08 22:27:38 | eyeglass | 1 | 82945 | 1 | 3.546 | 23391.1 |
249 | 2024-03-08 22:27:20 | eyeglass | 2 | 121059 | 5 | 3.983 | 30393.9 |
248 | 2024-03-08 22:27:02 | eyeglass | 1 | 82945 | 1 | 4.703 | 17636.6 |
247 | 2024-03-08 22:25:12 | eyeglass | 1 | 82945 | 1 | 2.876 | 28840.4 |
246 | 2024-03-07 10:30:33 | eyeglass | 1 | 82945 | 1 | 1.736 | 47779.4 |
245 | 2024-03-06 04:09:43 | eyeglass | 3 | 146162 | 31 | 20.300 | 7200.1 |
244 | 2024-03-05 01:20:46 | eyeglass | 4 | 161609 | 323 | 41.970 | 3850.6 |
243 | 2024-03-05 01:20:57 | eyeglass | 3 | 146162 | 31 | 14.016 | 10428.2 |
242 | 2024-03-02 07:04:54 | eyeglass | 1 | 82945 | 1 | 1.670 | 49667.7 |
241 | 2024-03-02 06:47:20 | eyeglass | 3 | 146162 | 31 | 14.203 | 10290.9 |
240 | 2024-02-29 23:26:52 | eyeglass | 4 | 161609 | 323 | 18.533 | 8720.1 |
239 | 2024-02-29 06:35:49 | eyeglass | 4 | 161609 | 323 | 12.330 | 13107.0 |
238 | 2024-02-27 06:00:40 | eyeglass | 4 | 161609 | 323 | 14.796 | 10922.5 |
237 | 2024-02-27 06:00:40 | eyeglass | 3 | 146162 | 31 | 11.283 | 12954.2 |
236 | 2024-02-26 11:46:19 | eyeglass | 4 | 161609 | 323 | 12.486 | 12943.2 |
235 | 2024-02-26 11:46:24 | eyeglass | 3 | 146162 | 31 | 7.720 | 18932.9 |
234 | 2024-02-26 11:46:22 | eyeglass | 2 | 121059 | 5 | 3.783 | 32000.8 |
233 | 2024-02-26 11:46:20 | eyeglass | 1 | 82945 | 1 | 1.373 | 60411.5 |
232 | 2024-02-02 13:11:59 | eyeglass | 1 | 82945 | 1 | 1.343 | 61761.0 |
231 | 2023-12-30 04:17:41 | eyeglass | 1 | 82945 | 1 | 1.233 | 67270.9 |
230 | 2023-12-21 08:03:52 | eyeglass | 1 | 82945 | 1 | 1.393 | 59544.1 |
229 | 2023-10-09 03:31:35 | eyeglass | 1 | 82945 | 1 | 1.373 | 60411.5 |
228 | 2023-09-20 02:37:43 | eyeglass | 1 | 82945 | 1 | 1.390 | 59672.7 |
227 | 2023-08-05 04:22:47 | eyeglass | 1 | 82945 | 1 | 1.263 | 65673.0 |
226 | 2023-05-06 10:04:20 | eyeglass | 1 | 82945 | 1 | 1.233 | 67270.9 |
225 | 2023-03-01 23:19:23 | eyeglass | 1 | 82945 | 1 | 1.233 | 67270.9 |
224 | 2022-12-26 06:38:59 | eyeglass | 1 | 82945 | 1 | 1.236 | 67107.6 |
223 | 2022-09-17 11:00:48 | eyeglass | 1 | 82945 | 1 | 1.330 | 62364.7 |
222 | 2022-06-30 14:03:49 | eyeglass | 1 | 82945 | 1 | 1.216 | 68211.3 |
221 | 2022-03-01 05:54:52 | eyeglass | 1 | 82945 | 1 | 1.283 | 64649.3 |
220 | 2021-12-13 22:04:23 | eyeglass | 1 | 82945 | 1 | 1.406 | 58993.6 |
219 | 2021-11-27 20:35:38 | eyeglass | 1 | 82945 | 1 | 1.296 | 64000.8 |
218 | 2021-11-22 21:05:51 | eyeglass | 1 | 82945 | 1 | 1.876 | 44213.8 |
217 | 2021-11-08 14:02:52 | eyeglass | 1 | 82945 | 1 | 1.360 | 60989.0 |
216 | 2021-05-17 12:35:20 | eyeglass | 3 | 146162 | 31 | 6.186 | 23627.9 |
215 | 2021-04-30 21:54:20 | eyeglass | 2 | 121059 | 5 | 3.390 | 35710.6 |
214 | 2021-04-28 04:17:05 | eyeglass | 1 | 82945 | 1 | 2.830 | 29309.2 |
213 | 2021-04-17 13:22:31 | eyeglass | 3 | 146162 | 31 | 6.453 | 22650.2 |
212 | 2021-03-28 01:43:34 | eyeglass | 1 | 82945 | 1 | 1.500 | 55296.7 |
211 | 2021-02-07 22:03:55 | eyeglass | 2 | 121059 | 5 | 3.186 | 37997.2 |
210 | 2021-02-01 12:16:14 | eyeglass | 1 | 82945 | 1 | 1.406 | 58993.6 |
209 | 2021-01-30 00:52:23 | eyeglass | 3 | 146162 | 31 | 6.313 | 23152.5 |
208 | 2021-01-11 09:03:57 | eyeglass | 1 | 82945 | 1 | 2.610 | 31779.7 |
207 | 2021-01-01 20:18:08 | eyeglass | 3 | 146162 | 31 | 7.236 | 20199.3 |
206 | 2020-11-10 14:32:28 | eyeglass | 3 | 146162 | 31 | 6.813 | 21453.4 |
205 | 2020-10-28 10:23:36 | eyeglass | 1 | 82945 | 1 | 1.376 | 60279.8 |
204 | 2020-10-26 05:41:29 | eyeglass | 2 | 121059 | 5 | 3.360 | 36029.5 |
203 | 2020-10-26 03:52:22 | eyeglass | 1 | 82945 | 1 | 1.266 | 65517.4 |
202 | 2020-09-29 12:20:16 | eyeglass | 1 | 82945 | 1 | 1.220 | 67987.7 |
201 | 2020-08-05 22:59:48 | eyeglass | 1 | 82945 | 1 | 1.280 | 64800.8 |
200 | 2020-04-04 05:42:39 | eyeglass | 1 | 82945 | 1 | 1.266 | 65517.4 |
199 | 2020-03-28 15:17:06 | eyeglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
198 | 2020-03-22 19:13:23 | eyeglass | 1 | 82945 | 1 | 2.813 | 29486.3 |
197 | 2020-02-29 16:13:34 | eyeglass | 1 | 82945 | 1 | 1.390 | 59672.7 |
196 | 2020-02-13 21:35:43 | eyeglass | 1 | 82945 | 1 | 3.140 | 26415.6 |
195 | 2020-02-08 05:29:15 | eyeglass | 1 | 82945 | 1 | 1.296 | 64000.8 |
194 | 2020-01-30 21:04:22 | eyeglass | 1 | 82945 | 1 | 2.436 | 34049.7 |
193 | 2020-01-28 22:49:31 | eyeglass | 1 | 82945 | 1 | 3.016 | 27501.7 |
192 | 2020-01-27 20:52:15 | eyeglass | 1 | 82945 | 1 | 1.483 | 55930.5 |
191 | 2020-01-22 00:06:09 | eyeglass | 1 | 82945 | 1 | 1.660 | 49966.9 |
190 | 2020-01-16 19:07:51 | eyeglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
189 | 2020-01-16 17:59:25 | eyeglass | 1 | 82945 | 1 | 1.453 | 57085.3 |
188 | 2020-01-14 22:26:27 | eyeglass | 1 | 82945 | 1 | 2.953 | 28088.4 |
187 | 2020-01-02 18:18:02 | eyeglass | 1 | 82945 | 1 | 1.313 | 63172.1 |
186 | 2019-12-31 20:45:07 | eyeglass | 1 | 82945 | 1 | 1.500 | 55296.7 |
185 | 2019-12-27 02:20:46 | eyeglass | 1 | 82945 | 1 | 2.970 | 27927.6 |
184 | 2019-09-26 10:33:44 | eyeglass | 1 | 82945 | 1 | 1.196 | 69352.0 |
183 | 2019-06-17 08:24:48 | eyeglass | 1 | 82945 | 1 | 1.360 | 60989.0 |
182 | 2019-02-23 17:14:20 | eyeglass | 1 | 82945 | 1 | 1.300 | 63803.8 |
181 | 2018-10-28 22:33:59 | eyeglass | 1 | 82945 | 1 | 1.343 | 61761.0 |
180 | 2018-07-18 16:24:38 | eyeglass | 1 | 82945 | 1 | 1.430 | 58003.5 |
179 | 2018-06-22 14:27:50 | eyeglass | 1 | 82945 | 1 | 1.373 | 60411.5 |
178 | 2018-02-10 19:20:59 | eyeglass | 1 | 82945 | 1 | 1.763 | 47047.6 |
177 | 2017-11-12 14:49:14 | eyeglass | 1 | 82945 | 1 | 2.230 | 37195.1 |
176 | 2017-06-04 20:23:55 | eyeglass | 1 | 82945 | 1 | 2.196 | 37770.9 |