History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"terry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
492 | 2024-04-03 02:57:55 | terry | 2 | 53800 | 103 | 4.216 | 12760.9 |
491 | 2024-04-03 02:40:34 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
490 | 2024-03-31 03:19:25 | terry | 1 | 28756 | 13 | 1.016 | 28303.1 |
489 | 2024-03-29 19:03:33 | terry | 2 | 53800 | 103 | 1.843 | 29191.5 |
488 | 2024-03-29 06:42:24 | terry | 1 | 28756 | 13 | 1.406 | 20452.3 |
487 | 2024-03-29 06:42:14 | terry | 2 | 53800 | 103 | 3.766 | 14285.7 |
486 | 2024-03-29 01:21:31 | terry | 2 | 53800 | 103 | 3.140 | 17133.8 |
485 | 2024-03-29 01:14:02 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
484 | 2024-03-03 20:50:55 | terry | 1 | 28756 | 13 | 1.110 | 25906.3 |
483 | 2024-03-01 09:30:04 | terry | 1 | 28756 | 13 | 1.170 | 24577.8 |
482 | 2024-02-27 20:02:50 | terry | 1 | 28756 | 13 | 0.530 | 54256.6 |
481 | 2024-01-28 18:10:09 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
480 | 2024-01-28 17:08:03 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
479 | 2024-01-17 07:19:41 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
478 | 2024-01-09 10:32:35 | terry | 2 | 53800 | 103 | 1.406 | 38264.6 |
477 | 2024-01-09 00:03:05 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
476 | 2023-11-19 20:43:26 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
475 | 2023-11-16 06:08:28 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
474 | 2023-11-11 19:29:49 | terry | 1 | 28756 | 13 | 0.440 | 65354.5 |
473 | 2023-11-04 02:28:58 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
472 | 2023-10-23 18:53:12 | terry | 1 | 28756 | 13 | 1.046 | 27491.4 |
471 | 2023-10-20 16:12:42 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
470 | 2023-10-13 17:19:40 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
469 | 2023-10-04 15:00:18 | terry | 1 | 28756 | 13 | 0.486 | 59168.7 |
468 | 2023-09-24 18:59:41 | terry | 2 | 53800 | 103 | 1.500 | 35866.7 |
467 | 2023-09-19 12:02:22 | terry | 1 | 28756 | 13 | 0.546 | 52666.7 |
466 | 2023-09-02 18:53:46 | terry | 1 | 28756 | 13 | 1.000 | 28756.0 |
465 | 2023-08-31 19:21:50 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
464 | 2023-06-05 01:51:23 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
463 | 2023-05-02 12:55:46 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
462 | 2023-03-27 04:57:00 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
461 | 2023-01-10 17:40:17 | terry | 1 | 28756 | 13 | 0.423 | 67981.1 |
460 | 2022-12-28 21:13:43 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
459 | 2022-10-18 10:14:01 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
458 | 2022-08-21 08:08:58 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
457 | 2022-06-10 00:26:51 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
456 | 2022-04-20 18:39:30 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
455 | 2022-02-17 15:32:44 | terry | 1 | 28756 | 13 | 0.486 | 59168.7 |
454 | 2021-12-29 07:07:10 | terry | 1 | 28756 | 13 | 0.450 | 63902.2 |
453 | 2021-12-08 23:31:39 | terry | 1 | 28756 | 13 | 0.456 | 63061.4 |
452 | 2021-10-14 07:02:23 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
451 | 2021-10-12 06:04:11 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
450 | 2021-09-15 18:14:17 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
449 | 2021-09-01 12:20:29 | terry | 1 | 28756 | 13 | 0.450 | 63902.2 |
448 | 2021-08-15 00:29:20 | terry | 1 | 28756 | 13 | 0.440 | 65354.5 |
447 | 2021-06-15 20:31:51 | terry | 1 | 28756 | 13 | 0.486 | 59168.7 |
446 | 2021-05-21 03:33:47 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
445 | 2021-04-21 13:48:23 | terry | 1 | 28756 | 13 | 0.563 | 51076.4 |
444 | 2021-03-16 11:16:49 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
443 | 2021-02-24 10:06:20 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
442 | 2021-01-06 17:49:07 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
441 | 2020-12-13 11:37:17 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
440 | 2020-10-20 02:10:11 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
439 | 2020-09-05 04:02:20 | terry | 1 | 28756 | 13 | 0.450 | 63902.2 |
438 | 2020-09-03 02:26:09 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
437 | 2020-08-24 05:17:14 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
436 | 2020-08-21 08:44:57 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
435 | 2020-08-03 06:03:28 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
434 | 2020-07-26 20:53:44 | terry | 1 | 28756 | 13 | 0.466 | 61708.2 |
433 | 2020-05-26 08:55:28 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
432 | 2020-05-19 23:14:07 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
431 | 2020-03-27 04:42:06 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
430 | 2020-03-25 12:20:57 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
429 | 2020-03-24 17:25:59 | terry | 1 | 28756 | 13 | 0.530 | 54256.6 |
428 | 2020-03-21 16:22:30 | terry | 1 | 28756 | 13 | 0.470 | 61183.0 |
427 | 2020-03-21 03:08:57 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
426 | 2020-03-21 01:31:55 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
425 | 2020-03-18 00:51:15 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
424 | 2020-03-11 05:01:58 | terry | 1 | 28756 | 13 | 0.450 | 63902.2 |
423 | 2020-02-26 16:11:37 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
422 | 2020-02-24 16:34:44 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
421 | 2020-02-24 09:53:39 | terry | 1 | 28756 | 13 | 0.546 | 52666.7 |
420 | 2020-02-17 05:41:08 | terry | 1 | 28756 | 13 | 1.093 | 26309.2 |
419 | 2020-02-14 19:45:58 | terry | 1 | 28756 | 13 | 0.580 | 49579.3 |
418 | 2020-02-14 01:31:51 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
417 | 2020-02-10 21:17:30 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
416 | 2020-02-08 05:16:31 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
415 | 2020-01-29 02:14:05 | terry | 1 | 28756 | 13 | 0.560 | 51350.0 |
414 | 2020-01-28 21:51:57 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
413 | 2020-01-28 18:39:15 | terry | 1 | 28756 | 13 | 0.560 | 51350.0 |
412 | 2020-01-26 17:58:58 | terry | 1 | 28756 | 13 | 0.533 | 53951.2 |
411 | 2020-01-22 18:10:43 | terry | 1 | 28756 | 13 | 1.110 | 25906.3 |
410 | 2020-01-22 08:21:39 | terry | 1 | 28756 | 13 | 0.560 | 51350.0 |
409 | 2020-01-20 23:53:27 | terry | 1 | 28756 | 13 | 1.170 | 24577.8 |
408 | 2020-01-10 17:27:33 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
407 | 2020-01-10 01:48:36 | terry | 1 | 28756 | 13 | 0.483 | 59536.2 |
406 | 2020-01-09 17:55:44 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
405 | 2020-01-06 23:21:03 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
404 | 2020-01-02 18:07:38 | terry | 1 | 28756 | 13 | 0.626 | 45936.1 |
403 | 2019-12-24 09:33:22 | terry | 1 | 28756 | 13 | 0.530 | 54256.6 |
402 | 2019-12-24 05:54:16 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
401 | 2019-12-23 23:59:11 | terry | 1 | 28756 | 13 | 0.486 | 59168.7 |
400 | 2019-12-23 15:28:05 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
399 | 2019-12-09 18:38:18 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
398 | 2019-12-08 06:50:55 | terry | 1 | 28756 | 13 | 0.533 | 53951.2 |
397 | 2019-11-27 13:25:07 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
396 | 2019-11-14 02:21:05 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
395 | 2019-11-10 06:06:31 | terry | 1 | 28756 | 13 | 0.436 | 65954.1 |
394 | 2019-10-29 12:46:26 | terry | 1 | 28756 | 13 | 0.440 | 65354.5 |
393 | 2019-10-06 21:52:18 | terry | 1 | 28756 | 13 | 0.586 | 49071.7 |