History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spean"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
487 | 2024-04-25 20:27:29 | spean | 1 | 28756 | 7 | 0.763 | 37688.1 |
486 | 2024-04-12 21:01:22 | spean | 1 | 28756 | 7 | 0.546 | 52666.7 |
485 | 2024-04-03 07:57:47 | spean | 2 | 53800 | 127 | 3.876 | 13880.3 |
484 | 2024-04-03 07:25:48 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
483 | 2024-03-31 08:11:57 | spean | 2 | 53800 | 127 | 3.736 | 14400.4 |
482 | 2024-03-31 08:11:49 | spean | 1 | 28756 | 7 | 0.546 | 52666.7 |
481 | 2024-03-28 23:27:09 | spean | 2 | 53800 | 127 | 1.826 | 29463.3 |
480 | 2024-03-28 23:27:07 | spean | 1 | 28756 | 7 | 1.123 | 25606.4 |
479 | 2024-03-28 23:26:35 | spean | 2 | 53800 | 127 | 2.140 | 25140.2 |
478 | 2024-03-28 23:26:27 | spean | 1 | 28756 | 7 | 1.033 | 27837.4 |
477 | 2024-03-05 18:07:06 | spean | 1 | 28756 | 7 | 1.220 | 23570.5 |
476 | 2024-03-04 00:29:50 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
475 | 2024-03-01 03:05:48 | spean | 1 | 28756 | 7 | 0.546 | 52666.7 |
474 | 2024-02-28 04:51:23 | spean | 2 | 53800 | 127 | 1.893 | 28420.5 |
473 | 2024-02-27 23:08:00 | spean | 2 | 53800 | 127 | 1.860 | 28924.7 |
472 | 2024-02-27 20:34:13 | spean | 1 | 28756 | 7 | 0.516 | 55728.7 |
471 | 2024-02-03 00:09:20 | spean | 1 | 28756 | 7 | 0.530 | 54256.6 |
470 | 2024-01-28 19:37:41 | spean | 1 | 28756 | 7 | 0.516 | 55728.7 |
469 | 2024-01-28 17:27:07 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
468 | 2024-01-25 21:16:00 | spean | 2 | 53800 | 127 | 1.593 | 33772.8 |
467 | 2024-01-02 08:30:51 | spean | 2 | 53800 | 127 | 1.406 | 38264.6 |
466 | 2023-12-29 09:02:41 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
465 | 2023-12-16 01:10:42 | spean | 2 | 53800 | 127 | 1.546 | 34799.5 |
464 | 2023-11-19 20:01:41 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
463 | 2023-11-19 17:41:05 | spean | 1 | 28756 | 7 | 0.466 | 61708.2 |
462 | 2023-11-14 16:26:40 | spean | 1 | 28756 | 7 | 0.450 | 63902.2 |
461 | 2023-11-11 10:33:51 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
460 | 2023-11-05 05:58:05 | spean | 2 | 53800 | 127 | 1.390 | 38705.0 |
459 | 2023-11-04 20:20:12 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
458 | 2023-11-03 21:08:49 | spean | 1 | 28756 | 7 | 0.530 | 54256.6 |
457 | 2023-11-02 12:16:05 | spean | 2 | 53800 | 127 | 1.516 | 35488.1 |
456 | 2023-10-23 01:53:26 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
455 | 2023-10-20 22:26:08 | spean | 1 | 28756 | 7 | 1.126 | 25538.2 |
454 | 2023-10-20 21:01:10 | spean | 1 | 28756 | 7 | 0.440 | 65354.5 |
453 | 2023-10-18 05:12:00 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
452 | 2023-10-11 07:40:18 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
451 | 2023-10-04 13:19:15 | spean | 1 | 28756 | 7 | 0.530 | 54256.6 |
450 | 2023-09-23 12:26:27 | spean | 1 | 28756 | 7 | 0.470 | 61183.0 |
449 | 2023-09-12 06:47:58 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
448 | 2023-08-15 08:36:25 | spean | 1 | 28756 | 7 | 0.466 | 61708.2 |
447 | 2023-08-10 14:31:32 | spean | 2 | 53800 | 127 | 1.360 | 39558.8 |
446 | 2023-07-13 00:49:49 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
445 | 2023-05-18 21:00:08 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
444 | 2023-05-15 06:46:41 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
443 | 2023-04-24 04:43:25 | spean | 2 | 53800 | 127 | 1.346 | 39970.3 |
442 | 2023-03-25 07:47:32 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
441 | 2023-03-14 14:04:07 | spean | 1 | 28756 | 7 | 0.486 | 59168.7 |
440 | 2023-01-30 16:47:45 | spean | 2 | 53800 | 127 | 1.720 | 31279.1 |
439 | 2023-01-01 23:18:27 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
438 | 2022-11-30 13:57:43 | spean | 1 | 28756 | 7 | 0.440 | 65354.5 |
437 | 2022-11-27 07:09:20 | spean | 1 | 28756 | 7 | 0.483 | 59536.2 |
436 | 2022-11-22 21:42:06 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
435 | 2022-11-20 21:10:35 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
434 | 2022-11-16 16:12:02 | spean | 1 | 28756 | 7 | 0.423 | 67981.1 |
433 | 2022-11-12 06:28:13 | spean | 2 | 53800 | 127 | 1.516 | 35488.1 |
432 | 2022-09-26 06:49:11 | spean | 1 | 28756 | 7 | 0.440 | 65354.5 |
431 | 2022-08-31 14:19:55 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
430 | 2022-08-15 06:05:18 | spean | 1 | 28756 | 7 | 0.486 | 59168.7 |
429 | 2022-07-29 13:20:37 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
428 | 2022-07-29 08:46:51 | spean | 1 | 28756 | 7 | 0.466 | 61708.2 |
427 | 2022-07-24 03:28:00 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
426 | 2022-07-19 07:20:53 | spean | 2 | 53800 | 127 | 1.376 | 39098.8 |
425 | 2022-06-15 20:32:46 | spean | 2 | 53800 | 127 | 1.393 | 38621.7 |
424 | 2022-05-14 17:39:51 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
423 | 2022-05-13 06:17:41 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
422 | 2022-03-19 11:28:56 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
421 | 2022-02-03 09:17:42 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
420 | 2022-02-01 06:02:57 | spean | 1 | 28756 | 7 | 0.533 | 53951.2 |
419 | 2021-11-28 21:46:09 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
418 | 2021-11-25 06:04:06 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
417 | 2021-10-08 22:32:59 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
416 | 2021-09-06 21:16:30 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
415 | 2021-08-20 07:15:17 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
414 | 2021-08-15 22:47:02 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
413 | 2021-07-12 12:26:15 | spean | 1 | 28756 | 7 | 0.500 | 57512.0 |
412 | 2021-05-11 21:44:59 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
411 | 2021-05-01 02:40:19 | spean | 1 | 28756 | 7 | 0.606 | 47452.1 |
410 | 2021-03-30 10:33:53 | spean | 1 | 28756 | 7 | 0.530 | 54256.6 |
409 | 2021-02-08 05:06:52 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
408 | 2021-02-07 11:17:26 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
407 | 2021-01-14 01:11:50 | spean | 1 | 28756 | 7 | 0.986 | 29164.3 |
406 | 2020-11-05 16:00:33 | spean | 1 | 28756 | 7 | 0.483 | 59536.2 |
405 | 2020-10-26 19:58:39 | spean | 1 | 28756 | 7 | 0.470 | 61183.0 |
404 | 2020-10-22 06:55:54 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
403 | 2020-10-01 03:55:50 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
402 | 2020-09-07 00:50:45 | spean | 1 | 28756 | 7 | 0.436 | 65954.1 |
401 | 2020-08-13 21:21:50 | spean | 1 | 28756 | 7 | 0.513 | 56054.6 |
400 | 2020-08-10 22:17:08 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
399 | 2020-08-01 16:07:35 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
398 | 2020-07-18 01:21:23 | spean | 1 | 28756 | 7 | 0.483 | 59536.2 |
397 | 2020-07-16 00:28:21 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |
396 | 2020-07-15 16:10:38 | spean | 1 | 28756 | 7 | 0.486 | 59168.7 |
395 | 2020-05-06 15:05:39 | spean | 1 | 28756 | 7 | 0.456 | 63061.4 |
394 | 2020-04-30 04:44:19 | spean | 1 | 28756 | 7 | 0.466 | 61708.2 |
393 | 2020-03-26 00:58:24 | spean | 1 | 28756 | 7 | 0.516 | 55728.7 |
392 | 2020-03-25 15:06:59 | spean | 1 | 28756 | 7 | 0.546 | 52666.7 |
391 | 2020-03-25 13:00:40 | spean | 1 | 28756 | 7 | 0.516 | 55728.7 |
390 | 2020-03-22 21:36:50 | spean | 1 | 28756 | 7 | 0.640 | 44931.3 |
389 | 2020-03-21 23:14:01 | spean | 1 | 28756 | 7 | 0.610 | 47141.0 |
388 | 2020-03-21 05:22:21 | spean | 1 | 28756 | 7 | 0.453 | 63479.0 |