History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lactase"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 371 | 2025-10-04 02:29:49 | lactase | 2 | 107671 | 14 | 3.206 | 33584.2 |
| 370 | 2025-10-02 20:49:21 | lactase | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 369 | 2025-09-29 15:06:45 | lactase | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 368 | 2025-09-18 19:20:55 | lactase | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 367 | 2025-08-27 03:42:56 | lactase | 1 | 69583 | 4 | 6.453 | 10783.0 |
| 366 | 2025-08-23 07:19:51 | lactase | 1 | 69583 | 4 | 3.030 | 22964.7 |
| 365 | 2025-08-15 08:20:50 | lactase | 1 | 69583 | 4 | 4.406 | 15792.8 |
| 364 | 2025-08-15 05:58:14 | lactase | 1 | 69583 | 4 | 2.986 | 23303.1 |
| 363 | 2025-07-31 23:57:50 | lactase | 1 | 69583 | 4 | 8.546 | 8142.2 |
| 362 | 2025-07-27 05:52:07 | lactase | 1 | 69583 | 4 | 2.920 | 23829.8 |
| 361 | 2025-07-27 02:21:10 | lactase | 1 | 69583 | 4 | 4.780 | 14557.1 |
| 360 | 2025-07-24 00:57:50 | lactase | 1 | 69583 | 4 | 6.203 | 11217.6 |
| 359 | 2025-07-22 16:55:48 | lactase | 1 | 69583 | 4 | 5.453 | 12760.5 |
| 358 | 2025-07-18 23:11:56 | lactase | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 357 | 2025-07-17 03:37:50 | lactase | 3 | 134027 | 182 | 31.733 | 4223.6 |
| 356 | 2025-07-14 09:04:52 | lactase | 3 | 134027 | 182 | 38.653 | 3467.4 |
| 355 | 2025-07-14 06:23:26 | lactase | 2 | 107671 | 14 | 14.953 | 7200.6 |
| 354 | 2025-07-13 17:18:41 | lactase | 2 | 107671 | 14 | 3.390 | 31761.4 |
| 353 | 2025-07-13 07:36:17 | lactase | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 352 | 2025-07-07 09:29:49 | lactase | 1 | 69583 | 4 | 3.563 | 19529.3 |
| 351 | 2025-06-30 23:01:57 | lactase | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 350 | 2025-06-25 02:27:29 | lactase | 1 | 69583 | 4 | 4.250 | 16372.5 |
| 349 | 2025-06-21 23:05:03 | lactase | 1 | 69583 | 4 | 2.846 | 24449.4 |
| 348 | 2025-06-17 06:23:19 | lactase | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 347 | 2025-06-12 07:09:36 | lactase | 1 | 69583 | 4 | 3.213 | 21656.7 |
| 346 | 2025-06-07 04:17:32 | lactase | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 345 | 2025-06-04 09:02:40 | lactase | 1 | 69583 | 4 | 5.953 | 11688.7 |
| 344 | 2025-05-10 12:06:28 | lactase | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 343 | 2025-05-10 07:14:41 | lactase | 1 | 69583 | 4 | 3.096 | 22475.1 |
| 342 | 2025-05-04 07:29:25 | lactase | 1 | 69583 | 4 | 4.923 | 14134.3 |
| 341 | 2025-05-02 08:54:14 | lactase | 1 | 69583 | 4 | 5.906 | 11781.7 |
| 340 | 2025-04-27 08:24:23 | lactase | 2 | 107671 | 14 | 3.423 | 31455.2 |
| 339 | 2025-04-26 04:31:43 | lactase | 3 | 134027 | 182 | 38.063 | 3521.2 |
| 338 | 2025-04-23 07:30:39 | lactase | 3 | 134027 | 182 | 31.970 | 4192.3 |
| 337 | 2025-04-23 04:08:48 | lactase | 1 | 69583 | 4 | 5.986 | 11624.3 |
| 336 | 2025-04-22 02:21:51 | lactase | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 335 | 2025-04-22 01:16:21 | lactase | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 334 | 2025-04-19 18:39:17 | lactase | 1 | 69583 | 4 | 1.200 | 57985.8 |
| 333 | 2025-04-18 20:45:10 | lactase | 1 | 69583 | 4 | 6.046 | 11508.9 |
| 332 | 2025-03-31 10:02:16 | lactase | 3 | 134027 | 182 | 33.596 | 3989.4 |
| 331 | 2025-03-31 10:01:13 | lactase | 3 | 134027 | 182 | 28.313 | 4733.8 |
| 330 | 2025-03-31 07:52:38 | lactase | 3 | 134027 | 182 | 19.550 | 6855.6 |
| 329 | 2025-03-31 03:57:03 | lactase | 3 | 134027 | 182 | 32.656 | 4104.2 |
| 328 | 2025-03-29 11:19:43 | lactase | 3 | 134027 | 182 | 26.876 | 4986.9 |
| 327 | 2025-03-26 01:46:35 | lactase | 3 | 134027 | 182 | 37.150 | 3607.7 |
| 326 | 2025-03-25 05:16:07 | lactase | 2 | 107671 | 14 | 24.873 | 4328.8 |
| 325 | 2025-03-24 08:49:59 | lactase | 1 | 69583 | 4 | 7.063 | 9851.8 |
| 324 | 2025-03-23 05:26:48 | lactase | 1 | 69583 | 4 | 5.940 | 11714.3 |
| 323 | 2025-03-22 09:21:45 | lactase | 3 | 134027 | 182 | 36.503 | 3671.7 |
| 322 | 2025-03-22 07:03:05 | lactase | 2 | 107671 | 14 | 15.016 | 7170.4 |
| 321 | 2025-03-20 04:06:29 | lactase | 1 | 69583 | 4 | 3.063 | 22717.3 |
| 320 | 2025-03-16 02:34:38 | lactase | 1 | 69583 | 4 | 7.936 | 8768.0 |
| 319 | 2025-03-11 17:36:53 | lactase | 1 | 69583 | 4 | 6.393 | 10884.2 |
| 318 | 2025-03-03 00:23:27 | lactase | 1 | 69583 | 4 | 9.266 | 7509.5 |
| 317 | 2025-03-01 01:50:34 | lactase | 3 | 134027 | 182 | 35.750 | 3749.0 |
| 316 | 2025-02-26 16:40:59 | lactase | 3 | 134027 | 182 | 20.216 | 6629.7 |
| 315 | 2025-02-24 11:19:46 | lactase | 3 | 134027 | 182 | 34.863 | 3844.4 |
| 314 | 2025-02-23 14:04:26 | lactase | 1 | 69583 | 4 | 3.373 | 20629.4 |
| 313 | 2025-02-23 00:10:41 | lactase | 3 | 134027 | 182 | 27.416 | 4888.6 |
| 312 | 2025-02-20 21:24:37 | lactase | 3 | 134027 | 182 | 24.420 | 5488.4 |
| 311 | 2025-02-20 21:00:45 | lactase | 3 | 134027 | 182 | 28.236 | 4746.7 |
| 310 | 2025-02-08 08:40:44 | lactase | 1 | 69583 | 4 | 5.830 | 11935.3 |
| 309 | 2025-02-04 19:30:12 | lactase | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 308 | 2025-01-15 01:47:57 | lactase | 3 | 134027 | 182 | 35.660 | 3758.5 |
| 307 | 2025-01-13 09:13:38 | lactase | 3 | 134027 | 182 | 35.460 | 3779.7 |
| 306 | 2025-01-11 11:47:22 | lactase | 3 | 134027 | 182 | 45.816 | 2925.3 |
| 305 | 2025-01-07 15:15:21 | lactase | 3 | 134027 | 182 | 31.173 | 4299.5 |
| 304 | 2025-01-07 15:15:24 | lactase | 2 | 107671 | 14 | 18.766 | 5737.6 |
| 303 | 2025-01-07 15:14:43 | lactase | 1 | 69583 | 4 | 5.190 | 13407.1 |
| 302 | 2025-01-05 11:11:15 | lactase | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 301 | 2025-01-04 22:37:30 | lactase | 1 | 69583 | 4 | 6.313 | 11022.2 |
| 300 | 2024-12-28 23:48:23 | lactase | 1 | 69583 | 4 | 5.856 | 11882.3 |
| 299 | 2024-11-29 09:52:36 | lactase | 1 | 69583 | 4 | 3.623 | 19205.9 |
| 298 | 2024-11-28 06:20:13 | lactase | 1 | 69583 | 4 | 7.406 | 9395.5 |
| 297 | 2024-10-06 01:30:19 | lactase | 2 | 107671 | 14 | 12.716 | 8467.4 |
| 296 | 2024-09-29 04:53:43 | lactase | 2 | 107671 | 14 | 25.783 | 4176.0 |
| 295 | 2024-09-27 23:36:11 | lactase | 3 | 134027 | 182 | 65.800 | 2036.9 |
| 294 | 2024-09-27 16:43:34 | lactase | 3 | 134027 | 182 | 30.393 | 4409.8 |
| 293 | 2024-09-27 08:12:45 | lactase | 3 | 134027 | 182 | 38.593 | 3472.8 |
| 292 | 2024-09-27 04:18:26 | lactase | 3 | 134027 | 182 | 42.503 | 3153.4 |
| 291 | 2024-09-27 04:18:26 | lactase | 2 | 107671 | 14 | 26.016 | 4138.6 |
| 290 | 2024-09-27 04:18:13 | lactase | 1 | 69583 | 4 | 4.123 | 16876.8 |
| 289 | 2024-09-20 18:50:31 | lactase | 1 | 69583 | 4 | 9.296 | 7485.3 |
| 288 | 2024-09-16 00:21:53 | lactase | 1 | 69583 | 4 | 4.453 | 15626.1 |
| 287 | 2024-09-13 22:37:53 | lactase | 1 | 69583 | 4 | 9.000 | 7731.4 |
| 286 | 2024-08-31 18:01:55 | lactase | 1 | 69583 | 4 | 9.796 | 7103.2 |
| 285 | 2024-08-31 18:01:44 | lactase | 1 | 69583 | 4 | 9.220 | 7547.0 |
| 284 | 2024-08-16 17:16:31 | lactase | 1 | 69583 | 4 | 8.830 | 7880.3 |
| 283 | 2024-08-14 17:36:43 | lactase | 1 | 69583 | 4 | 3.923 | 17737.2 |
| 282 | 2024-08-11 19:15:23 | lactase | 3 | 134027 | 182 | 28.250 | 4744.3 |
| 281 | 2024-08-11 07:40:32 | lactase | 3 | 134027 | 182 | 25.766 | 5201.7 |
| 280 | 2024-08-09 04:40:40 | lactase | 3 | 134027 | 182 | 40.163 | 3337.1 |
| 279 | 2024-08-07 06:23:26 | lactase | 3 | 134027 | 182 | 22.953 | 5839.2 |
| 278 | 2024-08-04 18:18:50 | lactase | 3 | 134027 | 182 | 37.270 | 3596.1 |
| 277 | 2024-08-04 18:18:50 | lactase | 2 | 107671 | 14 | 9.173 | 11737.8 |
| 276 | 2024-08-04 18:18:40 | lactase | 1 | 69583 | 4 | 2.593 | 26834.9 |
| 275 | 2024-07-24 15:50:22 | lactase | 1 | 69583 | 4 | 2.440 | 28517.6 |
| 274 | 2024-07-13 10:08:40 | lactase | 1 | 69583 | 4 | 4.360 | 15959.4 |
| 273 | 2024-07-12 10:20:10 | lactase | 1 | 69583 | 4 | 5.533 | 12576.0 |
| 272 | 2024-07-01 21:58:32 | lactase | 3 | 134027 | 182 | 24.080 | 5565.9 |