History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crystals"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2024-04-26 07:44:53 | crystals | 4 | 161609 | 705 | 15.050 | 10738.1 |
344 | 2024-04-25 22:25:09 | crystals | 4 | 161609 | 705 | 16.030 | 10081.7 |
343 | 2024-04-25 16:22:48 | crystals | 4 | 161609 | 705 | 18.313 | 8824.8 |
342 | 2024-04-25 10:11:21 | crystals | 4 | 161609 | 705 | 12.156 | 13294.6 |
341 | 2024-04-25 05:49:48 | crystals | 4 | 161609 | 705 | 15.016 | 10762.5 |
340 | 2024-04-19 12:18:14 | crystals | 4 | 161609 | 705 | 15.110 | 10695.5 |
339 | 2024-04-04 15:36:47 | crystals | 2 | 121059 | 6 | 11.080 | 10925.9 |
338 | 2024-04-04 15:36:45 | crystals | 3 | 146162 | 60 | 9.046 | 16157.6 |
337 | 2024-04-04 15:36:20 | crystals | 1 | 82945 | 2 | 5.253 | 15790.0 |
336 | 2024-03-27 05:16:45 | crystals | 2 | 121059 | 6 | 6.046 | 20023.0 |
335 | 2024-03-27 05:15:57 | crystals | 1 | 82945 | 2 | 1.483 | 55930.5 |
334 | 2024-03-27 05:15:46 | crystals | 3 | 146162 | 60 | 7.123 | 20519.7 |
333 | 2024-03-26 20:50:52 | crystals | 4 | 161609 | 705 | 17.876 | 9040.6 |
332 | 2024-03-26 17:18:09 | crystals | 4 | 161609 | 705 | 12.250 | 13192.6 |
331 | 2024-03-26 06:50:09 | crystals | 4 | 161609 | 705 | 13.423 | 12039.7 |
330 | 2024-03-26 06:34:06 | crystals | 4 | 161609 | 705 | 23.236 | 6955.1 |
329 | 2024-03-26 03:57:00 | crystals | 4 | 161609 | 705 | 33.236 | 4862.5 |
328 | 2024-03-26 03:57:03 | crystals | 3 | 146162 | 60 | 14.266 | 10245.5 |
327 | 2024-03-26 03:57:08 | crystals | 2 | 121059 | 6 | 4.313 | 28068.4 |
326 | 2024-03-26 03:21:41 | crystals | 1 | 82945 | 2 | 1.563 | 53067.8 |
325 | 2024-03-07 10:32:20 | crystals | 1 | 82945 | 2 | 3.546 | 23391.1 |
324 | 2024-02-06 15:31:46 | crystals | 2 | 121059 | 6 | 3.940 | 30725.6 |
323 | 2024-02-06 15:29:14 | crystals | 3 | 146162 | 60 | 7.126 | 20511.1 |
322 | 2024-02-04 17:22:23 | crystals | 3 | 146162 | 60 | 7.296 | 20033.2 |
321 | 2024-02-04 17:21:11 | crystals | 4 | 161609 | 705 | 14.420 | 11207.3 |
320 | 2024-01-31 04:18:47 | crystals | 2 | 121059 | 6 | 3.843 | 31501.2 |
319 | 2024-01-31 04:15:59 | crystals | 3 | 146162 | 60 | 7.796 | 18748.3 |
318 | 2024-01-30 09:46:04 | crystals | 2 | 121059 | 6 | 5.610 | 21579.1 |
317 | 2024-01-30 09:42:28 | crystals | 3 | 146162 | 60 | 9.190 | 15904.5 |
316 | 2024-01-30 00:03:35 | crystals | 4 | 161609 | 705 | 13.610 | 11874.3 |
315 | 2024-01-29 22:46:40 | crystals | 4 | 161609 | 705 | 12.830 | 12596.2 |
314 | 2024-01-29 22:00:13 | crystals | 3 | 146162 | 60 | 7.220 | 20244.0 |
313 | 2024-01-29 22:00:05 | crystals | 4 | 161609 | 705 | 12.516 | 12912.2 |
312 | 2024-01-29 22:00:09 | crystals | 2 | 121059 | 6 | 3.796 | 31891.2 |
311 | 2024-01-29 22:00:01 | crystals | 1 | 82945 | 2 | 1.500 | 55296.7 |
310 | 2024-01-15 03:00:51 | crystals | 1 | 82945 | 2 | 1.356 | 61168.9 |
309 | 2024-01-03 18:37:45 | crystals | 1 | 82945 | 2 | 1.593 | 52068.4 |
308 | 2023-12-22 07:32:53 | crystals | 1 | 82945 | 2 | 1.280 | 64800.8 |
307 | 2023-12-14 05:33:59 | crystals | 1 | 82945 | 2 | 1.546 | 53651.4 |
306 | 2023-11-23 18:49:56 | crystals | 1 | 82945 | 2 | 1.360 | 60989.0 |
305 | 2023-11-10 17:52:22 | crystals | 1 | 82945 | 2 | 1.436 | 57761.1 |
304 | 2023-10-31 09:37:00 | crystals | 1 | 82945 | 2 | 1.326 | 62552.8 |
303 | 2023-10-26 08:54:50 | crystals | 1 | 82945 | 2 | 1.406 | 58993.6 |
302 | 2023-10-15 12:22:29 | crystals | 1 | 82945 | 2 | 1.393 | 59544.1 |
301 | 2023-09-18 13:54:16 | crystals | 1 | 82945 | 2 | 1.436 | 57761.1 |
300 | 2023-08-21 12:59:34 | crystals | 1 | 82945 | 2 | 1.453 | 57085.3 |
299 | 2023-06-01 09:27:46 | crystals | 1 | 82945 | 2 | 2.890 | 28700.7 |
298 | 2023-05-22 10:17:06 | crystals | 1 | 82945 | 2 | 1.263 | 65673.0 |
297 | 2023-03-17 13:30:50 | crystals | 1 | 82945 | 2 | 1.263 | 65673.0 |
296 | 2023-02-16 10:15:51 | crystals | 1 | 82945 | 2 | 1.376 | 60279.8 |
295 | 2023-01-05 06:25:04 | crystals | 1 | 82945 | 2 | 1.263 | 65673.0 |
294 | 2022-11-17 05:10:24 | crystals | 4 | 161609 | 705 | 10.296 | 15696.3 |
293 | 2022-10-23 00:24:08 | crystals | 1 | 82945 | 2 | 1.263 | 65673.0 |
292 | 2022-09-30 10:27:31 | crystals | 1 | 82945 | 2 | 1.483 | 55930.5 |
291 | 2022-06-25 10:54:47 | crystals | 1 | 82945 | 2 | 1.263 | 65673.0 |
290 | 2022-06-18 22:44:24 | crystals | 4 | 161609 | 705 | 10.736 | 15053.0 |
289 | 2022-05-12 18:01:24 | crystals | 1 | 82945 | 2 | 1.500 | 55296.7 |
288 | 2022-03-02 10:31:06 | crystals | 1 | 82945 | 2 | 1.750 | 47397.1 |
287 | 2022-02-04 18:56:34 | crystals | 4 | 161609 | 705 | 11.843 | 13646.0 |
286 | 2022-02-02 22:00:59 | crystals | 1 | 82945 | 2 | 1.440 | 57600.7 |
285 | 2022-02-02 15:44:27 | crystals | 4 | 161609 | 705 | 10.420 | 15509.5 |
284 | 2022-01-31 18:13:14 | crystals | 1 | 82945 | 2 | 1.360 | 60989.0 |
283 | 2021-11-24 19:33:53 | crystals | 1 | 82945 | 2 | 1.283 | 64649.3 |
282 | 2021-11-22 16:37:38 | crystals | 1 | 82945 | 2 | 1.280 | 64800.8 |
281 | 2021-11-15 13:09:07 | crystals | 1 | 82945 | 2 | 1.346 | 61623.3 |
280 | 2021-11-15 10:32:09 | crystals | 1 | 82945 | 2 | 1.436 | 57761.1 |
279 | 2021-11-14 12:08:14 | crystals | 1 | 82945 | 2 | 1.440 | 57600.7 |
278 | 2021-11-13 14:04:58 | crystals | 1 | 82945 | 2 | 1.283 | 64649.3 |
277 | 2021-11-12 16:16:03 | crystals | 1 | 82945 | 2 | 1.440 | 57600.7 |
276 | 2021-11-11 09:06:44 | crystals | 1 | 82945 | 2 | 1.546 | 53651.4 |
275 | 2021-11-03 20:45:54 | crystals | 4 | 161609 | 705 | 12.000 | 13467.4 |
274 | 2021-10-04 06:10:22 | crystals | 1 | 82945 | 2 | 1.420 | 58412.0 |
273 | 2021-10-02 04:03:27 | crystals | 1 | 82945 | 2 | 1.283 | 64649.3 |
272 | 2021-09-27 16:14:38 | crystals | 1 | 82945 | 2 | 2.813 | 29486.3 |
271 | 2021-09-26 23:04:22 | crystals | 1 | 82945 | 2 | 1.283 | 64649.3 |
270 | 2021-09-22 01:32:05 | crystals | 1 | 82945 | 2 | 1.436 | 57761.1 |
269 | 2021-08-26 08:03:59 | crystals | 1 | 82945 | 2 | 2.956 | 28059.9 |
268 | 2021-08-24 04:42:39 | crystals | 1 | 82945 | 2 | 1.266 | 65517.4 |
267 | 2021-08-12 14:16:46 | crystals | 1 | 82945 | 2 | 1.563 | 53067.8 |
266 | 2021-05-01 16:52:08 | crystals | 1 | 82945 | 2 | 1.560 | 53169.9 |
265 | 2021-04-02 20:39:32 | crystals | 4 | 161609 | 705 | 20.970 | 7706.7 |
264 | 2021-02-20 22:26:19 | crystals | 4 | 161609 | 705 | 11.170 | 14468.1 |
263 | 2021-01-31 03:17:16 | crystals | 1 | 82945 | 2 | 1.516 | 54713.1 |
262 | 2021-01-29 06:55:08 | crystals | 1 | 82945 | 2 | 1.453 | 57085.3 |
261 | 2021-01-27 04:54:07 | crystals | 1 | 82945 | 2 | 1.296 | 64000.8 |
260 | 2021-01-27 04:38:23 | crystals | 1 | 82945 | 2 | 1.326 | 62552.8 |
259 | 2021-01-03 05:39:51 | crystals | 1 | 82945 | 2 | 1.280 | 64800.8 |
258 | 2020-11-23 12:43:35 | crystals | 4 | 161609 | 705 | 10.406 | 15530.4 |
257 | 2020-11-18 17:41:22 | crystals | 1 | 82945 | 2 | 1.440 | 57600.7 |
256 | 2020-11-08 10:10:16 | crystals | 4 | 161609 | 705 | 10.610 | 15231.8 |
255 | 2020-11-06 01:20:33 | crystals | 4 | 161609 | 705 | 12.690 | 12735.1 |
254 | 2020-10-29 12:10:53 | crystals | 4 | 161609 | 705 | 11.936 | 13539.6 |
253 | 2020-10-26 12:44:00 | crystals | 1 | 82945 | 2 | 1.330 | 62364.7 |
252 | 2020-10-24 10:26:42 | crystals | 1 | 82945 | 2 | 1.403 | 59119.7 |
251 | 2020-09-24 06:38:22 | crystals | 1 | 82945 | 2 | 1.360 | 60989.0 |
250 | 2020-09-03 00:49:33 | crystals | 1 | 82945 | 2 | 1.436 | 57761.1 |
249 | 2020-08-30 13:41:01 | crystals | 4 | 161609 | 705 | 12.796 | 12629.6 |
248 | 2020-07-22 19:17:03 | crystals | 1 | 82945 | 2 | 1.313 | 63172.1 |
247 | 2020-07-18 23:28:26 | crystals | 1 | 82945 | 2 | 1.373 | 60411.5 |
246 | 2020-04-20 20:40:05 | crystals | 1 | 82945 | 2 | 1.486 | 55817.6 |