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 |
| 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 |
| 313 | 2020-03-29 02:21:52 | lancing | 1 | 69583 | 5 | 2.640 | 26357.2 |
| 312 | 2020-03-26 14:36:29 | lancing | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 311 | 2020-03-22 20:40:08 | lancing | 1 | 69583 | 5 | 1.453 | 47889.2 |
| 310 | 2020-03-20 21:27:49 | lancing | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 309 | 2020-03-11 02:26:38 | lancing | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 308 | 2020-03-03 05:45:19 | lancing | 2 | 107671 | 118 | 3.563 | 30219.2 |
| 307 | 2020-03-02 21:58:27 | lancing | 2 | 107671 | 118 | 3.733 | 28843.0 |
| 306 | 2020-03-01 00:27:56 | lancing | 2 | 107671 | 118 | 3.343 | 32207.9 |
| 305 | 2020-02-29 14:46:17 | lancing | 2 | 107671 | 118 | 7.546 | 14268.6 |
| 304 | 2020-02-28 21:23:50 | lancing | 2 | 107671 | 118 | 4.000 | 26917.8 |
| 303 | 2020-02-22 19:03:44 | lancing | 1 | 69583 | 5 | 4.030 | 17266.3 |
| 302 | 2020-02-19 15:44:51 | lancing | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 301 | 2020-02-18 03:40:02 | lancing | 1 | 69583 | 5 | 2.860 | 24329.7 |
| 300 | 2020-02-10 21:08:58 | lancing | 1 | 69583 | 5 | 3.546 | 19623.0 |
| 299 | 2020-02-04 04:52:52 | lancing | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 298 | 2020-02-03 22:08:58 | lancing | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 297 | 2020-02-03 16:40:24 | lancing | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 296 | 2020-02-01 02:53:38 | lancing | 1 | 69583 | 5 | 2.766 | 25156.5 |
| 295 | 2020-01-30 07:33:26 | lancing | 1 | 69583 | 5 | 2.063 | 33729.0 |
| 294 | 2020-01-26 20:06:48 | lancing | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 293 | 2020-01-24 00:46:47 | lancing | 1 | 69583 | 5 | 2.936 | 23699.9 |
| 292 | 2020-01-15 20:04:16 | lancing | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 291 | 2020-01-15 00:49:43 | lancing | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 290 | 2020-01-14 22:11:31 | lancing | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 289 | 2020-01-12 06:21:12 | lancing | 2 | 107671 | 118 | 6.280 | 17145.1 |
| 288 | 2020-01-12 05:24:11 | lancing | 2 | 107671 | 118 | 2.923 | 36835.8 |
| 287 | 2020-01-11 22:45:02 | lancing | 2 | 107671 | 118 | 3.626 | 29694.2 |
| 286 | 2020-01-11 21:43:31 | lancing | 2 | 107671 | 118 | 4.346 | 24774.7 |
| 285 | 2020-01-11 13:39:41 | lancing | 2 | 107671 | 118 | 4.126 | 26095.7 |
| 284 | 2020-01-11 11:35:46 | lancing | 1 | 69583 | 5 | 1.920 | 36241.1 |
| 283 | 2020-01-11 09:29:28 | lancing | 1 | 69583 | 5 | 1.576 | 44151.6 |
| 282 | 2020-01-04 18:59:34 | lancing | 1 | 69583 | 5 | 1.266 | 54962.9 |