History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"squab"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
503 | 2024-04-17 17:42:43 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
502 | 2024-04-09 06:27:27 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
501 | 2024-04-06 06:21:03 | squab | 1 | 28756 | 6 | 0.563 | 51076.4 |
500 | 2024-03-31 16:03:40 | squab | 1 | 28756 | 6 | 0.513 | 56054.6 |
499 | 2024-03-30 09:41:08 | squab | 3 | 83667 | 531 | 6.936 | 12062.7 |
498 | 2024-03-30 09:40:47 | squab | 2 | 53800 | 44 | 6.780 | 7935.1 |
497 | 2024-03-29 09:12:57 | squab | 2 | 53800 | 44 | 4.703 | 11439.5 |
496 | 2024-03-29 09:10:11 | squab | 1 | 28756 | 6 | 0.546 | 52666.7 |
495 | 2024-03-07 02:24:20 | squab | 1 | 28756 | 6 | 0.530 | 54256.6 |
494 | 2024-03-01 13:00:09 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
493 | 2024-02-28 03:04:08 | squab | 1 | 28756 | 6 | 0.560 | 51350.0 |
492 | 2024-02-05 14:40:17 | squab | 3 | 83667 | 531 | 4.360 | 19189.7 |
491 | 2024-02-05 07:45:10 | squab | 3 | 83667 | 531 | 8.063 | 10376.7 |
490 | 2024-02-03 23:10:39 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
489 | 2024-01-29 05:26:55 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
488 | 2024-01-29 01:37:53 | squab | 1 | 28756 | 6 | 0.440 | 65354.5 |
487 | 2024-01-07 11:55:19 | squab | 2 | 53800 | 44 | 1.343 | 40059.6 |
486 | 2023-12-23 06:48:38 | squab | 1 | 28756 | 6 | 0.453 | 63479.0 |
485 | 2023-12-08 21:07:24 | squab | 2 | 53800 | 44 | 1.516 | 35488.1 |
484 | 2023-12-08 10:46:48 | squab | 1 | 28756 | 6 | 0.546 | 52666.7 |
483 | 2023-12-08 10:46:47 | squab | 1 | 28756 | 6 | 0.470 | 61183.0 |
482 | 2023-11-21 08:17:08 | squab | 3 | 83667 | 531 | 3.220 | 25983.5 |
481 | 2023-11-19 21:01:55 | squab | 1 | 28756 | 6 | 0.530 | 54256.6 |
480 | 2023-11-19 09:18:01 | squab | 3 | 83667 | 531 | 4.000 | 20916.8 |
479 | 2023-11-15 20:47:37 | squab | 3 | 83667 | 531 | 4.190 | 19968.3 |
478 | 2023-11-12 08:49:37 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
477 | 2023-11-11 06:19:11 | squab | 3 | 83667 | 531 | 3.736 | 22394.8 |
476 | 2023-11-10 17:33:27 | squab | 1 | 28756 | 6 | 0.516 | 55728.7 |
475 | 2023-11-08 22:14:00 | squab | 1 | 28756 | 6 | 0.483 | 59536.2 |
474 | 2023-11-05 16:32:44 | squab | 3 | 83667 | 531 | 4.156 | 20131.6 |
473 | 2023-11-05 16:32:42 | squab | 2 | 53800 | 44 | 1.686 | 31909.8 |
472 | 2023-11-04 12:54:30 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
471 | 2023-11-03 10:17:31 | squab | 1 | 28756 | 6 | 0.440 | 65354.5 |
470 | 2023-11-03 08:38:07 | squab | 1 | 28756 | 6 | 0.513 | 56054.6 |
469 | 2023-10-21 04:05:41 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
468 | 2023-10-13 17:05:21 | squab | 1 | 28756 | 6 | 0.530 | 54256.6 |
467 | 2023-10-11 23:24:09 | squab | 1 | 28756 | 6 | 0.453 | 63479.0 |
466 | 2023-10-05 22:19:50 | squab | 1 | 28756 | 6 | 0.470 | 61183.0 |
465 | 2023-09-27 08:31:16 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
464 | 2023-09-23 16:18:23 | squab | 1 | 28756 | 6 | 0.483 | 59536.2 |
463 | 2023-08-13 19:17:23 | squab | 3 | 83667 | 531 | 3.236 | 25855.1 |
462 | 2023-08-08 13:54:16 | squab | 1 | 28756 | 6 | 0.453 | 63479.0 |
461 | 2023-06-25 06:40:23 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
460 | 2023-05-10 09:56:47 | squab | 1 | 28756 | 6 | 0.470 | 61183.0 |
459 | 2023-04-25 04:56:17 | squab | 3 | 83667 | 531 | 3.170 | 26393.4 |
458 | 2023-03-05 02:54:28 | squab | 1 | 28756 | 6 | 0.440 | 65354.5 |
457 | 2023-02-13 20:36:08 | squab | 1 | 28756 | 6 | 0.983 | 29253.3 |
456 | 2023-02-02 02:52:18 | squab | 3 | 83667 | 531 | 3.140 | 26645.5 |
455 | 2023-01-27 19:46:58 | squab | 3 | 83667 | 531 | 3.186 | 26260.8 |
454 | 2023-01-19 05:21:12 | squab | 3 | 83667 | 531 | 3.140 | 26645.5 |
453 | 2022-12-27 13:09:05 | squab | 1 | 28756 | 6 | 0.423 | 67981.1 |
452 | 2022-12-13 01:38:15 | squab | 3 | 83667 | 531 | 3.533 | 23681.6 |
451 | 2022-11-09 23:13:05 | squab | 3 | 83667 | 531 | 3.296 | 25384.4 |
450 | 2022-09-28 12:10:12 | squab | 1 | 28756 | 6 | 0.516 | 55728.7 |
449 | 2022-09-15 23:08:08 | squab | 1 | 28756 | 6 | 0.486 | 59168.7 |
448 | 2022-07-01 15:32:37 | squab | 1 | 28756 | 6 | 0.423 | 67981.1 |
447 | 2022-06-13 03:40:21 | squab | 3 | 83667 | 531 | 3.123 | 26790.6 |
446 | 2022-05-04 19:07:42 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
445 | 2022-04-22 18:56:32 | squab | 3 | 83667 | 531 | 4.250 | 19686.4 |
444 | 2022-03-06 12:32:55 | squab | 1 | 28756 | 6 | 0.483 | 59536.2 |
443 | 2022-03-04 08:33:36 | squab | 1 | 28756 | 6 | 0.516 | 55728.7 |
442 | 2022-02-01 07:30:06 | squab | 3 | 83667 | 531 | 3.733 | 22412.8 |
441 | 2021-12-22 15:49:06 | squab | 1 | 28756 | 6 | 0.513 | 56054.6 |
440 | 2021-12-19 02:56:36 | squab | 1 | 28756 | 6 | 0.453 | 63479.0 |
439 | 2021-12-17 00:59:57 | squab | 1 | 28756 | 6 | 0.533 | 53951.2 |
438 | 2021-10-24 03:28:33 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
437 | 2021-10-22 03:02:53 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
436 | 2021-09-27 02:47:59 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
435 | 2021-08-20 02:29:59 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
434 | 2021-06-30 18:11:04 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
433 | 2021-06-10 08:17:46 | squab | 3 | 83667 | 531 | 3.170 | 26393.4 |
432 | 2021-05-14 22:10:09 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
431 | 2021-05-09 04:42:47 | squab | 1 | 28756 | 6 | 0.530 | 54256.6 |
430 | 2021-04-28 05:09:35 | squab | 2 | 53800 | 44 | 1.343 | 40059.6 |
429 | 2021-04-10 04:30:36 | squab | 3 | 83667 | 531 | 3.750 | 22311.2 |
428 | 2021-03-16 05:02:32 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
427 | 2021-02-25 07:55:09 | squab | 3 | 83667 | 531 | 3.780 | 22134.1 |
426 | 2021-02-19 05:32:46 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
425 | 2021-01-24 15:54:57 | squab | 3 | 83667 | 531 | 3.300 | 25353.6 |
424 | 2021-01-16 19:25:24 | squab | 1 | 28756 | 6 | 0.533 | 53951.2 |
423 | 2020-12-13 02:21:25 | squab | 2 | 53800 | 44 | 1.423 | 37807.4 |
422 | 2020-12-01 01:40:15 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
421 | 2020-11-10 16:18:15 | squab | 3 | 83667 | 531 | 3.500 | 23904.9 |
420 | 2020-11-07 23:14:20 | squab | 1 | 28756 | 6 | 0.470 | 61183.0 |
419 | 2020-11-03 18:35:38 | squab | 1 | 28756 | 6 | 0.486 | 59168.7 |
418 | 2020-11-02 07:25:03 | squab | 3 | 83667 | 531 | 3.970 | 21074.8 |
417 | 2020-10-29 11:13:25 | squab | 2 | 53800 | 44 | 1.406 | 38264.6 |
416 | 2020-10-24 18:59:59 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
415 | 2020-10-23 12:05:58 | squab | 3 | 83667 | 531 | 3.250 | 25743.7 |
414 | 2020-10-20 03:38:39 | squab | 3 | 83667 | 531 | 3.203 | 26121.4 |
413 | 2020-10-18 12:40:08 | squab | 1 | 28756 | 6 | 0.500 | 57512.0 |
412 | 2020-10-14 12:04:21 | squab | 1 | 28756 | 6 | 0.466 | 61708.2 |
411 | 2020-10-09 12:17:30 | squab | 3 | 83667 | 531 | 3.470 | 24111.5 |
410 | 2020-10-07 03:48:54 | squab | 3 | 83667 | 531 | 3.830 | 21845.2 |
409 | 2020-10-02 14:16:11 | squab | 1 | 28756 | 6 | 0.486 | 59168.7 |
408 | 2020-09-22 07:20:55 | squab | 1 | 28756 | 6 | 0.436 | 65954.1 |
407 | 2020-09-17 13:33:18 | squab | 3 | 83667 | 531 | 3.313 | 25254.2 |
406 | 2020-09-11 16:46:47 | squab | 3 | 83667 | 531 | 3.220 | 25983.5 |
405 | 2020-08-27 15:10:05 | squab | 3 | 83667 | 531 | 3.266 | 25617.6 |
404 | 2020-08-07 20:21:04 | squab | 3 | 83667 | 531 | 3.283 | 25484.9 |