History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stern"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
489 | 2024-04-20 07:39:27 | stern | 1 | 28756 | 7 | 0.563 | 51076.4 |
488 | 2024-04-03 07:58:26 | stern | 2 | 53800 | 122 | 5.453 | 9866.1 |
487 | 2024-04-03 07:24:19 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
486 | 2024-03-31 04:38:01 | stern | 2 | 53800 | 122 | 1.983 | 27130.6 |
485 | 2024-03-31 04:20:20 | stern | 1 | 28756 | 7 | 1.030 | 27918.4 |
484 | 2024-03-04 00:29:34 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
483 | 2024-03-01 03:04:57 | stern | 1 | 28756 | 7 | 0.640 | 44931.3 |
482 | 2024-02-25 22:14:50 | stern | 2 | 53800 | 122 | 5.766 | 9330.6 |
481 | 2024-02-25 19:21:40 | stern | 1 | 28756 | 7 | 0.470 | 61183.0 |
480 | 2024-02-03 00:09:59 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
479 | 2024-01-29 14:07:21 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
478 | 2024-01-28 17:27:28 | stern | 1 | 28756 | 7 | 0.970 | 29645.4 |
477 | 2024-01-12 09:09:01 | stern | 2 | 53800 | 122 | 1.546 | 34799.5 |
476 | 2023-12-29 11:44:47 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
475 | 2023-11-23 19:04:25 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
474 | 2023-11-18 02:36:31 | stern | 2 | 53800 | 122 | 1.656 | 32487.9 |
473 | 2023-11-12 21:15:27 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
472 | 2023-11-12 21:00:11 | stern | 2 | 53800 | 122 | 1.580 | 34050.6 |
471 | 2023-11-09 00:08:00 | stern | 1 | 28756 | 7 | 0.486 | 59168.7 |
470 | 2023-11-07 08:15:59 | stern | 2 | 53800 | 122 | 1.563 | 34421.0 |
469 | 2023-11-02 12:05:35 | stern | 2 | 53800 | 122 | 1.533 | 35094.6 |
468 | 2023-10-30 22:43:51 | stern | 2 | 53800 | 122 | 1.703 | 31591.3 |
467 | 2023-10-25 23:37:37 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
466 | 2023-10-20 22:01:41 | stern | 2 | 53800 | 122 | 1.393 | 38621.7 |
465 | 2023-10-20 17:55:20 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
464 | 2023-10-17 23:55:51 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
463 | 2023-10-13 17:16:10 | stern | 1 | 28756 | 7 | 0.440 | 65354.5 |
462 | 2023-10-04 12:49:25 | stern | 1 | 28756 | 7 | 0.440 | 65354.5 |
461 | 2023-09-23 12:26:39 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
460 | 2023-09-21 19:12:05 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
459 | 2023-09-10 04:23:08 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
458 | 2023-08-23 19:15:50 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
457 | 2023-08-01 00:33:22 | stern | 2 | 53800 | 122 | 1.576 | 34137.1 |
456 | 2023-06-18 19:56:02 | stern | 1 | 28756 | 7 | 0.486 | 59168.7 |
455 | 2023-04-25 09:38:00 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
454 | 2023-04-21 17:09:14 | stern | 1 | 28756 | 7 | 0.440 | 65354.5 |
453 | 2023-04-11 15:47:03 | stern | 2 | 53800 | 122 | 1.470 | 36598.6 |
452 | 2023-04-02 11:40:59 | stern | 1 | 28756 | 7 | 0.516 | 55728.7 |
451 | 2023-01-15 04:34:03 | stern | 1 | 28756 | 7 | 0.516 | 55728.7 |
450 | 2023-01-14 19:28:01 | stern | 2 | 53800 | 122 | 1.343 | 40059.6 |
449 | 2022-12-30 03:56:22 | stern | 1 | 28756 | 7 | 0.486 | 59168.7 |
448 | 2022-12-18 05:55:19 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
447 | 2022-11-22 04:55:55 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
446 | 2022-11-04 17:33:05 | stern | 1 | 28756 | 7 | 0.486 | 59168.7 |
445 | 2022-10-18 12:07:02 | stern | 2 | 53800 | 122 | 1.513 | 35558.5 |
444 | 2022-08-14 21:13:12 | stern | 1 | 28756 | 7 | 0.486 | 59168.7 |
443 | 2022-08-06 10:49:15 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
442 | 2022-07-29 03:42:34 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
441 | 2022-06-24 02:26:41 | stern | 1 | 28756 | 7 | 0.423 | 67981.1 |
440 | 2022-05-14 17:15:13 | stern | 2 | 53800 | 122 | 1.390 | 38705.0 |
439 | 2022-04-17 14:57:35 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
438 | 2022-02-27 02:57:45 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
437 | 2021-12-29 11:48:42 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
436 | 2021-12-10 06:32:53 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
435 | 2021-12-07 16:29:19 | stern | 1 | 28756 | 7 | 0.643 | 44721.6 |
434 | 2021-10-15 00:47:56 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
433 | 2021-09-21 22:50:57 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
432 | 2021-09-12 18:34:22 | stern | 1 | 28756 | 7 | 0.440 | 65354.5 |
431 | 2021-07-27 02:19:36 | stern | 1 | 28756 | 7 | 0.470 | 61183.0 |
430 | 2021-06-12 14:22:32 | stern | 1 | 28756 | 7 | 0.576 | 49923.6 |
429 | 2021-06-03 16:50:20 | stern | 2 | 53800 | 122 | 3.030 | 17755.8 |
428 | 2021-05-17 20:21:28 | stern | 1 | 28756 | 7 | 0.890 | 32310.1 |
427 | 2021-03-13 04:42:40 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
426 | 2021-01-30 07:06:53 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
425 | 2021-01-23 00:26:31 | stern | 2 | 53800 | 122 | 1.406 | 38264.6 |
424 | 2021-01-02 05:40:46 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
423 | 2020-12-10 01:42:32 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
422 | 2020-11-24 18:47:30 | stern | 2 | 53800 | 122 | 1.420 | 37887.3 |
421 | 2020-11-19 06:02:40 | stern | 1 | 28756 | 7 | 1.030 | 27918.4 |
420 | 2020-11-18 03:50:52 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
419 | 2020-11-02 05:50:54 | stern | 1 | 28756 | 7 | 0.593 | 48492.4 |
418 | 2020-11-01 18:44:25 | stern | 2 | 53800 | 122 | 1.686 | 31909.8 |
417 | 2020-10-27 20:50:53 | stern | 2 | 53800 | 122 | 1.563 | 34421.0 |
416 | 2020-10-24 12:44:24 | stern | 2 | 53800 | 122 | 1.563 | 34421.0 |
415 | 2020-10-07 05:58:42 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
414 | 2020-10-05 01:37:37 | stern | 2 | 53800 | 122 | 1.736 | 30990.8 |
413 | 2020-09-03 08:45:58 | stern | 1 | 28756 | 7 | 0.686 | 41918.4 |
412 | 2020-08-30 17:35:08 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
411 | 2020-08-24 20:59:34 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
410 | 2020-08-19 15:50:05 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
409 | 2020-08-11 08:42:14 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
408 | 2020-07-30 09:59:39 | stern | 1 | 28756 | 7 | 0.533 | 53951.2 |
407 | 2020-07-30 04:08:41 | stern | 2 | 53800 | 122 | 1.420 | 37887.3 |
406 | 2020-05-26 07:24:37 | stern | 1 | 28756 | 7 | 0.453 | 63479.0 |
405 | 2020-03-30 15:49:29 | stern | 1 | 28756 | 7 | 0.483 | 59536.2 |
404 | 2020-03-25 00:15:15 | stern | 1 | 28756 | 7 | 1.063 | 27051.7 |
403 | 2020-03-23 20:15:03 | stern | 1 | 28756 | 7 | 0.546 | 52666.7 |
402 | 2020-03-23 15:21:24 | stern | 1 | 28756 | 7 | 0.546 | 52666.7 |
401 | 2020-03-22 21:45:24 | stern | 1 | 28756 | 7 | 0.513 | 56054.6 |
400 | 2020-03-21 06:58:30 | stern | 1 | 28756 | 7 | 0.436 | 65954.1 |
399 | 2020-03-18 01:25:48 | stern | 1 | 28756 | 7 | 0.470 | 61183.0 |
398 | 2020-02-29 20:43:23 | stern | 2 | 53800 | 122 | 2.516 | 21383.1 |
397 | 2020-02-29 16:03:34 | stern | 2 | 53800 | 122 | 3.576 | 15044.7 |
396 | 2020-02-29 12:18:55 | stern | 2 | 53800 | 122 | 1.920 | 28020.8 |
395 | 2020-02-29 07:12:59 | stern | 2 | 53800 | 122 | 1.470 | 36598.6 |
394 | 2020-02-27 17:52:28 | stern | 2 | 53800 | 122 | 1.876 | 28678.0 |
393 | 2020-02-24 20:43:50 | stern | 1 | 28756 | 7 | 0.500 | 57512.0 |
392 | 2020-02-23 16:50:16 | stern | 1 | 28756 | 7 | 0.593 | 48492.4 |
391 | 2020-02-23 01:54:03 | stern | 1 | 28756 | 7 | 1.030 | 27918.4 |
390 | 2020-02-21 00:50:47 | stern | 1 | 28756 | 7 | 0.530 | 54256.6 |