History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"avatar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
417 | 2024-04-15 16:55:16 | avatar | 1 | 48755 | 2 | 3.406 | 14314.4 |
416 | 2024-04-01 06:10:27 | avatar | 2 | 82551 | 8 | 2.640 | 31269.3 |
415 | 2024-04-01 06:10:22 | avatar | 1 | 48755 | 2 | 0.983 | 49598.2 |
414 | 2024-04-01 06:10:09 | avatar | 3 | 112716 | 245 | 6.000 | 18786.0 |
413 | 2024-04-01 00:31:40 | avatar | 3 | 112716 | 245 | 19.406 | 5808.3 |
412 | 2024-03-31 22:21:51 | avatar | 3 | 112716 | 245 | 9.233 | 12207.9 |
411 | 2024-03-30 04:14:28 | avatar | 1 | 48755 | 2 | 1.703 | 28628.9 |
410 | 2024-03-14 19:01:21 | avatar | 1 | 48755 | 2 | 2.813 | 17332.0 |
409 | 2024-03-08 00:45:42 | avatar | 1 | 48755 | 2 | 2.876 | 16952.4 |
408 | 2024-03-07 14:49:08 | avatar | 1 | 48755 | 2 | 0.733 | 66514.3 |
407 | 2024-02-28 06:24:20 | avatar | 2 | 82551 | 8 | 2.610 | 31628.7 |
406 | 2024-02-28 06:24:08 | avatar | 3 | 112716 | 245 | 8.513 | 13240.5 |
405 | 2024-02-27 10:18:58 | avatar | 2 | 82551 | 8 | 2.266 | 36430.3 |
404 | 2024-02-27 10:18:49 | avatar | 3 | 112716 | 245 | 5.716 | 19719.4 |
403 | 2024-02-27 05:00:57 | avatar | 3 | 112716 | 245 | 9.610 | 11729.0 |
402 | 2024-02-11 18:19:38 | avatar | 3 | 112716 | 245 | 8.343 | 13510.2 |
401 | 2024-02-11 03:46:22 | avatar | 3 | 112716 | 245 | 4.906 | 22975.1 |
400 | 2024-01-26 12:31:11 | avatar | 1 | 48755 | 2 | 0.923 | 52822.3 |
399 | 2024-01-09 18:39:28 | avatar | 3 | 112716 | 245 | 5.673 | 19868.9 |
398 | 2024-01-05 01:53:35 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
397 | 2024-01-03 13:11:34 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
396 | 2023-12-09 11:18:27 | avatar | 3 | 112716 | 245 | 5.050 | 22320.0 |
395 | 2023-12-09 11:18:28 | avatar | 2 | 82551 | 8 | 2.393 | 34496.9 |
394 | 2023-12-08 13:05:16 | avatar | 1 | 48755 | 2 | 0.826 | 59025.4 |
393 | 2023-12-08 13:05:15 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
392 | 2023-12-05 08:19:44 | avatar | 1 | 48755 | 2 | 0.873 | 55847.7 |
391 | 2023-11-24 06:45:38 | avatar | 3 | 112716 | 245 | 5.656 | 19928.6 |
390 | 2023-11-24 06:45:35 | avatar | 2 | 82551 | 8 | 2.580 | 31996.5 |
389 | 2023-11-21 01:06:47 | avatar | 3 | 112716 | 245 | 4.953 | 22757.1 |
388 | 2023-11-11 00:36:06 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
387 | 2023-11-09 13:52:59 | avatar | 1 | 48755 | 2 | 0.846 | 57630.0 |
386 | 2023-11-03 19:26:58 | avatar | 1 | 48755 | 2 | 1.486 | 32809.6 |
385 | 2023-10-31 23:45:38 | avatar | 3 | 112716 | 245 | 5.170 | 21801.9 |
384 | 2023-10-31 20:41:51 | avatar | 3 | 112716 | 245 | 5.953 | 18934.3 |
383 | 2023-10-31 20:41:52 | avatar | 2 | 82551 | 8 | 2.640 | 31269.3 |
382 | 2023-10-27 03:57:45 | avatar | 1 | 48755 | 2 | 0.890 | 54780.9 |
381 | 2023-10-20 20:35:14 | avatar | 1 | 48755 | 2 | 1.656 | 29441.4 |
380 | 2023-10-18 04:39:20 | avatar | 1 | 48755 | 2 | 0.873 | 55847.7 |
379 | 2023-10-12 09:16:44 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
378 | 2023-10-04 09:48:06 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
377 | 2023-09-23 18:51:19 | avatar | 1 | 48755 | 2 | 0.766 | 63648.8 |
376 | 2023-09-12 10:55:54 | avatar | 1 | 48755 | 2 | 0.826 | 59025.4 |
375 | 2023-08-21 19:21:26 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
374 | 2023-08-21 16:46:41 | avatar | 3 | 112716 | 245 | 5.330 | 21147.5 |
373 | 2023-08-19 14:37:20 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
372 | 2023-06-29 19:07:31 | avatar | 1 | 48755 | 2 | 0.860 | 56691.9 |
371 | 2023-05-25 14:19:02 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
370 | 2023-05-09 04:02:32 | avatar | 1 | 48755 | 2 | 1.516 | 32160.3 |
369 | 2023-05-05 16:08:36 | avatar | 3 | 112716 | 245 | 4.626 | 24365.8 |
368 | 2023-04-27 14:00:06 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
367 | 2023-04-19 03:26:04 | avatar | 1 | 48755 | 2 | 0.860 | 56691.9 |
366 | 2023-03-31 13:44:33 | avatar | 1 | 48755 | 2 | 0.826 | 59025.4 |
365 | 2023-03-30 11:37:04 | avatar | 3 | 112716 | 245 | 5.373 | 20978.2 |
364 | 2023-03-26 20:48:40 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
363 | 2023-03-21 19:07:42 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
362 | 2023-02-13 22:22:17 | avatar | 3 | 112716 | 245 | 6.330 | 17806.6 |
361 | 2023-01-26 21:22:16 | avatar | 1 | 48755 | 2 | 0.720 | 67715.3 |
360 | 2023-01-23 15:06:54 | avatar | 3 | 112716 | 245 | 5.436 | 20735.1 |
359 | 2023-01-07 08:03:59 | avatar | 1 | 48755 | 2 | 0.830 | 58741.0 |
358 | 2022-12-20 19:02:21 | avatar | 3 | 112716 | 245 | 5.030 | 22408.7 |
357 | 2022-11-25 11:27:48 | avatar | 3 | 112716 | 245 | 4.643 | 24276.5 |
356 | 2022-10-08 22:10:56 | avatar | 1 | 48755 | 2 | 0.733 | 66514.3 |
355 | 2022-10-07 04:40:34 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
354 | 2022-10-02 06:31:08 | avatar | 1 | 48755 | 2 | 0.873 | 55847.7 |
353 | 2022-06-14 18:32:47 | avatar | 1 | 48755 | 2 | 0.873 | 55847.7 |
352 | 2022-05-21 01:59:17 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
351 | 2022-05-18 15:59:04 | avatar | 1 | 48755 | 2 | 0.830 | 58741.0 |
350 | 2022-04-24 03:33:02 | avatar | 3 | 112716 | 245 | 4.673 | 24120.7 |
349 | 2022-04-21 23:06:02 | avatar | 3 | 112716 | 245 | 5.406 | 20850.2 |
348 | 2022-02-27 14:06:59 | avatar | 1 | 48755 | 2 | 0.766 | 63648.8 |
347 | 2022-02-04 15:38:21 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
346 | 2021-12-23 02:03:01 | avatar | 3 | 112716 | 245 | 5.500 | 20493.8 |
345 | 2021-12-11 02:07:16 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
344 | 2021-11-15 23:34:31 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
343 | 2021-11-12 16:23:03 | avatar | 1 | 48755 | 2 | 0.876 | 55656.4 |
342 | 2021-10-21 11:48:38 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
341 | 2021-08-17 11:52:27 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
340 | 2021-08-09 18:08:31 | avatar | 1 | 48755 | 2 | 0.750 | 65006.7 |
339 | 2021-06-14 15:59:41 | avatar | 1 | 48755 | 2 | 0.890 | 54780.9 |
338 | 2021-05-31 18:40:10 | avatar | 1 | 48755 | 2 | 0.890 | 54780.9 |
337 | 2021-05-18 05:32:03 | avatar | 1 | 48755 | 2 | 0.813 | 59969.2 |
336 | 2021-05-02 07:05:34 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
335 | 2021-04-04 15:55:37 | avatar | 1 | 48755 | 2 | 0.783 | 62266.9 |
334 | 2021-01-29 23:31:56 | avatar | 1 | 48755 | 2 | 0.936 | 52088.7 |
333 | 2021-01-19 23:20:58 | avatar | 1 | 48755 | 2 | 0.796 | 61250.0 |
332 | 2020-10-31 05:06:38 | avatar | 1 | 48755 | 2 | 0.826 | 59025.4 |
331 | 2020-10-27 07:21:14 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
330 | 2020-10-25 15:13:19 | avatar | 1 | 48755 | 2 | 0.766 | 63648.8 |
329 | 2020-07-26 15:43:39 | avatar | 1 | 48755 | 2 | 0.830 | 58741.0 |
328 | 2020-06-14 09:27:15 | avatar | 1 | 48755 | 2 | 0.856 | 56956.8 |
327 | 2020-04-24 09:34:15 | avatar | 1 | 48755 | 2 | 0.843 | 57835.1 |
326 | 2020-03-25 16:50:09 | avatar | 1 | 48755 | 2 | 0.766 | 63648.8 |
325 | 2020-03-25 00:12:48 | avatar | 1 | 48755 | 2 | 0.890 | 54780.9 |
324 | 2020-03-23 15:42:02 | avatar | 1 | 48755 | 2 | 0.763 | 63899.1 |
323 | 2020-03-22 20:34:10 | avatar | 1 | 48755 | 2 | 0.906 | 53813.5 |
322 | 2020-03-21 11:42:14 | avatar | 1 | 48755 | 2 | 0.876 | 55656.4 |
321 | 2020-03-19 19:02:58 | avatar | 1 | 48755 | 2 | 0.766 | 63648.8 |
320 | 2020-03-18 03:00:26 | avatar | 1 | 48755 | 2 | 0.780 | 62506.4 |
319 | 2020-02-24 20:12:37 | avatar | 1 | 48755 | 2 | 0.860 | 56691.9 |
318 | 2020-02-24 18:19:06 | avatar | 1 | 48755 | 2 | 0.873 | 55847.7 |