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 |
| 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 |
| 260 | 2024-10-29 22:16:57 | secondary | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 259 | 2024-10-22 17:16:36 | secondary | 3 | 148641 | 29 | 45.393 | 3274.5 |
| 258 | 2024-10-22 09:12:31 | secondary | 1 | 81242 | 1 | 10.233 | 7939.2 |
| 257 | 2024-10-12 20:06:50 | secondary | 3 | 148641 | 29 | 48.923 | 3038.3 |
| 256 | 2024-10-12 19:48:26 | secondary | 3 | 148641 | 29 | 31.720 | 4686.0 |
| 255 | 2024-10-10 11:24:22 | secondary | 3 | 148641 | 29 | 46.563 | 3192.3 |
| 254 | 2024-10-10 11:24:20 | secondary | 3 | 148641 | 29 | 47.516 | 3128.2 |
| 253 | 2024-08-14 12:48:04 | secondary | 1 | 81242 | 1 | 7.233 | 11232.1 |
| 252 | 2024-08-14 12:47:44 | secondary | 1 | 81242 | 1 | 4.846 | 16764.8 |
| 251 | 2024-08-09 00:31:47 | secondary | 1 | 81242 | 1 | 5.860 | 13863.8 |
| 250 | 2024-08-07 02:46:17 | secondary | 1 | 81242 | 1 | 8.080 | 10054.7 |
| 249 | 2024-08-03 09:38:17 | secondary | 3 | 148641 | 29 | 35.923 | 4137.8 |
| 248 | 2024-07-28 12:48:01 | secondary | 3 | 148641 | 29 | 25.923 | 5733.9 |
| 247 | 2024-07-26 20:56:37 | secondary | 4 | 165329 | 136 | 63.410 | 2607.3 |
| 246 | 2024-07-26 19:57:11 | secondary | 4 | 165329 | 136 | 77.163 | 2142.6 |
| 245 | 2024-07-26 10:04:23 | secondary | 4 | 165329 | 136 | 38.516 | 4292.5 |
| 244 | 2024-07-26 09:42:57 | secondary | 4 | 165329 | 136 | 61.846 | 2673.2 |
| 243 | 2024-07-26 09:42:59 | secondary | 3 | 148641 | 29 | 29.080 | 5111.5 |
| 242 | 2024-07-26 09:43:05 | secondary | 2 | 121436 | 5 | 15.640 | 7764.5 |
| 241 | 2024-07-26 09:39:57 | secondary | 1 | 81242 | 1 | 4.076 | 19931.8 |
| 240 | 2024-07-21 10:42:18 | secondary | 1 | 81242 | 1 | 5.703 | 14245.5 |
| 239 | 2024-07-11 10:31:18 | secondary | 3 | 148641 | 29 | 24.406 | 6090.3 |
| 238 | 2024-07-07 22:41:24 | secondary | 3 | 148641 | 29 | 34.910 | 4257.8 |
| 237 | 2024-07-07 22:41:37 | secondary | 2 | 121436 | 5 | 21.876 | 5551.1 |
| 236 | 2024-07-06 22:39:54 | secondary | 1 | 81242 | 1 | 6.876 | 11815.3 |
| 235 | 2024-06-15 02:19:01 | secondary | 1 | 81242 | 1 | 6.703 | 12120.2 |
| 234 | 2024-06-12 21:17:15 | secondary | 1 | 81242 | 1 | 5.046 | 16100.3 |
| 233 | 2024-05-19 15:40:49 | secondary | 4 | 165329 | 136 | 41.003 | 4032.1 |