History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"secondary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 360 | 2026-02-16 05:53:22 | secondary | 1 | 81242 | 1 | 2.546 | 31909.7 |
| 359 | 2026-02-07 10:59:39 | secondary | 4 | 165329 | 136 | 15.203 | 10874.8 |
| 358 | 2026-02-07 10:59:22 | secondary | 4 | 165329 | 136 | 31.330 | 5277.0 |
| 357 | 2026-02-07 10:59:01 | secondary | 4 | 165329 | 136 | 25.830 | 6400.7 |
| 356 | 2026-02-04 15:48:34 | secondary | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 355 | 2026-02-03 06:01:09 | secondary | 1 | 81242 | 1 | 1.563 | 51978.2 |
| 354 | 2026-01-31 01:22:51 | secondary | 1 | 81242 | 1 | 1.563 | 51978.2 |
| 353 | 2026-01-30 17:17:34 | secondary | 3 | 148641 | 29 | 7.173 | 20722.3 |
| 352 | 2026-01-28 16:28:54 | secondary | 4 | 165329 | 136 | 34.720 | 4761.8 |
| 351 | 2026-01-28 14:54:37 | secondary | 3 | 148641 | 29 | 10.530 | 14116.0 |
| 350 | 2026-01-26 16:51:50 | secondary | 1 | 81242 | 1 | 1.673 | 48560.7 |
| 349 | 2026-01-26 12:12:33 | secondary | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 348 | 2026-01-22 12:05:54 | secondary | 1 | 81242 | 1 | 7.156 | 11353.0 |
| 347 | 2026-01-20 00:43:51 | secondary | 2 | 121436 | 5 | 4.703 | 25821.0 |
| 346 | 2026-01-18 13:49:14 | secondary | 4 | 165329 | 136 | 11.423 | 14473.3 |
| 345 | 2026-01-18 11:39:56 | secondary | 3 | 148641 | 29 | 8.250 | 18017.1 |
| 344 | 2026-01-18 10:47:45 | secondary | 3 | 148641 | 29 | 14.893 | 9980.6 |
| 343 | 2026-01-18 08:57:47 | secondary | 3 | 148641 | 29 | 7.280 | 20417.7 |
| 342 | 2026-01-16 05:13:41 | secondary | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 341 | 2026-01-13 03:29:28 | secondary | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 340 | 2026-01-12 00:04:59 | secondary | 1 | 81242 | 1 | 1.403 | 57905.9 |
| 339 | 2026-01-08 03:47:35 | secondary | 2 | 121436 | 5 | 3.843 | 31599.3 |
| 338 | 2026-01-07 10:45:23 | secondary | 3 | 148641 | 29 | 12.216 | 12167.7 |
| 337 | 2026-01-06 23:25:35 | secondary | 2 | 121436 | 5 | 4.143 | 29311.1 |
| 336 | 2025-12-28 02:17:22 | secondary | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 335 | 2025-12-21 03:10:15 | secondary | 1 | 81242 | 1 | 2.390 | 33992.5 |
| 334 | 2025-12-15 09:12:28 | secondary | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 333 | 2025-12-15 04:49:43 | secondary | 1 | 81242 | 1 | 1.533 | 52995.4 |
| 332 | 2025-10-25 10:14:18 | secondary | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 331 | 2025-10-11 02:12:44 | secondary | 1 | 81242 | 1 | 2.126 | 38213.5 |
| 330 | 2025-09-29 05:09:58 | secondary | 1 | 81242 | 1 | 1.530 | 53099.3 |
| 329 | 2025-09-25 03:03:05 | secondary | 1 | 81242 | 1 | 7.236 | 11227.5 |
| 328 | 2025-09-25 03:02:55 | secondary | 1 | 81242 | 1 | 8.610 | 9435.8 |
| 327 | 2025-09-25 03:02:43 | secondary | 1 | 81242 | 1 | 7.000 | 11606.0 |
| 326 | 2025-09-25 03:02:31 | secondary | 1 | 81242 | 1 | 9.890 | 8214.6 |
| 325 | 2025-09-08 19:24:18 | secondary | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 324 | 2025-09-03 20:52:28 | secondary | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 323 | 2025-08-09 02:19:44 | secondary | 1 | 81242 | 1 | 10.016 | 8111.2 |
| 322 | 2025-08-02 11:42:05 | secondary | 3 | 148641 | 29 | 19.396 | 7663.5 |
| 321 | 2025-07-27 12:09:00 | secondary | 1 | 81242 | 1 | 3.343 | 24302.1 |
| 320 | 2025-07-22 21:30:57 | secondary | 2 | 121436 | 5 | 19.580 | 6202.0 |
| 319 | 2025-07-11 08:42:39 | secondary | 1 | 81242 | 1 | 5.716 | 14213.1 |
| 318 | 2025-07-09 22:50:07 | secondary | 3 | 148641 | 29 | 30.470 | 4878.3 |
| 317 | 2025-07-08 17:41:26 | secondary | 3 | 148641 | 29 | 47.660 | 3118.8 |
| 316 | 2025-07-08 09:44:47 | secondary | 2 | 121436 | 5 | 18.283 | 6642.0 |
| 315 | 2025-07-07 10:17:48 | secondary | 3 | 148641 | 29 | 41.360 | 3593.8 |
| 314 | 2025-07-07 01:59:57 | secondary | 1 | 81242 | 1 | 7.236 | 11227.5 |
| 313 | 2025-06-28 12:52:50 | secondary | 2 | 121436 | 5 | 25.846 | 4698.4 |
| 312 | 2025-06-28 04:44:48 | secondary | 3 | 148641 | 29 | 38.033 | 3908.2 |
| 311 | 2025-06-28 03:01:46 | secondary | 3 | 148641 | 29 | 44.926 | 3308.6 |
| 310 | 2025-06-27 11:12:35 | secondary | 1 | 81242 | 1 | 3.483 | 23325.3 |
| 309 | 2025-06-17 12:53:46 | secondary | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 308 | 2025-05-27 03:00:26 | secondary | 3 | 148641 | 29 | 28.330 | 5246.8 |
| 307 | 2025-05-24 11:21:27 | secondary | 1 | 81242 | 1 | 7.343 | 11063.9 |
| 306 | 2025-05-14 17:08:59 | secondary | 3 | 148641 | 29 | 30.753 | 4833.4 |
| 305 | 2025-05-13 01:12:13 | secondary | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 304 | 2025-05-10 05:17:04 | secondary | 1 | 81242 | 1 | 3.640 | 22319.2 |
| 303 | 2025-04-23 04:49:51 | secondary | 1 | 81242 | 1 | 6.650 | 12216.8 |
| 302 | 2025-04-06 22:11:30 | secondary | 1 | 81242 | 1 | 6.156 | 13197.2 |
| 301 | 2025-04-04 05:52:42 | secondary | 1 | 81242 | 1 | 6.953 | 11684.5 |
| 300 | 2025-03-31 14:03:27 | secondary | 2 | 121436 | 5 | 14.203 | 8550.0 |
| 299 | 2025-03-31 06:15:12 | secondary | 1 | 81242 | 1 | 7.330 | 11083.5 |
| 298 | 2025-03-31 03:27:02 | secondary | 3 | 148641 | 29 | 44.673 | 3327.3 |
| 297 | 2025-03-27 02:31:20 | secondary | 1 | 81242 | 1 | 10.546 | 7703.6 |
| 296 | 2025-03-25 12:14:13 | secondary | 1 | 81242 | 1 | 7.046 | 11530.2 |
| 295 | 2025-03-20 06:46:33 | secondary | 1 | 81242 | 1 | 9.580 | 8480.4 |
| 294 | 2025-03-01 04:52:59 | secondary | 2 | 121436 | 5 | 18.796 | 6460.7 |
| 293 | 2025-03-01 04:51:37 | secondary | 1 | 81242 | 1 | 4.483 | 18122.2 |
| 292 | 2025-02-25 01:37:04 | secondary | 3 | 148641 | 29 | 44.986 | 3304.2 |
| 291 | 2025-02-23 09:22:00 | secondary | 3 | 148641 | 29 | 20.940 | 7098.4 |
| 290 | 2025-02-15 05:35:16 | secondary | 2 | 121436 | 5 | 16.280 | 7459.2 |
| 289 | 2025-02-12 14:22:07 | secondary | 1 | 81242 | 1 | 7.343 | 11063.9 |
| 288 | 2025-02-10 21:28:10 | secondary | 3 | 148641 | 29 | 38.743 | 3836.6 |
| 287 | 2025-02-10 21:24:49 | secondary | 2 | 121436 | 5 | 13.970 | 8692.6 |
| 286 | 2025-02-10 21:24:37 | secondary | 1 | 81242 | 1 | 5.156 | 15756.8 |
| 285 | 2025-02-09 17:02:56 | secondary | 3 | 148641 | 29 | 30.750 | 4833.9 |
| 284 | 2025-02-08 14:09:51 | secondary | 4 | 165329 | 136 | 38.143 | 4334.5 |
| 283 | 2025-02-04 15:28:50 | secondary | 4 | 165329 | 136 | 65.676 | 2517.3 |
| 282 | 2025-02-04 15:28:50 | secondary | 3 | 148641 | 29 | 25.546 | 5818.6 |
| 281 | 2025-02-04 14:24:28 | secondary | 1 | 81242 | 1 | 1.970 | 41239.6 |
| 280 | 2025-01-31 05:14:36 | secondary | 2 | 121436 | 5 | 15.873 | 7650.5 |
| 279 | 2025-01-24 18:37:04 | secondary | 1 | 81242 | 1 | 9.266 | 8767.8 |
| 278 | 2025-01-08 16:42:22 | secondary | 3 | 148641 | 29 | 16.500 | 9008.5 |
| 277 | 2025-01-04 21:04:51 | secondary | 3 | 148641 | 29 | 37.986 | 3913.0 |
| 276 | 2025-01-04 08:45:34 | secondary | 3 | 148641 | 29 | 39.720 | 3742.2 |
| 275 | 2025-01-01 10:26:27 | secondary | 2 | 121436 | 5 | 18.076 | 6718.1 |
| 274 | 2024-12-27 21:48:36 | secondary | 1 | 81242 | 1 | 7.186 | 11305.6 |
| 273 | 2024-12-19 14:28:51 | secondary | 4 | 165329 | 136 | 73.066 | 2262.7 |
| 272 | 2024-12-19 13:39:04 | secondary | 4 | 165329 | 136 | 89.553 | 1846.2 |
| 271 | 2024-12-19 11:34:01 | secondary | 4 | 165329 | 136 | 76.440 | 2162.9 |
| 270 | 2024-12-19 05:22:18 | secondary | 4 | 165329 | 136 | 61.626 | 2682.8 |
| 269 | 2024-12-19 05:22:19 | secondary | 2 | 121436 | 5 | 18.500 | 6564.1 |
| 268 | 2024-12-19 05:22:01 | secondary | 1 | 81242 | 1 | 6.580 | 12346.8 |
| 267 | 2024-11-26 21:38:46 | secondary | 1 | 81242 | 1 | 2.470 | 32891.5 |
| 266 | 2024-11-24 03:21:05 | secondary | 3 | 148641 | 29 | 24.736 | 6009.1 |
| 265 | 2024-11-17 22:26:56 | secondary | 3 | 148641 | 29 | 49.876 | 2980.2 |
| 264 | 2024-11-13 14:08:50 | secondary | 3 | 148641 | 29 | 38.563 | 3854.5 |
| 263 | 2024-11-06 18:07:33 | secondary | 1 | 81242 | 1 | 6.750 | 12035.9 |
| 262 | 2024-11-06 15:18:51 | secondary | 1 | 81242 | 1 | 4.376 | 18565.4 |
| 261 | 2024-11-01 19:43:43 | secondary | 3 | 148641 | 29 | 31.893 | 4660.6 |