History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trestle"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 321 | 2024-05-07 10:14:54 | trestle | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 320 | 2024-04-27 04:37:35 | trestle | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 319 | 2024-04-07 22:38:56 | trestle | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 318 | 2024-03-01 20:53:43 | trestle | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 317 | 2024-03-01 07:01:06 | trestle | 2 | 107671 | 30 | 3.673 | 29314.2 |
| 316 | 2024-03-01 07:00:48 | trestle | 3 | 134027 | 296 | 7.860 | 17051.8 |
| 315 | 2024-02-29 03:59:44 | trestle | 2 | 107671 | 30 | 3.623 | 29718.7 |
| 314 | 2024-02-29 03:54:57 | trestle | 3 | 134027 | 296 | 8.986 | 14915.1 |
| 313 | 2024-02-25 09:33:48 | trestle | 3 | 134027 | 296 | 6.580 | 20368.8 |
| 312 | 2024-01-23 18:00:04 | trestle | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 311 | 2024-01-14 15:42:45 | trestle | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 310 | 2024-01-04 07:16:20 | trestle | 2 | 107671 | 30 | 3.063 | 35152.1 |
| 309 | 2023-12-27 13:13:57 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 308 | 2023-12-20 11:04:44 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 307 | 2023-12-12 05:20:12 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 306 | 2023-12-10 18:17:41 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 305 | 2023-11-20 14:27:32 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 304 | 2023-11-20 11:33:31 | trestle | 1 | 69583 | 3 | 2.140 | 32515.4 |
| 303 | 2023-11-19 15:16:25 | trestle | 3 | 134027 | 296 | 5.810 | 23068.3 |
| 302 | 2023-11-03 08:43:37 | trestle | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 301 | 2023-11-01 19:39:26 | trestle | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 300 | 2023-10-28 21:25:41 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 299 | 2023-10-17 23:02:20 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 298 | 2023-10-16 04:13:28 | trestle | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 297 | 2023-10-11 09:13:32 | trestle | 2 | 107671 | 30 | 3.046 | 35348.3 |
| 296 | 2023-10-03 20:19:03 | trestle | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 295 | 2023-10-01 19:37:32 | trestle | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 294 | 2023-09-29 17:13:48 | trestle | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 293 | 2023-09-28 05:28:13 | trestle | 1 | 69583 | 3 | 2.686 | 25905.8 |
| 292 | 2023-09-26 19:24:58 | trestle | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 291 | 2023-09-25 23:32:41 | trestle | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 290 | 2023-09-23 01:19:30 | trestle | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 289 | 2023-09-12 14:37:37 | trestle | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 288 | 2023-09-11 02:25:11 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 287 | 2023-09-04 20:36:43 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 286 | 2023-09-03 05:58:55 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 285 | 2023-09-02 03:51:11 | trestle | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 284 | 2023-08-20 11:57:51 | trestle | 3 | 134027 | 296 | 5.906 | 22693.4 |
| 283 | 2023-08-12 19:45:17 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 282 | 2023-07-28 19:34:06 | trestle | 1 | 69583 | 3 | 2.220 | 31343.7 |
| 281 | 2023-07-21 21:11:31 | trestle | 2 | 107671 | 30 | 3.296 | 32667.2 |
| 280 | 2023-07-17 03:56:54 | trestle | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 279 | 2023-07-15 07:04:02 | trestle | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 278 | 2023-07-14 18:52:14 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 277 | 2023-07-11 19:17:03 | trestle | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 276 | 2023-07-10 09:35:53 | trestle | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 275 | 2023-06-09 07:59:53 | trestle | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 274 | 2023-06-08 08:04:06 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 273 | 2023-06-06 20:09:32 | trestle | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 272 | 2023-06-06 11:04:18 | trestle | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 271 | 2023-06-05 14:36:47 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 270 | 2023-06-04 19:38:35 | trestle | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 269 | 2023-06-03 02:29:24 | trestle | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 268 | 2023-06-02 02:25:58 | trestle | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 267 | 2023-06-01 10:54:47 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 266 | 2023-05-31 11:32:28 | trestle | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 265 | 2023-05-15 08:47:50 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 264 | 2023-05-04 19:43:46 | trestle | 3 | 134027 | 296 | 5.763 | 23256.5 |
| 263 | 2023-04-30 02:53:39 | trestle | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 262 | 2023-04-29 02:59:39 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 261 | 2023-04-28 03:04:10 | trestle | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 260 | 2023-04-27 02:53:49 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 259 | 2023-04-26 13:44:35 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 258 | 2023-04-26 03:02:34 | trestle | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 257 | 2023-04-25 12:07:16 | trestle | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 256 | 2023-04-25 02:44:22 | trestle | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 255 | 2023-04-04 19:07:22 | trestle | 2 | 107671 | 30 | 2.846 | 37832.4 |
| 254 | 2023-03-22 06:48:47 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 253 | 2023-03-13 17:36:46 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 252 | 2023-02-11 11:43:53 | trestle | 3 | 134027 | 296 | 5.986 | 22390.1 |
| 251 | 2023-01-04 15:15:18 | trestle | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 250 | 2023-01-03 16:13:56 | trestle | 2 | 107671 | 30 | 6.313 | 17055.4 |
| 249 | 2022-11-22 07:34:25 | trestle | 3 | 134027 | 296 | 5.753 | 23296.9 |
| 248 | 2022-11-13 16:53:16 | trestle | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 247 | 2022-09-30 06:34:19 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 246 | 2022-09-07 20:10:09 | trestle | 2 | 107671 | 30 | 2.890 | 37256.4 |
| 245 | 2022-06-29 17:07:04 | trestle | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 244 | 2022-06-29 00:10:06 | trestle | 3 | 134027 | 296 | 6.126 | 21878.4 |
| 243 | 2022-06-26 18:28:12 | trestle | 3 | 134027 | 296 | 6.016 | 22278.4 |
| 242 | 2022-06-25 19:43:04 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 241 | 2022-05-15 12:59:02 | trestle | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 240 | 2022-04-16 19:49:33 | trestle | 2 | 107671 | 30 | 2.800 | 38453.9 |
| 239 | 2022-02-10 07:30:27 | trestle | 3 | 134027 | 296 | 7.190 | 18640.8 |
| 238 | 2022-02-10 01:19:36 | trestle | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 237 | 2022-01-30 04:26:40 | trestle | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 236 | 2021-12-07 20:45:43 | trestle | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 235 | 2021-10-04 02:29:17 | trestle | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 234 | 2021-08-12 17:18:26 | trestle | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 233 | 2021-07-01 12:56:55 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 232 | 2021-05-29 16:19:47 | trestle | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 231 | 2021-05-04 04:38:11 | trestle | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 230 | 2021-04-02 07:49:18 | trestle | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 229 | 2021-03-31 15:37:39 | trestle | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 228 | 2021-02-10 21:51:39 | trestle | 1 | 69583 | 3 | 2.440 | 28517.6 |
| 227 | 2020-12-19 23:53:34 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 226 | 2020-11-13 16:00:34 | trestle | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 225 | 2020-10-20 04:02:52 | trestle | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 224 | 2020-10-12 19:47:38 | trestle | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 223 | 2020-10-08 08:48:14 | trestle | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 222 | 2020-09-19 13:38:33 | trestle | 1 | 69583 | 3 | 1.046 | 66522.9 |