History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clown"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1200 | 2024-04-30 09:36:51 | clown | 1 | 28756 | 7 | 0.516 | 55728.7 |
1199 | 2024-04-26 15:50:12 | clown | 3 | 83667 | 883 | 4.500 | 18592.7 |
1198 | 2024-04-11 12:04:29 | clown | 1 | 28756 | 7 | 0.533 | 53951.2 |
1197 | 2024-04-04 19:45:15 | clown | 3 | 83667 | 883 | 7.593 | 11019.0 |
1196 | 2024-04-03 08:31:30 | clown | 2 | 53800 | 97 | 3.266 | 16472.7 |
1195 | 2024-04-03 08:31:28 | clown | 1 | 28756 | 7 | 1.126 | 25538.2 |
1194 | 2024-04-03 08:30:58 | clown | 3 | 83667 | 883 | 4.173 | 20049.6 |
1193 | 2024-04-02 22:15:40 | clown | 3 | 83667 | 883 | 12.970 | 6450.8 |
1192 | 2024-04-02 22:15:38 | clown | 2 | 53800 | 97 | 1.923 | 27977.1 |
1191 | 2024-04-02 21:47:12 | clown | 1 | 28756 | 7 | 0.436 | 65954.1 |
1190 | 2024-03-31 03:42:44 | clown | 1 | 28756 | 7 | 1.096 | 26237.2 |
1189 | 2024-03-29 03:20:01 | clown | 1 | 28756 | 7 | 0.576 | 49923.6 |
1188 | 2024-03-27 04:20:23 | clown | 1 | 28756 | 7 | 0.486 | 59168.7 |
1187 | 2024-03-04 06:03:21 | clown | 1 | 28756 | 7 | 0.436 | 65954.1 |
1186 | 2024-03-01 00:37:41 | clown | 1 | 28756 | 7 | 0.983 | 29253.3 |
1185 | 2024-02-29 20:05:31 | clown | 3 | 83667 | 883 | 3.936 | 21256.9 |
1184 | 2024-02-27 20:39:59 | clown | 3 | 83667 | 883 | 5.736 | 14586.3 |
1183 | 2024-02-27 20:39:51 | clown | 2 | 53800 | 97 | 1.656 | 32487.9 |
1182 | 2024-02-26 01:55:26 | clown | 2 | 53800 | 97 | 2.703 | 19903.8 |
1181 | 2024-02-26 01:34:10 | clown | 1 | 28756 | 7 | 0.466 | 61708.2 |
1180 | 2024-01-30 21:25:56 | clown | 2 | 53800 | 97 | 3.250 | 16553.8 |
1179 | 2024-01-30 21:25:20 | clown | 3 | 83667 | 883 | 3.750 | 22311.2 |
1178 | 2024-01-29 12:31:00 | clown | 3 | 83667 | 883 | 3.423 | 24442.6 |
1177 | 2024-01-29 12:30:56 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1176 | 2024-01-26 23:30:09 | clown | 1 | 28756 | 7 | 0.533 | 53951.2 |
1175 | 2024-01-09 10:07:19 | clown | 2 | 53800 | 97 | 1.406 | 38264.6 |
1174 | 2023-12-27 23:52:07 | clown | 1 | 28756 | 7 | 0.530 | 54256.6 |
1173 | 2023-12-15 02:30:27 | clown | 3 | 83667 | 883 | 6.000 | 13944.5 |
1172 | 2023-12-15 02:30:29 | clown | 2 | 53800 | 97 | 3.393 | 15856.2 |
1171 | 2023-12-01 01:18:54 | clown | 3 | 83667 | 883 | 3.313 | 25254.2 |
1170 | 2023-12-01 01:18:51 | clown | 2 | 53800 | 97 | 1.686 | 31909.8 |
1169 | 2023-11-19 04:38:45 | clown | 3 | 83667 | 883 | 4.000 | 20916.8 |
1168 | 2023-11-15 17:41:51 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1167 | 2023-11-11 21:32:21 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1166 | 2023-11-04 13:42:20 | clown | 3 | 83667 | 883 | 3.906 | 21420.1 |
1165 | 2023-11-02 03:27:22 | clown | 3 | 83667 | 883 | 4.190 | 19968.3 |
1164 | 2023-11-02 03:27:20 | clown | 2 | 53800 | 97 | 1.690 | 31834.3 |
1163 | 2023-10-31 23:33:28 | clown | 1 | 28756 | 7 | 0.470 | 61183.0 |
1162 | 2023-10-29 06:41:02 | clown | 1 | 28756 | 7 | 0.436 | 65954.1 |
1161 | 2023-10-27 17:47:46 | clown | 1 | 28756 | 7 | 0.453 | 63479.0 |
1160 | 2023-10-20 22:05:54 | clown | 1 | 28756 | 7 | 1.110 | 25906.3 |
1159 | 2023-10-18 02:21:52 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1158 | 2023-10-16 08:25:30 | clown | 1 | 28756 | 7 | 0.533 | 53951.2 |
1157 | 2023-10-11 20:23:20 | clown | 1 | 28756 | 7 | 0.483 | 59536.2 |
1156 | 2023-10-04 14:06:59 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1155 | 2023-09-24 20:52:33 | clown | 1 | 28756 | 7 | 0.440 | 65354.5 |
1154 | 2023-09-24 07:52:15 | clown | 1 | 28756 | 7 | 0.623 | 46157.3 |
1153 | 2023-08-12 15:13:05 | clown | 1 | 28756 | 7 | 0.483 | 59536.2 |
1152 | 2023-07-13 01:45:52 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1151 | 2023-05-14 09:00:41 | clown | 1 | 28756 | 7 | 0.420 | 68466.7 |
1150 | 2023-04-01 18:17:27 | clown | 1 | 28756 | 7 | 0.440 | 65354.5 |
1149 | 2023-03-08 06:53:19 | clown | 1 | 28756 | 7 | 0.483 | 59536.2 |
1148 | 2022-12-31 18:05:22 | clown | 1 | 28756 | 7 | 0.436 | 65954.1 |
1147 | 2022-12-23 21:16:16 | clown | 1 | 28756 | 7 | 0.436 | 65954.1 |
1146 | 2022-09-22 06:01:46 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1145 | 2022-09-10 18:52:26 | clown | 1 | 28756 | 7 | 0.486 | 59168.7 |
1144 | 2022-09-06 02:02:39 | clown | 1 | 28756 | 7 | 0.453 | 63479.0 |
1143 | 2022-09-02 18:29:45 | clown | 1 | 28756 | 7 | 0.466 | 61708.2 |
1142 | 2022-08-15 05:18:15 | clown | 1 | 28756 | 7 | 0.610 | 47141.0 |
1141 | 2022-07-29 12:37:37 | clown | 1 | 28756 | 7 | 0.486 | 59168.7 |
1140 | 2022-07-29 01:39:08 | clown | 1 | 28756 | 7 | 0.423 | 67981.1 |
1139 | 2022-06-15 12:18:08 | clown | 3 | 83667 | 883 | 3.326 | 25155.4 |
1138 | 2022-06-03 05:39:14 | clown | 3 | 83667 | 883 | 3.313 | 25254.2 |
1137 | 2022-05-16 09:54:02 | clown | 3 | 83667 | 883 | 3.436 | 24350.1 |
1136 | 2022-05-14 13:32:16 | clown | 1 | 28756 | 7 | 0.440 | 65354.5 |
1135 | 2022-05-11 02:41:02 | clown | 1 | 28756 | 7 | 0.450 | 63902.2 |
1134 | 2022-05-10 02:01:18 | clown | 3 | 83667 | 883 | 4.593 | 18216.2 |
1133 | 2022-05-04 00:59:13 | clown | 1 | 28756 | 7 | 0.750 | 38341.3 |
1132 | 2022-02-06 08:23:29 | clown | 1 | 28756 | 7 | 0.623 | 46157.3 |
1131 | 2022-01-20 20:01:44 | clown | 1 | 28756 | 7 | 0.440 | 65354.5 |
1130 | 2022-01-20 02:16:44 | clown | 3 | 83667 | 883 | 3.263 | 25641.1 |
1129 | 2022-01-04 09:46:46 | clown | 3 | 83667 | 883 | 3.296 | 25384.4 |
1128 | 2022-01-03 18:23:18 | clown | 3 | 83667 | 883 | 3.860 | 21675.4 |
1127 | 2022-01-02 23:38:57 | clown | 3 | 83667 | 883 | 5.143 | 16268.1 |
1126 | 2022-01-02 08:35:29 | clown | 3 | 83667 | 883 | 3.860 | 21675.4 |
1125 | 2022-01-01 14:27:31 | clown | 3 | 83667 | 883 | 5.453 | 15343.3 |
1124 | 2021-12-29 12:19:10 | clown | 3 | 83667 | 883 | 3.686 | 22698.6 |
1123 | 2021-12-28 12:17:43 | clown | 3 | 83667 | 883 | 4.046 | 20678.9 |
1122 | 2021-12-27 12:15:54 | clown | 3 | 83667 | 883 | 4.126 | 20278.0 |
1121 | 2021-12-26 12:13:06 | clown | 3 | 83667 | 883 | 6.013 | 13914.4 |
1120 | 2021-12-25 12:30:40 | clown | 3 | 83667 | 883 | 3.610 | 23176.5 |
1119 | 2021-12-24 15:20:09 | clown | 3 | 83667 | 883 | 3.470 | 24111.5 |
1118 | 2021-12-23 14:00:33 | clown | 3 | 83667 | 883 | 3.313 | 25254.2 |
1117 | 2021-12-22 13:56:50 | clown | 3 | 83667 | 883 | 4.046 | 20678.9 |
1116 | 2021-12-21 13:54:41 | clown | 3 | 83667 | 883 | 3.826 | 21868.0 |
1115 | 2021-12-12 15:41:35 | clown | 3 | 83667 | 883 | 3.330 | 25125.2 |
1114 | 2021-12-09 12:23:23 | clown | 3 | 83667 | 883 | 3.403 | 24586.2 |
1113 | 2021-12-08 12:18:59 | clown | 3 | 83667 | 883 | 3.563 | 23482.2 |
1112 | 2021-12-08 04:31:07 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1111 | 2021-12-07 18:14:16 | clown | 1 | 28756 | 7 | 0.516 | 55728.7 |
1110 | 2021-12-07 12:17:57 | clown | 3 | 83667 | 883 | 4.093 | 20441.5 |
1109 | 2021-12-07 09:22:29 | clown | 1 | 28756 | 7 | 0.453 | 63479.0 |
1108 | 2021-12-06 21:02:35 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1107 | 2021-12-06 12:21:44 | clown | 3 | 83667 | 883 | 3.296 | 25384.4 |
1106 | 2021-12-06 01:59:48 | clown | 1 | 28756 | 7 | 0.486 | 59168.7 |
1105 | 2021-12-05 14:14:52 | clown | 1 | 28756 | 7 | 0.453 | 63479.0 |
1104 | 2021-12-02 07:42:51 | clown | 1 | 28756 | 7 | 0.466 | 61708.2 |
1103 | 2021-12-01 20:15:56 | clown | 1 | 28756 | 7 | 0.516 | 55728.7 |
1102 | 2021-12-01 08:52:09 | clown | 1 | 28756 | 7 | 0.500 | 57512.0 |
1101 | 2021-12-01 02:05:31 | clown | 1 | 28756 | 7 | 0.546 | 52666.7 |