History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cola"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1226 | 2025-02-05 23:40:26 | cola | 1 | 13983 | 21 | 1.313 | 10649.7 |
1225 | 2025-02-04 15:14:29 | cola | 1 | 13983 | 21 | 0.860 | 16259.3 |
1224 | 2025-01-26 17:13:28 | cola | 1 | 13983 | 21 | 0.250 | 55932.0 |
1223 | 2025-01-25 17:07:41 | cola | 2 | 29872 | 329 | 5.953 | 5018.0 |
1222 | 2025-01-25 17:01:13 | cola | 1 | 13983 | 21 | 0.220 | 63559.1 |
1221 | 2025-01-24 12:11:08 | cola | 1 | 13983 | 21 | 0.686 | 20383.4 |
1220 | 2025-01-05 20:25:59 | cola | 2 | 29872 | 329 | 5.986 | 4990.3 |
1219 | 2025-01-05 15:06:15 | cola | 2 | 29872 | 329 | 3.563 | 8383.9 |
1218 | 2025-01-05 14:58:22 | cola | 1 | 13983 | 21 | 0.250 | 55932.0 |
1217 | 2024-12-27 12:05:16 | cola | 1 | 13983 | 21 | 2.076 | 6735.5 |
1216 | 2024-12-26 19:09:47 | cola | 2 | 29872 | 329 | 4.703 | 6351.7 |
1215 | 2024-12-26 12:02:12 | cola | 2 | 29872 | 329 | 4.236 | 7051.9 |
1214 | 2024-12-26 12:01:15 | cola | 1 | 13983 | 21 | 1.186 | 11790.1 |
1213 | 2024-12-25 09:37:34 | cola | 1 | 13983 | 21 | 1.143 | 12233.6 |
1212 | 2024-12-06 16:44:35 | cola | 2 | 29872 | 329 | 4.483 | 6663.4 |
1211 | 2024-12-06 11:31:36 | cola | 2 | 29872 | 329 | 4.420 | 6758.4 |
1210 | 2024-12-06 11:28:56 | cola | 1 | 13983 | 21 | 0.343 | 40766.8 |
1209 | 2024-11-28 21:41:20 | cola | 2 | 29872 | 329 | 2.673 | 11175.5 |
1208 | 2024-11-27 11:36:20 | cola | 1 | 13983 | 21 | 0.250 | 55932.0 |
1207 | 2024-11-26 15:27:46 | cola | 2 | 29872 | 329 | 4.216 | 7085.4 |
1206 | 2024-11-26 11:18:40 | cola | 2 | 29872 | 329 | 4.546 | 6571.1 |
1205 | 2024-11-26 11:11:21 | cola | 1 | 13983 | 21 | 0.296 | 47239.9 |
1204 | 2024-11-25 17:38:36 | cola | 1 | 13983 | 21 | 0.873 | 16017.2 |
1203 | 2024-11-25 08:09:27 | cola | 1 | 13983 | 21 | 0.313 | 44674.1 |
1202 | 2024-11-09 22:17:01 | cola | 1 | 13983 | 21 | 0.220 | 63559.1 |
1201 | 2024-11-06 11:32:39 | cola | 2 | 29872 | 329 | 4.296 | 6953.4 |
1200 | 2024-11-06 09:27:34 | cola | 2 | 29872 | 329 | 6.126 | 4876.3 |
1199 | 2024-11-06 07:40:15 | cola | 1 | 13983 | 21 | 0.250 | 55932.0 |
1198 | 2024-10-28 06:55:19 | cola | 1 | 13983 | 21 | 1.250 | 11186.4 |
1197 | 2024-10-27 09:27:23 | cola | 2 | 29872 | 329 | 4.063 | 7352.2 |
1196 | 2024-10-27 09:23:56 | cola | 1 | 13983 | 21 | 0.653 | 21413.5 |
1195 | 2024-10-26 04:24:58 | cola | 1 | 13983 | 21 | 0.800 | 17478.8 |
1194 | 2024-10-24 13:29:42 | cola | 1 | 13983 | 21 | 0.890 | 15711.2 |
1193 | 2024-10-07 09:08:04 | cola | 1 | 13983 | 21 | 1.326 | 10545.2 |
1192 | 2024-10-02 07:46:41 | cola | 1 | 13983 | 21 | 0.983 | 14224.8 |
1191 | 2024-09-30 19:02:21 | cola | 1 | 13983 | 21 | 1.733 | 8068.7 |
1190 | 2024-09-28 04:40:00 | cola | 1 | 13983 | 21 | 0.216 | 64736.1 |
1189 | 2024-09-27 07:48:13 | cola | 1 | 13983 | 21 | 1.313 | 10649.7 |
1188 | 2024-09-26 01:26:29 | cola | 1 | 13983 | 21 | 2.936 | 4762.6 |
1187 | 2024-09-07 03:58:11 | cola | 1 | 13983 | 21 | 1.766 | 7917.9 |
1186 | 2024-08-31 17:31:32 | cola | 1 | 13983 | 21 | 2.656 | 5264.7 |
1185 | 2024-08-30 16:30:20 | cola | 1 | 13983 | 21 | 2.313 | 6045.4 |
1184 | 2024-08-30 04:36:18 | cola | 2 | 29872 | 329 | 7.026 | 4251.6 |
1183 | 2024-08-29 22:32:46 | cola | 2 | 29872 | 329 | 10.106 | 2955.9 |
1182 | 2024-08-29 08:37:08 | cola | 2 | 29872 | 329 | 5.736 | 5207.8 |
1181 | 2024-08-29 05:51:16 | cola | 2 | 29872 | 329 | 13.296 | 2246.7 |
1180 | 2024-08-29 03:49:42 | cola | 1 | 13983 | 21 | 0.216 | 64736.1 |
1179 | 2024-08-27 18:35:39 | cola | 1 | 13983 | 21 | 0.686 | 20383.4 |
1178 | 2024-08-26 16:13:38 | cola | 1 | 13983 | 21 | 1.893 | 7386.7 |
1177 | 2024-08-22 03:59:59 | cola | 2 | 29872 | 329 | 4.546 | 6571.1 |
1176 | 2024-08-11 05:47:47 | cola | 1 | 13983 | 21 | 0.280 | 49939.3 |
1175 | 2024-08-09 16:15:42 | cola | 1 | 13983 | 21 | 0.690 | 20265.2 |
1174 | 2024-08-07 17:08:39 | cola | 1 | 13983 | 21 | 0.970 | 14415.5 |
1173 | 2024-08-07 17:06:59 | cola | 1 | 13983 | 21 | 0.593 | 23580.1 |
1172 | 2024-08-02 02:28:42 | cola | 2 | 29872 | 329 | 4.110 | 7268.1 |
1171 | 2024-08-02 02:10:45 | cola | 1 | 13983 | 21 | 0.250 | 55932.0 |
1170 | 2024-07-30 15:29:36 | cola | 1 | 13983 | 21 | 0.283 | 49409.9 |
1169 | 2024-07-29 23:56:56 | cola | 2 | 29872 | 329 | 2.033 | 14693.6 |
1168 | 2024-07-29 22:30:26 | cola | 1 | 13983 | 21 | 0.220 | 63559.1 |
1167 | 2024-07-28 06:42:15 | cola | 1 | 13983 | 21 | 0.280 | 49939.3 |
1166 | 2024-07-27 15:18:05 | cola | 1 | 13983 | 21 | 0.796 | 17566.6 |
1165 | 2024-07-24 03:11:28 | cola | 1 | 13983 | 21 | 0.950 | 14718.9 |
1164 | 2024-07-23 09:00:57 | cola | 1 | 13983 | 21 | 0.796 | 17566.6 |
1163 | 2024-07-19 08:58:08 | cola | 1 | 13983 | 21 | 0.516 | 27098.8 |
1162 | 2024-07-16 19:01:36 | cola | 1 | 13983 | 21 | 0.846 | 16528.4 |
1161 | 2024-07-16 10:52:48 | cola | 1 | 13983 | 21 | 0.296 | 47239.9 |
1160 | 2024-07-05 13:45:17 | cola | 1 | 13983 | 21 | 1.656 | 8443.8 |
1159 | 2024-07-05 11:20:51 | cola | 1 | 13983 | 21 | 0.890 | 15711.2 |
1158 | 2024-07-04 22:24:08 | cola | 1 | 13983 | 21 | 0.953 | 14672.6 |
1157 | 2024-07-04 05:49:42 | cola | 1 | 13983 | 21 | 1.016 | 13762.8 |
1156 | 2024-07-03 00:27:52 | cola | 1 | 13983 | 21 | 0.953 | 14672.6 |
1155 | 2024-07-02 10:52:35 | cola | 1 | 13983 | 21 | 0.936 | 14939.1 |
1154 | 2024-07-01 18:59:30 | cola | 1 | 13983 | 21 | 0.703 | 19890.5 |
1153 | 2024-06-30 20:14:41 | cola | 1 | 13983 | 21 | 0.563 | 24836.6 |
1152 | 2024-06-30 16:36:40 | cola | 1 | 13983 | 21 | 0.953 | 14672.6 |
1151 | 2024-06-29 22:32:56 | cola | 2 | 29872 | 329 | 4.563 | 6546.6 |
1150 | 2024-06-29 18:51:23 | cola | 2 | 29872 | 329 | 3.516 | 8496.0 |
1149 | 2024-06-29 17:54:55 | cola | 1 | 13983 | 21 | 0.266 | 52567.7 |
1148 | 2024-06-28 06:31:17 | cola | 1 | 13983 | 21 | 1.360 | 10281.6 |
1147 | 2024-06-13 03:42:48 | cola | 1 | 13983 | 21 | 1.343 | 10411.8 |
1146 | 2024-06-09 21:29:55 | cola | 1 | 13983 | 21 | 1.140 | 12265.8 |
1145 | 2024-06-06 09:08:41 | cola | 1 | 13983 | 21 | 0.673 | 20777.1 |
1144 | 2024-05-31 20:05:20 | cola | 1 | 13983 | 21 | 0.266 | 52567.7 |
1143 | 2024-05-30 12:40:04 | cola | 1 | 13983 | 21 | 1.000 | 13983.0 |
1142 | 2024-05-29 06:20:17 | cola | 1 | 13983 | 21 | 1.063 | 13154.3 |
1141 | 2024-05-10 11:13:38 | cola | 1 | 13983 | 21 | 0.233 | 60012.9 |
1140 | 2024-05-09 23:05:20 | cola | 1 | 13983 | 21 | 0.263 | 53167.3 |
1139 | 2024-05-08 17:41:37 | cola | 1 | 13983 | 21 | 0.236 | 59250.0 |
1138 | 2024-05-07 16:12:39 | cola | 1 | 13983 | 21 | 0.263 | 53167.3 |
1137 | 2024-05-01 20:25:44 | cola | 1 | 13983 | 21 | 0.843 | 16587.2 |
1136 | 2024-04-30 00:07:57 | cola | 1 | 13983 | 21 | 0.266 | 52567.7 |
1135 | 2024-04-13 07:22:09 | cola | 1 | 13983 | 21 | 0.220 | 63559.1 |
1134 | 2024-04-10 05:20:44 | cola | 1 | 13983 | 21 | 0.296 | 47239.9 |
1133 | 2024-04-03 00:33:38 | cola | 1 | 13983 | 21 | 0.826 | 16928.6 |
1132 | 2024-04-01 15:45:36 | cola | 1 | 13983 | 21 | 0.656 | 21315.5 |
1131 | 2024-03-31 00:21:13 | cola | 1 | 13983 | 21 | 0.563 | 24836.6 |
1130 | 2024-03-26 19:12:46 | cola | 1 | 13983 | 21 | 0.280 | 49939.3 |
1129 | 2024-03-18 20:18:56 | cola | 1 | 13983 | 21 | 0.283 | 49409.9 |
1128 | 2024-03-10 04:06:29 | cola | 1 | 13983 | 21 | 0.296 | 47239.9 |
1127 | 2024-03-06 13:37:51 | cola | 2 | 29872 | 329 | 0.966 | 30923.4 |