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 |
| 403 | 2025-12-04 10:26:39 | biotype | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 402 | 2025-11-29 23:53:41 | biotype | 3 | 134027 | 70 | 17.233 | 7777.3 |
| 401 | 2025-11-28 02:56:15 | biotype | 3 | 134027 | 70 | 23.390 | 5730.1 |
| 400 | 2025-11-21 06:17:20 | biotype | 1 | 69583 | 3 | 3.873 | 17966.2 |
| 399 | 2025-11-01 07:04:01 | biotype | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 398 | 2025-09-30 19:05:53 | biotype | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 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 |