History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hornworm"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
366 | 2024-04-17 09:50:26 | hornworm | 4 | 161609 | 307 | 17.343 | 9318.4 |
365 | 2024-04-16 07:44:06 | hornworm | 2 | 121059 | 5 | 3.826 | 31641.1 |
364 | 2024-04-16 06:18:42 | hornworm | 3 | 146162 | 42 | 8.766 | 16673.7 |
363 | 2024-04-14 10:30:10 | hornworm | 4 | 161609 | 307 | 49.393 | 3271.9 |
362 | 2024-04-14 06:15:02 | hornworm | 4 | 161609 | 307 | 51.426 | 3142.6 |
361 | 2024-04-14 06:15:09 | hornworm | 3 | 146162 | 42 | 11.423 | 12795.4 |
360 | 2024-04-13 02:20:17 | hornworm | 4 | 161609 | 307 | 28.800 | 5611.4 |
359 | 2024-04-13 02:20:13 | hornworm | 3 | 146162 | 42 | 19.126 | 7642.1 |
358 | 2024-04-13 01:41:53 | hornworm | 2 | 121059 | 5 | 6.360 | 19034.4 |
357 | 2024-04-13 01:41:45 | hornworm | 4 | 161609 | 307 | 14.050 | 11502.4 |
356 | 2024-04-13 01:41:50 | hornworm | 3 | 146162 | 42 | 8.080 | 18089.4 |
355 | 2024-04-13 01:41:41 | hornworm | 1 | 82945 | 3 | 1.406 | 58993.6 |
354 | 2024-04-13 01:41:24 | hornworm | 4 | 161609 | 307 | 14.143 | 11426.8 |
353 | 2024-04-13 01:41:28 | hornworm | 3 | 146162 | 42 | 7.733 | 18901.1 |
352 | 2024-04-13 01:41:32 | hornworm | 2 | 121059 | 5 | 3.983 | 30393.9 |
351 | 2024-04-13 01:41:20 | hornworm | 1 | 82945 | 3 | 1.373 | 60411.5 |
350 | 2024-04-10 00:01:27 | hornworm | 1 | 82945 | 3 | 3.766 | 22024.7 |
349 | 2024-04-02 20:22:11 | hornworm | 1 | 82945 | 3 | 1.280 | 64800.8 |
348 | 2024-04-01 14:46:30 | hornworm | 1 | 82945 | 3 | 4.326 | 19173.6 |
347 | 2024-03-13 17:25:21 | hornworm | 2 | 121059 | 5 | 6.893 | 17562.6 |
346 | 2024-03-13 17:25:01 | hornworm | 3 | 146162 | 42 | 8.516 | 17163.2 |
345 | 2024-03-10 05:04:37 | hornworm | 1 | 82945 | 3 | 3.390 | 24467.6 |
344 | 2024-03-09 03:41:21 | hornworm | 4 | 161609 | 307 | 19.516 | 8280.8 |
343 | 2024-03-09 03:41:29 | hornworm | 1 | 82945 | 3 | 1.580 | 52496.8 |
342 | 2024-03-09 03:41:22 | hornworm | 2 | 121059 | 5 | 4.343 | 27874.5 |
341 | 2024-03-09 03:41:01 | hornworm | 3 | 146162 | 42 | 7.546 | 19369.5 |
340 | 2024-03-07 18:59:45 | hornworm | 3 | 146162 | 42 | 15.813 | 9243.2 |
339 | 2024-03-07 07:39:43 | hornworm | 4 | 161609 | 307 | 24.516 | 6592.0 |
338 | 2024-03-06 13:15:41 | hornworm | 3 | 146162 | 42 | 14.703 | 9941.0 |
337 | 2024-03-05 23:27:02 | hornworm | 4 | 161609 | 307 | 20.906 | 7730.3 |
336 | 2024-03-05 11:19:31 | hornworm | 4 | 161609 | 307 | 14.046 | 11505.7 |
335 | 2024-03-05 11:19:31 | hornworm | 3 | 146162 | 42 | 13.673 | 10689.8 |
334 | 2024-03-05 06:46:52 | hornworm | 4 | 161609 | 307 | 41.410 | 3902.7 |
333 | 2024-03-05 06:46:53 | hornworm | 3 | 146162 | 42 | 24.390 | 5992.7 |
332 | 2024-03-05 06:46:59 | hornworm | 2 | 121059 | 5 | 15.250 | 7938.3 |
331 | 2024-03-05 06:42:51 | hornworm | 1 | 82945 | 3 | 3.310 | 25058.9 |
330 | 2024-02-07 10:22:23 | hornworm | 1 | 82945 | 3 | 1.406 | 58993.6 |
329 | 2024-02-04 23:36:08 | hornworm | 2 | 121059 | 5 | 4.970 | 24357.9 |
328 | 2024-02-04 23:35:21 | hornworm | 3 | 146162 | 42 | 16.690 | 8757.5 |
327 | 2024-02-04 03:40:59 | hornworm | 3 | 146162 | 42 | 10.690 | 13672.8 |
326 | 2024-02-04 03:40:55 | hornworm | 2 | 121059 | 5 | 5.360 | 22585.6 |
325 | 2024-02-04 02:47:23 | hornworm | 4 | 161609 | 307 | 22.020 | 7339.2 |
324 | 2024-01-31 13:10:31 | hornworm | 2 | 121059 | 5 | 3.470 | 34887.3 |
323 | 2024-01-31 13:10:19 | hornworm | 3 | 146162 | 42 | 8.970 | 16294.5 |
322 | 2024-01-30 22:34:59 | hornworm | 4 | 161609 | 307 | 13.580 | 11900.5 |
321 | 2024-01-30 07:51:11 | hornworm | 3 | 146162 | 42 | 7.346 | 19896.8 |
320 | 2024-01-30 07:51:07 | hornworm | 2 | 121059 | 5 | 3.186 | 37997.2 |
319 | 2024-01-30 07:51:04 | hornworm | 1 | 82945 | 3 | 1.330 | 62364.7 |
318 | 2024-01-30 01:41:09 | hornworm | 1 | 82945 | 3 | 1.360 | 60989.0 |
317 | 2024-01-28 21:24:23 | hornworm | 4 | 161609 | 307 | 12.203 | 13243.4 |
316 | 2024-01-27 14:41:16 | hornworm | 4 | 161609 | 307 | 13.453 | 12012.9 |
315 | 2024-01-26 22:12:53 | hornworm | 4 | 161609 | 307 | 17.983 | 8986.8 |
314 | 2024-01-26 21:57:27 | hornworm | 4 | 161609 | 307 | 12.953 | 12476.6 |
313 | 2024-01-26 21:46:15 | hornworm | 4 | 161609 | 307 | 12.110 | 13345.1 |
312 | 2024-01-26 21:17:48 | hornworm | 4 | 161609 | 307 | 12.436 | 12995.3 |
311 | 2024-01-14 06:31:32 | hornworm | 2 | 121059 | 5 | 3.220 | 37596.0 |
310 | 2024-01-07 12:22:20 | hornworm | 1 | 82945 | 3 | 1.390 | 59672.7 |
309 | 2023-12-30 11:05:04 | hornworm | 1 | 82945 | 3 | 1.313 | 63172.1 |
308 | 2023-12-24 20:12:27 | hornworm | 1 | 82945 | 3 | 1.406 | 58993.6 |
307 | 2023-12-24 12:08:03 | hornworm | 1 | 82945 | 3 | 1.250 | 66356.0 |
306 | 2023-12-23 15:45:08 | hornworm | 4 | 161609 | 307 | 11.360 | 14226.1 |
305 | 2023-10-19 12:11:36 | hornworm | 2 | 121059 | 5 | 3.343 | 36212.7 |
304 | 2023-10-12 00:17:19 | hornworm | 1 | 82945 | 3 | 1.263 | 65673.0 |
303 | 2023-10-01 19:41:07 | hornworm | 4 | 161609 | 307 | 16.500 | 9794.5 |
302 | 2023-09-30 14:06:14 | hornworm | 4 | 161609 | 307 | 11.843 | 13646.0 |
301 | 2023-09-29 14:03:04 | hornworm | 4 | 161609 | 307 | 12.736 | 12689.1 |
300 | 2023-09-18 14:29:10 | hornworm | 1 | 82945 | 3 | 1.453 | 57085.3 |
299 | 2023-08-23 20:33:09 | hornworm | 4 | 161609 | 307 | 12.610 | 12815.9 |
298 | 2023-08-07 16:01:18 | hornworm | 1 | 82945 | 3 | 1.406 | 58993.6 |
297 | 2023-08-03 12:11:50 | hornworm | 4 | 161609 | 307 | 16.000 | 10100.6 |
296 | 2023-07-30 09:46:52 | hornworm | 2 | 121059 | 5 | 3.373 | 35890.6 |
295 | 2023-07-12 15:20:47 | hornworm | 4 | 161609 | 307 | 10.390 | 15554.3 |
294 | 2023-07-11 17:15:40 | hornworm | 4 | 161609 | 307 | 13.033 | 12400.0 |
293 | 2023-07-10 23:51:28 | hornworm | 4 | 161609 | 307 | 12.186 | 13261.9 |
292 | 2023-06-06 23:51:22 | hornworm | 4 | 161609 | 307 | 11.500 | 14053.0 |
291 | 2023-06-05 12:23:55 | hornworm | 4 | 161609 | 307 | 10.420 | 15509.5 |
290 | 2023-06-04 23:00:44 | hornworm | 4 | 161609 | 307 | 10.470 | 15435.4 |
289 | 2023-06-01 12:12:32 | hornworm | 4 | 161609 | 307 | 11.673 | 13844.7 |
288 | 2023-05-19 04:02:41 | hornworm | 1 | 82945 | 3 | 1.466 | 56579.1 |
287 | 2023-05-15 18:25:18 | hornworm | 1 | 82945 | 3 | 1.343 | 61761.0 |
286 | 2023-05-07 18:24:26 | hornworm | 1 | 82945 | 3 | 1.296 | 64000.8 |
285 | 2023-04-07 07:58:53 | hornworm | 2 | 121059 | 5 | 3.140 | 38553.8 |
284 | 2023-03-31 05:20:07 | hornworm | 4 | 161609 | 307 | 11.360 | 14226.1 |
283 | 2023-03-20 18:22:51 | hornworm | 4 | 161609 | 307 | 10.733 | 15057.2 |
282 | 2023-02-28 19:36:33 | hornworm | 1 | 82945 | 3 | 1.483 | 55930.5 |
281 | 2023-01-25 08:07:12 | hornworm | 4 | 161609 | 307 | 10.940 | 14772.3 |
280 | 2023-01-22 17:13:34 | hornworm | 1 | 82945 | 3 | 1.266 | 65517.4 |
279 | 2023-01-05 00:43:23 | hornworm | 2 | 121059 | 5 | 3.126 | 38726.5 |
278 | 2023-01-01 15:21:20 | hornworm | 4 | 161609 | 307 | 13.140 | 12299.0 |
277 | 2022-12-27 11:26:23 | hornworm | 4 | 161609 | 307 | 10.906 | 14818.4 |
276 | 2022-12-26 16:41:30 | hornworm | 1 | 82945 | 3 | 1.250 | 66356.0 |
275 | 2022-12-13 18:55:15 | hornworm | 4 | 161609 | 307 | 12.563 | 12863.9 |
274 | 2022-12-09 09:23:29 | hornworm | 4 | 161609 | 307 | 12.640 | 12785.5 |
273 | 2022-12-08 19:50:32 | hornworm | 4 | 161609 | 307 | 13.686 | 11808.3 |
272 | 2022-11-22 13:27:44 | hornworm | 4 | 161609 | 307 | 10.846 | 14900.3 |
271 | 2022-11-20 22:43:48 | hornworm | 1 | 82945 | 3 | 1.373 | 60411.5 |
270 | 2022-11-18 03:51:28 | hornworm | 1 | 82945 | 3 | 1.390 | 59672.7 |
269 | 2022-09-20 09:34:37 | hornworm | 1 | 82945 | 3 | 1.250 | 66356.0 |
268 | 2022-09-15 02:42:11 | hornworm | 1 | 82945 | 3 | 1.406 | 58993.6 |
267 | 2022-09-09 18:42:21 | hornworm | 2 | 121059 | 5 | 3.170 | 38189.0 |