History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"candler"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
500 | 2024-05-01 18:45:23 | candler | 3 | 134027 | 686 | 12.203 | 10983.1 |
499 | 2024-04-29 08:52:26 | candler | 1 | 69583 | 9 | 4.156 | 16742.8 |
498 | 2024-04-27 04:04:31 | candler | 1 | 69583 | 9 | 2.860 | 24329.7 |
497 | 2024-04-26 11:09:43 | candler | 2 | 107671 | 84 | 4.656 | 23125.2 |
496 | 2024-04-26 11:05:02 | candler | 3 | 134027 | 686 | 7.766 | 17258.2 |
495 | 2024-04-26 09:11:29 | candler | 2 | 107671 | 84 | 4.266 | 25239.3 |
494 | 2024-04-26 09:08:46 | candler | 3 | 134027 | 686 | 8.766 | 15289.4 |
493 | 2024-04-25 08:49:47 | candler | 2 | 107671 | 84 | 8.626 | 12482.1 |
492 | 2024-04-25 08:46:16 | candler | 3 | 134027 | 686 | 8.030 | 16690.8 |
491 | 2024-04-24 23:46:00 | candler | 2 | 107671 | 84 | 5.126 | 21004.9 |
490 | 2024-04-24 23:44:10 | candler | 3 | 134027 | 686 | 8.063 | 16622.5 |
489 | 2024-04-23 22:16:54 | candler | 3 | 134027 | 686 | 17.110 | 7833.3 |
488 | 2024-04-07 18:57:31 | candler | 1 | 69583 | 9 | 1.516 | 45899.1 |
487 | 2024-03-23 13:26:55 | candler | 1 | 69583 | 9 | 1.140 | 61037.7 |
486 | 2024-03-04 08:52:30 | candler | 3 | 134027 | 686 | 25.046 | 5351.2 |
485 | 2024-03-02 03:46:34 | candler | 3 | 134027 | 686 | 6.296 | 21287.6 |
484 | 2024-02-28 08:25:06 | candler | 3 | 134027 | 686 | 27.203 | 4926.9 |
483 | 2024-02-28 08:21:23 | candler | 2 | 107671 | 84 | 10.563 | 10193.2 |
482 | 2024-02-26 16:35:55 | candler | 3 | 134027 | 686 | 17.406 | 7700.0 |
481 | 2024-02-26 16:35:55 | candler | 2 | 107671 | 84 | 8.220 | 13098.7 |
480 | 2024-01-09 20:26:11 | candler | 3 | 134027 | 686 | 6.233 | 21502.8 |
479 | 2024-01-06 04:07:13 | candler | 2 | 107671 | 84 | 3.296 | 32667.2 |
478 | 2024-01-01 23:18:40 | candler | 2 | 107671 | 84 | 3.266 | 32967.2 |
477 | 2023-12-24 23:32:30 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
476 | 2023-12-15 01:24:50 | candler | 2 | 107671 | 84 | 3.373 | 31921.4 |
475 | 2023-11-29 00:37:09 | candler | 3 | 134027 | 686 | 9.060 | 14793.3 |
474 | 2023-11-26 08:45:00 | candler | 1 | 69583 | 9 | 1.266 | 54962.9 |
473 | 2023-11-16 00:44:18 | candler | 3 | 134027 | 686 | 7.453 | 17983.0 |
472 | 2023-11-15 08:33:04 | candler | 1 | 69583 | 9 | 1.233 | 56433.9 |
471 | 2023-11-14 16:10:09 | candler | 1 | 69583 | 9 | 1.186 | 58670.3 |
470 | 2023-11-14 08:59:25 | candler | 1 | 69583 | 9 | 1.216 | 57222.9 |
469 | 2023-11-12 00:22:52 | candler | 1 | 69583 | 9 | 1.283 | 54234.6 |
468 | 2023-11-06 07:22:44 | candler | 3 | 134027 | 686 | 7.813 | 17154.4 |
467 | 2023-10-30 21:36:04 | candler | 2 | 107671 | 84 | 3.126 | 34443.7 |
466 | 2023-10-29 11:04:08 | candler | 3 | 134027 | 686 | 8.013 | 16726.2 |
465 | 2023-10-28 22:34:14 | candler | 1 | 69583 | 9 | 1.143 | 60877.5 |
464 | 2023-10-26 11:43:56 | candler | 3 | 134027 | 686 | 6.690 | 20033.9 |
463 | 2023-10-21 05:44:30 | candler | 1 | 69583 | 9 | 2.436 | 28564.4 |
462 | 2023-10-18 08:53:02 | candler | 3 | 134027 | 686 | 7.000 | 19146.7 |
461 | 2023-10-13 07:37:43 | candler | 1 | 69583 | 9 | 1.173 | 59320.5 |
460 | 2023-09-28 23:26:13 | candler | 1 | 69583 | 9 | 1.233 | 56433.9 |
459 | 2023-09-17 02:39:10 | candler | 1 | 69583 | 9 | 1.143 | 60877.5 |
458 | 2023-08-08 21:29:16 | candler | 1 | 69583 | 9 | 1.263 | 55093.4 |
457 | 2023-07-29 01:21:40 | candler | 1 | 69583 | 9 | 1.170 | 59472.6 |
456 | 2023-07-28 19:43:31 | candler | 3 | 134027 | 686 | 6.343 | 21129.9 |
455 | 2023-05-11 14:15:40 | candler | 1 | 69583 | 9 | 2.250 | 30925.8 |
454 | 2023-04-20 17:10:27 | candler | 1 | 69583 | 9 | 1.250 | 55666.4 |
453 | 2023-04-09 15:54:57 | candler | 3 | 134027 | 686 | 7.203 | 18607.1 |
452 | 2023-04-08 08:39:11 | candler | 3 | 134027 | 686 | 5.843 | 22938.0 |
451 | 2023-03-04 03:42:55 | candler | 1 | 69583 | 9 | 1.076 | 64668.2 |
450 | 2023-01-26 15:04:14 | candler | 3 | 134027 | 686 | 5.830 | 22989.2 |
449 | 2023-01-11 00:36:50 | candler | 3 | 134027 | 686 | 5.766 | 23244.4 |
448 | 2023-01-04 14:15:23 | candler | 1 | 69583 | 9 | 1.076 | 64668.2 |
447 | 2022-12-26 18:16:11 | candler | 1 | 69583 | 9 | 1.313 | 52995.4 |
446 | 2022-12-12 10:40:32 | candler | 3 | 134027 | 686 | 6.610 | 20276.4 |
445 | 2022-11-22 00:15:22 | candler | 3 | 134027 | 686 | 5.970 | 22450.1 |
444 | 2022-11-18 10:06:22 | candler | 3 | 134027 | 686 | 6.593 | 20328.7 |
443 | 2022-10-11 23:23:25 | candler | 3 | 134027 | 686 | 5.936 | 22578.7 |
442 | 2022-09-17 08:29:35 | candler | 1 | 69583 | 9 | 1.156 | 60192.9 |
441 | 2022-09-14 15:47:08 | candler | 1 | 69583 | 9 | 1.126 | 61796.6 |
440 | 2022-08-16 01:01:16 | candler | 1 | 69583 | 9 | 1.140 | 61037.7 |
439 | 2022-08-15 17:31:48 | candler | 1 | 69583 | 9 | 1.203 | 57841.2 |
438 | 2022-07-18 11:00:35 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
437 | 2022-07-18 08:09:24 | candler | 1 | 69583 | 9 | 1.123 | 61961.7 |
436 | 2022-07-11 16:44:32 | candler | 3 | 134027 | 686 | 5.826 | 23005.0 |
435 | 2022-07-10 10:48:39 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
434 | 2022-06-30 03:00:55 | candler | 1 | 69583 | 9 | 1.250 | 55666.4 |
433 | 2022-06-25 15:57:16 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
432 | 2022-06-16 20:51:17 | candler | 1 | 69583 | 9 | 1.106 | 62914.1 |
431 | 2022-06-08 23:23:21 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
430 | 2022-06-01 19:39:27 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
429 | 2022-05-25 09:35:09 | candler | 1 | 69583 | 9 | 1.220 | 57035.2 |
428 | 2022-05-12 21:14:25 | candler | 3 | 134027 | 686 | 7.486 | 17903.7 |
427 | 2022-05-10 15:09:01 | candler | 3 | 134027 | 686 | 8.063 | 16622.5 |
426 | 2022-04-25 00:37:41 | candler | 3 | 134027 | 686 | 6.440 | 20811.6 |
425 | 2022-03-09 08:29:19 | candler | 1 | 69583 | 9 | 1.283 | 54234.6 |
424 | 2022-02-10 06:27:10 | candler | 1 | 69583 | 9 | 1.343 | 51811.6 |
423 | 2022-01-10 04:37:38 | candler | 3 | 134027 | 686 | 6.000 | 22337.8 |
422 | 2021-12-21 21:17:19 | candler | 1 | 69583 | 9 | 1.266 | 54962.9 |
421 | 2021-12-19 18:54:42 | candler | 1 | 69583 | 9 | 1.313 | 52995.4 |
420 | 2021-11-06 00:05:47 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
419 | 2021-10-22 22:35:25 | candler | 3 | 134027 | 686 | 14.766 | 9076.7 |
418 | 2021-10-22 18:34:48 | candler | 1 | 69583 | 9 | 1.250 | 55666.4 |
417 | 2021-09-10 16:58:55 | candler | 1 | 69583 | 9 | 1.093 | 63662.4 |
416 | 2021-09-08 12:35:46 | candler | 1 | 69583 | 9 | 1.343 | 51811.6 |
415 | 2021-08-26 10:35:23 | candler | 3 | 134027 | 686 | 12.016 | 11154.0 |
414 | 2021-08-24 01:44:17 | candler | 1 | 69583 | 9 | 1.110 | 62687.4 |
413 | 2021-08-22 00:57:18 | candler | 3 | 134027 | 686 | 7.250 | 18486.5 |
412 | 2021-08-21 21:21:44 | candler | 1 | 69583 | 9 | 1.220 | 57035.2 |
411 | 2021-08-06 07:14:25 | candler | 1 | 69583 | 9 | 1.093 | 63662.4 |
410 | 2021-07-26 10:32:17 | candler | 1 | 69583 | 9 | 1.220 | 57035.2 |
409 | 2021-07-25 07:39:11 | candler | 3 | 134027 | 686 | 6.376 | 21020.5 |
408 | 2021-07-10 09:27:45 | candler | 3 | 134027 | 686 | 6.170 | 21722.4 |
407 | 2021-06-20 19:50:04 | candler | 3 | 134027 | 686 | 6.110 | 21935.7 |
406 | 2021-05-16 16:44:06 | candler | 1 | 69583 | 9 | 1.186 | 58670.3 |
405 | 2021-05-02 06:59:40 | candler | 1 | 69583 | 9 | 1.313 | 52995.4 |
404 | 2021-04-16 10:34:26 | candler | 1 | 69583 | 9 | 1.236 | 56296.9 |
403 | 2021-04-05 03:49:28 | candler | 1 | 69583 | 9 | 1.143 | 60877.5 |
402 | 2021-03-19 11:57:30 | candler | 1 | 69583 | 9 | 1.280 | 54361.7 |
401 | 2021-02-23 07:51:44 | candler | 1 | 69583 | 9 | 1.250 | 55666.4 |