History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doodad"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
353 | 2024-03-04 15:53:30 | doodad | 1 | 48755 | 2 | 1.280 | 38089.8 |
352 | 2024-02-28 13:21:30 | doodad | 2 | 82551 | 14 | 2.783 | 29662.6 |
351 | 2024-02-28 13:21:12 | doodad | 3 | 112716 | 317 | 6.720 | 16773.2 |
350 | 2024-02-28 05:29:33 | doodad | 1 | 48755 | 2 | 0.920 | 52994.6 |
349 | 2024-02-27 09:15:58 | doodad | 2 | 82551 | 14 | 2.626 | 31436.0 |
348 | 2024-02-27 09:15:36 | doodad | 3 | 112716 | 317 | 6.126 | 18399.6 |
347 | 2024-02-26 20:34:02 | doodad | 3 | 112716 | 317 | 5.373 | 20978.2 |
346 | 2024-02-26 20:34:03 | doodad | 2 | 82551 | 14 | 2.373 | 34787.6 |
345 | 2024-02-26 20:33:56 | doodad | 1 | 48755 | 2 | 0.813 | 59969.2 |
344 | 2024-02-04 13:08:22 | doodad | 3 | 112716 | 317 | 14.673 | 7681.9 |
343 | 2024-02-04 13:08:18 | doodad | 2 | 82551 | 14 | 6.483 | 12733.5 |
342 | 2024-02-04 13:08:14 | doodad | 1 | 48755 | 2 | 0.956 | 50999.0 |
341 | 2024-02-04 12:59:59 | doodad | 3 | 112716 | 317 | 8.970 | 12565.9 |
340 | 2024-02-04 12:59:57 | doodad | 2 | 82551 | 14 | 5.610 | 14715.0 |
339 | 2024-02-04 12:59:51 | doodad | 1 | 48755 | 2 | 0.923 | 52822.3 |
338 | 2024-01-27 15:45:09 | doodad | 1 | 48755 | 2 | 0.876 | 55656.4 |
337 | 2024-01-13 08:16:31 | doodad | 2 | 82551 | 14 | 2.236 | 36919.1 |
336 | 2023-12-21 03:43:12 | doodad | 1 | 48755 | 2 | 0.843 | 57835.1 |
335 | 2023-11-29 16:34:36 | doodad | 1 | 48755 | 2 | 0.780 | 62506.4 |
334 | 2023-11-28 14:47:51 | doodad | 1 | 48755 | 2 | 0.826 | 59025.4 |
333 | 2023-11-21 04:36:55 | doodad | 3 | 112716 | 317 | 5.530 | 20382.6 |
332 | 2023-11-21 04:36:54 | doodad | 2 | 82551 | 14 | 2.550 | 32372.9 |
331 | 2023-11-21 03:51:34 | doodad | 1 | 48755 | 2 | 0.813 | 59969.2 |
330 | 2023-11-11 21:59:49 | doodad | 1 | 48755 | 2 | 0.796 | 61250.0 |
329 | 2023-10-27 03:58:45 | doodad | 1 | 48755 | 2 | 0.796 | 61250.0 |
328 | 2023-10-24 12:07:55 | doodad | 2 | 82551 | 14 | 3.203 | 25773.0 |
327 | 2023-10-20 06:44:09 | doodad | 1 | 48755 | 2 | 0.983 | 49598.2 |
326 | 2023-10-13 17:28:42 | doodad | 1 | 48755 | 2 | 0.736 | 66243.2 |
325 | 2023-10-08 08:24:27 | doodad | 1 | 48755 | 2 | 0.766 | 63648.8 |
324 | 2023-09-24 22:30:51 | doodad | 1 | 48755 | 2 | 0.830 | 58741.0 |
323 | 2023-09-15 16:56:33 | doodad | 1 | 48755 | 2 | 0.796 | 61250.0 |
322 | 2023-08-03 13:21:30 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
321 | 2023-08-02 16:12:58 | doodad | 2 | 82551 | 14 | 2.500 | 33020.4 |
320 | 2023-08-01 19:43:25 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
319 | 2023-05-02 15:45:59 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
318 | 2023-04-13 09:10:37 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
317 | 2023-04-11 17:08:42 | doodad | 2 | 82551 | 14 | 2.376 | 34743.7 |
316 | 2023-04-09 19:09:35 | doodad | 1 | 48755 | 2 | 0.720 | 67715.3 |
315 | 2023-02-23 05:10:47 | doodad | 1 | 48755 | 2 | 0.720 | 67715.3 |
314 | 2023-01-16 23:47:34 | doodad | 2 | 82551 | 14 | 2.093 | 39441.5 |
313 | 2022-12-19 02:15:25 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
312 | 2022-12-17 09:03:39 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
311 | 2022-12-14 04:04:10 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
310 | 2022-10-27 19:22:44 | doodad | 2 | 82551 | 14 | 2.123 | 38884.1 |
309 | 2022-09-02 19:14:43 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
308 | 2022-08-14 00:27:37 | doodad | 1 | 48755 | 2 | 0.830 | 58741.0 |
307 | 2022-07-02 12:23:55 | doodad | 1 | 48755 | 2 | 0.736 | 66243.2 |
306 | 2022-05-29 19:41:07 | doodad | 2 | 82551 | 14 | 2.080 | 39688.0 |
305 | 2022-04-13 20:21:16 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
304 | 2022-04-09 15:52:00 | doodad | 1 | 48755 | 2 | 0.766 | 63648.8 |
303 | 2022-01-07 11:18:52 | doodad | 1 | 48755 | 2 | 1.563 | 31193.2 |
302 | 2021-12-15 20:33:16 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
301 | 2021-12-12 15:34:58 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
300 | 2021-11-07 18:00:39 | doodad | 1 | 48755 | 2 | 0.873 | 55847.7 |
299 | 2021-09-25 05:37:31 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
298 | 2021-09-08 02:06:47 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
297 | 2021-09-05 09:31:21 | doodad | 1 | 48755 | 2 | 0.780 | 62506.4 |
296 | 2021-09-02 02:15:53 | doodad | 1 | 48755 | 2 | 0.763 | 63899.1 |
295 | 2021-06-02 03:15:52 | doodad | 1 | 48755 | 2 | 0.843 | 57835.1 |
294 | 2021-06-01 08:43:36 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
293 | 2021-04-06 07:04:06 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
292 | 2021-03-02 04:24:07 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
291 | 2021-01-21 14:41:11 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
290 | 2020-11-26 07:32:01 | doodad | 1 | 48755 | 2 | 0.766 | 63648.8 |
289 | 2020-10-15 22:09:20 | doodad | 1 | 48755 | 2 | 0.813 | 59969.2 |
288 | 2020-10-06 22:30:43 | doodad | 1 | 48755 | 2 | 0.843 | 57835.1 |
287 | 2020-08-28 06:33:08 | doodad | 1 | 48755 | 2 | 0.736 | 66243.2 |
286 | 2020-08-24 00:34:43 | doodad | 1 | 48755 | 2 | 0.906 | 53813.5 |
285 | 2020-08-21 04:46:35 | doodad | 1 | 48755 | 2 | 0.876 | 55656.4 |
284 | 2020-08-20 15:17:57 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
283 | 2020-08-04 21:29:00 | doodad | 1 | 48755 | 2 | 0.733 | 66514.3 |
282 | 2020-08-02 14:42:08 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
281 | 2020-05-25 13:26:52 | doodad | 1 | 48755 | 2 | 0.966 | 50471.0 |
280 | 2020-05-10 04:09:49 | doodad | 1 | 48755 | 2 | 0.796 | 61250.0 |
279 | 2020-03-28 08:00:57 | doodad | 1 | 48755 | 2 | 0.906 | 53813.5 |
278 | 2020-03-26 19:55:45 | doodad | 1 | 48755 | 2 | 0.843 | 57835.1 |
277 | 2020-03-24 02:30:57 | doodad | 1 | 48755 | 2 | 1.313 | 37132.5 |
276 | 2020-03-23 03:57:54 | doodad | 1 | 48755 | 2 | 0.876 | 55656.4 |
275 | 2020-03-20 08:22:09 | doodad | 1 | 48755 | 2 | 0.830 | 58741.0 |
274 | 2020-03-01 03:47:11 | doodad | 1 | 48755 | 2 | 0.873 | 55847.7 |
273 | 2020-02-27 07:04:43 | doodad | 1 | 48755 | 2 | 0.873 | 55847.7 |
272 | 2020-02-17 15:03:32 | doodad | 1 | 48755 | 2 | 0.890 | 54780.9 |
271 | 2020-02-08 09:17:55 | doodad | 1 | 48755 | 2 | 0.826 | 59025.4 |
270 | 2020-02-08 03:25:33 | doodad | 1 | 48755 | 2 | 2.796 | 17437.4 |
269 | 2020-02-07 14:43:52 | doodad | 1 | 48755 | 2 | 0.843 | 57835.1 |
268 | 2020-02-05 19:16:40 | doodad | 1 | 48755 | 2 | 2.686 | 18151.5 |
267 | 2020-02-05 06:42:21 | doodad | 1 | 48755 | 2 | 0.876 | 55656.4 |
266 | 2020-01-28 02:47:36 | doodad | 1 | 48755 | 2 | 2.033 | 23981.8 |
265 | 2020-01-22 20:08:16 | doodad | 1 | 48755 | 2 | 1.843 | 26454.2 |
264 | 2020-01-15 12:19:06 | doodad | 1 | 48755 | 2 | 0.826 | 59025.4 |
263 | 2020-01-15 04:28:46 | doodad | 1 | 48755 | 2 | 0.906 | 53813.5 |
262 | 2020-01-13 03:29:54 | doodad | 1 | 48755 | 2 | 0.873 | 55847.7 |
261 | 2020-01-07 11:33:52 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
260 | 2020-01-02 03:49:36 | doodad | 1 | 48755 | 2 | 0.890 | 54780.9 |
259 | 2019-12-27 03:54:43 | doodad | 1 | 48755 | 2 | 1.796 | 27146.4 |
258 | 2019-12-27 03:40:58 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
257 | 2019-12-26 16:15:14 | doodad | 1 | 48755 | 2 | 0.860 | 56691.9 |
256 | 2019-12-24 13:36:01 | doodad | 1 | 48755 | 2 | 0.750 | 65006.7 |
255 | 2019-11-19 11:33:34 | doodad | 1 | 48755 | 2 | 1.656 | 29441.4 |
254 | 2019-11-07 02:28:15 | doodad | 1 | 48755 | 2 | 0.780 | 62506.4 |