History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"motel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
515 | 2024-04-23 14:31:53 | motel | 2 | 53800 | 154 | 3.546 | 15172.0 |
514 | 2024-04-22 18:17:56 | motel | 1 | 28756 | 11 | 2.110 | 13628.4 |
513 | 2024-04-12 23:41:23 | motel | 2 | 53800 | 154 | 1.606 | 33499.4 |
512 | 2024-04-12 23:33:11 | motel | 2 | 53800 | 154 | 1.906 | 28226.7 |
511 | 2024-04-12 23:32:20 | motel | 2 | 53800 | 154 | 2.033 | 26463.4 |
510 | 2024-04-12 23:28:26 | motel | 1 | 28756 | 11 | 0.576 | 49923.6 |
509 | 2024-04-12 23:27:46 | motel | 1 | 28756 | 11 | 0.563 | 51076.4 |
508 | 2024-04-02 22:48:14 | motel | 2 | 53800 | 154 | 5.360 | 10037.3 |
507 | 2024-04-02 21:00:18 | motel | 1 | 28756 | 11 | 0.546 | 52666.7 |
506 | 2024-03-31 06:19:47 | motel | 2 | 53800 | 154 | 7.610 | 7069.6 |
505 | 2024-03-31 06:10:20 | motel | 1 | 28756 | 11 | 1.156 | 24875.4 |
504 | 2024-03-27 05:22:19 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
503 | 2024-03-15 22:23:41 | motel | 1 | 28756 | 11 | 0.560 | 51350.0 |
502 | 2024-03-04 01:45:48 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
501 | 2024-03-01 03:53:52 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
500 | 2024-02-25 21:52:22 | motel | 2 | 53800 | 154 | 5.576 | 9648.5 |
499 | 2024-02-25 19:29:22 | motel | 1 | 28756 | 11 | 0.546 | 52666.7 |
498 | 2024-01-28 20:12:07 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
497 | 2024-01-22 12:03:58 | motel | 1 | 28756 | 11 | 0.546 | 52666.7 |
496 | 2024-01-11 15:17:59 | motel | 1 | 28756 | 11 | 0.576 | 49923.6 |
495 | 2024-01-04 02:02:44 | motel | 2 | 53800 | 154 | 1.560 | 34487.2 |
494 | 2023-12-16 11:46:34 | motel | 2 | 53800 | 154 | 1.610 | 33416.1 |
493 | 2023-12-15 03:17:47 | motel | 1 | 28756 | 11 | 0.983 | 29253.3 |
492 | 2023-12-14 09:33:56 | motel | 2 | 53800 | 154 | 1.390 | 38705.0 |
491 | 2023-11-24 23:27:13 | motel | 2 | 53800 | 154 | 1.546 | 34799.5 |
490 | 2023-11-21 20:38:52 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
489 | 2023-11-13 22:53:24 | motel | 1 | 28756 | 11 | 0.440 | 65354.5 |
488 | 2023-11-11 18:54:39 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
487 | 2023-11-06 16:12:29 | motel | 1 | 28756 | 11 | 0.513 | 56054.6 |
486 | 2023-10-25 19:11:56 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
485 | 2023-10-22 22:01:43 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
484 | 2023-10-21 21:19:27 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
483 | 2023-10-19 03:12:55 | motel | 1 | 28756 | 11 | 0.466 | 61708.2 |
482 | 2023-10-13 15:43:15 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
481 | 2023-10-07 20:30:25 | motel | 1 | 28756 | 11 | 0.440 | 65354.5 |
480 | 2023-09-29 08:58:30 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
479 | 2023-09-28 07:21:22 | motel | 2 | 53800 | 154 | 1.470 | 36598.6 |
478 | 2023-09-22 10:55:26 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
477 | 2023-09-11 23:40:32 | motel | 2 | 53800 | 154 | 1.373 | 39184.3 |
476 | 2023-09-02 22:46:53 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
475 | 2023-08-27 13:27:01 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
474 | 2023-08-17 09:19:11 | motel | 2 | 53800 | 154 | 1.576 | 34137.1 |
473 | 2023-08-05 22:26:32 | motel | 1 | 28756 | 11 | 0.516 | 55728.7 |
472 | 2023-07-05 07:34:30 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
471 | 2023-06-01 13:55:07 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
470 | 2023-05-29 06:12:50 | motel | 2 | 53800 | 154 | 1.610 | 33416.1 |
469 | 2023-03-26 01:59:39 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
468 | 2023-03-18 12:53:20 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
467 | 2023-03-07 02:59:40 | motel | 2 | 53800 | 154 | 1.406 | 38264.6 |
466 | 2023-01-09 18:41:47 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
465 | 2022-12-13 12:48:27 | motel | 2 | 53800 | 154 | 1.513 | 35558.5 |
464 | 2022-11-23 20:35:51 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
463 | 2022-10-13 11:57:24 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
462 | 2022-09-20 03:39:13 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
461 | 2022-09-01 12:28:05 | motel | 2 | 53800 | 154 | 3.063 | 17564.5 |
460 | 2022-08-16 00:47:05 | motel | 1 | 28756 | 11 | 0.466 | 61708.2 |
459 | 2022-08-14 22:19:25 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
458 | 2022-08-06 08:23:24 | motel | 1 | 28756 | 11 | 0.440 | 65354.5 |
457 | 2022-07-31 07:18:54 | motel | 2 | 53800 | 154 | 1.440 | 37361.1 |
456 | 2022-07-29 06:30:38 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
455 | 2022-07-27 15:24:47 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
454 | 2022-07-18 14:40:52 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
453 | 2022-07-17 20:00:34 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
452 | 2022-07-10 04:53:38 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
451 | 2022-06-04 21:41:50 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
450 | 2022-05-31 10:38:02 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
449 | 2022-04-05 12:00:09 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
448 | 2022-03-04 04:24:46 | motel | 2 | 53800 | 154 | 1.486 | 36204.6 |
447 | 2022-02-10 11:34:44 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
446 | 2022-02-08 07:03:55 | motel | 1 | 28756 | 11 | 0.486 | 59168.7 |
445 | 2021-12-21 15:14:01 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
444 | 2021-11-27 22:43:01 | motel | 1 | 28756 | 11 | 0.466 | 61708.2 |
443 | 2021-10-09 10:56:20 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
442 | 2021-09-17 15:35:05 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
441 | 2021-09-05 06:39:01 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
440 | 2021-08-18 16:34:43 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
439 | 2021-08-16 12:12:07 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
438 | 2021-07-13 03:35:55 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
437 | 2021-06-14 06:21:56 | motel | 1 | 28756 | 11 | 0.450 | 63902.2 |
436 | 2021-05-01 21:36:56 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
435 | 2021-03-31 04:53:40 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
434 | 2021-03-11 10:42:33 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
433 | 2021-02-08 22:22:37 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
432 | 2020-12-08 06:08:18 | motel | 1 | 28756 | 11 | 0.483 | 59536.2 |
431 | 2020-10-30 22:50:44 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
430 | 2020-10-25 22:10:52 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
429 | 2020-10-20 13:09:41 | motel | 1 | 28756 | 11 | 0.890 | 32310.1 |
428 | 2020-10-10 03:33:06 | motel | 2 | 53800 | 154 | 1.406 | 38264.6 |
427 | 2020-10-01 19:02:55 | motel | 1 | 28756 | 11 | 0.546 | 52666.7 |
426 | 2020-09-05 08:20:37 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
425 | 2020-09-05 05:25:56 | motel | 1 | 28756 | 11 | 0.516 | 55728.7 |
424 | 2020-08-20 16:25:52 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
423 | 2020-07-18 09:46:10 | motel | 1 | 28756 | 11 | 0.513 | 56054.6 |
422 | 2020-07-17 09:53:22 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
421 | 2020-07-16 09:17:23 | motel | 1 | 28756 | 11 | 0.470 | 61183.0 |
420 | 2020-06-12 07:42:07 | motel | 1 | 28756 | 11 | 0.500 | 57512.0 |
419 | 2020-06-03 03:13:12 | motel | 1 | 28756 | 11 | 0.453 | 63479.0 |
418 | 2020-05-31 00:29:39 | motel | 1 | 28756 | 11 | 0.513 | 56054.6 |
417 | 2020-03-28 23:15:29 | motel | 1 | 28756 | 11 | 0.436 | 65954.1 |
416 | 2020-03-27 04:23:52 | motel | 1 | 28756 | 11 | 0.530 | 54256.6 |