History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lancing"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 413 | 2024-12-15 14:28:29 | lancing | 1 | 69583 | 5 | 5.750 | 12101.4 |
| 412 | 2024-12-15 05:31:17 | lancing | 1 | 69583 | 5 | 8.983 | 7746.1 |
| 411 | 2024-11-18 04:14:51 | lancing | 1 | 69583 | 5 | 3.983 | 17470.0 |
| 410 | 2024-11-14 13:39:59 | lancing | 2 | 107671 | 118 | 3.656 | 29450.5 |
| 409 | 2024-11-13 11:21:17 | lancing | 1 | 69583 | 5 | 3.703 | 18791.0 |
| 408 | 2024-11-12 14:29:16 | lancing | 2 | 107671 | 118 | 17.423 | 6179.8 |
| 407 | 2024-11-12 11:20:55 | lancing | 1 | 69583 | 5 | 10.030 | 6937.5 |
| 406 | 2024-11-12 09:52:07 | lancing | 2 | 107671 | 118 | 17.016 | 6327.6 |
| 405 | 2024-11-11 07:34:34 | lancing | 2 | 107671 | 118 | 3.186 | 33795.0 |
| 404 | 2024-11-11 03:42:31 | lancing | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 403 | 2024-10-26 08:06:37 | lancing | 1 | 69583 | 5 | 3.390 | 20526.0 |
| 402 | 2024-10-24 22:07:42 | lancing | 1 | 69583 | 5 | 2.780 | 25029.9 |
| 401 | 2024-10-14 00:47:57 | lancing | 1 | 69583 | 5 | 7.453 | 9336.2 |
| 400 | 2024-10-13 06:12:09 | lancing | 1 | 69583 | 5 | 5.563 | 12508.2 |
| 399 | 2024-10-11 17:55:50 | lancing | 1 | 69583 | 5 | 5.220 | 13330.1 |
| 398 | 2024-09-15 17:31:20 | lancing | 1 | 69583 | 5 | 9.473 | 7345.4 |
| 397 | 2024-09-11 17:25:39 | lancing | 1 | 69583 | 5 | 8.266 | 8418.0 |
| 396 | 2024-09-10 23:13:11 | lancing | 1 | 69583 | 5 | 9.483 | 7337.7 |
| 395 | 2024-09-08 19:37:52 | lancing | 1 | 69583 | 5 | 6.313 | 11022.2 |
| 394 | 2024-08-20 15:28:23 | lancing | 1 | 69583 | 5 | 8.233 | 8451.7 |
| 393 | 2024-08-16 05:58:17 | lancing | 1 | 69583 | 5 | 4.733 | 14701.7 |
| 392 | 2024-08-11 14:30:43 | lancing | 1 | 69583 | 5 | 4.186 | 16622.8 |
| 391 | 2024-08-02 01:02:28 | lancing | 1 | 69583 | 5 | 2.876 | 24194.4 |
| 390 | 2024-07-31 15:35:18 | lancing | 1 | 69583 | 5 | 4.576 | 15206.1 |
| 389 | 2024-07-08 12:42:57 | lancing | 1 | 69583 | 5 | 4.466 | 15580.6 |
| 388 | 2024-07-03 09:49:11 | lancing | 1 | 69583 | 5 | 6.500 | 10705.1 |
| 387 | 2024-07-02 00:44:32 | lancing | 1 | 69583 | 5 | 4.626 | 15041.7 |
| 386 | 2024-07-01 08:15:01 | lancing | 1 | 69583 | 5 | 6.093 | 11420.2 |
| 385 | 2024-06-26 02:40:33 | lancing | 1 | 69583 | 5 | 4.420 | 15742.8 |
| 384 | 2024-06-15 02:12:04 | lancing | 1 | 69583 | 5 | 4.233 | 16438.2 |
| 383 | 2024-06-13 00:31:23 | lancing | 1 | 69583 | 5 | 4.983 | 13964.1 |
| 382 | 2024-05-28 08:48:46 | lancing | 1 | 69583 | 5 | 4.326 | 16084.8 |
| 381 | 2024-05-11 22:05:42 | lancing | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 380 | 2024-04-14 10:54:33 | lancing | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 379 | 2024-03-31 12:08:47 | lancing | 1 | 69583 | 5 | 1.530 | 45479.1 |
| 378 | 2024-02-26 16:32:06 | lancing | 1 | 69583 | 5 | 2.716 | 25619.7 |
| 377 | 2024-01-21 12:54:17 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 376 | 2023-12-19 12:33:32 | lancing | 2 | 107671 | 118 | 3.186 | 33795.0 |
| 375 | 2023-11-30 20:19:35 | lancing | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 374 | 2023-11-29 13:07:46 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 373 | 2023-11-22 10:21:46 | lancing | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 372 | 2023-11-18 22:22:05 | lancing | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 371 | 2023-11-11 17:30:21 | lancing | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 370 | 2023-10-29 11:47:46 | lancing | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 369 | 2023-10-27 07:18:46 | lancing | 1 | 69583 | 5 | 1.653 | 42095.0 |
| 368 | 2023-10-06 21:53:46 | lancing | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 367 | 2023-09-23 05:14:27 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 366 | 2023-09-11 10:47:10 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 365 | 2023-09-06 17:20:41 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 364 | 2023-08-06 01:18:35 | lancing | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 363 | 2023-06-14 04:41:11 | lancing | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 362 | 2023-04-28 12:18:02 | lancing | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 361 | 2023-04-24 20:01:39 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 360 | 2023-04-02 15:19:39 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 359 | 2023-01-16 21:58:16 | lancing | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 358 | 2023-01-16 04:21:38 | lancing | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 357 | 2022-12-05 19:33:40 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 356 | 2022-11-13 18:39:37 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 355 | 2022-10-02 04:10:47 | lancing | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 354 | 2022-09-20 02:46:21 | lancing | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 353 | 2022-08-14 21:57:20 | lancing | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 352 | 2022-07-29 06:08:58 | lancing | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 351 | 2022-07-06 12:15:03 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 350 | 2022-06-15 04:33:50 | lancing | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 349 | 2022-03-22 11:08:30 | lancing | 1 | 69583 | 5 | 1.453 | 47889.2 |
| 348 | 2022-03-03 08:33:35 | lancing | 1 | 69583 | 5 | 1.160 | 59985.3 |
| 347 | 2022-02-28 11:18:01 | lancing | 1 | 69583 | 5 | 1.623 | 42873.1 |
| 346 | 2021-12-19 12:24:08 | lancing | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 345 | 2021-12-17 11:00:09 | lancing | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 344 | 2021-11-23 03:47:35 | lancing | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 343 | 2021-11-01 23:03:42 | lancing | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 342 | 2021-10-24 12:51:29 | lancing | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 341 | 2021-09-12 14:07:30 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 340 | 2021-08-25 23:08:52 | lancing | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 339 | 2021-08-23 13:26:00 | lancing | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 338 | 2021-06-16 18:20:40 | lancing | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 337 | 2021-06-15 18:27:26 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 336 | 2021-06-14 00:43:50 | lancing | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 335 | 2021-05-31 18:13:22 | lancing | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 334 | 2021-05-22 20:31:47 | lancing | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 333 | 2021-05-06 12:21:56 | lancing | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 332 | 2021-04-23 16:19:14 | lancing | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 331 | 2021-04-22 14:48:14 | lancing | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 330 | 2021-04-04 17:58:30 | lancing | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 329 | 2021-02-16 11:25:47 | lancing | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 328 | 2021-02-12 22:52:19 | lancing | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 327 | 2020-12-20 16:30:03 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 326 | 2020-12-09 16:12:50 | lancing | 2 | 107671 | 118 | 2.903 | 37089.6 |
| 325 | 2020-11-14 18:28:26 | lancing | 2 | 107671 | 118 | 2.936 | 36672.7 |
| 324 | 2020-11-12 05:11:18 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 323 | 2020-11-05 13:07:36 | lancing | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 322 | 2020-11-01 19:17:23 | lancing | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 321 | 2020-10-29 12:45:03 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 320 | 2020-10-24 16:04:57 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 319 | 2020-10-23 11:01:17 | lancing | 2 | 107671 | 118 | 3.233 | 33303.7 |
| 318 | 2020-10-10 20:52:36 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 317 | 2020-08-18 14:09:33 | lancing | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 316 | 2020-08-11 16:48:16 | lancing | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 315 | 2020-05-26 08:36:00 | lancing | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 314 | 2020-05-13 11:44:26 | lancing | 1 | 69583 | 5 | 1.190 | 58473.1 |