History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"locusts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
315 | 2024-04-14 10:13:42 | locusts | 2 | 107671 | 22 | 9.453 | 11390.1 |
314 | 2024-04-10 14:48:01 | locusts | 2 | 107671 | 22 | 3.376 | 31893.1 |
313 | 2024-04-10 12:08:31 | locusts | 2 | 107671 | 22 | 4.593 | 23442.4 |
312 | 2024-04-10 11:35:20 | locusts | 3 | 134027 | 237 | 6.610 | 20276.4 |
311 | 2024-04-09 18:45:24 | locusts | 1 | 69583 | 3 | 1.750 | 39761.7 |
310 | 2024-04-03 19:53:42 | locusts | 3 | 134027 | 237 | 23.003 | 5826.5 |
309 | 2024-04-03 19:53:41 | locusts | 2 | 107671 | 22 | 7.936 | 13567.4 |
308 | 2024-04-03 19:51:41 | locusts | 1 | 69583 | 3 | 3.796 | 18330.6 |
307 | 2024-03-28 10:06:34 | locusts | 1 | 69583 | 3 | 1.123 | 61961.7 |
306 | 2024-02-05 20:26:02 | locusts | 3 | 134027 | 237 | 13.813 | 9703.0 |
305 | 2024-01-31 18:52:11 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
304 | 2024-01-30 19:22:14 | locusts | 2 | 107671 | 22 | 3.016 | 35699.9 |
303 | 2024-01-30 19:21:26 | locusts | 3 | 134027 | 237 | 6.580 | 20368.8 |
302 | 2024-01-21 05:24:01 | locusts | 1 | 69583 | 3 | 1.186 | 58670.3 |
301 | 2024-01-19 05:33:07 | locusts | 3 | 134027 | 237 | 6.046 | 22167.9 |
300 | 2024-01-19 05:33:05 | locusts | 2 | 107671 | 22 | 3.080 | 34958.1 |
299 | 2024-01-12 01:10:50 | locusts | 3 | 134027 | 237 | 6.140 | 21828.5 |
298 | 2024-01-12 01:10:49 | locusts | 2 | 107671 | 22 | 3.186 | 33795.0 |
297 | 2023-12-30 05:19:24 | locusts | 1 | 69583 | 3 | 1.516 | 45899.1 |
296 | 2023-12-10 06:40:18 | locusts | 2 | 107671 | 22 | 2.780 | 38730.6 |
295 | 2023-11-18 11:01:31 | locusts | 1 | 69583 | 3 | 1.093 | 63662.4 |
294 | 2023-11-15 14:26:53 | locusts | 1 | 69583 | 3 | 1.140 | 61037.7 |
293 | 2023-11-11 20:00:56 | locusts | 1 | 69583 | 3 | 1.266 | 54962.9 |
292 | 2023-10-23 05:27:54 | locusts | 1 | 69583 | 3 | 1.093 | 63662.4 |
291 | 2023-10-19 11:37:54 | locusts | 1 | 69583 | 3 | 1.233 | 56433.9 |
290 | 2023-10-19 02:44:45 | locusts | 1 | 69583 | 3 | 1.186 | 58670.3 |
289 | 2023-10-14 08:22:45 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
288 | 2023-09-25 22:28:52 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
287 | 2023-09-17 10:00:18 | locusts | 1 | 69583 | 3 | 1.096 | 63488.1 |
286 | 2023-09-14 03:06:29 | locusts | 1 | 69583 | 3 | 1.110 | 62687.4 |
285 | 2023-09-08 14:44:32 | locusts | 2 | 107671 | 22 | 2.813 | 38276.2 |
284 | 2023-08-15 22:03:43 | locusts | 1 | 69583 | 3 | 1.063 | 65459.1 |
283 | 2023-07-05 14:25:17 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
282 | 2023-05-28 10:43:26 | locusts | 2 | 107671 | 22 | 3.016 | 35699.9 |
281 | 2023-05-21 08:49:40 | locusts | 1 | 69583 | 3 | 1.140 | 61037.7 |
280 | 2023-05-14 23:33:07 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
279 | 2023-03-08 14:53:07 | locusts | 2 | 107671 | 22 | 2.750 | 39153.1 |
278 | 2023-03-07 17:26:08 | locusts | 1 | 69583 | 3 | 1.063 | 65459.1 |
277 | 2023-01-28 17:19:01 | locusts | 1 | 69583 | 3 | 1.046 | 66522.9 |
276 | 2022-12-30 02:34:32 | locusts | 1 | 69583 | 3 | 1.080 | 64428.7 |
275 | 2022-12-14 14:32:44 | locusts | 2 | 107671 | 22 | 2.830 | 38046.3 |
274 | 2022-10-07 02:31:16 | locusts | 1 | 69583 | 3 | 1.190 | 58473.1 |
273 | 2022-09-30 18:03:34 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
272 | 2022-09-19 09:06:09 | locusts | 1 | 69583 | 3 | 1.080 | 64428.7 |
271 | 2022-08-04 07:55:05 | locusts | 2 | 107671 | 22 | 2.763 | 38968.9 |
270 | 2022-07-20 02:13:43 | locusts | 3 | 134027 | 237 | 5.563 | 24092.6 |
269 | 2022-06-02 08:55:12 | locusts | 1 | 69583 | 3 | 1.046 | 66522.9 |
268 | 2022-05-16 08:50:16 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
267 | 2022-04-27 21:02:31 | locusts | 1 | 69583 | 3 | 1.640 | 42428.7 |
266 | 2022-03-25 03:47:01 | locusts | 2 | 107671 | 22 | 2.906 | 37051.3 |
265 | 2022-01-29 00:39:58 | locusts | 1 | 69583 | 3 | 1.140 | 61037.7 |
264 | 2022-01-19 03:50:09 | locusts | 1 | 69583 | 3 | 1.046 | 66522.9 |
263 | 2022-01-17 00:57:34 | locusts | 1 | 69583 | 3 | 1.063 | 65459.1 |
262 | 2021-11-29 08:45:03 | locusts | 1 | 69583 | 3 | 1.140 | 61037.7 |
261 | 2021-11-27 07:15:52 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
260 | 2021-10-12 06:46:02 | locusts | 1 | 69583 | 3 | 1.063 | 65459.1 |
259 | 2021-07-11 00:55:26 | locusts | 1 | 69583 | 3 | 1.096 | 63488.1 |
258 | 2021-05-14 16:46:41 | locusts | 2 | 107671 | 22 | 3.360 | 32044.9 |
257 | 2021-04-07 03:57:24 | locusts | 1 | 69583 | 3 | 1.170 | 59472.6 |
256 | 2021-04-02 23:53:13 | locusts | 1 | 69583 | 3 | 1.986 | 35036.8 |
255 | 2021-02-20 09:42:33 | locusts | 2 | 107671 | 22 | 2.843 | 37872.3 |
254 | 2021-02-13 16:09:19 | locusts | 1 | 69583 | 3 | 1.060 | 65644.3 |
253 | 2021-01-30 23:38:54 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
252 | 2021-01-03 02:08:19 | locusts | 1 | 69583 | 3 | 1.063 | 65459.1 |
251 | 2020-12-29 02:56:25 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
250 | 2020-12-02 02:19:56 | locusts | 2 | 107671 | 22 | 2.876 | 37437.8 |
249 | 2020-10-28 21:41:24 | locusts | 3 | 134027 | 237 | 6.236 | 21492.5 |
248 | 2020-10-27 22:28:05 | locusts | 2 | 107671 | 22 | 2.893 | 37217.8 |
247 | 2020-10-18 06:07:46 | locusts | 1 | 69583 | 3 | 1.093 | 63662.4 |
246 | 2020-10-12 23:31:46 | locusts | 1 | 69583 | 3 | 1.093 | 63662.4 |
245 | 2020-10-05 01:55:15 | locusts | 1 | 69583 | 3 | 1.236 | 56296.9 |
244 | 2020-09-25 17:20:26 | locusts | 1 | 69583 | 3 | 1.046 | 66522.9 |
243 | 2020-08-16 18:49:14 | locusts | 1 | 69583 | 3 | 1.093 | 63662.4 |
242 | 2020-06-08 01:44:32 | locusts | 1 | 69583 | 3 | 1.186 | 58670.3 |
241 | 2020-03-29 02:39:38 | locusts | 1 | 69583 | 3 | 1.220 | 57035.2 |
240 | 2020-03-24 02:50:23 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
239 | 2020-03-23 18:06:02 | locusts | 1 | 69583 | 3 | 1.296 | 53690.6 |
238 | 2020-03-23 06:53:26 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
237 | 2020-03-20 18:29:31 | locusts | 1 | 69583 | 3 | 1.170 | 59472.6 |
236 | 2020-03-06 13:11:04 | locusts | 1 | 69583 | 3 | 1.050 | 66269.5 |
235 | 2020-02-23 21:51:44 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
234 | 2020-02-13 01:40:51 | locusts | 1 | 69583 | 3 | 3.606 | 19296.5 |
233 | 2020-02-12 11:51:33 | locusts | 1 | 69583 | 3 | 3.970 | 17527.2 |
232 | 2020-02-08 09:08:14 | locusts | 1 | 69583 | 3 | 1.346 | 51696.1 |
231 | 2020-02-07 01:40:58 | locusts | 1 | 69583 | 3 | 1.203 | 57841.2 |
230 | 2020-02-06 10:15:58 | locusts | 1 | 69583 | 3 | 1.263 | 55093.4 |
229 | 2020-01-29 09:08:43 | locusts | 1 | 69583 | 3 | 1.360 | 51164.0 |
228 | 2020-01-27 12:18:31 | locusts | 1 | 69583 | 3 | 1.546 | 45008.4 |
227 | 2020-01-18 04:54:30 | locusts | 1 | 69583 | 3 | 1.186 | 58670.3 |
226 | 2020-01-17 23:51:05 | locusts | 1 | 69583 | 3 | 2.753 | 25275.3 |
225 | 2020-01-14 14:39:13 | locusts | 1 | 69583 | 3 | 1.186 | 58670.3 |
224 | 2020-01-14 13:42:35 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
223 | 2020-01-08 17:59:44 | locusts | 1 | 69583 | 3 | 1.046 | 66522.9 |
222 | 2020-01-07 23:50:57 | locusts | 1 | 69583 | 3 | 1.266 | 54962.9 |
221 | 2019-12-28 23:46:53 | locusts | 1 | 69583 | 3 | 1.250 | 55666.4 |
220 | 2019-12-28 15:29:20 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
219 | 2019-12-27 01:51:58 | locusts | 1 | 69583 | 3 | 1.640 | 42428.7 |
218 | 2019-11-30 16:41:50 | locusts | 1 | 69583 | 3 | 1.173 | 59320.5 |
217 | 2019-10-19 20:09:47 | locusts | 1 | 69583 | 3 | 1.076 | 64668.2 |
216 | 2019-09-01 07:13:38 | locusts | 1 | 69583 | 3 | 1.183 | 58819.1 |