History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"avenue"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
455 | 2024-05-03 23:10:03 | avenue | 1 | 48755 | 4 | 1.970 | 24748.7 |
454 | 2024-04-05 23:59:54 | avenue | 3 | 112716 | 252 | 18.864 | 5975.2 |
453 | 2024-04-05 20:55:01 | avenue | 3 | 112716 | 252 | 5.733 | 19660.9 |
452 | 2024-04-05 20:55:00 | avenue | 2 | 82551 | 21 | 2.530 | 32628.9 |
451 | 2024-04-05 20:54:57 | avenue | 1 | 48755 | 4 | 0.826 | 59025.4 |
450 | 2024-04-03 05:02:25 | avenue | 1 | 48755 | 4 | 0.966 | 50471.0 |
449 | 2024-03-31 16:45:38 | avenue | 1 | 48755 | 4 | 2.970 | 16415.8 |
448 | 2024-03-14 19:30:01 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
447 | 2024-03-06 20:14:34 | avenue | 3 | 112716 | 252 | 13.550 | 8318.5 |
446 | 2024-03-06 13:33:44 | avenue | 3 | 112716 | 252 | 16.596 | 6791.8 |
445 | 2024-03-06 13:33:54 | avenue | 1 | 48755 | 4 | 0.970 | 50262.9 |
444 | 2024-03-06 13:33:42 | avenue | 2 | 82551 | 21 | 6.233 | 13244.2 |
443 | 2024-02-28 10:32:41 | avenue | 1 | 48755 | 4 | 3.263 | 14941.8 |
442 | 2024-01-26 08:52:29 | avenue | 3 | 112716 | 252 | 12.173 | 9259.5 |
441 | 2024-01-26 07:50:35 | avenue | 2 | 82551 | 21 | 2.766 | 29844.9 |
440 | 2024-01-26 07:50:23 | avenue | 3 | 112716 | 252 | 5.813 | 19390.3 |
439 | 2024-01-22 02:04:34 | avenue | 2 | 82551 | 21 | 2.470 | 33421.5 |
438 | 2024-01-22 02:04:31 | avenue | 3 | 112716 | 252 | 5.063 | 22262.7 |
437 | 2024-01-12 11:35:00 | avenue | 3 | 112716 | 252 | 4.763 | 23664.9 |
436 | 2024-01-12 11:34:57 | avenue | 2 | 82551 | 21 | 2.126 | 38829.3 |
435 | 2023-12-17 17:03:59 | avenue | 1 | 48755 | 4 | 0.780 | 62506.4 |
434 | 2023-12-03 17:15:05 | avenue | 1 | 48755 | 4 | 0.873 | 55847.7 |
433 | 2023-12-03 17:15:04 | avenue | 1 | 48755 | 4 | 0.966 | 50471.0 |
432 | 2023-11-17 11:24:42 | avenue | 1 | 48755 | 4 | 0.763 | 63899.1 |
431 | 2023-11-16 23:12:23 | avenue | 1 | 48755 | 4 | 0.860 | 56691.9 |
430 | 2023-11-05 03:34:38 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
429 | 2023-11-04 01:28:35 | avenue | 1 | 48755 | 4 | 0.813 | 59969.2 |
428 | 2023-10-19 02:25:09 | avenue | 1 | 48755 | 4 | 0.826 | 59025.4 |
427 | 2023-10-15 10:05:02 | avenue | 1 | 48755 | 4 | 0.830 | 58741.0 |
426 | 2023-10-14 23:30:31 | avenue | 1 | 48755 | 4 | 0.813 | 59969.2 |
425 | 2023-10-12 11:22:06 | avenue | 3 | 112716 | 252 | 6.266 | 17988.5 |
424 | 2023-10-09 01:48:10 | avenue | 3 | 112716 | 252 | 6.376 | 17678.2 |
423 | 2023-10-05 15:05:46 | avenue | 1 | 48755 | 4 | 0.766 | 63648.8 |
422 | 2023-10-01 02:43:12 | avenue | 3 | 112716 | 252 | 6.046 | 18643.1 |
421 | 2023-09-27 14:49:58 | avenue | 3 | 112716 | 252 | 4.783 | 23566.0 |
420 | 2023-09-27 14:49:56 | avenue | 2 | 82551 | 21 | 2.313 | 35690.0 |
419 | 2023-09-26 05:43:50 | avenue | 1 | 48755 | 4 | 0.763 | 63899.1 |
418 | 2023-09-15 18:50:58 | avenue | 1 | 48755 | 4 | 0.783 | 62266.9 |
417 | 2023-08-01 13:29:42 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
416 | 2023-06-24 19:21:47 | avenue | 1 | 48755 | 4 | 0.890 | 54780.9 |
415 | 2023-04-29 10:42:39 | avenue | 1 | 48755 | 4 | 0.796 | 61250.0 |
414 | 2023-03-09 06:25:53 | avenue | 1 | 48755 | 4 | 0.920 | 52994.6 |
413 | 2023-02-18 13:24:08 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
412 | 2022-12-17 01:12:10 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
411 | 2022-12-14 08:07:03 | avenue | 1 | 48755 | 4 | 0.810 | 60191.4 |
410 | 2022-11-17 10:41:58 | avenue | 1 | 48755 | 4 | 0.780 | 62506.4 |
409 | 2022-11-13 19:52:49 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
408 | 2022-08-25 00:53:20 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
407 | 2022-07-20 22:25:33 | avenue | 1 | 48755 | 4 | 0.736 | 66243.2 |
406 | 2022-07-17 05:09:52 | avenue | 1 | 48755 | 4 | 0.733 | 66514.3 |
405 | 2022-04-08 13:57:11 | avenue | 1 | 48755 | 4 | 1.076 | 45311.3 |
404 | 2022-03-13 00:36:15 | avenue | 1 | 48755 | 4 | 0.766 | 63648.8 |
403 | 2022-03-09 16:10:26 | avenue | 1 | 48755 | 4 | 0.940 | 51867.0 |
402 | 2022-01-05 21:37:40 | avenue | 1 | 48755 | 4 | 0.873 | 55847.7 |
401 | 2021-12-12 20:50:56 | avenue | 2 | 82551 | 21 | 2.233 | 36968.7 |
400 | 2021-11-26 00:04:33 | avenue | 1 | 48755 | 4 | 0.830 | 58741.0 |
399 | 2021-11-12 04:05:23 | avenue | 2 | 82551 | 21 | 2.216 | 37252.3 |
398 | 2021-11-08 06:25:00 | avenue | 1 | 48755 | 4 | 0.783 | 62266.9 |
397 | 2021-11-06 05:19:33 | avenue | 1 | 48755 | 4 | 0.796 | 61250.0 |
396 | 2021-09-21 13:51:26 | avenue | 1 | 48755 | 4 | 0.843 | 57835.1 |
395 | 2021-09-04 05:19:10 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
394 | 2021-08-26 09:53:01 | avenue | 1 | 48755 | 4 | 0.830 | 58741.0 |
393 | 2021-08-12 17:10:55 | avenue | 1 | 48755 | 4 | 0.860 | 56691.9 |
392 | 2021-07-02 20:44:42 | avenue | 2 | 82551 | 21 | 2.203 | 37472.1 |
391 | 2021-06-03 01:41:33 | avenue | 1 | 48755 | 4 | 0.860 | 56691.9 |
390 | 2021-05-25 16:28:35 | avenue | 1 | 48755 | 4 | 0.826 | 59025.4 |
389 | 2021-04-15 20:25:46 | avenue | 2 | 82551 | 21 | 2.623 | 31472.0 |
388 | 2021-03-18 23:21:58 | avenue | 2 | 82551 | 21 | 2.453 | 33653.1 |
387 | 2021-03-11 12:35:08 | avenue | 1 | 48755 | 4 | 0.843 | 57835.1 |
386 | 2021-02-20 04:44:53 | avenue | 1 | 48755 | 4 | 0.763 | 63899.1 |
385 | 2021-02-15 03:21:15 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
384 | 2021-02-14 08:53:10 | avenue | 2 | 82551 | 21 | 2.436 | 33887.9 |
383 | 2021-01-28 19:47:58 | avenue | 2 | 82551 | 21 | 2.156 | 38289.0 |
382 | 2021-01-22 10:12:24 | avenue | 1 | 48755 | 4 | 0.856 | 56956.8 |
381 | 2020-12-31 03:16:34 | avenue | 2 | 82551 | 21 | 2.123 | 38884.1 |
380 | 2020-12-23 14:39:59 | avenue | 1 | 48755 | 4 | 0.796 | 61250.0 |
379 | 2020-12-04 03:30:23 | avenue | 2 | 82551 | 21 | 2.203 | 37472.1 |
378 | 2020-11-16 15:10:38 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
377 | 2020-10-27 22:06:37 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
376 | 2020-10-26 00:56:44 | avenue | 1 | 48755 | 4 | 0.843 | 57835.1 |
375 | 2020-08-30 17:26:41 | avenue | 2 | 82551 | 21 | 2.470 | 33421.5 |
374 | 2020-08-14 06:32:36 | avenue | 1 | 48755 | 4 | 0.796 | 61250.0 |
373 | 2020-08-11 07:11:42 | avenue | 1 | 48755 | 4 | 0.813 | 59969.2 |
372 | 2020-07-30 14:31:38 | avenue | 2 | 82551 | 21 | 2.283 | 36159.0 |
371 | 2020-06-09 02:24:46 | avenue | 1 | 48755 | 4 | 0.766 | 63648.8 |
370 | 2020-05-03 19:51:56 | avenue | 1 | 48755 | 4 | 0.813 | 59969.2 |
369 | 2020-04-10 07:53:43 | avenue | 2 | 82551 | 21 | 2.483 | 33246.5 |
368 | 2020-04-09 07:11:59 | avenue | 2 | 82551 | 21 | 2.436 | 33887.9 |
367 | 2020-04-08 08:00:20 | avenue | 2 | 82551 | 21 | 2.593 | 31836.1 |
366 | 2020-04-07 07:18:57 | avenue | 2 | 82551 | 21 | 2.203 | 37472.1 |
365 | 2020-04-06 07:15:46 | avenue | 2 | 82551 | 21 | 2.326 | 35490.5 |
364 | 2020-04-02 12:35:18 | avenue | 2 | 82551 | 21 | 2.516 | 32810.4 |
363 | 2020-04-01 13:19:00 | avenue | 2 | 82551 | 21 | 2.470 | 33421.5 |
362 | 2020-03-31 12:56:17 | avenue | 2 | 82551 | 21 | 2.173 | 37989.4 |
361 | 2020-03-24 17:50:17 | avenue | 1 | 48755 | 4 | 0.843 | 57835.1 |
360 | 2020-03-24 00:01:47 | avenue | 1 | 48755 | 4 | 0.830 | 58741.0 |
359 | 2020-03-20 20:19:50 | avenue | 1 | 48755 | 4 | 0.766 | 63648.8 |
358 | 2020-03-12 17:25:03 | avenue | 1 | 48755 | 4 | 0.750 | 65006.7 |
357 | 2020-02-20 09:39:35 | avenue | 1 | 48755 | 4 | 1.920 | 25393.2 |
356 | 2020-02-17 01:23:38 | avenue | 1 | 48755 | 4 | 2.313 | 21078.7 |