History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cedar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1096 | 2024-04-26 20:10:52 | cedar | 3 | 83667 | 1017 | 13.576 | 6162.9 |
1095 | 2024-04-25 09:18:15 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1094 | 2024-04-20 11:55:37 | cedar | 3 | 83667 | 1017 | 14.296 | 5852.5 |
1093 | 2024-04-15 02:41:40 | cedar | 1 | 28756 | 5 | 1.910 | 15055.5 |
1092 | 2024-04-06 07:45:52 | cedar | 2 | 53800 | 65 | 1.843 | 29191.5 |
1091 | 2024-04-06 07:45:50 | cedar | 1 | 28756 | 5 | 0.690 | 41675.4 |
1090 | 2024-04-05 04:41:21 | cedar | 3 | 83667 | 1017 | 14.780 | 5660.8 |
1089 | 2024-03-31 16:15:05 | cedar | 1 | 28756 | 5 | 0.563 | 51076.4 |
1088 | 2024-03-29 02:25:03 | cedar | 2 | 53800 | 65 | 1.983 | 27130.6 |
1087 | 2024-03-29 02:25:01 | cedar | 1 | 28756 | 5 | 0.546 | 52666.7 |
1086 | 2024-03-29 02:24:38 | cedar | 3 | 83667 | 1017 | 3.936 | 21256.9 |
1085 | 2024-03-29 01:22:57 | cedar | 3 | 83667 | 1017 | 11.423 | 7324.4 |
1084 | 2024-03-29 01:22:58 | cedar | 2 | 53800 | 65 | 3.953 | 13609.9 |
1083 | 2024-03-29 01:12:58 | cedar | 1 | 28756 | 5 | 1.093 | 26309.2 |
1082 | 2024-03-07 05:26:57 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1081 | 2024-03-01 12:42:50 | cedar | 1 | 28756 | 5 | 1.140 | 25224.6 |
1080 | 2024-02-27 19:40:39 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1079 | 2024-02-03 21:24:03 | cedar | 1 | 28756 | 5 | 0.440 | 65354.5 |
1078 | 2024-01-29 07:38:43 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1077 | 2024-01-28 19:01:45 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
1076 | 2024-01-28 01:54:39 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1075 | 2024-01-25 16:21:21 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1074 | 2024-01-13 01:25:11 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1073 | 2023-12-27 06:20:57 | cedar | 3 | 83667 | 1017 | 3.610 | 23176.5 |
1072 | 2023-12-18 08:48:17 | cedar | 3 | 83667 | 1017 | 3.486 | 24000.9 |
1071 | 2023-12-18 08:48:13 | cedar | 2 | 53800 | 65 | 1.390 | 38705.0 |
1070 | 2023-12-07 23:09:41 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1069 | 2023-12-07 23:09:40 | cedar | 1 | 28756 | 5 | 0.533 | 53951.2 |
1068 | 2023-11-27 19:06:53 | cedar | 3 | 83667 | 1017 | 3.486 | 24000.9 |
1067 | 2023-11-27 19:06:47 | cedar | 2 | 53800 | 65 | 1.390 | 38705.0 |
1066 | 2023-11-22 08:15:15 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
1065 | 2023-11-11 22:07:34 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1064 | 2023-11-10 05:54:37 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1063 | 2023-11-05 03:37:14 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1062 | 2023-10-27 13:42:29 | cedar | 3 | 83667 | 1017 | 3.576 | 23396.8 |
1061 | 2023-10-24 21:19:18 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
1060 | 2023-10-24 08:48:43 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1059 | 2023-10-18 11:37:46 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
1058 | 2023-10-17 16:25:39 | cedar | 3 | 83667 | 1017 | 3.356 | 24930.6 |
1057 | 2023-10-17 16:25:37 | cedar | 2 | 53800 | 65 | 1.360 | 39558.8 |
1056 | 2023-10-11 00:30:48 | cedar | 1 | 28756 | 5 | 0.440 | 65354.5 |
1055 | 2023-10-06 04:14:34 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1054 | 2023-10-05 03:27:46 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1053 | 2023-09-19 20:40:17 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1052 | 2023-09-19 19:33:53 | cedar | 2 | 53800 | 65 | 1.406 | 38264.6 |
1051 | 2023-09-19 13:32:48 | cedar | 3 | 83667 | 1017 | 3.640 | 22985.4 |
1050 | 2023-09-17 07:40:42 | cedar | 2 | 53800 | 65 | 1.700 | 31647.1 |
1049 | 2023-09-17 07:40:39 | cedar | 3 | 83667 | 1017 | 3.923 | 21327.3 |
1048 | 2023-09-10 17:23:02 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1047 | 2023-09-09 08:33:47 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1046 | 2023-08-12 06:19:44 | cedar | 3 | 83667 | 1017 | 3.856 | 21697.9 |
1045 | 2023-07-03 10:23:58 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1044 | 2023-07-03 09:57:26 | cedar | 3 | 83667 | 1017 | 3.310 | 25277.0 |
1043 | 2023-06-29 01:15:37 | cedar | 3 | 83667 | 1017 | 3.796 | 22040.8 |
1042 | 2023-06-17 13:19:21 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
1041 | 2023-05-23 08:47:52 | cedar | 3 | 83667 | 1017 | 3.890 | 21508.2 |
1040 | 2023-05-10 22:04:45 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
1039 | 2023-04-07 23:44:38 | cedar | 3 | 83667 | 1017 | 3.796 | 22040.8 |
1038 | 2023-04-03 02:31:36 | cedar | 3 | 83667 | 1017 | 3.703 | 22594.4 |
1037 | 2023-03-31 19:26:20 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1036 | 2023-03-31 12:34:28 | cedar | 3 | 83667 | 1017 | 3.263 | 25641.1 |
1035 | 2023-03-26 23:17:55 | cedar | 1 | 28756 | 5 | 0.843 | 34111.5 |
1034 | 2023-03-26 21:50:03 | cedar | 1 | 28756 | 5 | 0.470 | 61183.0 |
1033 | 2023-03-21 02:38:08 | cedar | 3 | 83667 | 1017 | 3.953 | 21165.4 |
1032 | 2023-02-09 20:00:54 | cedar | 3 | 83667 | 1017 | 3.250 | 25743.7 |
1031 | 2023-01-25 14:14:49 | cedar | 3 | 83667 | 1017 | 4.076 | 20526.7 |
1030 | 2023-01-15 14:13:22 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
1029 | 2022-12-22 10:00:49 | cedar | 3 | 83667 | 1017 | 3.920 | 21343.6 |
1028 | 2022-12-15 02:07:53 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1027 | 2022-12-11 09:43:20 | cedar | 3 | 83667 | 1017 | 3.610 | 23176.5 |
1026 | 2022-11-07 09:31:18 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
1025 | 2022-11-05 10:24:31 | cedar | 3 | 83667 | 1017 | 3.420 | 24464.0 |
1024 | 2022-10-29 00:04:55 | cedar | 3 | 83667 | 1017 | 3.800 | 22017.6 |
1023 | 2022-10-25 00:56:57 | cedar | 3 | 83667 | 1017 | 3.893 | 21491.7 |
1022 | 2022-09-21 16:43:37 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
1021 | 2022-09-11 09:55:11 | cedar | 3 | 83667 | 1017 | 3.390 | 24680.5 |
1020 | 2022-09-02 01:13:54 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
1019 | 2022-08-31 23:19:24 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1018 | 2022-07-29 01:43:30 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1017 | 2022-07-23 20:29:31 | cedar | 3 | 83667 | 1017 | 3.606 | 23202.2 |
1016 | 2022-07-13 07:23:28 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
1015 | 2022-07-08 13:06:47 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
1014 | 2022-06-29 04:14:48 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
1013 | 2022-06-26 23:12:03 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1012 | 2022-06-04 17:54:18 | cedar | 3 | 83667 | 1017 | 3.356 | 24930.6 |
1011 | 2022-05-30 06:12:22 | cedar | 3 | 83667 | 1017 | 3.296 | 25384.4 |
1010 | 2022-05-27 01:32:40 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
1009 | 2022-05-26 08:50:12 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1008 | 2022-05-20 21:21:26 | cedar | 3 | 83667 | 1017 | 3.390 | 24680.5 |
1007 | 2022-04-17 16:10:51 | cedar | 3 | 83667 | 1017 | 3.343 | 25027.5 |
1006 | 2022-04-02 06:49:02 | cedar | 3 | 83667 | 1017 | 3.970 | 21074.8 |
1005 | 2022-03-06 07:24:53 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
1004 | 2022-02-18 08:37:55 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1003 | 2021-12-18 21:41:00 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
1002 | 2021-12-16 18:53:58 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
1001 | 2021-11-13 16:32:59 | cedar | 1 | 28756 | 5 | 0.470 | 61183.0 |
1000 | 2021-11-08 16:22:52 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
999 | 2021-10-19 20:11:39 | cedar | 1 | 28756 | 5 | 0.450 | 63902.2 |
998 | 2021-10-10 19:52:46 | cedar | 3 | 83667 | 1017 | 3.830 | 21845.2 |
997 | 2021-10-05 22:22:17 | cedar | 3 | 83667 | 1017 | 3.750 | 22311.2 |