History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"twenty"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 365 | 2024-04-27 05:52:04 | twenty | 2 | 82551 | 25 | 2.923 | 28241.9 |
| 364 | 2024-04-27 05:52:00 | twenty | 1 | 48755 | 2 | 0.966 | 50471.0 |
| 363 | 2024-04-27 05:51:43 | twenty | 3 | 112716 | 342 | 5.796 | 19447.2 |
| 362 | 2024-04-27 03:04:37 | twenty | 3 | 112716 | 342 | 20.376 | 5531.8 |
| 361 | 2024-03-31 22:46:54 | twenty | 3 | 112716 | 342 | 17.890 | 6300.5 |
| 360 | 2024-03-31 22:46:49 | twenty | 2 | 82551 | 25 | 8.516 | 9693.6 |
| 359 | 2024-03-31 22:46:43 | twenty | 1 | 48755 | 2 | 1.873 | 26030.4 |
| 358 | 2024-03-30 00:59:37 | twenty | 1 | 48755 | 2 | 1.860 | 26212.4 |
| 357 | 2024-03-08 18:56:18 | twenty | 3 | 112716 | 342 | 10.220 | 11029.0 |
| 356 | 2024-03-08 00:34:28 | twenty | 2 | 82551 | 25 | 5.423 | 15222.4 |
| 355 | 2024-03-08 00:34:09 | twenty | 3 | 112716 | 342 | 5.940 | 18975.8 |
| 354 | 2024-03-07 07:02:17 | twenty | 3 | 112716 | 342 | 6.110 | 18447.8 |
| 353 | 2024-03-07 05:46:04 | twenty | 1 | 48755 | 2 | 0.923 | 52822.3 |
| 352 | 2024-02-17 22:15:08 | twenty | 2 | 82551 | 25 | 5.830 | 14159.7 |
| 351 | 2024-02-17 22:05:21 | twenty | 3 | 112716 | 342 | 5.860 | 19234.8 |
| 350 | 2024-02-11 18:17:29 | twenty | 3 | 112716 | 342 | 19.063 | 5912.8 |
| 349 | 2024-02-10 14:28:24 | twenty | 3 | 112716 | 342 | 7.206 | 15642.0 |
| 348 | 2024-02-04 14:34:46 | twenty | 2 | 82551 | 25 | 3.000 | 27517.0 |
| 347 | 2024-02-04 14:34:26 | twenty | 3 | 112716 | 342 | 8.236 | 13685.8 |
| 346 | 2024-02-04 08:48:57 | twenty | 3 | 112716 | 342 | 8.640 | 13045.8 |
| 345 | 2024-02-04 08:39:16 | twenty | 2 | 82551 | 25 | 2.640 | 31269.3 |
| 344 | 2024-02-04 08:39:07 | twenty | 1 | 48755 | 2 | 1.813 | 26891.9 |
| 343 | 2024-01-27 15:29:52 | twenty | 1 | 48755 | 2 | 0.733 | 66514.3 |
| 342 | 2024-01-08 03:09:40 | twenty | 2 | 82551 | 25 | 2.330 | 35429.6 |
| 341 | 2024-01-02 08:07:15 | twenty | 2 | 82551 | 25 | 2.126 | 38829.3 |
| 340 | 2024-01-02 08:07:11 | twenty | 3 | 112716 | 342 | 4.703 | 23966.8 |
| 339 | 2023-12-14 05:08:36 | twenty | 3 | 112716 | 342 | 5.093 | 22131.6 |
| 338 | 2023-12-11 10:26:28 | twenty | 3 | 112716 | 342 | 5.310 | 21227.1 |
| 337 | 2023-12-11 10:26:24 | twenty | 2 | 82551 | 25 | 2.296 | 35954.3 |
| 336 | 2023-11-27 06:24:46 | twenty | 1 | 48755 | 2 | 0.720 | 67715.3 |
| 335 | 2023-11-22 18:36:09 | twenty | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 334 | 2023-11-11 09:45:39 | twenty | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 333 | 2023-10-31 00:53:19 | twenty | 1 | 48755 | 2 | 1.670 | 29194.6 |
| 332 | 2023-10-29 12:28:41 | twenty | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 331 | 2023-10-24 16:21:14 | twenty | 1 | 48755 | 2 | 0.846 | 57630.0 |
| 330 | 2023-10-16 13:57:25 | twenty | 2 | 82551 | 25 | 2.313 | 35690.0 |
| 329 | 2023-10-15 12:30:29 | twenty | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 328 | 2023-09-24 08:21:19 | twenty | 1 | 48755 | 2 | 0.793 | 61481.7 |
| 327 | 2023-09-13 13:09:21 | twenty | 1 | 48755 | 2 | 1.623 | 30040.0 |
| 326 | 2023-09-13 11:46:45 | twenty | 3 | 112716 | 342 | 4.800 | 23482.5 |
| 325 | 2023-09-09 13:57:20 | twenty | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 324 | 2023-07-28 09:56:20 | twenty | 2 | 82551 | 25 | 2.080 | 39688.0 |
| 323 | 2023-06-13 12:27:40 | twenty | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 322 | 2023-06-04 14:31:47 | twenty | 3 | 112716 | 342 | 5.076 | 22205.7 |
| 321 | 2023-04-08 08:33:30 | twenty | 2 | 82551 | 25 | 2.296 | 35954.3 |
| 320 | 2023-03-30 11:42:18 | twenty | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 319 | 2023-03-09 22:21:17 | twenty | 3 | 112716 | 342 | 4.406 | 25582.4 |
| 318 | 2023-02-06 03:59:46 | twenty | 3 | 112716 | 342 | 5.093 | 22131.6 |
| 317 | 2023-01-13 05:47:53 | twenty | 1 | 48755 | 2 | 0.720 | 67715.3 |
| 316 | 2023-01-04 00:40:20 | twenty | 2 | 82551 | 25 | 2.013 | 41008.9 |
| 315 | 2022-12-20 19:50:22 | twenty | 3 | 112716 | 342 | 5.406 | 20850.2 |
| 314 | 2022-12-15 11:38:41 | twenty | 3 | 112716 | 342 | 5.670 | 19879.4 |
| 313 | 2022-11-23 13:53:34 | twenty | 3 | 112716 | 342 | 4.716 | 23900.8 |
| 312 | 2022-11-04 01:50:53 | twenty | 3 | 112716 | 342 | 4.500 | 25048.0 |
| 311 | 2022-11-03 22:11:22 | twenty | 3 | 112716 | 342 | 4.436 | 25409.4 |
| 310 | 2022-10-18 18:05:34 | twenty | 1 | 48755 | 2 | 0.830 | 58741.0 |
| 309 | 2022-10-15 09:54:55 | twenty | 3 | 112716 | 342 | 4.470 | 25216.1 |
| 308 | 2022-09-20 05:17:11 | twenty | 3 | 112716 | 342 | 4.500 | 25048.0 |
| 307 | 2022-09-05 09:23:24 | twenty | 2 | 82551 | 25 | 2.063 | 40015.0 |
| 306 | 2022-08-29 19:38:13 | twenty | 3 | 112716 | 342 | 5.580 | 20200.0 |
| 305 | 2022-08-06 00:59:51 | twenty | 3 | 112716 | 342 | 4.466 | 25238.7 |
| 304 | 2022-06-09 23:51:55 | twenty | 1 | 48755 | 2 | 0.733 | 66514.3 |
| 303 | 2022-02-15 11:12:23 | twenty | 1 | 48755 | 2 | 0.720 | 67715.3 |
| 302 | 2022-02-13 06:36:48 | twenty | 1 | 48755 | 2 | 0.826 | 59025.4 |
| 301 | 2022-02-12 17:21:15 | twenty | 2 | 82551 | 25 | 2.063 | 40015.0 |
| 300 | 2022-02-12 02:02:25 | twenty | 2 | 82551 | 25 | 2.186 | 37763.5 |
| 299 | 2022-02-11 12:09:56 | twenty | 2 | 82551 | 25 | 2.533 | 32590.2 |
| 298 | 2022-02-11 03:22:15 | twenty | 2 | 82551 | 25 | 2.343 | 35233.0 |
| 297 | 2022-02-10 10:28:46 | twenty | 2 | 82551 | 25 | 2.143 | 38521.2 |
| 296 | 2022-02-10 05:35:54 | twenty | 2 | 82551 | 25 | 2.420 | 34112.0 |
| 295 | 2022-02-09 22:31:57 | twenty | 2 | 82551 | 25 | 2.453 | 33653.1 |
| 294 | 2022-02-09 14:08:00 | twenty | 2 | 82551 | 25 | 2.076 | 39764.5 |
| 293 | 2022-02-09 10:28:23 | twenty | 2 | 82551 | 25 | 2.766 | 29844.9 |
| 292 | 2022-02-08 12:46:55 | twenty | 2 | 82551 | 25 | 2.140 | 38575.2 |
| 291 | 2022-02-08 10:21:46 | twenty | 2 | 82551 | 25 | 2.596 | 31799.3 |
| 290 | 2022-02-07 18:28:01 | twenty | 2 | 82551 | 25 | 2.186 | 37763.5 |
| 289 | 2021-12-25 20:17:45 | twenty | 2 | 82551 | 25 | 2.250 | 36689.3 |
| 288 | 2021-12-24 20:45:29 | twenty | 2 | 82551 | 25 | 2.516 | 32810.4 |
| 287 | 2021-12-19 12:32:46 | twenty | 2 | 82551 | 25 | 2.580 | 31996.5 |
| 286 | 2021-12-18 22:29:33 | twenty | 2 | 82551 | 25 | 2.530 | 32628.9 |
| 285 | 2021-12-17 12:14:49 | twenty | 2 | 82551 | 25 | 2.486 | 33206.4 |
| 284 | 2021-12-17 00:57:52 | twenty | 2 | 82551 | 25 | 2.656 | 31080.9 |
| 283 | 2021-12-16 18:05:47 | twenty | 2 | 82551 | 25 | 2.063 | 40015.0 |
| 282 | 2021-12-16 05:41:24 | twenty | 2 | 82551 | 25 | 2.440 | 33832.4 |
| 281 | 2021-12-15 20:05:54 | twenty | 2 | 82551 | 25 | 2.343 | 35233.0 |
| 280 | 2021-12-15 03:16:47 | twenty | 2 | 82551 | 25 | 2.436 | 33887.9 |
| 279 | 2021-12-14 16:50:50 | twenty | 2 | 82551 | 25 | 4.703 | 17552.8 |
| 278 | 2021-11-30 16:18:14 | twenty | 1 | 48755 | 2 | 0.826 | 59025.4 |
| 277 | 2021-11-23 21:26:15 | twenty | 2 | 82551 | 25 | 3.216 | 25668.8 |
| 276 | 2021-11-15 23:05:22 | twenty | 2 | 82551 | 25 | 2.626 | 31436.0 |
| 275 | 2021-11-15 12:01:22 | twenty | 2 | 82551 | 25 | 2.250 | 36689.3 |
| 274 | 2021-11-14 17:03:02 | twenty | 2 | 82551 | 25 | 2.470 | 33421.5 |
| 273 | 2021-11-14 01:10:19 | twenty | 2 | 82551 | 25 | 2.453 | 33653.1 |
| 272 | 2021-11-13 14:06:35 | twenty | 2 | 82551 | 25 | 2.593 | 31836.1 |
| 271 | 2021-11-12 23:25:39 | twenty | 2 | 82551 | 25 | 2.516 | 32810.4 |
| 270 | 2021-11-12 13:30:14 | twenty | 2 | 82551 | 25 | 2.593 | 31836.1 |
| 269 | 2021-11-11 20:58:17 | twenty | 2 | 82551 | 25 | 2.343 | 35233.0 |
| 268 | 2021-11-11 10:09:03 | twenty | 2 | 82551 | 25 | 2.470 | 33421.5 |
| 267 | 2021-11-10 23:30:29 | twenty | 2 | 82551 | 25 | 2.266 | 36430.3 |
| 266 | 2021-11-01 01:57:35 | twenty | 2 | 82551 | 25 | 2.406 | 34310.5 |