History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clearable"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 403 | 2024-05-28 10:48:07 | clearable | 1 | 81242 | 3 | 2.203 | 36877.9 |
| 402 | 2024-05-24 02:55:44 | clearable | 1 | 81242 | 3 | 4.780 | 16996.2 |
| 401 | 2024-05-17 09:08:32 | clearable | 4 | 165329 | 476 | 41.283 | 4004.8 |
| 400 | 2024-05-15 04:18:34 | clearable | 4 | 165329 | 476 | 54.893 | 3011.8 |
| 399 | 2024-05-15 02:31:07 | clearable | 4 | 165329 | 476 | 50.940 | 3245.6 |
| 398 | 2024-05-14 14:13:34 | clearable | 1 | 81242 | 3 | 5.283 | 15378.0 |
| 397 | 2024-05-11 01:52:28 | clearable | 4 | 165329 | 476 | 49.443 | 3343.8 |
| 396 | 2024-05-08 22:22:14 | clearable | 4 | 165329 | 476 | 43.223 | 3825.0 |
| 395 | 2024-05-08 09:18:54 | clearable | 4 | 165329 | 476 | 12.123 | 13637.6 |
| 394 | 2024-05-02 00:00:01 | clearable | 2 | 121436 | 14 | 6.236 | 19473.4 |
| 393 | 2024-04-25 11:53:59 | clearable | 3 | 148641 | 91 | 18.516 | 8027.7 |
| 392 | 2024-04-25 11:53:58 | clearable | 2 | 121436 | 14 | 14.470 | 8392.3 |
| 391 | 2024-04-25 10:22:47 | clearable | 1 | 81242 | 3 | 3.486 | 23305.2 |
| 390 | 2024-04-24 20:24:53 | clearable | 3 | 148641 | 91 | 29.690 | 5006.4 |
| 389 | 2024-04-24 20:14:24 | clearable | 2 | 121436 | 14 | 5.826 | 20843.8 |
| 388 | 2024-04-24 18:52:27 | clearable | 1 | 81242 | 3 | 3.030 | 26812.5 |
| 387 | 2024-04-23 04:30:12 | clearable | 2 | 121436 | 14 | 10.033 | 12103.7 |
| 386 | 2024-04-23 04:29:57 | clearable | 3 | 148641 | 91 | 18.660 | 7965.8 |
| 385 | 2024-04-23 01:43:42 | clearable | 1 | 81242 | 3 | 1.673 | 48560.7 |
| 384 | 2024-04-19 03:40:01 | clearable | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 383 | 2024-04-11 13:49:31 | clearable | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 382 | 2024-04-10 16:22:36 | clearable | 4 | 165329 | 476 | 47.596 | 3473.6 |
| 381 | 2024-04-10 16:22:38 | clearable | 3 | 148641 | 91 | 18.826 | 7895.5 |
| 380 | 2024-04-10 16:22:37 | clearable | 2 | 121436 | 14 | 11.283 | 10762.7 |
| 379 | 2024-04-10 08:51:58 | clearable | 1 | 81242 | 3 | 1.766 | 46003.4 |
| 378 | 2024-03-30 05:39:09 | clearable | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 377 | 2024-03-23 06:24:02 | clearable | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 376 | 2024-03-18 06:42:37 | clearable | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 375 | 2024-03-16 15:27:33 | clearable | 3 | 148641 | 91 | 9.143 | 16257.4 |
| 374 | 2024-03-16 15:27:33 | clearable | 2 | 121436 | 14 | 4.373 | 27769.5 |
| 373 | 2024-03-16 15:11:31 | clearable | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 372 | 2024-03-06 05:29:50 | clearable | 1 | 81242 | 3 | 3.123 | 26014.1 |
| 371 | 2024-03-04 18:42:19 | clearable | 4 | 165329 | 476 | 58.613 | 2820.7 |
| 370 | 2024-03-03 12:53:44 | clearable | 2 | 121436 | 14 | 3.626 | 33490.3 |
| 369 | 2024-02-29 13:32:56 | clearable | 4 | 165329 | 476 | 20.066 | 8239.3 |
| 368 | 2024-02-26 16:55:18 | clearable | 3 | 148641 | 91 | 23.316 | 6375.1 |
| 367 | 2024-02-22 11:45:40 | clearable | 4 | 165329 | 476 | 44.986 | 3675.1 |
| 366 | 2024-02-22 11:45:40 | clearable | 3 | 148641 | 91 | 26.220 | 5669.0 |
| 365 | 2024-02-22 11:45:43 | clearable | 2 | 121436 | 14 | 7.580 | 16020.6 |
| 364 | 2024-02-22 03:19:03 | clearable | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 363 | 2024-02-18 14:28:28 | clearable | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 362 | 2024-02-14 19:56:43 | clearable | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 361 | 2024-02-04 12:14:50 | clearable | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 360 | 2024-02-01 18:35:09 | clearable | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 359 | 2024-01-22 21:34:31 | clearable | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 358 | 2024-01-12 17:58:18 | clearable | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 357 | 2024-01-08 16:39:51 | clearable | 4 | 165329 | 476 | 13.050 | 12668.9 |
| 356 | 2024-01-02 02:20:14 | clearable | 4 | 165329 | 476 | 13.640 | 12120.9 |
| 355 | 2023-12-06 02:20:49 | clearable | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 354 | 2023-12-04 03:55:47 | clearable | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 353 | 2023-11-24 18:12:53 | clearable | 2 | 121436 | 14 | 3.203 | 37913.2 |
| 352 | 2023-11-20 15:05:28 | clearable | 1 | 81242 | 3 | 1.530 | 53099.3 |
| 351 | 2023-11-02 12:37:51 | clearable | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 350 | 2023-10-04 08:49:09 | clearable | 4 | 165329 | 476 | 13.626 | 12133.3 |
| 349 | 2023-09-20 07:37:31 | clearable | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 348 | 2023-08-24 06:29:21 | clearable | 2 | 121436 | 14 | 3.186 | 38115.5 |
| 347 | 2023-08-04 05:29:57 | clearable | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 346 | 2023-07-16 07:36:17 | clearable | 4 | 165329 | 476 | 11.170 | 14801.2 |
| 345 | 2023-07-15 18:21:17 | clearable | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 344 | 2023-05-11 03:58:00 | clearable | 2 | 121436 | 14 | 3.186 | 38115.5 |
| 343 | 2023-04-23 03:52:40 | clearable | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 342 | 2023-04-12 01:21:16 | clearable | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 341 | 2023-04-10 05:29:33 | clearable | 4 | 165329 | 476 | 10.596 | 15603.0 |
| 340 | 2023-03-31 15:36:22 | clearable | 4 | 165329 | 476 | 12.063 | 13705.5 |
| 339 | 2023-02-18 06:13:31 | clearable | 2 | 121436 | 14 | 3.093 | 39261.6 |
| 338 | 2023-02-15 17:17:27 | clearable | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 337 | 2022-12-27 05:36:32 | clearable | 4 | 165329 | 476 | 10.563 | 15651.7 |
| 336 | 2022-12-23 01:25:27 | clearable | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 335 | 2022-12-12 09:20:15 | clearable | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 334 | 2022-11-29 20:45:50 | clearable | 2 | 121436 | 14 | 3.046 | 39867.4 |
| 333 | 2022-11-25 11:54:14 | clearable | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 332 | 2022-09-07 00:14:48 | clearable | 4 | 165329 | 476 | 10.753 | 15375.2 |
| 331 | 2022-08-28 09:56:06 | clearable | 4 | 165329 | 476 | 11.546 | 14319.2 |
| 330 | 2022-08-21 03:44:06 | clearable | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 329 | 2022-08-19 07:49:34 | clearable | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 328 | 2022-08-16 00:20:30 | clearable | 1 | 81242 | 3 | 1.346 | 60358.1 |
| 327 | 2022-07-08 08:13:23 | clearable | 2 | 121436 | 14 | 3.093 | 39261.6 |
| 326 | 2022-04-13 01:43:05 | clearable | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 325 | 2022-04-11 20:04:16 | clearable | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 324 | 2022-02-28 02:54:49 | clearable | 2 | 121436 | 14 | 3.266 | 37181.9 |
| 323 | 2022-01-13 02:22:38 | clearable | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 322 | 2022-01-10 22:57:48 | clearable | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 321 | 2021-12-21 02:46:44 | clearable | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 320 | 2021-09-07 10:39:02 | clearable | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 319 | 2021-08-04 10:44:31 | clearable | 3 | 148641 | 91 | 6.266 | 23721.8 |
| 318 | 2021-06-06 12:33:12 | clearable | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 317 | 2021-06-03 08:07:12 | clearable | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 316 | 2021-05-30 00:19:08 | clearable | 3 | 148641 | 91 | 7.470 | 19898.4 |
| 315 | 2021-05-25 11:23:08 | clearable | 4 | 165329 | 476 | 12.013 | 13762.5 |
| 314 | 2021-05-05 18:37:52 | clearable | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 313 | 2021-05-02 16:00:44 | clearable | 4 | 165329 | 476 | 19.376 | 8532.7 |
| 312 | 2021-05-01 11:53:57 | clearable | 3 | 148641 | 91 | 7.266 | 20457.1 |
| 311 | 2021-04-22 15:22:48 | clearable | 4 | 165329 | 476 | 13.453 | 12289.4 |
| 310 | 2021-04-03 22:02:28 | clearable | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 309 | 2021-03-28 15:26:15 | clearable | 4 | 165329 | 476 | 13.046 | 12672.8 |
| 308 | 2021-03-08 08:39:39 | clearable | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 307 | 2021-02-24 16:18:15 | clearable | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 306 | 2021-02-22 14:49:21 | clearable | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 305 | 2021-01-14 09:36:48 | clearable | 3 | 148641 | 91 | 6.923 | 21470.6 |
| 304 | 2021-01-12 00:09:19 | clearable | 4 | 165329 | 476 | 11.003 | 15025.8 |