History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aviary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
352 | 2024-04-13 13:47:09 | aviary | 1 | 48755 | 3 | 0.893 | 54596.9 |
351 | 2024-04-09 19:31:02 | aviary | 1 | 48755 | 3 | 1.093 | 44606.6 |
350 | 2024-04-09 17:34:36 | aviary | 1 | 48755 | 3 | 3.593 | 13569.4 |
349 | 2024-03-05 03:43:42 | aviary | 1 | 48755 | 3 | 0.983 | 49598.2 |
348 | 2024-02-28 11:15:17 | aviary | 3 | 112716 | 261 | 11.330 | 9948.5 |
347 | 2024-02-27 08:32:58 | aviary | 2 | 82551 | 24 | 2.626 | 31436.0 |
346 | 2024-02-27 00:55:01 | aviary | 3 | 112716 | 261 | 10.343 | 10897.8 |
345 | 2024-02-26 11:14:11 | aviary | 2 | 82551 | 24 | 2.673 | 30883.3 |
344 | 2024-02-26 11:13:45 | aviary | 3 | 112716 | 261 | 5.670 | 19879.4 |
343 | 2024-02-23 16:22:34 | aviary | 3 | 112716 | 261 | 5.826 | 19347.1 |
342 | 2024-02-18 16:13:27 | aviary | 1 | 48755 | 3 | 0.940 | 51867.0 |
341 | 2024-02-12 16:45:01 | aviary | 3 | 112716 | 261 | 9.876 | 11413.1 |
340 | 2024-02-11 11:11:44 | aviary | 3 | 112716 | 261 | 7.936 | 14203.1 |
339 | 2024-02-11 03:37:07 | aviary | 3 | 112716 | 261 | 4.920 | 22909.8 |
338 | 2024-02-07 21:58:08 | aviary | 1 | 48755 | 3 | 0.766 | 63648.8 |
337 | 2023-12-31 14:08:35 | aviary | 1 | 48755 | 3 | 0.876 | 55656.4 |
336 | 2023-12-26 01:57:14 | aviary | 3 | 112716 | 261 | 4.720 | 23880.5 |
335 | 2023-12-24 01:03:47 | aviary | 3 | 112716 | 261 | 5.470 | 20606.2 |
334 | 2023-12-11 17:18:08 | aviary | 1 | 48755 | 3 | 0.860 | 56691.9 |
333 | 2023-12-03 23:34:27 | aviary | 1 | 48755 | 3 | 0.936 | 52088.7 |
332 | 2023-11-19 23:44:45 | aviary | 1 | 48755 | 3 | 0.763 | 63899.1 |
331 | 2023-11-12 11:08:46 | aviary | 3 | 112716 | 261 | 4.813 | 23419.1 |
330 | 2023-11-09 02:26:00 | aviary | 1 | 48755 | 3 | 0.733 | 66514.3 |
329 | 2023-10-18 11:36:52 | aviary | 1 | 48755 | 3 | 0.733 | 66514.3 |
328 | 2023-10-16 09:03:47 | aviary | 1 | 48755 | 3 | 0.856 | 56956.8 |
327 | 2023-09-23 02:47:44 | aviary | 1 | 48755 | 3 | 0.860 | 56691.9 |
326 | 2023-09-17 22:30:22 | aviary | 1 | 48755 | 3 | 0.890 | 54780.9 |
325 | 2023-09-13 12:24:04 | aviary | 1 | 48755 | 3 | 0.736 | 66243.2 |
324 | 2023-09-05 01:46:24 | aviary | 1 | 48755 | 3 | 0.733 | 66514.3 |
323 | 2023-08-15 03:35:23 | aviary | 3 | 112716 | 261 | 4.703 | 23966.8 |
322 | 2023-07-19 03:25:44 | aviary | 3 | 112716 | 261 | 4.703 | 23966.8 |
321 | 2023-07-08 23:16:07 | aviary | 1 | 48755 | 3 | 0.750 | 65006.7 |
320 | 2023-07-08 09:41:16 | aviary | 1 | 48755 | 3 | 0.763 | 63899.1 |
319 | 2023-05-22 15:53:37 | aviary | 1 | 48755 | 3 | 0.763 | 63899.1 |
318 | 2023-04-30 03:17:56 | aviary | 3 | 112716 | 261 | 8.796 | 12814.5 |
317 | 2023-03-31 12:21:36 | aviary | 3 | 112716 | 261 | 5.670 | 19879.4 |
316 | 2023-03-27 15:20:44 | aviary | 1 | 48755 | 3 | 0.890 | 54780.9 |
315 | 2023-03-13 14:24:12 | aviary | 3 | 112716 | 261 | 5.453 | 20670.5 |
314 | 2023-02-09 16:07:36 | aviary | 1 | 48755 | 3 | 0.890 | 54780.9 |
313 | 2023-02-04 11:03:51 | aviary | 3 | 112716 | 261 | 5.330 | 21147.5 |
312 | 2023-01-01 10:56:58 | aviary | 3 | 112716 | 261 | 4.623 | 24381.6 |
311 | 2022-12-24 00:54:05 | aviary | 3 | 112716 | 261 | 4.813 | 23419.1 |
310 | 2022-11-17 05:43:26 | aviary | 3 | 112716 | 261 | 5.263 | 21416.7 |
309 | 2022-10-19 18:32:38 | aviary | 3 | 112716 | 261 | 4.826 | 23356.0 |
308 | 2022-10-19 13:37:10 | aviary | 1 | 48755 | 3 | 0.860 | 56691.9 |
307 | 2022-09-11 01:46:23 | aviary | 3 | 112716 | 261 | 4.686 | 24053.8 |
306 | 2022-08-06 11:46:31 | aviary | 1 | 48755 | 3 | 0.736 | 66243.2 |
305 | 2022-06-21 20:01:02 | aviary | 1 | 48755 | 3 | 0.953 | 51159.5 |
304 | 2022-06-20 18:15:49 | aviary | 3 | 112716 | 261 | 4.656 | 24208.8 |
303 | 2022-04-29 20:09:25 | aviary | 1 | 48755 | 3 | 0.733 | 66514.3 |
302 | 2022-02-27 04:08:53 | aviary | 1 | 48755 | 3 | 0.750 | 65006.7 |
301 | 2022-01-31 01:58:01 | aviary | 3 | 112716 | 261 | 5.343 | 21096.0 |
300 | 2022-01-16 17:49:25 | aviary | 1 | 48755 | 3 | 0.873 | 55847.7 |
299 | 2021-12-12 09:50:41 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
298 | 2021-11-29 02:57:39 | aviary | 1 | 48755 | 3 | 0.843 | 57835.1 |
297 | 2021-11-15 14:10:21 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
296 | 2021-11-09 16:33:23 | aviary | 3 | 112716 | 261 | 5.206 | 21651.2 |
295 | 2021-08-22 04:00:13 | aviary | 1 | 48755 | 3 | 0.843 | 57835.1 |
294 | 2021-08-12 17:33:55 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
293 | 2021-07-19 06:57:03 | aviary | 2 | 82551 | 24 | 2.250 | 36689.3 |
292 | 2021-05-29 06:51:36 | aviary | 1 | 48755 | 3 | 1.720 | 28345.9 |
291 | 2021-05-05 04:40:34 | aviary | 1 | 48755 | 3 | 1.576 | 30935.9 |
290 | 2021-05-03 16:17:41 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
289 | 2021-04-01 21:29:01 | aviary | 1 | 48755 | 3 | 1.220 | 39963.1 |
288 | 2021-02-02 16:06:24 | aviary | 1 | 48755 | 3 | 1.673 | 29142.3 |
287 | 2021-01-31 06:55:49 | aviary | 3 | 112716 | 261 | 4.906 | 22975.1 |
286 | 2021-01-16 22:03:48 | aviary | 1 | 48755 | 3 | 0.750 | 65006.7 |
285 | 2020-12-17 16:39:27 | aviary | 1 | 48755 | 3 | 0.750 | 65006.7 |
284 | 2020-11-22 02:09:39 | aviary | 1 | 48755 | 3 | 0.763 | 63899.1 |
283 | 2020-11-13 07:53:43 | aviary | 3 | 112716 | 261 | 5.216 | 21609.7 |
282 | 2020-11-13 05:57:52 | aviary | 2 | 82551 | 24 | 2.580 | 31996.5 |
281 | 2020-11-09 14:06:18 | aviary | 1 | 48755 | 3 | 0.796 | 61250.0 |
280 | 2020-11-04 09:48:59 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
279 | 2020-10-31 19:26:26 | aviary | 1 | 48755 | 3 | 0.780 | 62506.4 |
278 | 2020-10-31 04:44:33 | aviary | 3 | 112716 | 261 | 6.186 | 18221.1 |
277 | 2020-10-28 07:49:33 | aviary | 1 | 48755 | 3 | 0.860 | 56691.9 |
276 | 2020-10-23 17:13:30 | aviary | 3 | 112716 | 261 | 5.190 | 21717.9 |
275 | 2020-10-04 12:57:34 | aviary | 2 | 82551 | 24 | 2.266 | 36430.3 |
274 | 2020-09-28 15:07:54 | aviary | 3 | 112716 | 261 | 4.846 | 23259.6 |
273 | 2020-09-15 17:10:20 | aviary | 2 | 82551 | 24 | 2.263 | 36478.6 |
272 | 2020-09-14 09:05:04 | aviary | 3 | 112716 | 261 | 5.110 | 22057.9 |
271 | 2020-09-13 06:25:58 | aviary | 1 | 48755 | 3 | 0.733 | 66514.3 |
270 | 2020-09-11 17:39:15 | aviary | 1 | 48755 | 3 | 0.766 | 63648.8 |
269 | 2020-09-01 16:52:08 | aviary | 1 | 48755 | 3 | 0.750 | 65006.7 |
268 | 2020-08-05 00:17:17 | aviary | 3 | 112716 | 261 | 4.876 | 23116.5 |
267 | 2020-08-04 17:27:22 | aviary | 3 | 112716 | 261 | 5.453 | 20670.5 |
266 | 2020-08-01 19:09:53 | aviary | 1 | 48755 | 3 | 0.843 | 57835.1 |
265 | 2020-07-30 03:57:50 | aviary | 2 | 82551 | 24 | 2.220 | 37185.1 |
264 | 2020-07-27 21:21:14 | aviary | 3 | 112716 | 261 | 5.313 | 21215.1 |
263 | 2020-07-21 12:09:10 | aviary | 1 | 48755 | 3 | 0.906 | 53813.5 |
262 | 2020-04-30 07:43:17 | aviary | 1 | 48755 | 3 | 0.783 | 62266.9 |
261 | 2020-03-29 18:49:04 | aviary | 1 | 48755 | 3 | 0.813 | 59969.2 |
260 | 2020-03-26 08:14:40 | aviary | 1 | 48755 | 3 | 1.013 | 48129.3 |
259 | 2020-03-24 22:25:24 | aviary | 1 | 48755 | 3 | 0.796 | 61250.0 |
258 | 2020-03-23 06:43:52 | aviary | 1 | 48755 | 3 | 1.780 | 27390.4 |
257 | 2020-03-22 16:26:39 | aviary | 1 | 48755 | 3 | 0.830 | 58741.0 |
256 | 2020-03-21 15:39:33 | aviary | 1 | 48755 | 3 | 1.186 | 41108.8 |
255 | 2020-03-18 14:29:25 | aviary | 1 | 48755 | 3 | 0.856 | 56956.8 |
254 | 2020-02-24 00:36:12 | aviary | 1 | 48755 | 3 | 0.906 | 53813.5 |
253 | 2020-02-20 15:53:53 | aviary | 1 | 48755 | 3 | 0.876 | 55656.4 |