History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"greenies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
361 | 2024-04-25 10:33:43 | greenies | 1 | 82945 | 4 | 1.453 | 57085.3 |
360 | 2024-04-23 02:21:52 | greenies | 1 | 82945 | 4 | 2.813 | 29486.3 |
359 | 2024-04-07 19:16:42 | greenies | 3 | 146162 | 251 | 14.766 | 9898.6 |
358 | 2024-04-06 16:20:33 | greenies | 2 | 121059 | 30 | 4.016 | 30144.2 |
357 | 2024-04-06 16:20:16 | greenies | 3 | 146162 | 251 | 8.766 | 16673.7 |
356 | 2024-04-05 02:38:51 | greenies | 3 | 146162 | 251 | 26.906 | 5432.3 |
355 | 2024-04-05 02:38:51 | greenies | 2 | 121059 | 30 | 6.783 | 17847.4 |
354 | 2024-04-05 02:38:47 | greenies | 1 | 82945 | 4 | 2.436 | 34049.7 |
353 | 2024-04-01 11:23:57 | greenies | 2 | 121059 | 30 | 7.156 | 16917.1 |
352 | 2024-04-01 09:09:51 | greenies | 1 | 82945 | 4 | 3.000 | 27648.3 |
351 | 2024-04-01 09:09:42 | greenies | 2 | 121059 | 30 | 4.390 | 27576.1 |
350 | 2024-03-31 04:58:00 | greenies | 3 | 146162 | 251 | 13.406 | 10902.7 |
349 | 2024-03-30 22:55:18 | greenies | 3 | 146162 | 251 | 9.250 | 15801.3 |
348 | 2024-03-30 13:04:59 | greenies | 3 | 146162 | 251 | 14.860 | 9835.9 |
347 | 2024-03-30 13:04:59 | greenies | 2 | 121059 | 30 | 12.313 | 9831.8 |
346 | 2024-03-30 12:18:44 | greenies | 1 | 82945 | 4 | 1.530 | 54212.4 |
345 | 2024-03-30 00:04:52 | greenies | 1 | 82945 | 4 | 2.970 | 27927.6 |
344 | 2024-03-27 18:46:36 | greenies | 1 | 82945 | 4 | 1.326 | 62552.8 |
343 | 2024-03-23 17:57:54 | greenies | 1 | 82945 | 4 | 4.813 | 17233.5 |
342 | 2024-03-20 19:35:26 | greenies | 1 | 82945 | 4 | 2.966 | 27965.3 |
341 | 2024-03-15 09:48:14 | greenies | 1 | 82945 | 4 | 3.796 | 21850.6 |
340 | 2024-02-29 08:16:39 | greenies | 1 | 82945 | 4 | 1.393 | 59544.1 |
339 | 2024-02-26 09:36:33 | greenies | 2 | 121059 | 30 | 4.033 | 30017.1 |
338 | 2024-02-26 09:36:19 | greenies | 3 | 146162 | 251 | 7.483 | 19532.5 |
337 | 2024-02-26 06:18:59 | greenies | 3 | 146162 | 251 | 26.893 | 5434.9 |
336 | 2024-02-22 05:07:01 | greenies | 1 | 82945 | 4 | 1.500 | 55296.7 |
335 | 2024-02-22 05:06:48 | greenies | 2 | 121059 | 30 | 4.046 | 29920.7 |
334 | 2024-02-22 05:06:23 | greenies | 3 | 146162 | 251 | 9.063 | 16127.3 |
333 | 2024-02-21 12:39:45 | greenies | 3 | 146162 | 251 | 13.126 | 11135.3 |
332 | 2024-02-20 00:14:20 | greenies | 3 | 146162 | 251 | 10.610 | 13775.9 |
331 | 2024-02-20 00:14:20 | greenies | 2 | 121059 | 30 | 8.593 | 14088.1 |
330 | 2024-02-19 18:07:48 | greenies | 1 | 82945 | 4 | 1.420 | 58412.0 |
329 | 2024-02-16 23:30:09 | greenies | 2 | 121059 | 30 | 3.750 | 32282.4 |
328 | 2024-01-29 22:29:54 | greenies | 1 | 82945 | 4 | 1.406 | 58993.6 |
327 | 2024-01-17 21:47:37 | greenies | 1 | 82945 | 4 | 1.263 | 65673.0 |
326 | 2023-12-18 13:24:33 | greenies | 1 | 82945 | 4 | 1.453 | 57085.3 |
325 | 2023-12-13 08:25:59 | greenies | 1 | 82945 | 4 | 1.233 | 67270.9 |
324 | 2023-12-11 08:07:29 | greenies | 3 | 146162 | 251 | 6.203 | 23563.1 |
323 | 2023-12-07 01:55:06 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
322 | 2023-11-17 03:13:00 | greenies | 2 | 121059 | 30 | 3.376 | 35858.7 |
321 | 2023-10-25 15:34:04 | greenies | 1 | 82945 | 4 | 1.283 | 64649.3 |
320 | 2023-10-18 08:57:13 | greenies | 1 | 82945 | 4 | 1.406 | 58993.6 |
319 | 2023-10-03 17:11:30 | greenies | 1 | 82945 | 4 | 1.236 | 67107.6 |
318 | 2023-10-03 11:31:45 | greenies | 3 | 146162 | 251 | 7.360 | 19859.0 |
317 | 2023-10-03 11:31:43 | greenies | 2 | 121059 | 30 | 3.860 | 31362.4 |
316 | 2023-10-03 08:12:18 | greenies | 1 | 82945 | 4 | 2.686 | 30880.5 |
315 | 2023-10-01 23:54:34 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
314 | 2023-09-21 23:15:47 | greenies | 1 | 82945 | 4 | 1.250 | 66356.0 |
313 | 2023-09-12 04:36:00 | greenies | 3 | 146162 | 251 | 8.343 | 17519.1 |
312 | 2023-09-07 21:08:59 | greenies | 3 | 146162 | 251 | 7.283 | 20068.9 |
311 | 2023-08-18 09:01:01 | greenies | 2 | 121059 | 30 | 3.313 | 36540.6 |
310 | 2023-08-17 22:41:11 | greenies | 1 | 82945 | 4 | 1.373 | 60411.5 |
309 | 2023-07-31 09:57:26 | greenies | 1 | 82945 | 4 | 1.233 | 67270.9 |
308 | 2023-05-25 00:18:58 | greenies | 3 | 146162 | 251 | 6.220 | 23498.7 |
307 | 2023-05-07 11:21:51 | greenies | 1 | 82945 | 4 | 1.250 | 66356.0 |
306 | 2023-05-03 16:44:49 | greenies | 1 | 82945 | 4 | 1.420 | 58412.0 |
305 | 2023-04-30 19:19:03 | greenies | 2 | 121059 | 30 | 3.253 | 37214.6 |
304 | 2023-04-26 09:20:23 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
303 | 2023-03-05 04:20:40 | greenies | 3 | 146162 | 251 | 6.296 | 23215.1 |
302 | 2023-02-16 03:18:01 | greenies | 1 | 82945 | 4 | 1.376 | 60279.8 |
301 | 2023-02-04 18:27:32 | greenies | 2 | 121059 | 30 | 3.530 | 34294.3 |
300 | 2023-01-25 03:13:26 | greenies | 1 | 82945 | 4 | 1.343 | 61761.0 |
299 | 2023-01-15 05:37:32 | greenies | 1 | 82945 | 4 | 1.250 | 66356.0 |
298 | 2022-12-23 05:43:00 | greenies | 1 | 82945 | 4 | 1.233 | 67270.9 |
297 | 2022-12-14 05:35:53 | greenies | 3 | 146162 | 251 | 6.953 | 21021.4 |
296 | 2022-12-13 20:57:56 | greenies | 1 | 82945 | 4 | 1.420 | 58412.0 |
295 | 2022-11-18 14:16:25 | greenies | 2 | 121059 | 30 | 3.156 | 38358.4 |
294 | 2022-11-16 08:33:19 | greenies | 1 | 82945 | 4 | 1.513 | 54821.5 |
293 | 2022-11-10 14:24:16 | greenies | 1 | 82945 | 4 | 1.876 | 44213.8 |
292 | 2022-10-14 12:34:28 | greenies | 1 | 82945 | 4 | 1.236 | 67107.6 |
291 | 2022-08-20 08:42:17 | greenies | 1 | 82945 | 4 | 1.233 | 67270.9 |
290 | 2022-08-17 23:53:56 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
289 | 2022-08-01 16:01:52 | greenies | 3 | 146162 | 251 | 7.686 | 19016.7 |
288 | 2022-06-28 00:07:47 | greenies | 1 | 82945 | 4 | 1.236 | 67107.6 |
287 | 2022-06-22 20:12:06 | greenies | 2 | 121059 | 30 | 3.376 | 35858.7 |
286 | 2022-04-04 09:06:52 | greenies | 1 | 82945 | 4 | 1.236 | 67107.6 |
285 | 2022-03-11 11:44:01 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
284 | 2022-03-05 10:26:29 | greenies | 3 | 146162 | 251 | 6.466 | 22604.7 |
283 | 2022-01-05 22:36:55 | greenies | 1 | 82945 | 4 | 1.500 | 55296.7 |
282 | 2022-01-05 13:07:28 | greenies | 1 | 82945 | 4 | 1.403 | 59119.7 |
281 | 2022-01-04 22:29:07 | greenies | 1 | 82945 | 4 | 1.390 | 59672.7 |
280 | 2022-01-01 18:25:58 | greenies | 1 | 82945 | 4 | 1.593 | 52068.4 |
279 | 2021-12-19 13:24:06 | greenies | 1 | 82945 | 4 | 1.940 | 42755.2 |
278 | 2021-12-19 04:34:09 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
277 | 2021-12-18 19:42:22 | greenies | 1 | 82945 | 4 | 1.420 | 58412.0 |
276 | 2021-12-16 10:54:49 | greenies | 1 | 82945 | 4 | 1.516 | 54713.1 |
275 | 2021-12-14 02:20:39 | greenies | 1 | 82945 | 4 | 1.453 | 57085.3 |
274 | 2021-12-13 16:40:47 | greenies | 1 | 82945 | 4 | 1.453 | 57085.3 |
273 | 2021-12-13 05:18:50 | greenies | 1 | 82945 | 4 | 1.250 | 66356.0 |
272 | 2021-12-12 14:04:33 | greenies | 1 | 82945 | 4 | 1.530 | 54212.4 |
271 | 2021-12-12 04:08:48 | greenies | 1 | 82945 | 4 | 1.470 | 56425.2 |
270 | 2021-12-04 14:15:45 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
269 | 2021-11-18 16:35:33 | greenies | 1 | 82945 | 4 | 1.266 | 65517.4 |
268 | 2021-10-21 17:38:06 | greenies | 1 | 82945 | 4 | 1.406 | 58993.6 |
267 | 2021-10-20 20:06:56 | greenies | 1 | 82945 | 4 | 1.283 | 64649.3 |
266 | 2021-09-22 10:35:57 | greenies | 1 | 82945 | 4 | 1.453 | 57085.3 |
265 | 2021-09-21 13:58:33 | greenies | 1 | 82945 | 4 | 1.516 | 54713.1 |
264 | 2021-09-15 02:15:11 | greenies | 1 | 82945 | 4 | 1.280 | 64800.8 |
263 | 2021-08-29 12:59:54 | greenies | 1 | 82945 | 4 | 1.250 | 66356.0 |
262 | 2021-08-28 04:53:17 | greenies | 1 | 82945 | 4 | 1.233 | 67270.9 |