History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biotype"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
397 | 2025-09-04 21:39:43 | biotype | 1 | 69583 | 3 | 1.110 | 62687.4 |
396 | 2025-08-19 11:24:46 | biotype | 1 | 69583 | 3 | 3.220 | 21609.6 |
395 | 2025-08-12 18:08:43 | biotype | 1 | 69583 | 3 | 2.906 | 23944.6 |
394 | 2025-08-09 16:11:40 | biotype | 1 | 69583 | 3 | 7.283 | 9554.2 |
393 | 2025-08-03 22:25:20 | biotype | 1 | 69583 | 3 | 2.470 | 28171.3 |
392 | 2025-08-01 20:48:23 | biotype | 3 | 134027 | 70 | 38.736 | 3460.0 |
391 | 2025-07-31 21:37:49 | biotype | 1 | 69583 | 3 | 2.796 | 24886.6 |
390 | 2025-07-28 03:11:47 | biotype | 3 | 134027 | 70 | 17.596 | 7616.9 |
389 | 2025-07-27 07:53:53 | biotype | 3 | 134027 | 70 | 49.423 | 2711.8 |
388 | 2025-07-27 07:53:49 | biotype | 3 | 134027 | 70 | 28.283 | 4738.8 |
387 | 2025-07-25 10:49:16 | biotype | 3 | 134027 | 70 | 21.063 | 6363.1 |
386 | 2025-07-25 06:25:20 | biotype | 1 | 69583 | 3 | 4.313 | 16133.3 |
385 | 2025-07-20 08:23:37 | biotype | 3 | 134027 | 70 | 8.656 | 15483.7 |
384 | 2025-07-07 18:15:16 | biotype | 1 | 69583 | 3 | 1.220 | 57035.2 |
383 | 2025-07-07 07:51:08 | biotype | 1 | 69583 | 3 | 3.373 | 20629.4 |
382 | 2025-07-05 15:29:07 | biotype | 1 | 69583 | 3 | 3.003 | 23171.2 |
381 | 2025-07-04 21:25:13 | biotype | 1 | 69583 | 3 | 3.030 | 22964.7 |
380 | 2025-07-04 09:55:43 | biotype | 1 | 69583 | 3 | 3.843 | 18106.4 |
379 | 2025-06-29 05:05:07 | biotype | 1 | 69583 | 3 | 1.233 | 56433.9 |
378 | 2025-05-28 20:51:15 | biotype | 1 | 69583 | 3 | 8.500 | 8186.2 |
377 | 2025-05-27 06:03:58 | biotype | 3 | 134027 | 70 | 26.360 | 5084.5 |
376 | 2025-05-22 15:21:40 | biotype | 1 | 69583 | 3 | 5.873 | 11847.9 |
375 | 2025-05-15 16:24:00 | biotype | 1 | 69583 | 3 | 2.486 | 27989.9 |
374 | 2025-05-14 03:30:34 | biotype | 3 | 134027 | 70 | 44.530 | 3009.8 |
373 | 2025-05-10 05:18:39 | biotype | 3 | 134027 | 70 | 27.923 | 4799.9 |
372 | 2025-05-02 07:03:16 | biotype | 1 | 69583 | 3 | 5.640 | 12337.4 |
371 | 2025-04-30 22:19:23 | biotype | 3 | 134027 | 70 | 31.573 | 4245.0 |
370 | 2025-04-30 17:33:49 | biotype | 3 | 134027 | 70 | 26.610 | 5036.7 |
369 | 2025-04-28 11:38:31 | biotype | 3 | 134027 | 70 | 25.440 | 5268.4 |
368 | 2025-04-24 00:24:42 | biotype | 3 | 134027 | 70 | 26.440 | 5069.1 |
367 | 2025-04-23 21:26:38 | biotype | 3 | 134027 | 70 | 39.290 | 3411.2 |
366 | 2025-04-22 14:09:56 | biotype | 1 | 69583 | 3 | 1.250 | 55666.4 |
365 | 2025-04-17 20:48:58 | biotype | 1 | 69583 | 3 | 2.716 | 25619.7 |
364 | 2025-04-16 11:01:22 | biotype | 1 | 69583 | 3 | 2.920 | 23829.8 |
363 | 2025-03-31 09:05:15 | biotype | 1 | 69583 | 3 | 8.953 | 7772.0 |
362 | 2025-03-24 02:31:47 | biotype | 3 | 134027 | 70 | 31.316 | 4279.8 |
361 | 2025-03-22 04:14:39 | biotype | 3 | 134027 | 70 | 21.656 | 6188.9 |
360 | 2025-03-21 04:14:18 | biotype | 3 | 134027 | 70 | 33.456 | 4006.1 |
359 | 2025-03-20 16:18:46 | biotype | 1 | 69583 | 3 | 3.673 | 18944.5 |
358 | 2025-03-19 12:05:01 | biotype | 3 | 134027 | 70 | 6.013 | 22289.5 |
357 | 2025-03-17 05:38:39 | biotype | 1 | 69583 | 3 | 8.610 | 8081.6 |
356 | 2025-03-04 19:18:02 | biotype | 2 | 107671 | 14 | 16.203 | 6645.1 |
355 | 2025-03-03 14:18:06 | biotype | 2 | 107671 | 14 | 24.360 | 4420.0 |
354 | 2025-02-24 19:25:18 | biotype | 2 | 107671 | 14 | 23.186 | 4643.8 |
353 | 2025-02-24 17:54:23 | biotype | 1 | 69583 | 3 | 5.580 | 12470.1 |
352 | 2025-02-21 03:10:43 | biotype | 3 | 134027 | 70 | 33.770 | 3968.8 |
351 | 2025-02-21 03:10:32 | biotype | 2 | 107671 | 14 | 9.940 | 10832.1 |
350 | 2025-02-21 03:09:40 | biotype | 1 | 69583 | 3 | 5.670 | 12272.1 |
349 | 2025-02-20 17:00:10 | biotype | 3 | 134027 | 70 | 34.470 | 3888.2 |
348 | 2025-02-18 06:53:27 | biotype | 3 | 134027 | 70 | 27.890 | 4805.6 |
347 | 2025-02-13 11:10:28 | biotype | 3 | 134027 | 70 | 36.046 | 3718.2 |
346 | 2025-02-13 11:09:18 | biotype | 2 | 107671 | 14 | 14.800 | 7275.1 |
345 | 2025-02-13 11:09:08 | biotype | 1 | 69583 | 3 | 1.313 | 52995.4 |
344 | 2025-02-12 16:06:54 | biotype | 1 | 69583 | 3 | 5.610 | 12403.4 |
343 | 2025-02-10 15:12:20 | biotype | 1 | 69583 | 3 | 9.280 | 7498.2 |
342 | 2025-02-04 15:55:42 | biotype | 4 | 151207 | 756 | 59.883 | 2525.0 |
341 | 2025-02-04 10:10:49 | biotype | 4 | 151207 | 756 | 55.226 | 2738.0 |
340 | 2025-02-04 08:39:46 | biotype | 4 | 151207 | 756 | 69.600 | 2172.5 |
339 | 2025-02-04 05:12:31 | biotype | 4 | 151207 | 756 | 49.156 | 3076.1 |
338 | 2025-02-04 05:09:06 | biotype | 4 | 151207 | 756 | 11.143 | 13569.7 |
337 | 2025-01-27 17:49:39 | biotype | 1 | 69583 | 3 | 8.843 | 7868.7 |
336 | 2025-01-25 17:18:56 | biotype | 1 | 69583 | 3 | 6.330 | 10992.6 |
335 | 2025-01-10 14:21:53 | biotype | 1 | 69583 | 3 | 2.986 | 23303.1 |
334 | 2025-01-06 17:23:38 | biotype | 2 | 107671 | 14 | 3.140 | 34290.1 |
333 | 2024-12-26 06:47:09 | biotype | 1 | 69583 | 3 | 5.156 | 13495.5 |
332 | 2024-12-18 11:56:27 | biotype | 2 | 107671 | 14 | 18.830 | 5718.1 |
331 | 2024-12-15 17:23:45 | biotype | 3 | 134027 | 70 | 11.686 | 11469.0 |
330 | 2024-12-15 16:11:28 | biotype | 3 | 134027 | 70 | 24.943 | 5373.3 |
329 | 2024-12-15 16:11:00 | biotype | 2 | 107671 | 14 | 13.656 | 7884.5 |
328 | 2024-12-09 19:21:22 | biotype | 1 | 69583 | 3 | 3.046 | 22844.1 |
327 | 2024-12-09 14:30:10 | biotype | 3 | 134027 | 70 | 29.426 | 4554.7 |
326 | 2024-12-09 14:30:07 | biotype | 2 | 107671 | 14 | 17.233 | 6248.0 |
325 | 2024-12-09 14:30:02 | biotype | 3 | 134027 | 70 | 18.143 | 7387.3 |
324 | 2024-12-09 14:29:46 | biotype | 1 | 69583 | 3 | 9.626 | 7228.7 |
323 | 2024-12-04 08:08:20 | biotype | 1 | 69583 | 3 | 5.826 | 11943.5 |
322 | 2024-11-15 22:54:07 | biotype | 1 | 69583 | 3 | 3.703 | 18791.0 |
321 | 2024-11-09 11:26:40 | biotype | 1 | 69583 | 3 | 4.796 | 14508.5 |
320 | 2024-11-07 22:47:42 | biotype | 1 | 69583 | 3 | 5.796 | 12005.3 |
319 | 2024-10-12 15:54:12 | biotype | 1 | 69583 | 3 | 6.360 | 10940.7 |
318 | 2024-10-10 10:09:52 | biotype | 1 | 69583 | 3 | 5.953 | 11688.7 |
317 | 2024-09-30 17:27:17 | biotype | 1 | 69583 | 3 | 7.593 | 9164.1 |
316 | 2024-09-29 12:04:56 | biotype | 1 | 69583 | 3 | 9.640 | 7218.2 |
315 | 2024-09-27 22:33:05 | biotype | 3 | 134027 | 70 | 33.766 | 3969.3 |
314 | 2024-09-22 20:20:48 | biotype | 3 | 134027 | 70 | 39.970 | 3353.2 |
313 | 2024-09-22 19:12:35 | biotype | 3 | 134027 | 70 | 39.080 | 3429.6 |
312 | 2024-09-22 13:26:20 | biotype | 3 | 134027 | 70 | 54.463 | 2460.9 |
311 | 2024-09-01 08:44:25 | biotype | 1 | 69583 | 3 | 10.360 | 6716.5 |
310 | 2024-08-25 17:25:07 | biotype | 1 | 69583 | 3 | 1.203 | 57841.2 |
309 | 2024-08-20 22:44:18 | biotype | 3 | 134027 | 70 | 50.473 | 2655.4 |
308 | 2024-08-19 21:40:33 | biotype | 3 | 134027 | 70 | 72.766 | 1841.9 |
307 | 2024-08-19 17:37:30 | biotype | 3 | 134027 | 70 | 55.296 | 2423.8 |
306 | 2024-08-19 12:29:51 | biotype | 2 | 107671 | 14 | 16.016 | 6722.7 |
305 | 2024-08-19 12:29:42 | biotype | 1 | 69583 | 3 | 4.343 | 16021.9 |
304 | 2024-08-13 07:58:23 | biotype | 3 | 134027 | 70 | 28.343 | 4728.8 |
303 | 2024-08-08 02:20:11 | biotype | 3 | 134027 | 70 | 26.453 | 5066.6 |
302 | 2024-08-07 06:34:07 | biotype | 4 | 151207 | 756 | 22.250 | 6795.8 |
301 | 2024-08-06 18:40:00 | biotype | 2 | 107671 | 14 | 4.893 | 22005.1 |
300 | 2024-08-06 18:39:41 | biotype | 4 | 151207 | 756 | 19.330 | 7822.4 |
299 | 2024-08-06 18:39:39 | biotype | 3 | 134027 | 70 | 21.050 | 6367.1 |
298 | 2024-08-06 17:29:22 | biotype | 4 | 151207 | 756 | 34.940 | 4327.6 |