History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yearend"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 299 | 2025-12-24 21:53:11 | yearend | 1 | 69583 | 3 | 3.330 | 20895.8 |
| 298 | 2025-12-21 20:46:51 | yearend | 3 | 134027 | 260 | 6.706 | 19986.1 |
| 297 | 2025-12-21 00:03:08 | yearend | 1 | 69583 | 3 | 3.143 | 22139.0 |
| 296 | 2025-12-19 23:32:48 | yearend | 3 | 134027 | 260 | 12.203 | 10983.1 |
| 295 | 2025-12-17 19:21:15 | yearend | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 294 | 2025-12-07 13:59:44 | yearend | 1 | 69583 | 3 | 2.326 | 29915.3 |
| 293 | 2025-12-07 00:28:15 | yearend | 3 | 134027 | 260 | 6.156 | 21771.8 |
| 292 | 2025-12-04 22:22:27 | yearend | 3 | 134027 | 260 | 6.716 | 19956.4 |
| 291 | 2025-11-30 03:10:42 | yearend | 3 | 134027 | 260 | 7.080 | 18930.4 |
| 290 | 2025-11-30 02:20:44 | yearend | 3 | 134027 | 260 | 6.046 | 22167.9 |
| 289 | 2025-11-29 08:20:49 | yearend | 2 | 107671 | 18 | 3.280 | 32826.5 |
| 288 | 2025-11-28 22:41:42 | yearend | 2 | 107671 | 18 | 6.703 | 16063.1 |
| 287 | 2025-11-28 12:30:14 | yearend | 2 | 107671 | 18 | 3.360 | 32044.9 |
| 286 | 2025-11-28 10:30:49 | yearend | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 285 | 2025-11-28 09:37:31 | yearend | 1 | 69583 | 3 | 2.376 | 29285.8 |
| 284 | 2025-11-27 23:07:56 | yearend | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 283 | 2025-09-30 18:04:34 | yearend | 2 | 107671 | 18 | 3.576 | 30109.3 |
| 282 | 2025-09-25 13:00:37 | yearend | 2 | 107671 | 18 | 5.220 | 20626.6 |
| 281 | 2025-09-25 12:05:13 | yearend | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 280 | 2025-09-23 21:33:03 | yearend | 3 | 134027 | 260 | 5.876 | 22809.2 |
| 279 | 2025-09-19 04:18:51 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 278 | 2025-09-08 19:42:39 | yearend | 2 | 107671 | 18 | 3.626 | 29694.2 |
| 277 | 2025-09-05 00:06:43 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 276 | 2025-09-03 21:46:03 | yearend | 3 | 134027 | 260 | 6.720 | 19944.5 |
| 275 | 2025-08-17 08:14:15 | yearend | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 274 | 2025-08-05 15:42:14 | yearend | 2 | 107671 | 18 | 8.300 | 12972.4 |
| 273 | 2025-08-02 14:38:59 | yearend | 2 | 107671 | 18 | 8.813 | 12217.3 |
| 272 | 2025-08-02 03:52:20 | yearend | 1 | 69583 | 3 | 5.893 | 11807.7 |
| 271 | 2025-08-01 03:08:26 | yearend | 1 | 69583 | 3 | 8.483 | 8202.6 |
| 270 | 2025-08-01 02:14:06 | yearend | 1 | 69583 | 3 | 3.360 | 20709.2 |
| 269 | 2025-07-31 07:13:32 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 268 | 2025-07-31 02:22:39 | yearend | 2 | 107671 | 18 | 3.376 | 31893.1 |
| 267 | 2025-07-30 22:58:45 | yearend | 1 | 69583 | 3 | 4.720 | 14742.2 |
| 266 | 2025-07-30 22:19:32 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 265 | 2025-07-30 18:22:04 | yearend | 3 | 134027 | 260 | 17.000 | 7883.9 |
| 264 | 2025-07-30 15:22:40 | yearend | 3 | 134027 | 260 | 6.860 | 19537.5 |
| 263 | 2025-07-29 09:54:23 | yearend | 3 | 134027 | 260 | 27.190 | 4929.3 |
| 262 | 2025-07-29 09:54:18 | yearend | 3 | 134027 | 260 | 25.123 | 5334.8 |
| 261 | 2025-07-25 11:05:51 | yearend | 3 | 134027 | 260 | 26.253 | 5105.2 |
| 260 | 2025-07-11 15:11:25 | yearend | 1 | 69583 | 3 | 8.440 | 8244.4 |
| 259 | 2025-07-04 19:33:50 | yearend | 2 | 107671 | 18 | 5.796 | 18576.8 |
| 258 | 2025-07-02 02:19:08 | yearend | 1 | 69583 | 3 | 3.563 | 19529.3 |
| 257 | 2025-06-30 07:22:20 | yearend | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 256 | 2025-06-09 10:21:49 | yearend | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 255 | 2025-06-06 14:14:16 | yearend | 2 | 107671 | 18 | 10.516 | 10238.8 |
| 254 | 2025-06-03 11:08:55 | yearend | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 253 | 2025-06-02 15:11:39 | yearend | 1 | 69583 | 3 | 6.033 | 11533.7 |
| 252 | 2025-05-31 23:19:05 | yearend | 2 | 107671 | 18 | 8.186 | 13153.1 |
| 251 | 2025-05-28 06:49:30 | yearend | 3 | 134027 | 260 | 6.936 | 19323.4 |
| 250 | 2025-05-23 08:00:22 | yearend | 1 | 69583 | 3 | 5.073 | 13716.3 |
| 249 | 2025-05-20 08:42:27 | yearend | 1 | 69583 | 3 | 4.063 | 17126.0 |
| 248 | 2025-05-20 01:58:48 | yearend | 1 | 69583 | 3 | 8.123 | 8566.2 |
| 247 | 2025-05-13 04:02:50 | yearend | 1 | 69583 | 3 | 4.780 | 14557.1 |
| 246 | 2025-05-08 14:57:19 | yearend | 2 | 107671 | 18 | 19.923 | 5404.4 |
| 245 | 2025-05-07 06:22:40 | yearend | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 244 | 2025-05-03 08:00:42 | yearend | 3 | 134027 | 260 | 20.156 | 6649.5 |
| 243 | 2025-05-02 15:31:50 | yearend | 3 | 134027 | 260 | 38.796 | 3454.7 |
| 242 | 2025-05-02 02:46:44 | yearend | 3 | 134027 | 260 | 37.250 | 3598.0 |
| 241 | 2025-05-02 01:33:49 | yearend | 1 | 69583 | 3 | 5.890 | 11813.8 |
| 240 | 2025-05-01 05:16:17 | yearend | 3 | 134027 | 260 | 24.530 | 5463.8 |
| 239 | 2025-04-23 09:21:21 | yearend | 3 | 134027 | 260 | 37.330 | 3590.3 |
| 238 | 2025-04-22 13:44:07 | yearend | 2 | 107671 | 18 | 3.703 | 29076.7 |
| 237 | 2025-04-22 04:58:12 | yearend | 3 | 134027 | 260 | 11.766 | 11391.0 |
| 236 | 2025-04-20 07:45:38 | yearend | 1 | 69583 | 3 | 3.190 | 21812.9 |
| 235 | 2025-04-20 07:45:21 | yearend | 1 | 69583 | 3 | 5.890 | 11813.8 |
| 234 | 2025-04-20 01:22:25 | yearend | 1 | 69583 | 3 | 7.280 | 9558.1 |
| 233 | 2025-03-27 08:31:07 | yearend | 1 | 69583 | 3 | 5.390 | 12909.6 |
| 232 | 2025-03-20 10:08:48 | yearend | 1 | 69583 | 3 | 7.440 | 9352.6 |
| 231 | 2025-03-20 08:55:38 | yearend | 1 | 69583 | 3 | 4.313 | 16133.3 |
| 230 | 2025-03-18 22:55:13 | yearend | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 229 | 2025-03-13 07:21:07 | yearend | 1 | 69583 | 3 | 5.046 | 13789.7 |
| 228 | 2025-02-27 18:00:01 | yearend | 1 | 69583 | 3 | 2.733 | 25460.3 |
| 227 | 2024-12-29 09:26:03 | yearend | 1 | 69583 | 3 | 2.986 | 23303.1 |
| 226 | 2024-12-22 02:38:43 | yearend | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 225 | 2024-12-09 14:10:44 | yearend | 1 | 69583 | 3 | 8.233 | 8451.7 |
| 224 | 2024-12-05 09:08:59 | yearend | 3 | 134027 | 260 | 27.110 | 4943.8 |
| 223 | 2024-12-04 20:55:04 | yearend | 3 | 134027 | 260 | 36.176 | 3704.9 |
| 222 | 2024-12-04 20:55:01 | yearend | 2 | 107671 | 18 | 14.266 | 7547.4 |
| 221 | 2024-12-01 20:04:52 | yearend | 1 | 69583 | 3 | 3.016 | 23071.3 |
| 220 | 2024-11-25 15:38:50 | yearend | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 219 | 2024-10-26 09:13:56 | yearend | 1 | 69583 | 3 | 5.470 | 12720.8 |
| 218 | 2024-10-21 02:22:05 | yearend | 1 | 69583 | 3 | 4.826 | 14418.4 |
| 217 | 2024-10-08 17:32:46 | yearend | 1 | 69583 | 3 | 5.873 | 11847.9 |
| 216 | 2024-09-19 00:41:12 | yearend | 1 | 69583 | 3 | 7.890 | 8819.1 |
| 215 | 2024-09-10 17:58:02 | yearend | 1 | 69583 | 3 | 10.250 | 6788.6 |
| 214 | 2024-09-02 00:23:00 | yearend | 1 | 69583 | 3 | 4.593 | 15149.8 |
| 213 | 2024-08-17 00:11:24 | yearend | 1 | 69583 | 3 | 4.843 | 14367.7 |
| 212 | 2024-08-13 15:16:06 | yearend | 1 | 69583 | 3 | 10.406 | 6686.8 |
| 211 | 2024-08-03 22:45:29 | yearend | 1 | 69583 | 3 | 3.356 | 20733.9 |
| 210 | 2024-08-02 11:46:06 | yearend | 1 | 69583 | 3 | 4.143 | 16795.3 |
| 209 | 2024-08-02 11:43:42 | yearend | 1 | 69583 | 3 | 4.080 | 17054.7 |
| 208 | 2024-07-30 15:07:44 | yearend | 1 | 69583 | 3 | 2.343 | 29698.3 |
| 207 | 2024-07-23 14:34:35 | yearend | 1 | 69583 | 3 | 7.720 | 9013.3 |
| 206 | 2024-07-18 15:27:00 | yearend | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 205 | 2024-07-15 06:11:37 | yearend | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 204 | 2024-06-17 05:53:50 | yearend | 1 | 69583 | 3 | 4.140 | 16807.5 |
| 203 | 2024-06-17 00:27:43 | yearend | 1 | 69583 | 3 | 6.296 | 11051.9 |
| 202 | 2024-06-16 02:34:04 | yearend | 1 | 69583 | 3 | 4.156 | 16742.8 |
| 201 | 2024-06-14 17:02:29 | yearend | 1 | 69583 | 3 | 3.890 | 17887.7 |
| 200 | 2024-06-06 16:20:05 | yearend | 1 | 69583 | 3 | 2.500 | 27833.2 |