History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"distance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
522 | 2024-05-14 05:04:35 | distance | 3 | 146162 | 112 | 11.576 | 12626.3 |
521 | 2024-05-10 12:39:12 | distance | 2 | 121059 | 10 | 4.016 | 30144.2 |
520 | 2024-05-10 12:38:05 | distance | 3 | 146162 | 112 | 8.766 | 16673.7 |
519 | 2024-05-10 12:29:21 | distance | 3 | 146162 | 112 | 7.190 | 20328.5 |
518 | 2024-04-26 18:39:22 | distance | 1 | 82945 | 3 | 1.410 | 58826.2 |
517 | 2024-04-25 18:13:01 | distance | 2 | 121059 | 10 | 8.220 | 14727.4 |
516 | 2024-04-25 18:12:52 | distance | 1 | 82945 | 3 | 2.486 | 33364.8 |
515 | 2024-04-25 18:12:22 | distance | 2 | 121059 | 10 | 8.656 | 13985.6 |
514 | 2024-04-25 12:42:32 | distance | 2 | 121059 | 10 | 3.296 | 36729.1 |
513 | 2024-04-21 04:45:55 | distance | 3 | 146162 | 112 | 27.000 | 5413.4 |
512 | 2024-04-21 04:45:59 | distance | 3 | 146162 | 112 | 19.923 | 7336.3 |
511 | 2024-04-19 20:07:22 | distance | 3 | 146162 | 112 | 24.286 | 6018.4 |
510 | 2024-04-18 23:47:58 | distance | 3 | 146162 | 112 | 15.250 | 9584.4 |
509 | 2024-04-18 23:48:00 | distance | 2 | 121059 | 10 | 8.596 | 14083.2 |
508 | 2024-04-18 22:07:15 | distance | 1 | 82945 | 3 | 1.296 | 64000.8 |
507 | 2024-04-05 05:25:10 | distance | 3 | 146162 | 112 | 16.576 | 8817.7 |
506 | 2024-04-05 05:25:12 | distance | 2 | 121059 | 10 | 8.423 | 14372.4 |
505 | 2024-04-05 05:25:08 | distance | 1 | 82945 | 3 | 1.500 | 55296.7 |
504 | 2024-03-28 21:56:28 | distance | 1 | 82945 | 3 | 4.080 | 20329.7 |
503 | 2024-03-26 19:29:50 | distance | 1 | 82945 | 3 | 4.936 | 16804.1 |
502 | 2024-03-18 05:55:13 | distance | 2 | 121059 | 10 | 8.983 | 13476.5 |
501 | 2024-03-18 05:13:14 | distance | 3 | 146162 | 112 | 7.703 | 18974.7 |
500 | 2024-03-18 00:46:25 | distance | 2 | 121059 | 10 | 13.906 | 8705.5 |
499 | 2024-03-18 00:45:01 | distance | 3 | 146162 | 112 | 9.030 | 16186.3 |
498 | 2024-03-16 19:14:55 | distance | 3 | 146162 | 112 | 8.516 | 17163.2 |
497 | 2024-03-16 19:14:46 | distance | 2 | 121059 | 10 | 3.906 | 30993.1 |
496 | 2024-03-15 20:12:56 | distance | 2 | 121059 | 10 | 3.580 | 33815.4 |
495 | 2024-03-15 20:12:38 | distance | 1 | 82945 | 3 | 1.233 | 67270.9 |
494 | 2024-03-10 21:07:17 | distance | 1 | 82945 | 3 | 1.406 | 58993.6 |
493 | 2024-02-26 05:16:55 | distance | 1 | 82945 | 3 | 4.826 | 17187.1 |
492 | 2024-02-24 21:20:09 | distance | 1 | 82945 | 3 | 2.936 | 28251.0 |
491 | 2024-02-21 01:51:51 | distance | 1 | 82945 | 3 | 1.563 | 53067.8 |
490 | 2024-02-05 12:44:57 | distance | 2 | 121059 | 10 | 4.266 | 28377.6 |
489 | 2024-02-05 10:35:38 | distance | 3 | 146162 | 112 | 9.470 | 15434.2 |
488 | 2024-02-05 02:31:43 | distance | 3 | 146162 | 112 | 7.420 | 19698.4 |
487 | 2024-02-03 08:20:26 | distance | 1 | 82945 | 3 | 1.376 | 60279.8 |
486 | 2024-02-01 06:09:24 | distance | 2 | 121059 | 10 | 3.640 | 33258.0 |
485 | 2024-02-01 06:08:28 | distance | 3 | 146162 | 112 | 7.626 | 19166.3 |
484 | 2024-02-01 05:56:59 | distance | 3 | 146162 | 112 | 6.626 | 22058.9 |
483 | 2024-02-01 05:56:56 | distance | 2 | 121059 | 10 | 3.233 | 37444.8 |
482 | 2024-02-01 05:56:28 | distance | 2 | 121059 | 10 | 3.593 | 33693.0 |
481 | 2024-02-01 05:56:08 | distance | 3 | 146162 | 112 | 6.750 | 21653.6 |
480 | 2024-01-05 03:25:32 | distance | 3 | 146162 | 112 | 6.266 | 23326.2 |
479 | 2023-12-15 06:12:33 | distance | 2 | 121059 | 10 | 3.250 | 37248.9 |
478 | 2023-12-07 15:38:19 | distance | 1 | 82945 | 3 | 1.376 | 60279.8 |
477 | 2023-12-05 17:25:36 | distance | 1 | 82945 | 3 | 1.250 | 66356.0 |
476 | 2023-11-26 16:35:25 | distance | 1 | 82945 | 3 | 1.313 | 63172.1 |
475 | 2023-11-21 16:41:15 | distance | 3 | 146162 | 112 | 9.390 | 15565.7 |
474 | 2023-11-03 06:55:01 | distance | 1 | 82945 | 3 | 1.233 | 67270.9 |
473 | 2023-10-12 21:26:54 | distance | 3 | 146162 | 112 | 7.123 | 20519.7 |
472 | 2023-10-12 07:04:48 | distance | 1 | 82945 | 3 | 1.546 | 53651.4 |
471 | 2023-09-19 07:53:18 | distance | 1 | 82945 | 3 | 1.280 | 64800.8 |
470 | 2023-09-15 12:30:52 | distance | 1 | 82945 | 3 | 1.466 | 56579.1 |
469 | 2023-09-15 12:03:13 | distance | 2 | 121059 | 10 | 3.580 | 33815.4 |
468 | 2023-08-15 04:15:24 | distance | 1 | 82945 | 3 | 2.656 | 31229.3 |
467 | 2023-07-24 09:54:35 | distance | 3 | 146162 | 112 | 6.220 | 23498.7 |
466 | 2023-07-10 14:01:30 | distance | 1 | 82945 | 3 | 1.233 | 67270.9 |
465 | 2023-06-19 17:24:51 | distance | 2 | 121059 | 10 | 3.406 | 35542.9 |
464 | 2023-05-04 07:59:34 | distance | 1 | 82945 | 3 | 1.250 | 66356.0 |
463 | 2023-04-16 08:02:28 | distance | 1 | 82945 | 3 | 1.280 | 64800.8 |
462 | 2023-04-05 19:45:39 | distance | 3 | 146162 | 112 | 6.110 | 23921.8 |
461 | 2023-03-15 15:11:11 | distance | 2 | 121059 | 10 | 4.003 | 30242.1 |
460 | 2023-03-04 18:16:30 | distance | 1 | 82945 | 3 | 1.313 | 63172.1 |
459 | 2023-01-22 02:21:00 | distance | 1 | 82945 | 3 | 1.250 | 66356.0 |
458 | 2023-01-04 01:23:33 | distance | 3 | 146162 | 112 | 6.390 | 22873.6 |
457 | 2022-12-19 10:03:43 | distance | 2 | 121059 | 10 | 3.640 | 33258.0 |
456 | 2022-10-07 17:44:16 | distance | 1 | 82945 | 3 | 1.360 | 60989.0 |
455 | 2022-10-04 05:10:50 | distance | 1 | 82945 | 3 | 1.250 | 66356.0 |
454 | 2022-09-10 03:23:02 | distance | 3 | 146162 | 112 | 6.173 | 23677.6 |
453 | 2022-08-23 06:55:30 | distance | 2 | 121059 | 10 | 3.110 | 38925.7 |
452 | 2022-08-17 05:17:55 | distance | 2 | 121059 | 10 | 3.093 | 39139.7 |
451 | 2022-08-15 09:13:06 | distance | 1 | 82945 | 3 | 1.283 | 64649.3 |
450 | 2022-08-14 01:58:16 | distance | 1 | 82945 | 3 | 1.450 | 57203.4 |
449 | 2022-06-17 07:47:43 | distance | 1 | 82945 | 3 | 1.296 | 64000.8 |
448 | 2022-05-31 05:31:38 | distance | 1 | 82945 | 3 | 1.280 | 64800.8 |
447 | 2022-05-29 00:54:38 | distance | 1 | 82945 | 3 | 1.250 | 66356.0 |
446 | 2022-03-31 10:55:16 | distance | 3 | 146162 | 112 | 6.703 | 21805.5 |
445 | 2022-03-15 11:33:07 | distance | 1 | 82945 | 3 | 2.000 | 41472.5 |
444 | 2022-02-12 09:07:16 | distance | 1 | 82945 | 3 | 1.283 | 64649.3 |
443 | 2021-12-14 18:30:43 | distance | 3 | 146162 | 112 | 6.296 | 23215.1 |
442 | 2021-12-08 15:20:26 | distance | 3 | 146162 | 112 | 6.876 | 21256.8 |
441 | 2021-12-08 01:57:53 | distance | 1 | 82945 | 3 | 1.420 | 58412.0 |
440 | 2021-12-01 19:14:38 | distance | 1 | 82945 | 3 | 2.983 | 27805.9 |
439 | 2021-11-24 21:45:58 | distance | 3 | 146162 | 112 | 7.703 | 18974.7 |
438 | 2021-11-24 10:50:16 | distance | 3 | 146162 | 112 | 8.423 | 17352.7 |
437 | 2021-11-23 14:41:08 | distance | 3 | 146162 | 112 | 7.156 | 20425.1 |
436 | 2021-11-23 02:43:39 | distance | 3 | 146162 | 112 | 6.483 | 22545.4 |
435 | 2021-11-22 15:26:46 | distance | 3 | 146162 | 112 | 7.313 | 19986.6 |
434 | 2021-11-18 14:31:30 | distance | 3 | 146162 | 112 | 10.406 | 14045.9 |
433 | 2021-11-18 02:35:45 | distance | 3 | 146162 | 112 | 6.360 | 22981.4 |
432 | 2021-11-17 17:03:36 | distance | 3 | 146162 | 112 | 6.560 | 22280.8 |
431 | 2021-11-10 17:26:54 | distance | 3 | 146162 | 112 | 9.330 | 15665.8 |
430 | 2021-11-10 07:58:47 | distance | 3 | 146162 | 112 | 10.313 | 14172.6 |
429 | 2021-11-09 19:56:27 | distance | 3 | 146162 | 112 | 6.403 | 22827.1 |
428 | 2021-11-09 08:07:53 | distance | 3 | 146162 | 112 | 6.830 | 21400.0 |
427 | 2021-11-08 08:24:39 | distance | 3 | 146162 | 112 | 7.140 | 20470.9 |
426 | 2021-11-08 00:14:09 | distance | 3 | 146162 | 112 | 6.233 | 23449.7 |
425 | 2021-10-31 19:04:18 | distance | 1 | 82945 | 3 | 1.236 | 67107.6 |
424 | 2021-10-25 21:56:42 | distance | 3 | 146162 | 112 | 6.530 | 22383.2 |
423 | 2021-10-24 22:03:37 | distance | 3 | 146162 | 112 | 7.593 | 19249.6 |