History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
496 | 2024-04-21 04:45:07 | drain | 1 | 28756 | 8 | 1.080 | 26625.9 |
495 | 2024-04-10 05:17:13 | drain | 1 | 28756 | 8 | 1.063 | 27051.7 |
494 | 2024-04-03 06:10:55 | drain | 1 | 28756 | 8 | 1.656 | 17364.7 |
493 | 2024-03-31 05:55:31 | drain | 2 | 53800 | 128 | 3.970 | 13551.6 |
492 | 2024-03-27 05:04:39 | drain | 1 | 28756 | 8 | 1.080 | 26625.9 |
491 | 2024-03-10 20:04:58 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |
490 | 2024-03-04 00:28:38 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
489 | 2024-02-26 01:55:32 | drain | 2 | 53800 | 128 | 2.423 | 22203.9 |
488 | 2024-02-26 01:33:39 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
487 | 2024-02-07 17:23:11 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
486 | 2024-02-03 00:10:39 | drain | 1 | 28756 | 8 | 1.033 | 27837.4 |
485 | 2024-01-26 20:46:45 | drain | 1 | 28756 | 8 | 0.703 | 40904.7 |
484 | 2024-01-15 02:50:58 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
483 | 2024-01-09 16:21:05 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
482 | 2024-01-04 14:38:38 | drain | 2 | 53800 | 128 | 1.436 | 37465.2 |
481 | 2024-01-04 04:14:12 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
480 | 2023-12-25 23:40:41 | drain | 2 | 53800 | 128 | 1.733 | 31044.4 |
479 | 2023-12-24 21:58:07 | drain | 2 | 53800 | 128 | 1.763 | 30516.2 |
478 | 2023-12-14 01:34:15 | drain | 2 | 53800 | 128 | 2.873 | 18726.1 |
477 | 2023-12-08 18:30:03 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
476 | 2023-11-20 22:16:24 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
475 | 2023-11-18 03:56:11 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
474 | 2023-11-13 04:08:22 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |
473 | 2023-11-12 19:11:54 | drain | 2 | 53800 | 128 | 1.623 | 33148.5 |
472 | 2023-11-02 03:04:15 | drain | 1 | 28756 | 8 | 0.516 | 55728.7 |
471 | 2023-10-28 19:51:54 | drain | 1 | 28756 | 8 | 0.516 | 55728.7 |
470 | 2023-10-21 16:59:52 | drain | 2 | 53800 | 128 | 1.483 | 36277.8 |
469 | 2023-10-21 09:07:17 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
468 | 2023-10-20 11:41:23 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
467 | 2023-10-15 21:32:08 | drain | 2 | 53800 | 128 | 1.500 | 35866.7 |
466 | 2023-10-13 05:39:12 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
465 | 2023-10-10 16:30:54 | drain | 2 | 53800 | 128 | 1.360 | 39558.8 |
464 | 2023-10-04 23:26:47 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
463 | 2023-10-01 12:48:21 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
462 | 2023-09-28 06:42:55 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
461 | 2023-09-24 15:07:47 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
460 | 2023-09-24 03:09:44 | drain | 1 | 28756 | 8 | 1.140 | 25224.6 |
459 | 2023-08-25 21:42:48 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
458 | 2023-07-22 12:36:51 | drain | 2 | 53800 | 128 | 1.406 | 38264.6 |
457 | 2023-06-20 23:03:21 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
456 | 2023-06-17 18:39:36 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
455 | 2023-05-26 13:48:56 | drain | 1 | 28756 | 8 | 0.423 | 67981.1 |
454 | 2023-04-03 15:20:32 | drain | 2 | 53800 | 128 | 1.390 | 38705.0 |
453 | 2023-03-21 09:32:16 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
452 | 2023-03-15 09:48:08 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
451 | 2023-01-06 19:28:17 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
450 | 2023-01-02 08:47:35 | drain | 2 | 53800 | 128 | 1.326 | 40573.2 |
449 | 2022-12-07 04:07:25 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
448 | 2022-10-01 19:54:22 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
447 | 2022-09-12 06:40:27 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
446 | 2022-09-07 12:49:05 | drain | 2 | 53800 | 128 | 1.343 | 40059.6 |
445 | 2022-09-03 19:07:00 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
444 | 2022-08-23 15:33:26 | drain | 1 | 28756 | 8 | 0.466 | 61708.2 |
443 | 2022-08-06 22:35:45 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
442 | 2022-07-17 21:47:41 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
441 | 2022-07-02 21:37:50 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
440 | 2022-06-16 22:29:44 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
439 | 2022-05-15 01:13:40 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
438 | 2022-05-07 13:45:54 | drain | 1 | 28756 | 8 | 0.470 | 61183.0 |
437 | 2022-05-05 01:43:13 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
436 | 2022-02-03 00:50:54 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
435 | 2022-02-02 18:57:42 | drain | 1 | 28756 | 8 | 0.470 | 61183.0 |
434 | 2021-11-27 02:16:51 | drain | 1 | 28756 | 8 | 0.516 | 55728.7 |
433 | 2021-11-26 23:47:54 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
432 | 2021-11-11 21:24:11 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
431 | 2021-11-02 01:29:02 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
430 | 2021-10-10 14:33:50 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
429 | 2021-10-08 13:31:08 | drain | 1 | 28756 | 8 | 0.513 | 56054.6 |
428 | 2021-09-17 08:06:17 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
427 | 2021-08-15 13:30:57 | drain | 1 | 28756 | 8 | 0.423 | 67981.1 |
426 | 2021-08-02 05:58:09 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
425 | 2021-06-01 16:38:32 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
424 | 2021-05-23 22:07:40 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
423 | 2021-05-07 10:43:21 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
422 | 2021-04-27 21:25:35 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
421 | 2021-04-22 19:55:28 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |
420 | 2021-04-05 19:13:24 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
419 | 2021-02-19 15:19:22 | drain | 1 | 28756 | 8 | 0.450 | 63902.2 |
418 | 2021-02-13 22:07:03 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
417 | 2021-01-23 06:04:41 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
416 | 2021-01-21 05:54:12 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
415 | 2020-11-26 02:02:34 | drain | 1 | 28756 | 8 | 0.420 | 68466.7 |
414 | 2020-11-16 20:56:40 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
413 | 2020-10-21 08:24:21 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
412 | 2020-10-14 21:41:36 | drain | 1 | 28756 | 8 | 0.436 | 65954.1 |
411 | 2020-09-27 02:13:45 | drain | 1 | 28756 | 8 | 0.423 | 67981.1 |
410 | 2020-09-14 23:10:20 | drain | 1 | 28756 | 8 | 0.483 | 59536.2 |
409 | 2020-09-08 20:50:11 | drain | 1 | 28756 | 8 | 0.420 | 68466.7 |
408 | 2020-09-07 11:48:41 | drain | 1 | 28756 | 8 | 0.423 | 67981.1 |
407 | 2020-08-30 15:33:46 | drain | 1 | 28756 | 8 | 0.440 | 65354.5 |
406 | 2020-08-05 11:27:28 | drain | 1 | 28756 | 8 | 0.500 | 57512.0 |
405 | 2020-07-25 00:26:16 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |
404 | 2020-07-21 19:06:03 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
403 | 2020-07-18 07:40:09 | drain | 1 | 28756 | 8 | 0.453 | 63479.0 |
402 | 2020-07-16 07:51:02 | drain | 1 | 28756 | 8 | 0.470 | 61183.0 |
401 | 2020-04-08 09:22:49 | drain | 1 | 28756 | 8 | 0.470 | 61183.0 |
400 | 2020-03-30 08:56:11 | drain | 1 | 28756 | 8 | 0.486 | 59168.7 |
399 | 2020-03-26 19:45:36 | drain | 1 | 28756 | 8 | 0.516 | 55728.7 |
398 | 2020-03-24 15:10:39 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |
397 | 2020-03-23 06:25:09 | drain | 1 | 28756 | 8 | 0.546 | 52666.7 |