History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"maggots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
286 | 2024-03-25 15:50:15 | maggots | 1 | 69583 | 5 | 1.186 | 58670.3 |
285 | 2024-03-13 22:43:11 | maggots | 3 | 134027 | 226 | 10.750 | 12467.6 |
284 | 2024-03-13 02:13:23 | maggots | 3 | 134027 | 226 | 12.406 | 10803.4 |
283 | 2024-03-11 16:13:55 | maggots | 3 | 134027 | 226 | 9.610 | 13946.6 |
282 | 2024-03-10 19:12:18 | maggots | 3 | 134027 | 226 | 18.720 | 7159.6 |
281 | 2024-03-09 16:35:28 | maggots | 3 | 134027 | 226 | 18.033 | 7432.3 |
280 | 2024-03-08 22:23:23 | maggots | 3 | 134027 | 226 | 7.733 | 17331.8 |
279 | 2024-03-06 16:16:19 | maggots | 3 | 134027 | 226 | 20.126 | 6659.4 |
278 | 2024-03-04 15:46:54 | maggots | 3 | 134027 | 226 | 9.003 | 14886.9 |
277 | 2024-03-03 15:33:47 | maggots | 3 | 134027 | 226 | 22.720 | 5899.1 |
276 | 2024-03-02 18:01:59 | maggots | 3 | 134027 | 226 | 21.220 | 6316.1 |
275 | 2024-03-02 15:18:23 | maggots | 3 | 134027 | 226 | 8.296 | 16155.6 |
274 | 2024-03-01 21:03:58 | maggots | 3 | 134027 | 226 | 8.050 | 16649.3 |
273 | 2024-02-28 07:38:33 | maggots | 2 | 107671 | 16 | 6.596 | 16323.7 |
272 | 2024-02-28 07:19:26 | maggots | 3 | 134027 | 226 | 24.033 | 5576.8 |
271 | 2024-02-28 06:09:44 | maggots | 3 | 134027 | 226 | 7.143 | 18763.4 |
270 | 2024-02-28 06:09:41 | maggots | 2 | 107671 | 16 | 3.513 | 30649.3 |
269 | 2024-02-28 06:09:40 | maggots | 1 | 69583 | 5 | 1.343 | 51811.6 |
268 | 2024-01-17 21:46:18 | maggots | 1 | 69583 | 5 | 1.466 | 47464.5 |
267 | 2024-01-12 10:51:45 | maggots | 3 | 134027 | 226 | 6.500 | 20619.5 |
266 | 2024-01-12 10:51:43 | maggots | 2 | 107671 | 16 | 3.126 | 34443.7 |
265 | 2024-01-07 11:05:14 | maggots | 3 | 134027 | 226 | 5.860 | 22871.5 |
264 | 2023-12-14 05:38:30 | maggots | 1 | 69583 | 5 | 1.186 | 58670.3 |
263 | 2023-12-11 20:12:48 | maggots | 3 | 134027 | 226 | 5.796 | 23124.1 |
262 | 2023-11-27 14:20:07 | maggots | 1 | 69583 | 5 | 1.140 | 61037.7 |
261 | 2023-11-21 03:50:46 | maggots | 3 | 134027 | 226 | 6.190 | 21652.2 |
260 | 2023-11-17 21:45:44 | maggots | 1 | 69583 | 5 | 1.250 | 55666.4 |
259 | 2023-11-13 02:04:53 | maggots | 1 | 69583 | 5 | 1.126 | 61796.6 |
258 | 2023-11-09 10:51:58 | maggots | 1 | 69583 | 5 | 1.106 | 62914.1 |
257 | 2023-11-06 15:54:52 | maggots | 1 | 69583 | 5 | 1.203 | 57841.2 |
256 | 2023-11-04 15:52:41 | maggots | 1 | 69583 | 5 | 1.236 | 56296.9 |
255 | 2023-11-04 14:49:49 | maggots | 1 | 69583 | 5 | 1.690 | 41173.4 |
254 | 2023-10-13 15:21:37 | maggots | 1 | 69583 | 5 | 1.123 | 61961.7 |
253 | 2023-09-29 10:01:47 | maggots | 1 | 69583 | 5 | 1.283 | 54234.6 |
252 | 2023-09-16 12:43:22 | maggots | 1 | 69583 | 5 | 1.266 | 54962.9 |
251 | 2023-09-02 10:10:36 | maggots | 1 | 69583 | 5 | 1.060 | 65644.3 |
250 | 2023-08-11 06:12:29 | maggots | 1 | 69583 | 5 | 1.296 | 53690.6 |
249 | 2023-06-04 00:35:19 | maggots | 1 | 69583 | 5 | 1.060 | 65644.3 |
248 | 2023-04-22 15:41:51 | maggots | 1 | 69583 | 5 | 1.076 | 64668.2 |
247 | 2023-03-26 16:51:37 | maggots | 1 | 69583 | 5 | 1.110 | 62687.4 |
246 | 2023-01-10 18:35:36 | maggots | 1 | 69583 | 5 | 1.093 | 63662.4 |
245 | 2022-12-30 00:53:35 | maggots | 1 | 69583 | 5 | 1.266 | 54962.9 |
244 | 2022-10-18 01:28:58 | maggots | 1 | 69583 | 5 | 1.106 | 62914.1 |
243 | 2022-08-26 04:24:33 | maggots | 1 | 69583 | 5 | 1.203 | 57841.2 |
242 | 2022-06-06 20:04:20 | maggots | 1 | 69583 | 5 | 1.093 | 63662.4 |
241 | 2022-05-18 14:56:23 | maggots | 1 | 69583 | 5 | 1.123 | 61961.7 |
240 | 2022-04-25 05:39:20 | maggots | 3 | 134027 | 226 | 5.876 | 22809.2 |
239 | 2022-04-07 18:59:12 | maggots | 3 | 134027 | 226 | 6.640 | 20184.8 |
238 | 2022-03-02 00:47:08 | maggots | 3 | 134027 | 226 | 6.393 | 20964.6 |
237 | 2022-02-16 16:56:15 | maggots | 1 | 69583 | 5 | 1.296 | 53690.6 |
236 | 2021-12-23 23:15:41 | maggots | 1 | 69583 | 5 | 1.220 | 57035.2 |
235 | 2021-12-22 07:22:13 | maggots | 1 | 69583 | 5 | 1.453 | 47889.2 |
234 | 2021-12-12 07:09:38 | maggots | 1 | 69583 | 5 | 2.170 | 32065.9 |
233 | 2021-12-10 04:49:57 | maggots | 1 | 69583 | 5 | 1.173 | 59320.5 |
232 | 2021-11-11 17:42:25 | maggots | 1 | 69583 | 5 | 1.233 | 56433.9 |
231 | 2021-10-19 12:25:32 | maggots | 1 | 69583 | 5 | 1.060 | 65644.3 |
230 | 2021-09-10 08:08:02 | maggots | 1 | 69583 | 5 | 1.093 | 63662.4 |
229 | 2021-09-09 10:58:27 | maggots | 1 | 69583 | 5 | 1.093 | 63662.4 |
228 | 2021-08-22 20:00:29 | maggots | 1 | 69583 | 5 | 1.080 | 64428.7 |
227 | 2021-06-16 07:08:12 | maggots | 1 | 69583 | 5 | 1.106 | 62914.1 |
226 | 2021-06-16 06:47:53 | maggots | 2 | 107671 | 16 | 2.953 | 36461.6 |
225 | 2021-06-09 10:51:01 | maggots | 1 | 69583 | 5 | 1.093 | 63662.4 |
224 | 2021-05-09 12:52:12 | maggots | 3 | 134027 | 226 | 6.626 | 20227.4 |
223 | 2021-05-08 23:10:15 | maggots | 2 | 107671 | 16 | 3.156 | 34116.3 |
222 | 2021-05-02 11:15:17 | maggots | 1 | 69583 | 5 | 1.296 | 53690.6 |
221 | 2021-04-26 17:14:25 | maggots | 1 | 69583 | 5 | 1.140 | 61037.7 |
220 | 2021-04-05 20:13:41 | maggots | 1 | 69583 | 5 | 1.283 | 54234.6 |
219 | 2021-03-26 22:17:16 | maggots | 1 | 69583 | 5 | 1.076 | 64668.2 |
218 | 2021-03-26 21:47:26 | maggots | 2 | 107671 | 16 | 2.923 | 36835.8 |
217 | 2021-03-10 10:58:48 | maggots | 1 | 69583 | 5 | 1.266 | 54962.9 |
216 | 2021-03-01 01:19:50 | maggots | 1 | 69583 | 5 | 1.096 | 63488.1 |
215 | 2021-02-13 18:52:58 | maggots | 1 | 69583 | 5 | 1.080 | 64428.7 |
214 | 2021-01-29 22:12:26 | maggots | 3 | 134027 | 226 | 6.530 | 20524.8 |
213 | 2021-01-10 04:55:13 | maggots | 2 | 107671 | 16 | 2.936 | 36672.7 |
212 | 2020-12-07 03:05:33 | maggots | 1 | 69583 | 5 | 1.080 | 64428.7 |
211 | 2020-10-17 12:15:40 | maggots | 3 | 134027 | 226 | 6.203 | 21606.8 |
210 | 2020-10-15 17:06:26 | maggots | 1 | 69583 | 5 | 1.156 | 60192.9 |
209 | 2020-10-09 08:31:10 | maggots | 1 | 69583 | 5 | 1.076 | 64668.2 |
208 | 2020-10-08 20:41:55 | maggots | 1 | 69583 | 5 | 1.140 | 61037.7 |
207 | 2020-09-28 15:58:45 | maggots | 3 | 134027 | 226 | 6.563 | 20421.6 |
206 | 2020-09-28 12:59:40 | maggots | 1 | 69583 | 5 | 1.076 | 64668.2 |
205 | 2020-09-28 11:51:14 | maggots | 2 | 107671 | 16 | 3.173 | 33933.5 |
204 | 2020-09-17 05:35:20 | maggots | 3 | 134027 | 226 | 6.500 | 20619.5 |
203 | 2020-09-04 06:34:15 | maggots | 1 | 69583 | 5 | 1.546 | 45008.4 |
202 | 2020-09-03 20:39:17 | maggots | 1 | 69583 | 5 | 1.216 | 57222.9 |
201 | 2020-08-31 20:27:20 | maggots | 1 | 69583 | 5 | 1.313 | 52995.4 |
200 | 2020-08-14 08:45:51 | maggots | 2 | 107671 | 16 | 3.330 | 32333.6 |
199 | 2020-08-02 01:33:12 | maggots | 1 | 69583 | 5 | 1.173 | 59320.5 |
198 | 2020-08-01 11:37:17 | maggots | 2 | 107671 | 16 | 2.890 | 37256.4 |
197 | 2020-07-26 11:04:33 | maggots | 3 | 134027 | 226 | 6.986 | 19185.1 |
196 | 2020-06-04 20:07:27 | maggots | 1 | 69583 | 5 | 1.233 | 56433.9 |
195 | 2020-05-30 03:10:06 | maggots | 1 | 69583 | 5 | 1.186 | 58670.3 |
194 | 2020-03-28 13:32:53 | maggots | 1 | 69583 | 5 | 1.236 | 56296.9 |
193 | 2020-03-24 13:59:32 | maggots | 1 | 69583 | 5 | 1.390 | 50059.7 |
192 | 2020-03-24 04:12:51 | maggots | 1 | 69583 | 5 | 1.283 | 54234.6 |
191 | 2020-03-23 08:38:28 | maggots | 1 | 69583 | 5 | 1.326 | 52475.9 |
190 | 2020-03-20 16:52:37 | maggots | 1 | 69583 | 5 | 1.253 | 55533.1 |
189 | 2020-03-03 14:48:55 | maggots | 1 | 69583 | 5 | 1.310 | 53116.8 |
188 | 2020-02-28 16:08:31 | maggots | 1 | 69583 | 5 | 1.220 | 57035.2 |
187 | 2020-02-26 20:39:43 | maggots | 1 | 69583 | 5 | 1.283 | 54234.6 |