History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oriole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
397 | 2024-04-27 03:01:28 | oriole | 1 | 48755 | 2 | 1.970 | 24748.7 |
396 | 2024-03-30 20:11:07 | oriole | 2 | 82551 | 38 | 5.983 | 13797.6 |
395 | 2024-03-30 19:54:18 | oriole | 3 | 112716 | 551 | 19.593 | 5752.9 |
394 | 2024-03-30 07:31:58 | oriole | 2 | 82551 | 38 | 3.153 | 26181.7 |
393 | 2024-03-30 07:31:39 | oriole | 3 | 112716 | 551 | 5.360 | 21029.1 |
392 | 2024-03-28 19:17:28 | oriole | 2 | 82551 | 38 | 3.046 | 27101.4 |
391 | 2024-03-28 14:31:21 | oriole | 1 | 48755 | 2 | 0.876 | 55656.4 |
390 | 2024-03-28 14:31:15 | oriole | 3 | 112716 | 551 | 5.936 | 18988.5 |
389 | 2024-03-28 14:31:14 | oriole | 2 | 82551 | 38 | 2.610 | 31628.7 |
388 | 2024-02-04 13:38:01 | oriole | 1 | 48755 | 2 | 4.983 | 9784.3 |
387 | 2024-01-21 21:06:30 | oriole | 1 | 48755 | 2 | 1.076 | 45311.3 |
386 | 2024-01-12 16:43:51 | oriole | 1 | 48755 | 2 | 0.826 | 59025.4 |
385 | 2024-01-11 09:25:14 | oriole | 3 | 112716 | 551 | 6.000 | 18786.0 |
384 | 2024-01-11 09:25:13 | oriole | 2 | 82551 | 38 | 2.703 | 30540.5 |
383 | 2024-01-02 17:33:04 | oriole | 2 | 82551 | 38 | 2.233 | 36968.7 |
382 | 2023-12-22 02:33:38 | oriole | 3 | 112716 | 551 | 5.173 | 21789.3 |
381 | 2023-12-22 02:33:40 | oriole | 2 | 82551 | 38 | 2.470 | 33421.5 |
380 | 2023-12-08 08:24:00 | oriole | 1 | 48755 | 2 | 0.830 | 58741.0 |
379 | 2023-11-21 20:38:03 | oriole | 3 | 112716 | 551 | 7.423 | 15184.7 |
378 | 2023-11-17 09:36:01 | oriole | 1 | 48755 | 2 | 0.796 | 61250.0 |
377 | 2023-11-17 01:52:05 | oriole | 1 | 48755 | 2 | 0.856 | 56956.8 |
376 | 2023-11-06 10:53:40 | oriole | 2 | 82551 | 38 | 2.500 | 33020.4 |
375 | 2023-11-04 13:11:05 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
374 | 2023-11-03 16:21:13 | oriole | 1 | 48755 | 2 | 0.716 | 68093.6 |
373 | 2023-10-29 17:31:07 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
372 | 2023-10-21 16:25:32 | oriole | 3 | 112716 | 551 | 6.623 | 17018.9 |
371 | 2023-10-19 00:52:16 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
370 | 2023-10-14 10:23:51 | oriole | 3 | 112716 | 551 | 6.110 | 18447.8 |
369 | 2023-10-13 17:57:32 | oriole | 1 | 48755 | 2 | 0.873 | 55847.7 |
368 | 2023-10-09 06:23:58 | oriole | 2 | 82551 | 38 | 2.313 | 35690.0 |
367 | 2023-10-09 05:19:02 | oriole | 3 | 112716 | 551 | 6.326 | 17817.9 |
366 | 2023-10-08 08:08:16 | oriole | 2 | 82551 | 38 | 2.780 | 29694.6 |
365 | 2023-10-03 15:27:25 | oriole | 1 | 48755 | 2 | 0.826 | 59025.4 |
364 | 2023-09-30 06:37:44 | oriole | 3 | 112716 | 551 | 5.390 | 20912.1 |
363 | 2023-09-30 06:37:45 | oriole | 2 | 82551 | 38 | 2.466 | 33475.7 |
362 | 2023-09-28 12:59:50 | oriole | 3 | 112716 | 551 | 13.610 | 8281.9 |
361 | 2023-09-28 12:59:57 | oriole | 2 | 82551 | 38 | 5.983 | 13797.6 |
360 | 2023-09-24 21:49:31 | oriole | 1 | 48755 | 2 | 0.780 | 62506.4 |
359 | 2023-09-22 11:28:08 | oriole | 1 | 48755 | 2 | 0.813 | 59969.2 |
358 | 2023-09-19 17:06:11 | oriole | 1 | 48755 | 2 | 0.893 | 54596.9 |
357 | 2023-09-04 16:39:48 | oriole | 1 | 48755 | 2 | 0.813 | 59969.2 |
356 | 2023-08-21 07:40:00 | oriole | 1 | 48755 | 2 | 0.860 | 56691.9 |
355 | 2023-07-19 15:01:07 | oriole | 2 | 82551 | 38 | 2.156 | 38289.0 |
354 | 2023-07-08 15:37:24 | oriole | 1 | 48755 | 2 | 0.766 | 63648.8 |
353 | 2023-06-13 08:32:36 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
352 | 2023-05-30 06:47:20 | oriole | 1 | 48755 | 2 | 0.733 | 66514.3 |
351 | 2023-04-05 02:51:50 | oriole | 2 | 82551 | 38 | 2.640 | 31269.3 |
350 | 2023-03-24 02:43:13 | oriole | 1 | 48755 | 2 | 0.813 | 59969.2 |
349 | 2023-02-10 18:25:19 | oriole | 1 | 48755 | 2 | 0.736 | 66243.2 |
348 | 2023-01-09 00:42:25 | oriole | 1 | 48755 | 2 | 0.733 | 66514.3 |
347 | 2023-01-03 13:51:19 | oriole | 2 | 82551 | 38 | 2.126 | 38829.3 |
346 | 2022-10-20 16:18:09 | oriole | 1 | 48755 | 2 | 0.810 | 60191.4 |
345 | 2022-10-08 08:24:54 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
344 | 2022-09-08 17:01:25 | oriole | 2 | 82551 | 38 | 2.140 | 38575.2 |
343 | 2022-09-06 14:01:15 | oriole | 2 | 82551 | 38 | 2.156 | 38289.0 |
342 | 2022-07-04 11:43:55 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
341 | 2022-05-25 01:08:35 | oriole | 3 | 112716 | 551 | 5.156 | 21861.1 |
340 | 2022-05-24 09:13:50 | oriole | 3 | 112716 | 551 | 5.343 | 21096.0 |
339 | 2022-05-23 11:42:42 | oriole | 1 | 48755 | 2 | 0.923 | 52822.3 |
338 | 2022-03-30 00:22:18 | oriole | 2 | 82551 | 38 | 2.576 | 32046.2 |
337 | 2022-03-27 20:26:42 | oriole | 2 | 82551 | 38 | 5.280 | 15634.7 |
336 | 2022-03-13 19:49:42 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
335 | 2022-02-11 08:00:51 | oriole | 1 | 48755 | 2 | 0.860 | 56691.9 |
334 | 2022-01-19 10:00:02 | oriole | 3 | 112716 | 551 | 5.940 | 18975.8 |
333 | 2021-12-27 08:45:51 | oriole | 2 | 82551 | 38 | 2.186 | 37763.5 |
332 | 2021-12-25 01:40:30 | oriole | 3 | 112716 | 551 | 4.953 | 22757.1 |
331 | 2021-12-05 00:18:30 | oriole | 1 | 48755 | 2 | 0.810 | 60191.4 |
330 | 2021-11-26 16:35:27 | oriole | 1 | 48755 | 2 | 0.876 | 55656.4 |
329 | 2021-11-21 03:52:36 | oriole | 3 | 112716 | 551 | 6.203 | 18171.2 |
328 | 2021-11-01 20:30:42 | oriole | 1 | 48755 | 2 | 0.796 | 61250.0 |
327 | 2021-10-29 14:28:43 | oriole | 3 | 112716 | 551 | 4.923 | 22895.8 |
326 | 2021-10-21 03:12:47 | oriole | 3 | 112716 | 551 | 5.420 | 20796.3 |
325 | 2021-09-19 03:41:26 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
324 | 2021-08-20 09:32:53 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
323 | 2021-08-12 17:07:19 | oriole | 1 | 48755 | 2 | 0.843 | 57835.1 |
322 | 2021-08-12 15:22:50 | oriole | 1 | 48755 | 2 | 0.733 | 66514.3 |
321 | 2021-08-08 15:40:59 | oriole | 1 | 48755 | 2 | 0.780 | 62506.4 |
320 | 2021-08-06 13:59:10 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
319 | 2021-08-05 06:18:29 | oriole | 1 | 48755 | 2 | 0.830 | 58741.0 |
318 | 2021-07-26 06:21:50 | oriole | 1 | 48755 | 2 | 0.733 | 66514.3 |
317 | 2021-07-07 11:59:18 | oriole | 1 | 48755 | 2 | 0.763 | 63899.1 |
316 | 2021-05-19 17:25:57 | oriole | 1 | 48755 | 2 | 0.780 | 62506.4 |
315 | 2021-05-17 00:42:17 | oriole | 1 | 48755 | 2 | 0.890 | 54780.9 |
314 | 2021-04-16 20:35:23 | oriole | 1 | 48755 | 2 | 0.810 | 60191.4 |
313 | 2021-03-19 19:50:37 | oriole | 1 | 48755 | 2 | 0.906 | 53813.5 |
312 | 2021-03-18 23:10:52 | oriole | 2 | 82551 | 38 | 2.470 | 33421.5 |
311 | 2021-02-16 20:28:30 | oriole | 1 | 48755 | 2 | 0.826 | 59025.4 |
310 | 2021-01-29 13:27:08 | oriole | 1 | 48755 | 2 | 0.876 | 55656.4 |
309 | 2021-01-28 19:29:21 | oriole | 2 | 82551 | 38 | 2.470 | 33421.5 |
308 | 2021-01-01 02:00:44 | oriole | 1 | 48755 | 2 | 0.753 | 64747.7 |
307 | 2020-11-17 15:10:57 | oriole | 1 | 48755 | 2 | 0.860 | 56691.9 |
306 | 2020-11-01 15:42:26 | oriole | 1 | 48755 | 2 | 0.906 | 53813.5 |
305 | 2020-10-23 07:48:30 | oriole | 1 | 48755 | 2 | 0.750 | 65006.7 |
304 | 2020-10-15 23:16:41 | oriole | 1 | 48755 | 2 | 0.830 | 58741.0 |
303 | 2020-10-04 06:19:48 | oriole | 1 | 48755 | 2 | 0.796 | 61250.0 |
302 | 2020-09-24 21:01:29 | oriole | 1 | 48755 | 2 | 0.763 | 63899.1 |
301 | 2020-08-15 23:02:40 | oriole | 1 | 48755 | 2 | 0.843 | 57835.1 |
300 | 2020-08-13 02:27:01 | oriole | 1 | 48755 | 2 | 0.733 | 66514.3 |
299 | 2020-08-03 13:20:24 | oriole | 1 | 48755 | 2 | 0.936 | 52088.7 |
298 | 2020-08-02 20:00:59 | oriole | 1 | 48755 | 2 | 0.766 | 63648.8 |