History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"diatom"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
356 | 2024-04-27 08:44:52 | diatom | 1 | 48755 | 2 | 1.686 | 28917.6 |
355 | 2024-04-06 12:40:16 | diatom | 1 | 48755 | 2 | 3.046 | 16006.2 |
354 | 2024-03-30 07:21:57 | diatom | 3 | 112716 | 223 | 12.703 | 8873.2 |
353 | 2024-03-29 02:57:47 | diatom | 1 | 48755 | 2 | 1.843 | 26454.2 |
352 | 2024-03-29 02:57:31 | diatom | 3 | 112716 | 223 | 8.440 | 13355.0 |
351 | 2024-03-29 02:57:35 | diatom | 2 | 82551 | 18 | 3.970 | 20793.7 |
350 | 2024-03-07 08:59:43 | diatom | 1 | 48755 | 2 | 2.296 | 21234.8 |
349 | 2024-03-02 17:53:51 | diatom | 1 | 48755 | 2 | 1.050 | 46433.3 |
348 | 2024-02-28 13:19:16 | diatom | 2 | 82551 | 18 | 4.203 | 19641.0 |
347 | 2024-02-28 13:19:04 | diatom | 3 | 112716 | 223 | 6.080 | 18538.8 |
346 | 2024-02-28 07:29:01 | diatom | 2 | 82551 | 18 | 2.656 | 31080.9 |
345 | 2024-02-28 00:54:31 | diatom | 3 | 112716 | 223 | 5.296 | 21283.2 |
344 | 2024-02-28 00:54:30 | diatom | 2 | 82551 | 18 | 2.280 | 36206.6 |
343 | 2024-02-28 00:54:28 | diatom | 1 | 48755 | 2 | 0.716 | 68093.6 |
342 | 2023-12-31 13:52:26 | diatom | 3 | 112716 | 223 | 4.703 | 23966.8 |
341 | 2023-12-22 20:54:58 | diatom | 1 | 48755 | 2 | 0.766 | 63648.8 |
340 | 2023-12-10 20:39:16 | diatom | 1 | 48755 | 2 | 0.826 | 59025.4 |
339 | 2023-11-26 02:50:39 | diatom | 1 | 48755 | 2 | 0.783 | 62266.9 |
338 | 2023-11-21 16:29:11 | diatom | 1 | 48755 | 2 | 0.736 | 66243.2 |
337 | 2023-11-04 12:43:47 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
336 | 2023-10-30 02:48:28 | diatom | 1 | 48755 | 2 | 0.766 | 63648.8 |
335 | 2023-10-24 10:45:55 | diatom | 1 | 48755 | 2 | 0.856 | 56956.8 |
334 | 2023-10-13 03:19:39 | diatom | 3 | 112716 | 223 | 7.673 | 14690.0 |
333 | 2023-10-11 03:26:06 | diatom | 1 | 48755 | 2 | 0.716 | 68093.6 |
332 | 2023-10-05 16:13:30 | diatom | 3 | 112716 | 223 | 5.343 | 21096.0 |
331 | 2023-09-28 01:10:27 | diatom | 1 | 48755 | 2 | 2.220 | 21961.7 |
330 | 2023-09-26 21:33:55 | diatom | 3 | 112716 | 223 | 5.360 | 21029.1 |
329 | 2023-09-26 21:33:45 | diatom | 2 | 82551 | 18 | 2.593 | 31836.1 |
328 | 2023-09-25 22:07:51 | diatom | 1 | 48755 | 2 | 1.673 | 29142.3 |
327 | 2023-09-12 18:43:28 | diatom | 1 | 48755 | 2 | 0.843 | 57835.1 |
326 | 2023-08-30 12:40:42 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
325 | 2023-07-22 04:23:04 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
324 | 2023-07-20 19:44:37 | diatom | 3 | 112716 | 223 | 4.906 | 22975.1 |
323 | 2023-07-16 10:33:02 | diatom | 3 | 112716 | 223 | 5.826 | 19347.1 |
322 | 2023-05-13 10:35:58 | diatom | 1 | 48755 | 2 | 0.810 | 60191.4 |
321 | 2023-04-22 21:22:25 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
320 | 2023-04-01 03:57:30 | diatom | 3 | 112716 | 223 | 5.030 | 22408.7 |
319 | 2023-02-11 17:33:02 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
318 | 2023-01-29 23:42:33 | diatom | 3 | 112716 | 223 | 4.626 | 24365.8 |
317 | 2023-01-27 14:06:02 | diatom | 1 | 48755 | 2 | 0.736 | 66243.2 |
316 | 2023-01-03 19:39:16 | diatom | 3 | 112716 | 223 | 6.016 | 18736.0 |
315 | 2023-01-02 22:43:22 | diatom | 3 | 112716 | 223 | 5.530 | 20382.6 |
314 | 2023-01-01 15:23:46 | diatom | 3 | 112716 | 223 | 5.593 | 20153.0 |
313 | 2022-12-30 05:51:29 | diatom | 3 | 112716 | 223 | 5.313 | 21215.1 |
312 | 2022-12-27 22:02:39 | diatom | 3 | 112716 | 223 | 9.423 | 11961.8 |
311 | 2022-12-24 20:27:39 | diatom | 3 | 112716 | 223 | 5.516 | 20434.4 |
310 | 2022-12-09 02:11:05 | diatom | 1 | 48755 | 2 | 0.716 | 68093.6 |
309 | 2022-12-04 22:07:31 | diatom | 3 | 112716 | 223 | 4.610 | 24450.3 |
308 | 2022-12-02 00:27:06 | diatom | 3 | 112716 | 223 | 5.920 | 19039.9 |
307 | 2022-10-13 07:50:33 | diatom | 1 | 48755 | 2 | 0.720 | 67715.3 |
306 | 2022-09-29 03:09:18 | diatom | 3 | 112716 | 223 | 4.733 | 23814.9 |
305 | 2022-09-06 02:33:41 | diatom | 3 | 112716 | 223 | 4.580 | 24610.5 |
304 | 2022-09-02 19:35:07 | diatom | 3 | 112716 | 223 | 5.046 | 22337.7 |
303 | 2022-08-30 01:57:30 | diatom | 3 | 112716 | 223 | 5.000 | 22543.2 |
302 | 2022-08-21 20:51:11 | diatom | 3 | 112716 | 223 | 4.716 | 23900.8 |
301 | 2022-08-09 16:04:28 | diatom | 1 | 48755 | 2 | 0.736 | 66243.2 |
300 | 2022-06-30 15:18:04 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
299 | 2022-04-03 06:46:03 | diatom | 1 | 48755 | 2 | 0.736 | 66243.2 |
298 | 2022-03-13 19:56:35 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
297 | 2022-01-17 17:42:03 | diatom | 1 | 48755 | 2 | 0.826 | 59025.4 |
296 | 2021-12-03 12:28:43 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
295 | 2021-11-01 18:45:27 | diatom | 1 | 48755 | 2 | 0.830 | 58741.0 |
294 | 2021-09-02 17:11:40 | diatom | 1 | 48755 | 2 | 0.796 | 61250.0 |
293 | 2021-07-27 15:40:04 | diatom | 2 | 82551 | 18 | 2.126 | 38829.3 |
292 | 2021-05-29 17:37:51 | diatom | 1 | 48755 | 2 | 1.656 | 29441.4 |
291 | 2021-05-20 18:35:09 | diatom | 1 | 48755 | 2 | 0.856 | 56956.8 |
290 | 2021-05-18 13:05:43 | diatom | 2 | 82551 | 18 | 2.486 | 33206.4 |
289 | 2021-05-11 23:28:27 | diatom | 3 | 112716 | 223 | 5.610 | 20092.0 |
288 | 2021-04-21 01:57:43 | diatom | 1 | 48755 | 2 | 0.766 | 63648.8 |
287 | 2021-04-12 18:32:34 | diatom | 3 | 112716 | 223 | 5.423 | 20784.8 |
286 | 2021-02-26 23:36:12 | diatom | 1 | 48755 | 2 | 0.813 | 59969.2 |
285 | 2021-02-25 23:13:56 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
284 | 2021-02-19 15:36:09 | diatom | 3 | 112716 | 223 | 4.796 | 23502.1 |
283 | 2021-02-07 13:45:00 | diatom | 3 | 112716 | 223 | 5.890 | 19136.8 |
282 | 2021-02-02 01:47:00 | diatom | 1 | 48755 | 2 | 0.766 | 63648.8 |
281 | 2021-01-31 04:44:12 | diatom | 3 | 112716 | 223 | 5.076 | 22205.7 |
280 | 2021-01-31 00:24:01 | diatom | 2 | 82551 | 18 | 2.203 | 37472.1 |
279 | 2021-01-05 19:17:13 | diatom | 1 | 48755 | 2 | 0.783 | 62266.9 |
278 | 2020-12-01 09:14:14 | diatom | 3 | 112716 | 223 | 4.750 | 23729.7 |
277 | 2020-11-22 06:25:28 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
276 | 2020-11-09 21:12:47 | diatom | 1 | 48755 | 2 | 0.766 | 63648.8 |
275 | 2020-11-05 18:47:21 | diatom | 3 | 112716 | 223 | 5.030 | 22408.7 |
274 | 2020-10-31 21:24:30 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
273 | 2020-10-23 14:47:57 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
272 | 2020-10-23 05:31:21 | diatom | 1 | 48755 | 2 | 0.733 | 66514.3 |
271 | 2020-10-19 20:13:37 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
270 | 2020-09-28 02:59:58 | diatom | 3 | 112716 | 223 | 5.343 | 21096.0 |
269 | 2020-09-24 13:58:07 | diatom | 2 | 82551 | 18 | 2.186 | 37763.5 |
268 | 2020-09-06 08:55:48 | diatom | 3 | 112716 | 223 | 4.780 | 23580.8 |
267 | 2020-08-25 10:54:58 | diatom | 1 | 48755 | 2 | 0.763 | 63899.1 |
266 | 2020-08-21 21:53:01 | diatom | 3 | 112716 | 223 | 5.016 | 22471.3 |
265 | 2020-08-09 00:17:29 | diatom | 1 | 48755 | 2 | 0.763 | 63899.1 |
264 | 2020-07-26 05:01:05 | diatom | 3 | 112716 | 223 | 4.966 | 22697.5 |
263 | 2020-07-25 09:30:49 | diatom | 2 | 82551 | 18 | 2.406 | 34310.5 |
262 | 2020-07-20 02:45:00 | diatom | 3 | 112716 | 223 | 4.860 | 23192.6 |
261 | 2020-05-07 18:58:24 | diatom | 1 | 48755 | 2 | 0.750 | 65006.7 |
260 | 2020-03-26 19:03:28 | diatom | 1 | 48755 | 2 | 0.796 | 61250.0 |
259 | 2020-03-26 11:12:02 | diatom | 1 | 48755 | 2 | 1.766 | 27607.6 |
258 | 2020-03-24 02:55:31 | diatom | 1 | 48755 | 2 | 2.766 | 17626.5 |
257 | 2020-03-23 22:49:16 | diatom | 1 | 48755 | 2 | 0.830 | 58741.0 |