History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"midgut"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2024-04-27 15:36:32 | midgut | 1 | 48755 | 3 | 1.156 | 42175.6 |
344 | 2024-04-17 13:37:19 | midgut | 3 | 112716 | 155 | 12.690 | 8882.3 |
343 | 2024-04-16 06:21:09 | midgut | 1 | 48755 | 3 | 0.876 | 55656.4 |
342 | 2024-04-12 20:49:16 | midgut | 3 | 112716 | 155 | 10.360 | 10879.9 |
341 | 2024-04-11 16:08:17 | midgut | 3 | 112716 | 155 | 4.593 | 24540.8 |
340 | 2024-04-01 06:53:10 | midgut | 1 | 48755 | 3 | 0.876 | 55656.4 |
339 | 2024-03-31 15:47:05 | midgut | 1 | 48755 | 3 | 0.906 | 53813.5 |
338 | 2024-03-31 15:46:59 | midgut | 3 | 112716 | 155 | 5.953 | 18934.3 |
337 | 2024-03-31 15:47:01 | midgut | 1 | 48755 | 3 | 1.843 | 26454.2 |
336 | 2024-03-31 15:46:58 | midgut | 2 | 82551 | 14 | 3.326 | 24819.9 |
335 | 2024-03-28 22:54:50 | midgut | 1 | 48755 | 3 | 1.000 | 48755.0 |
334 | 2024-03-07 06:51:19 | midgut | 1 | 48755 | 3 | 0.953 | 51159.5 |
333 | 2024-02-28 08:20:58 | midgut | 3 | 112716 | 155 | 12.313 | 9154.2 |
332 | 2024-02-28 07:58:51 | midgut | 3 | 112716 | 155 | 11.360 | 9922.2 |
331 | 2024-02-28 07:58:50 | midgut | 2 | 82551 | 14 | 3.000 | 27517.0 |
330 | 2024-02-28 07:58:49 | midgut | 1 | 48755 | 3 | 1.766 | 27607.6 |
329 | 2024-02-03 05:05:31 | midgut | 1 | 48755 | 3 | 1.783 | 27344.4 |
328 | 2024-01-16 18:04:36 | midgut | 3 | 112716 | 155 | 5.123 | 22002.0 |
327 | 2024-01-16 18:04:35 | midgut | 2 | 82551 | 14 | 2.546 | 32423.8 |
326 | 2024-01-14 20:50:03 | midgut | 2 | 82551 | 14 | 2.093 | 39441.5 |
325 | 2024-01-01 20:22:21 | midgut | 1 | 48755 | 3 | 0.796 | 61250.0 |
324 | 2023-12-17 09:46:55 | midgut | 3 | 112716 | 155 | 6.953 | 16211.1 |
323 | 2023-12-17 09:46:57 | midgut | 2 | 82551 | 14 | 4.313 | 19140.0 |
322 | 2023-12-10 14:46:42 | midgut | 3 | 112716 | 155 | 4.703 | 23966.8 |
321 | 2023-12-10 12:04:43 | midgut | 1 | 48755 | 3 | 0.750 | 65006.7 |
320 | 2023-12-03 09:42:50 | midgut | 1 | 48755 | 3 | 0.826 | 59025.4 |
319 | 2023-12-03 09:42:49 | midgut | 1 | 48755 | 3 | 0.846 | 57630.0 |
318 | 2023-11-23 14:43:03 | midgut | 3 | 112716 | 155 | 4.843 | 23274.0 |
317 | 2023-11-23 14:43:04 | midgut | 2 | 82551 | 14 | 2.390 | 34540.2 |
316 | 2023-11-17 13:09:36 | midgut | 1 | 48755 | 3 | 0.783 | 62266.9 |
315 | 2023-11-12 02:56:04 | midgut | 1 | 48755 | 3 | 0.893 | 54596.9 |
314 | 2023-11-06 01:51:08 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
313 | 2023-10-23 02:52:13 | midgut | 2 | 82551 | 14 | 2.220 | 37185.1 |
312 | 2023-10-21 20:59:17 | midgut | 1 | 48755 | 3 | 0.810 | 60191.4 |
311 | 2023-10-21 15:47:09 | midgut | 1 | 48755 | 3 | 0.810 | 60191.4 |
310 | 2023-10-18 17:09:32 | midgut | 1 | 48755 | 3 | 0.843 | 57835.1 |
309 | 2023-10-11 15:00:19 | midgut | 1 | 48755 | 3 | 0.796 | 61250.0 |
308 | 2023-10-05 14:31:51 | midgut | 1 | 48755 | 3 | 0.720 | 67715.3 |
307 | 2023-09-26 23:16:42 | midgut | 3 | 112716 | 155 | 4.686 | 24053.8 |
306 | 2023-09-19 14:48:54 | midgut | 3 | 112716 | 155 | 5.360 | 21029.1 |
305 | 2023-09-13 12:56:35 | midgut | 1 | 48755 | 3 | 1.673 | 29142.3 |
304 | 2023-09-10 15:39:18 | midgut | 3 | 112716 | 155 | 5.000 | 22543.2 |
303 | 2023-08-19 10:18:54 | midgut | 1 | 48755 | 3 | 0.830 | 58741.0 |
302 | 2023-08-03 14:33:59 | midgut | 1 | 48755 | 3 | 0.780 | 62506.4 |
301 | 2023-08-03 03:46:09 | midgut | 2 | 82551 | 14 | 2.093 | 39441.5 |
300 | 2023-06-11 12:33:24 | midgut | 3 | 112716 | 155 | 4.686 | 24053.8 |
299 | 2023-05-16 19:14:29 | midgut | 1 | 48755 | 3 | 0.733 | 66514.3 |
298 | 2023-04-13 10:36:40 | midgut | 2 | 82551 | 14 | 2.406 | 34310.5 |
297 | 2023-04-07 20:06:40 | midgut | 1 | 48755 | 3 | 0.733 | 66514.3 |
296 | 2023-03-14 18:14:32 | midgut | 3 | 112716 | 155 | 4.453 | 25312.4 |
295 | 2023-03-12 16:59:05 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
294 | 2023-01-26 12:07:55 | midgut | 3 | 112716 | 155 | 4.470 | 25216.1 |
293 | 2023-01-19 21:00:56 | midgut | 2 | 82551 | 14 | 3.110 | 26543.7 |
292 | 2023-01-02 00:14:41 | midgut | 1 | 48755 | 3 | 0.860 | 56691.9 |
291 | 2022-12-18 04:50:52 | midgut | 3 | 112716 | 155 | 4.453 | 25312.4 |
290 | 2022-12-12 12:21:24 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
289 | 2022-12-12 07:24:27 | midgut | 3 | 112716 | 155 | 5.250 | 21469.7 |
288 | 2022-11-04 09:54:21 | midgut | 3 | 112716 | 155 | 4.670 | 24136.2 |
287 | 2022-10-31 17:40:32 | midgut | 2 | 82551 | 14 | 2.376 | 34743.7 |
286 | 2022-09-21 19:54:37 | midgut | 1 | 48755 | 3 | 0.736 | 66243.2 |
285 | 2022-08-11 19:54:42 | midgut | 3 | 112716 | 155 | 4.516 | 24959.3 |
284 | 2022-08-05 19:11:45 | midgut | 1 | 48755 | 3 | 0.830 | 58741.0 |
283 | 2022-05-23 18:08:55 | midgut | 2 | 82551 | 14 | 2.106 | 39198.0 |
282 | 2022-05-03 09:53:26 | midgut | 1 | 48755 | 3 | 1.080 | 45143.5 |
281 | 2022-05-01 05:26:08 | midgut | 1 | 48755 | 3 | 0.860 | 56691.9 |
280 | 2022-04-29 01:07:06 | midgut | 1 | 48755 | 3 | 0.970 | 50262.9 |
279 | 2022-03-25 01:47:01 | midgut | 1 | 48755 | 3 | 0.733 | 66514.3 |
278 | 2022-01-18 02:11:02 | midgut | 1 | 48755 | 3 | 0.780 | 62506.4 |
277 | 2021-11-24 08:02:41 | midgut | 1 | 48755 | 3 | 0.766 | 63648.8 |
276 | 2021-11-13 20:04:58 | midgut | 1 | 48755 | 3 | 0.736 | 66243.2 |
275 | 2021-10-20 04:25:57 | midgut | 1 | 48755 | 3 | 0.736 | 66243.2 |
274 | 2021-08-07 22:45:24 | midgut | 1 | 48755 | 3 | 0.810 | 60191.4 |
273 | 2021-05-28 15:10:56 | midgut | 1 | 48755 | 3 | 0.796 | 61250.0 |
272 | 2021-05-13 11:35:16 | midgut | 1 | 48755 | 3 | 0.856 | 56956.8 |
271 | 2021-05-02 21:01:13 | midgut | 1 | 48755 | 3 | 0.830 | 58741.0 |
270 | 2021-04-22 18:58:49 | midgut | 1 | 48755 | 3 | 0.983 | 49598.2 |
269 | 2021-04-01 03:44:41 | midgut | 1 | 48755 | 3 | 0.766 | 63648.8 |
268 | 2021-01-16 03:25:51 | midgut | 1 | 48755 | 3 | 0.846 | 57630.0 |
267 | 2021-01-14 06:14:28 | midgut | 1 | 48755 | 3 | 0.890 | 54780.9 |
266 | 2020-12-17 03:22:14 | midgut | 1 | 48755 | 3 | 0.736 | 66243.2 |
265 | 2020-11-06 17:57:57 | midgut | 1 | 48755 | 3 | 0.953 | 51159.5 |
264 | 2020-10-04 06:48:55 | midgut | 1 | 48755 | 3 | 0.766 | 63648.8 |
263 | 2020-09-11 06:26:52 | midgut | 1 | 48755 | 3 | 0.750 | 65006.7 |
262 | 2020-08-23 04:12:10 | midgut | 1 | 48755 | 3 | 0.750 | 65006.7 |
261 | 2020-07-21 16:17:33 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
260 | 2020-06-13 23:36:29 | midgut | 1 | 48755 | 3 | 0.783 | 62266.9 |
259 | 2020-06-13 21:21:22 | midgut | 1 | 48755 | 3 | 0.750 | 65006.7 |
258 | 2020-03-27 21:12:58 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
257 | 2020-03-26 07:36:24 | midgut | 1 | 48755 | 3 | 0.860 | 56691.9 |
256 | 2020-03-25 02:20:30 | midgut | 1 | 48755 | 3 | 0.860 | 56691.9 |
255 | 2020-03-23 15:57:05 | midgut | 1 | 48755 | 3 | 0.733 | 66514.3 |
254 | 2020-03-23 02:35:23 | midgut | 1 | 48755 | 3 | 0.763 | 63899.1 |
253 | 2020-03-22 12:34:28 | midgut | 1 | 48755 | 3 | 0.766 | 63648.8 |
252 | 2020-03-19 21:41:19 | midgut | 1 | 48755 | 3 | 0.813 | 59969.2 |
251 | 2020-03-19 01:52:31 | midgut | 1 | 48755 | 3 | 0.750 | 65006.7 |
250 | 2020-03-18 23:01:46 | midgut | 1 | 48755 | 3 | 0.766 | 63648.8 |
249 | 2020-03-12 05:50:34 | midgut | 1 | 48755 | 3 | 0.810 | 60191.4 |
248 | 2020-02-28 23:25:57 | midgut | 1 | 48755 | 3 | 2.766 | 17626.5 |
247 | 2020-02-18 09:06:18 | midgut | 1 | 48755 | 3 | 1.953 | 24964.2 |
246 | 2020-02-11 03:06:09 | midgut | 1 | 48755 | 3 | 0.936 | 52088.7 |