History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"columnar"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 383 | 2025-11-08 02:25:52 | columnar | 4 | 161609 | 353 | 13.000 | 12431.5 |
| 382 | 2025-10-31 03:13:39 | columnar | 4 | 161609 | 353 | 12.330 | 13107.0 |
| 381 | 2025-10-23 17:39:40 | columnar | 1 | 82945 | 2 | 3.593 | 23085.2 |
| 380 | 2025-10-23 17:23:05 | columnar | 4 | 161609 | 353 | 73.383 | 2202.3 |
| 379 | 2025-10-06 13:50:40 | columnar | 1 | 82945 | 2 | 3.203 | 25896.0 |
| 378 | 2025-10-06 05:39:05 | columnar | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 377 | 2025-09-22 22:43:45 | columnar | 4 | 161609 | 353 | 12.780 | 12645.5 |
| 376 | 2025-09-19 07:39:08 | columnar | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 375 | 2025-09-16 08:36:36 | columnar | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 374 | 2025-09-11 13:47:17 | columnar | 4 | 161609 | 353 | 13.046 | 12387.6 |
| 373 | 2025-09-10 07:49:54 | columnar | 2 | 121059 | 9 | 4.170 | 29030.9 |
| 372 | 2025-09-03 02:02:25 | columnar | 3 | 146162 | 36 | 7.283 | 20068.9 |
| 371 | 2025-08-31 22:51:54 | columnar | 3 | 146162 | 36 | 7.643 | 19123.6 |
| 370 | 2025-08-29 15:56:53 | columnar | 4 | 161609 | 353 | 11.750 | 13754.0 |
| 369 | 2025-08-28 03:48:03 | columnar | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 368 | 2025-08-07 23:30:36 | columnar | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 367 | 2025-08-05 11:33:23 | columnar | 4 | 161609 | 353 | 33.816 | 4779.1 |
| 366 | 2025-08-02 02:06:50 | columnar | 4 | 161609 | 353 | 30.283 | 5336.6 |
| 365 | 2025-07-27 03:52:30 | columnar | 1 | 82945 | 2 | 8.766 | 9462.1 |
| 364 | 2025-07-25 04:36:26 | columnar | 1 | 82945 | 2 | 5.653 | 14672.7 |
| 363 | 2025-07-24 08:28:00 | columnar | 1 | 82945 | 2 | 5.516 | 15037.2 |
| 362 | 2025-07-23 23:38:38 | columnar | 1 | 82945 | 2 | 7.263 | 11420.2 |
| 361 | 2025-07-22 09:17:34 | columnar | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 360 | 2025-07-19 21:25:13 | columnar | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 359 | 2025-07-18 10:57:42 | columnar | 4 | 161609 | 353 | 40.250 | 4015.1 |
| 358 | 2025-07-16 22:04:25 | columnar | 4 | 161609 | 353 | 49.643 | 3255.4 |
| 357 | 2025-07-16 14:26:50 | columnar | 4 | 161609 | 353 | 45.270 | 3569.9 |
| 356 | 2025-07-14 17:54:17 | columnar | 2 | 121059 | 9 | 11.983 | 10102.6 |
| 355 | 2025-07-14 10:13:40 | columnar | 4 | 161609 | 353 | 61.160 | 2642.4 |
| 354 | 2025-07-13 04:23:54 | columnar | 1 | 82945 | 2 | 2.403 | 34517.3 |
| 353 | 2025-06-26 03:54:23 | columnar | 1 | 82945 | 2 | 9.093 | 9121.9 |
| 352 | 2025-06-21 03:13:02 | columnar | 1 | 82945 | 2 | 9.860 | 8412.3 |
| 351 | 2025-06-20 06:20:18 | columnar | 1 | 82945 | 2 | 4.720 | 17573.1 |
| 350 | 2025-04-29 02:14:13 | columnar | 1 | 82945 | 2 | 1.580 | 52496.8 |
| 349 | 2025-04-23 05:20:19 | columnar | 1 | 82945 | 2 | 8.156 | 10169.8 |
| 348 | 2025-04-23 04:25:58 | columnar | 1 | 82945 | 2 | 8.546 | 9705.7 |
| 347 | 2025-04-23 03:17:45 | columnar | 1 | 82945 | 2 | 5.140 | 16137.2 |
| 346 | 2025-04-16 02:35:45 | columnar | 1 | 82945 | 2 | 5.313 | 15611.7 |
| 345 | 2025-04-11 03:36:03 | columnar | 1 | 82945 | 2 | 6.766 | 12259.1 |
| 344 | 2025-04-02 13:18:32 | columnar | 1 | 82945 | 2 | 7.186 | 11542.6 |
| 343 | 2025-03-22 17:14:56 | columnar | 2 | 121059 | 9 | 21.220 | 5704.9 |
| 342 | 2025-03-22 13:53:24 | columnar | 3 | 146162 | 36 | 9.503 | 15380.6 |
| 341 | 2025-03-21 09:41:27 | columnar | 3 | 146162 | 36 | 35.173 | 4155.5 |
| 340 | 2025-03-20 05:04:09 | columnar | 1 | 82945 | 2 | 8.266 | 10034.5 |
| 339 | 2025-03-17 00:18:07 | columnar | 1 | 82945 | 2 | 6.203 | 13371.8 |
| 338 | 2025-03-11 19:26:22 | columnar | 3 | 146162 | 36 | 36.643 | 3988.8 |
| 337 | 2025-03-10 16:03:02 | columnar | 3 | 146162 | 36 | 40.066 | 3648.0 |
| 336 | 2025-03-09 12:20:45 | columnar | 4 | 161609 | 353 | 96.460 | 1675.4 |
| 335 | 2025-03-07 14:42:05 | columnar | 1 | 82945 | 2 | 6.500 | 12760.8 |
| 334 | 2025-03-07 07:16:10 | columnar | 4 | 161609 | 353 | 37.253 | 4338.1 |
| 333 | 2025-03-06 21:10:57 | columnar | 3 | 146162 | 36 | 28.436 | 5140.0 |
| 332 | 2025-03-06 21:10:55 | columnar | 2 | 121059 | 9 | 17.763 | 6815.2 |
| 331 | 2025-03-06 18:26:52 | columnar | 4 | 161609 | 353 | 67.486 | 2394.7 |
| 330 | 2025-03-06 18:26:46 | columnar | 3 | 146162 | 36 | 29.970 | 4876.9 |
| 329 | 2025-03-06 18:26:46 | columnar | 2 | 121059 | 9 | 19.390 | 6243.4 |
| 328 | 2025-03-06 17:45:40 | columnar | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 327 | 2025-02-13 15:35:05 | columnar | 2 | 121059 | 9 | 9.626 | 12576.3 |
| 326 | 2025-02-12 16:28:19 | columnar | 1 | 82945 | 2 | 5.546 | 14955.8 |
| 325 | 2025-02-09 13:00:00 | columnar | 1 | 82945 | 2 | 11.033 | 7517.9 |
| 324 | 2025-02-09 12:56:38 | columnar | 3 | 146162 | 36 | 7.750 | 18859.6 |
| 323 | 2025-02-09 12:56:37 | columnar | 2 | 121059 | 9 | 3.940 | 30725.6 |
| 322 | 2025-02-07 08:19:23 | columnar | 3 | 146162 | 36 | 49.570 | 2948.6 |
| 321 | 2025-02-07 08:02:50 | columnar | 3 | 146162 | 36 | 36.800 | 3971.8 |
| 320 | 2025-02-06 23:00:50 | columnar | 3 | 146162 | 36 | 22.003 | 6642.8 |
| 319 | 2025-02-04 23:35:08 | columnar | 1 | 82945 | 2 | 3.593 | 23085.2 |
| 318 | 2025-02-02 20:26:37 | columnar | 3 | 146162 | 36 | 38.406 | 3805.7 |
| 317 | 2025-02-02 20:26:38 | columnar | 2 | 121059 | 9 | 23.206 | 5216.7 |
| 316 | 2025-02-02 20:25:33 | columnar | 1 | 82945 | 2 | 5.470 | 15163.6 |
| 315 | 2025-01-04 21:31:14 | columnar | 1 | 82945 | 2 | 7.190 | 11536.2 |
| 314 | 2025-01-03 00:45:49 | columnar | 1 | 82945 | 2 | 4.500 | 18432.2 |
| 313 | 2024-12-04 20:23:59 | columnar | 1 | 82945 | 2 | 9.906 | 8373.2 |
| 312 | 2024-12-01 02:28:40 | columnar | 1 | 82945 | 2 | 6.906 | 12010.6 |
| 311 | 2024-11-30 15:36:37 | columnar | 1 | 82945 | 2 | 9.563 | 8673.5 |
| 310 | 2024-10-31 11:00:31 | columnar | 1 | 82945 | 2 | 6.843 | 12121.1 |
| 309 | 2024-10-31 00:58:55 | columnar | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 308 | 2024-10-29 21:51:04 | columnar | 2 | 121059 | 9 | 15.843 | 7641.2 |
| 307 | 2024-10-28 17:28:56 | columnar | 1 | 82945 | 2 | 3.846 | 21566.6 |
| 306 | 2024-10-26 08:31:37 | columnar | 3 | 146162 | 36 | 41.000 | 3564.9 |
| 305 | 2024-10-23 02:06:45 | columnar | 3 | 146162 | 36 | 38.830 | 3764.2 |
| 304 | 2024-10-23 02:06:51 | columnar | 2 | 121059 | 9 | 18.580 | 6515.6 |
| 303 | 2024-10-23 02:04:35 | columnar | 1 | 82945 | 2 | 3.360 | 24686.0 |
| 302 | 2024-10-21 00:58:34 | columnar | 3 | 146162 | 36 | 30.483 | 4794.9 |
| 301 | 2024-10-15 19:43:54 | columnar | 3 | 146162 | 36 | 43.070 | 3393.6 |
| 300 | 2024-10-15 19:43:49 | columnar | 3 | 146162 | 36 | 45.976 | 3179.1 |
| 299 | 2024-10-15 19:43:52 | columnar | 2 | 121059 | 9 | 9.673 | 12515.1 |
| 298 | 2024-09-23 19:35:06 | columnar | 1 | 82945 | 2 | 13.983 | 5931.8 |
| 297 | 2024-09-12 17:20:29 | columnar | 1 | 82945 | 2 | 11.453 | 7242.2 |
| 296 | 2024-08-23 12:23:58 | columnar | 1 | 82945 | 2 | 7.360 | 11269.7 |
| 295 | 2024-08-05 03:49:18 | columnar | 1 | 82945 | 2 | 7.563 | 10967.2 |
| 294 | 2024-08-04 23:55:33 | columnar | 3 | 146162 | 36 | 36.330 | 4023.2 |
| 293 | 2024-08-04 23:55:17 | columnar | 2 | 121059 | 9 | 17.203 | 7037.1 |
| 292 | 2024-08-03 18:57:39 | columnar | 3 | 146162 | 36 | 44.750 | 3266.2 |
| 291 | 2024-08-03 18:57:36 | columnar | 2 | 121059 | 9 | 15.843 | 7641.2 |
| 290 | 2024-08-03 08:54:53 | columnar | 3 | 146162 | 36 | 46.703 | 3129.6 |
| 289 | 2024-08-03 08:54:46 | columnar | 2 | 121059 | 9 | 15.906 | 7610.9 |
| 288 | 2024-08-02 21:25:16 | columnar | 1 | 82945 | 2 | 5.453 | 15210.9 |
| 287 | 2024-07-30 15:24:39 | columnar | 3 | 146162 | 36 | 14.683 | 9954.5 |
| 286 | 2024-07-28 19:16:04 | columnar | 4 | 161609 | 353 | 54.360 | 2972.9 |
| 285 | 2024-07-28 09:38:27 | columnar | 4 | 161609 | 353 | 45.896 | 3521.2 |
| 284 | 2024-07-28 06:00:49 | columnar | 4 | 161609 | 353 | 51.470 | 3139.9 |