History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"microbes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 375 | 2024-04-30 22:28:02 | microbes | 3 | 146162 | 112 | 7.233 | 20207.7 |
| 374 | 2024-04-20 06:18:16 | microbes | 2 | 121059 | 16 | 4.516 | 26806.7 |
| 373 | 2024-04-18 23:30:11 | microbes | 2 | 121059 | 16 | 10.110 | 11974.2 |
| 372 | 2024-04-18 23:11:02 | microbes | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 371 | 2024-04-15 16:39:06 | microbes | 2 | 121059 | 16 | 8.673 | 13958.1 |
| 370 | 2024-04-15 16:38:33 | microbes | 3 | 146162 | 112 | 7.906 | 18487.5 |
| 369 | 2024-04-12 00:04:14 | microbes | 3 | 146162 | 112 | 18.266 | 8001.9 |
| 368 | 2024-04-10 22:57:41 | microbes | 3 | 146162 | 112 | 9.220 | 15852.7 |
| 367 | 2024-04-10 13:29:08 | microbes | 3 | 146162 | 112 | 9.843 | 14849.3 |
| 366 | 2024-04-09 18:40:08 | microbes | 3 | 146162 | 112 | 14.716 | 9932.2 |
| 365 | 2024-04-09 18:40:11 | microbes | 2 | 121059 | 16 | 4.393 | 27557.3 |
| 364 | 2024-04-09 18:40:07 | microbes | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 363 | 2024-04-05 19:05:47 | microbes | 1 | 82945 | 3 | 3.813 | 21753.2 |
| 362 | 2024-03-31 04:28:31 | microbes | 1 | 82945 | 3 | 3.500 | 23698.6 |
| 361 | 2024-03-06 20:40:21 | microbes | 1 | 82945 | 3 | 3.250 | 25521.5 |
| 360 | 2024-03-05 06:48:05 | microbes | 2 | 121059 | 16 | 12.906 | 9380.1 |
| 359 | 2024-03-05 06:41:26 | microbes | 1 | 82945 | 3 | 2.376 | 34909.5 |
| 358 | 2024-03-03 09:38:07 | microbes | 2 | 121059 | 16 | 3.623 | 33414.0 |
| 357 | 2024-03-01 17:09:06 | microbes | 3 | 146162 | 112 | 8.673 | 16852.5 |
| 356 | 2024-02-27 17:40:01 | microbes | 3 | 146162 | 112 | 8.233 | 17753.2 |
| 355 | 2024-02-27 17:40:00 | microbes | 2 | 121059 | 16 | 5.686 | 21290.7 |
| 354 | 2024-02-27 17:39:56 | microbes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 353 | 2024-02-09 19:51:04 | microbes | 3 | 146162 | 112 | 10.953 | 13344.5 |
| 352 | 2024-02-05 13:32:22 | microbes | 3 | 146162 | 112 | 7.376 | 19815.9 |
| 351 | 2024-02-03 00:20:35 | microbes | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 350 | 2024-02-02 19:54:49 | microbes | 2 | 121059 | 16 | 3.796 | 31891.2 |
| 349 | 2024-01-29 12:15:13 | microbes | 3 | 146162 | 112 | 14.940 | 9783.3 |
| 348 | 2024-01-27 01:28:11 | microbes | 2 | 121059 | 16 | 3.516 | 34430.9 |
| 347 | 2024-01-27 01:23:43 | microbes | 3 | 146162 | 112 | 7.206 | 20283.4 |
| 346 | 2024-01-26 13:38:03 | microbes | 3 | 146162 | 112 | 8.780 | 16647.2 |
| 345 | 2024-01-17 01:28:04 | microbes | 3 | 146162 | 112 | 6.220 | 23498.7 |
| 344 | 2024-01-16 13:44:48 | microbes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 343 | 2024-01-14 12:45:45 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 342 | 2023-12-24 20:33:31 | microbes | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 341 | 2023-12-21 21:39:24 | microbes | 3 | 146162 | 112 | 7.483 | 19532.5 |
| 340 | 2023-12-21 19:14:21 | microbes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 339 | 2023-12-08 08:18:11 | microbes | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 338 | 2023-11-19 20:01:36 | microbes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 337 | 2023-11-13 00:19:18 | microbes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 336 | 2023-10-27 16:28:21 | microbes | 3 | 146162 | 112 | 9.610 | 15209.4 |
| 335 | 2023-10-25 15:47:43 | microbes | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 334 | 2023-10-22 00:30:19 | microbes | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 333 | 2023-09-01 11:56:55 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 332 | 2023-08-05 11:04:19 | microbes | 3 | 146162 | 112 | 6.906 | 21164.5 |
| 331 | 2023-07-05 04:06:49 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 330 | 2023-06-06 04:36:47 | microbes | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 329 | 2023-04-19 11:41:27 | microbes | 3 | 146162 | 112 | 6.046 | 24175.0 |
| 328 | 2023-03-27 01:48:54 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 327 | 2023-03-24 23:59:33 | microbes | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 326 | 2023-01-22 01:02:05 | microbes | 3 | 146162 | 112 | 6.110 | 23921.8 |
| 325 | 2023-01-11 00:24:17 | microbes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 324 | 2022-12-06 21:14:37 | microbes | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 323 | 2022-11-01 20:39:15 | microbes | 3 | 146162 | 112 | 6.093 | 23988.5 |
| 322 | 2022-10-17 11:59:38 | microbes | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 321 | 2022-08-03 07:46:00 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 320 | 2022-07-27 00:28:24 | microbes | 2 | 121059 | 16 | 3.170 | 38189.0 |
| 319 | 2022-06-14 11:52:42 | microbes | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 318 | 2022-06-06 16:37:27 | microbes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 317 | 2022-06-04 13:29:57 | microbes | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 316 | 2022-06-04 12:26:06 | microbes | 3 | 146162 | 112 | 6.186 | 23627.9 |
| 315 | 2022-04-05 08:20:35 | microbes | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 314 | 2022-04-01 21:26:02 | microbes | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 313 | 2022-02-16 13:03:33 | microbes | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 312 | 2022-02-14 08:44:58 | microbes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 311 | 2021-12-21 12:00:32 | microbes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 310 | 2021-12-10 01:21:11 | microbes | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 309 | 2021-10-19 08:59:48 | microbes | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 308 | 2021-09-14 07:01:13 | microbes | 1 | 82945 | 3 | 3.533 | 23477.2 |
| 307 | 2021-09-11 01:53:49 | microbes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 306 | 2021-09-09 07:09:39 | microbes | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 305 | 2021-09-07 02:50:09 | microbes | 1 | 82945 | 3 | 1.216 | 68211.3 |
| 304 | 2021-06-10 05:00:20 | microbes | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 303 | 2021-05-20 21:53:09 | microbes | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 302 | 2021-04-21 07:11:41 | microbes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 301 | 2021-03-07 18:40:10 | microbes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 300 | 2021-02-02 06:19:10 | microbes | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 299 | 2021-01-06 02:06:38 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 298 | 2020-12-08 15:10:48 | microbes | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 297 | 2020-12-04 00:23:07 | microbes | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 296 | 2020-11-02 00:15:57 | microbes | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 295 | 2020-10-15 02:14:48 | microbes | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 294 | 2020-10-09 00:09:53 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 293 | 2020-09-19 00:42:07 | microbes | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 292 | 2020-09-01 14:10:58 | microbes | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 291 | 2020-08-02 07:05:22 | microbes | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 290 | 2020-06-02 23:49:37 | microbes | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 289 | 2020-05-30 21:13:17 | microbes | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 288 | 2020-03-26 07:57:48 | microbes | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 287 | 2020-03-21 08:16:36 | microbes | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 286 | 2020-02-24 11:58:29 | microbes | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 285 | 2020-02-24 01:28:35 | microbes | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 284 | 2020-02-21 02:44:50 | microbes | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 283 | 2020-02-12 01:47:07 | microbes | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 282 | 2020-02-08 02:59:54 | microbes | 3 | 146162 | 112 | 10.173 | 14367.6 |
| 281 | 2020-02-05 13:57:56 | microbes | 1 | 82945 | 3 | 1.643 | 50483.9 |
| 280 | 2020-02-02 22:28:43 | microbes | 1 | 82945 | 3 | 1.893 | 43816.7 |
| 279 | 2020-01-31 01:24:41 | microbes | 1 | 82945 | 3 | 3.156 | 26281.7 |
| 278 | 2020-01-27 23:09:06 | microbes | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 277 | 2020-01-22 14:31:01 | microbes | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 276 | 2020-01-21 22:03:12 | microbes | 3 | 146162 | 112 | 6.156 | 23743.0 |