History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
492 | 2024-05-06 10:26:48 | whams | 1 | 28756 | 9 | 1.063 | 27051.7 |
491 | 2024-04-30 12:10:20 | whams | 1 | 28756 | 9 | 1.126 | 25538.2 |
490 | 2024-04-30 06:04:06 | whams | 2 | 53800 | 157 | 3.360 | 16011.9 |
489 | 2024-04-29 12:48:37 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
488 | 2024-04-17 10:04:49 | whams | 1 | 28756 | 9 | 0.640 | 44931.3 |
487 | 2024-04-03 08:34:57 | whams | 2 | 53800 | 157 | 1.623 | 33148.5 |
486 | 2024-04-03 08:34:54 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
485 | 2024-04-03 08:34:49 | whams | 2 | 53800 | 157 | 1.436 | 37465.2 |
484 | 2024-04-03 08:34:45 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
483 | 2024-03-31 01:21:45 | whams | 2 | 53800 | 157 | 3.576 | 15044.7 |
482 | 2024-03-31 01:09:49 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
481 | 2024-03-29 08:32:54 | whams | 2 | 53800 | 157 | 3.030 | 17755.8 |
480 | 2024-03-29 08:15:11 | whams | 1 | 28756 | 9 | 0.546 | 52666.7 |
479 | 2024-03-23 12:21:45 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
478 | 2024-03-04 07:28:32 | whams | 2 | 53800 | 157 | 3.453 | 15580.7 |
477 | 2024-03-04 07:28:08 | whams | 1 | 28756 | 9 | 1.466 | 19615.3 |
476 | 2024-02-28 01:34:28 | whams | 2 | 53800 | 157 | 1.736 | 30990.8 |
475 | 2024-02-28 01:34:19 | whams | 1 | 28756 | 9 | 0.530 | 54256.6 |
474 | 2024-02-03 03:27:03 | whams | 1 | 28756 | 9 | 0.983 | 29253.3 |
473 | 2024-01-29 02:37:39 | whams | 1 | 28756 | 9 | 0.923 | 31154.9 |
472 | 2024-01-28 21:24:45 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
471 | 2024-01-16 13:15:12 | whams | 2 | 53800 | 157 | 2.580 | 20852.7 |
470 | 2023-12-18 23:34:06 | whams | 1 | 28756 | 9 | 0.423 | 67981.1 |
469 | 2023-12-16 10:09:32 | whams | 2 | 53800 | 157 | 1.360 | 39558.8 |
468 | 2023-12-01 07:32:51 | whams | 2 | 53800 | 157 | 1.453 | 37026.8 |
467 | 2023-11-12 01:01:20 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
466 | 2023-11-10 02:58:58 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
465 | 2023-11-03 03:00:19 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
464 | 2023-10-28 01:05:12 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
463 | 2023-10-23 23:26:30 | whams | 1 | 28756 | 9 | 0.516 | 55728.7 |
462 | 2023-10-23 20:47:24 | whams | 2 | 53800 | 157 | 1.313 | 40974.9 |
461 | 2023-10-13 16:46:32 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
460 | 2023-10-07 16:36:43 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
459 | 2023-10-05 07:11:45 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
458 | 2023-09-23 18:13:11 | whams | 1 | 28756 | 9 | 0.466 | 61708.2 |
457 | 2023-09-12 09:11:10 | whams | 1 | 28756 | 9 | 0.466 | 61708.2 |
456 | 2023-08-04 00:22:16 | whams | 2 | 53800 | 157 | 1.313 | 40974.9 |
455 | 2023-08-01 10:51:06 | whams | 1 | 28756 | 9 | 0.453 | 63479.0 |
454 | 2023-04-28 01:37:38 | whams | 1 | 28756 | 9 | 0.440 | 65354.5 |
453 | 2023-04-10 12:10:40 | whams | 2 | 53800 | 157 | 1.513 | 35558.5 |
452 | 2023-02-19 09:21:22 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
451 | 2023-01-17 17:34:21 | whams | 2 | 53800 | 157 | 1.296 | 41512.3 |
450 | 2022-12-16 06:06:28 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
449 | 2022-10-28 01:03:22 | whams | 2 | 53800 | 157 | 1.470 | 36598.6 |
448 | 2022-08-28 16:38:20 | whams | 1 | 28756 | 9 | 0.530 | 54256.6 |
447 | 2022-08-25 11:56:53 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
446 | 2022-07-26 02:57:06 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
445 | 2022-06-25 20:43:26 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
444 | 2022-05-27 21:16:39 | whams | 2 | 53800 | 157 | 1.313 | 40974.9 |
443 | 2022-04-06 20:31:53 | whams | 1 | 28756 | 9 | 0.640 | 44931.3 |
442 | 2022-01-20 14:01:21 | whams | 2 | 53800 | 157 | 1.530 | 35163.4 |
441 | 2022-01-04 04:16:36 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
440 | 2021-11-06 15:18:00 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
439 | 2021-10-10 22:20:55 | whams | 1 | 28756 | 9 | 0.440 | 65354.5 |
438 | 2021-07-05 05:52:10 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
437 | 2021-04-19 06:29:42 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
436 | 2021-01-31 15:30:46 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
435 | 2021-01-03 21:39:37 | whams | 1 | 28756 | 9 | 0.450 | 63902.2 |
434 | 2020-12-06 22:46:15 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
433 | 2020-10-27 11:02:06 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
432 | 2020-10-24 07:31:15 | whams | 1 | 28756 | 9 | 0.466 | 61708.2 |
431 | 2020-08-23 17:17:03 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
430 | 2020-07-22 17:00:17 | whams | 1 | 28756 | 9 | 0.440 | 65354.5 |
429 | 2020-03-30 17:23:49 | whams | 1 | 28756 | 9 | 0.440 | 65354.5 |
428 | 2020-03-26 18:50:09 | whams | 1 | 28756 | 9 | 0.466 | 61708.2 |
427 | 2020-03-25 07:26:32 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
426 | 2020-03-23 16:57:46 | whams | 1 | 28756 | 9 | 0.486 | 59168.7 |
425 | 2020-03-22 00:33:26 | whams | 1 | 28756 | 9 | 0.530 | 54256.6 |
424 | 2020-03-20 22:07:20 | whams | 1 | 28756 | 9 | 0.950 | 30269.5 |
423 | 2020-03-20 02:08:14 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
422 | 2020-03-19 22:44:04 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
421 | 2020-03-19 00:12:30 | whams | 1 | 28756 | 9 | 0.546 | 52666.7 |
420 | 2020-03-18 05:17:08 | whams | 1 | 28756 | 9 | 0.486 | 59168.7 |
419 | 2020-03-17 23:56:17 | whams | 1 | 28756 | 9 | 0.406 | 70827.6 |
418 | 2020-02-27 04:48:31 | whams | 1 | 28756 | 9 | 0.563 | 51076.4 |
417 | 2020-02-24 11:08:13 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
416 | 2020-02-22 09:01:34 | whams | 1 | 28756 | 9 | 0.953 | 30174.2 |
415 | 2020-02-19 22:23:34 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
414 | 2020-02-19 10:12:50 | whams | 1 | 28756 | 9 | 0.533 | 53951.2 |
413 | 2020-02-18 12:09:32 | whams | 1 | 28756 | 9 | 0.546 | 52666.7 |
412 | 2020-02-08 19:00:11 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
411 | 2020-01-30 01:30:29 | whams | 1 | 28756 | 9 | 0.483 | 59536.2 |
410 | 2020-01-29 18:31:10 | whams | 1 | 28756 | 9 | 1.093 | 26309.2 |
409 | 2020-01-29 03:38:53 | whams | 1 | 28756 | 9 | 0.546 | 52666.7 |
408 | 2020-01-23 11:34:04 | whams | 1 | 28756 | 9 | 0.810 | 35501.2 |
407 | 2020-01-22 23:39:00 | whams | 1 | 28756 | 9 | 0.516 | 55728.7 |
406 | 2020-01-20 22:52:26 | whams | 1 | 28756 | 9 | 1.076 | 26724.9 |
405 | 2020-01-19 07:13:09 | whams | 1 | 28756 | 9 | 0.513 | 56054.6 |
404 | 2020-01-15 01:33:59 | whams | 1 | 28756 | 9 | 0.546 | 52666.7 |
403 | 2020-01-10 18:37:04 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
402 | 2020-01-10 08:28:34 | whams | 1 | 28756 | 9 | 0.516 | 55728.7 |
401 | 2020-01-07 00:21:42 | whams | 1 | 28756 | 9 | 0.516 | 55728.7 |
400 | 2020-01-02 10:28:55 | whams | 1 | 28756 | 9 | 0.453 | 63479.0 |
399 | 2019-12-24 09:26:07 | whams | 1 | 28756 | 9 | 0.470 | 61183.0 |
398 | 2019-12-24 02:54:39 | whams | 1 | 28756 | 9 | 0.516 | 55728.7 |
397 | 2019-12-23 21:33:28 | whams | 1 | 28756 | 9 | 0.436 | 65954.1 |
396 | 2019-12-23 16:08:50 | whams | 1 | 28756 | 9 | 0.466 | 61708.2 |
395 | 2019-12-19 22:28:03 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |
394 | 2019-12-12 09:11:24 | whams | 1 | 28756 | 9 | 0.500 | 57512.0 |
393 | 2019-11-17 00:55:53 | whams | 1 | 28756 | 9 | 0.420 | 68466.7 |