History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ditches"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 337 | 2024-05-01 20:07:15 | ditches | 1 | 69583 | 11 | 3.953 | 17602.6 |
| 336 | 2024-04-20 15:48:21 | ditches | 1 | 69583 | 11 | 3.390 | 20526.0 |
| 335 | 2024-04-06 11:15:00 | ditches | 1 | 69583 | 11 | 3.156 | 22047.8 |
| 334 | 2024-03-31 05:23:30 | ditches | 1 | 69583 | 11 | 5.360 | 12981.9 |
| 333 | 2024-03-31 05:21:15 | ditches | 1 | 69583 | 11 | 1.373 | 50679.5 |
| 332 | 2024-03-28 12:33:17 | ditches | 1 | 69583 | 11 | 1.190 | 58473.1 |
| 331 | 2024-03-13 03:57:17 | ditches | 1 | 69583 | 11 | 1.080 | 64428.7 |
| 330 | 2024-03-07 19:26:04 | ditches | 3 | 134027 | 532 | 14.533 | 9222.3 |
| 329 | 2024-03-06 23:56:19 | ditches | 3 | 134027 | 532 | 17.656 | 7591.0 |
| 328 | 2024-03-06 13:44:03 | ditches | 3 | 134027 | 532 | 17.890 | 7491.7 |
| 327 | 2024-03-06 13:11:57 | ditches | 3 | 134027 | 532 | 15.330 | 8742.8 |
| 326 | 2024-03-04 22:01:42 | ditches | 3 | 134027 | 532 | 17.000 | 7883.9 |
| 325 | 2024-03-04 14:14:16 | ditches | 3 | 134027 | 532 | 17.233 | 7777.3 |
| 324 | 2024-03-04 14:14:18 | ditches | 2 | 107671 | 90 | 12.013 | 8962.9 |
| 323 | 2024-03-04 13:54:13 | ditches | 1 | 69583 | 11 | 1.190 | 58473.1 |
| 322 | 2024-02-25 17:25:20 | ditches | 1 | 69583 | 11 | 1.173 | 59320.5 |
| 321 | 2024-02-03 08:19:10 | ditches | 2 | 107671 | 90 | 2.873 | 37476.9 |
| 320 | 2024-02-03 08:15:17 | ditches | 3 | 134027 | 532 | 5.876 | 22809.2 |
| 319 | 2024-02-02 22:09:12 | ditches | 2 | 107671 | 90 | 5.106 | 21087.2 |
| 318 | 2024-01-29 14:16:52 | ditches | 1 | 69583 | 11 | 1.203 | 57841.2 |
| 317 | 2024-01-22 09:42:58 | ditches | 1 | 69583 | 11 | 1.106 | 62914.1 |
| 316 | 2024-01-17 07:41:33 | ditches | 3 | 134027 | 532 | 6.170 | 21722.4 |
| 315 | 2023-12-31 14:39:55 | ditches | 3 | 134027 | 532 | 6.690 | 20033.9 |
| 314 | 2023-12-22 09:23:20 | ditches | 1 | 69583 | 11 | 1.296 | 53690.6 |
| 313 | 2023-12-20 05:47:48 | ditches | 1 | 69583 | 11 | 1.233 | 56433.9 |
| 312 | 2023-12-17 07:42:12 | ditches | 3 | 134027 | 532 | 6.483 | 20673.6 |
| 311 | 2023-12-08 15:39:22 | ditches | 2 | 107671 | 90 | 2.733 | 39396.6 |
| 310 | 2023-12-02 20:37:03 | ditches | 2 | 107671 | 90 | 11.596 | 9285.2 |
| 309 | 2023-11-23 11:43:53 | ditches | 3 | 134027 | 532 | 6.016 | 22278.4 |
| 308 | 2023-11-23 11:43:50 | ditches | 2 | 107671 | 90 | 2.966 | 36301.8 |
| 307 | 2023-11-17 13:19:28 | ditches | 1 | 69583 | 11 | 1.170 | 59472.6 |
| 306 | 2023-11-11 19:07:13 | ditches | 1 | 69583 | 11 | 2.550 | 27287.5 |
| 305 | 2023-11-09 19:39:50 | ditches | 1 | 69583 | 11 | 1.216 | 57222.9 |
| 304 | 2023-11-09 19:23:58 | ditches | 2 | 107671 | 90 | 2.873 | 37476.9 |
| 303 | 2023-10-21 19:19:37 | ditches | 1 | 69583 | 11 | 1.076 | 64668.2 |
| 302 | 2023-10-19 14:08:58 | ditches | 1 | 69583 | 11 | 1.280 | 54361.7 |
| 301 | 2023-10-14 13:02:43 | ditches | 1 | 69583 | 11 | 1.156 | 60192.9 |
| 300 | 2023-10-07 14:41:14 | ditches | 1 | 69583 | 11 | 1.110 | 62687.4 |
| 299 | 2023-10-04 09:05:19 | ditches | 3 | 134027 | 532 | 6.016 | 22278.4 |
| 298 | 2023-09-29 18:43:47 | ditches | 1 | 69583 | 11 | 1.266 | 54962.9 |
| 297 | 2023-09-26 19:59:23 | ditches | 1 | 69583 | 11 | 1.203 | 57841.2 |
| 296 | 2023-08-13 11:30:52 | ditches | 2 | 107671 | 90 | 3.296 | 32667.2 |
| 295 | 2023-08-03 06:00:31 | ditches | 1 | 69583 | 11 | 1.186 | 58670.3 |
| 294 | 2023-07-14 07:22:38 | ditches | 3 | 134027 | 532 | 5.673 | 23625.4 |
| 293 | 2023-07-05 01:21:55 | ditches | 1 | 69583 | 11 | 1.076 | 64668.2 |
| 292 | 2023-04-29 02:52:29 | ditches | 1 | 69583 | 11 | 1.060 | 65644.3 |
| 291 | 2023-04-24 15:31:05 | ditches | 2 | 107671 | 90 | 2.970 | 36252.9 |
| 290 | 2023-03-31 04:25:27 | ditches | 3 | 134027 | 532 | 6.266 | 21389.6 |
| 289 | 2023-03-28 13:33:33 | ditches | 1 | 69583 | 11 | 1.153 | 60349.5 |
| 288 | 2023-02-18 09:19:48 | ditches | 1 | 69583 | 11 | 1.203 | 57841.2 |
| 287 | 2023-01-29 08:46:27 | ditches | 2 | 107671 | 90 | 2.750 | 39153.1 |
| 286 | 2022-12-27 19:50:16 | ditches | 3 | 134027 | 532 | 5.593 | 23963.3 |
| 285 | 2022-12-23 09:07:30 | ditches | 1 | 69583 | 11 | 1.043 | 66714.3 |
| 284 | 2022-12-19 18:17:03 | ditches | 1 | 69583 | 11 | 1.220 | 57035.2 |
| 283 | 2022-12-15 13:40:02 | ditches | 1 | 69583 | 11 | 1.140 | 61037.7 |
| 282 | 2022-11-25 06:53:45 | ditches | 1 | 69583 | 11 | 1.126 | 61796.6 |
| 281 | 2022-11-10 02:14:52 | ditches | 2 | 107671 | 90 | 3.123 | 34476.8 |
| 280 | 2022-09-10 16:24:48 | ditches | 1 | 69583 | 11 | 1.046 | 66522.9 |
| 279 | 2022-09-05 14:47:02 | ditches | 1 | 69583 | 11 | 1.170 | 59472.6 |
| 278 | 2022-09-01 21:06:21 | ditches | 1 | 69583 | 11 | 1.076 | 64668.2 |
| 277 | 2022-08-28 05:41:12 | ditches | 3 | 134027 | 532 | 6.096 | 21986.1 |
| 276 | 2022-08-25 21:51:49 | ditches | 1 | 69583 | 11 | 1.063 | 65459.1 |
| 275 | 2022-08-23 12:28:40 | ditches | 1 | 69583 | 11 | 1.046 | 66522.9 |
| 274 | 2022-06-11 14:20:09 | ditches | 2 | 107671 | 90 | 2.763 | 38968.9 |
| 273 | 2022-05-17 14:07:52 | ditches | 1 | 69583 | 11 | 1.326 | 52475.9 |
| 272 | 2022-05-14 00:53:40 | ditches | 1 | 69583 | 11 | 1.360 | 51164.0 |
| 271 | 2022-04-07 05:23:36 | ditches | 1 | 69583 | 11 | 1.060 | 65644.3 |
| 270 | 2022-04-05 01:28:57 | ditches | 1 | 69583 | 11 | 1.190 | 58473.1 |
| 269 | 2022-02-09 07:05:48 | ditches | 1 | 69583 | 11 | 1.063 | 65459.1 |
| 268 | 2022-01-26 08:52:27 | ditches | 2 | 107671 | 90 | 4.123 | 26114.7 |
| 267 | 2022-01-06 15:51:16 | ditches | 1 | 69583 | 11 | 1.390 | 50059.7 |
| 266 | 2022-01-04 13:38:36 | ditches | 1 | 69583 | 11 | 1.250 | 55666.4 |
| 265 | 2021-11-07 00:34:37 | ditches | 1 | 69583 | 11 | 1.186 | 58670.3 |
| 264 | 2021-11-05 01:52:56 | ditches | 1 | 69583 | 11 | 1.173 | 59320.5 |
| 263 | 2021-11-03 04:02:58 | ditches | 2 | 107671 | 90 | 2.810 | 38317.1 |
| 262 | 2021-09-28 16:39:29 | ditches | 1 | 69583 | 11 | 1.343 | 51811.6 |
| 261 | 2021-09-07 05:59:15 | ditches | 1 | 69583 | 11 | 1.046 | 66522.9 |
| 260 | 2021-08-12 17:04:40 | ditches | 1 | 69583 | 11 | 1.186 | 58670.3 |
| 259 | 2021-08-05 07:42:33 | ditches | 1 | 69583 | 11 | 1.063 | 65459.1 |
| 258 | 2021-05-20 19:35:12 | ditches | 1 | 69583 | 11 | 1.173 | 59320.5 |
| 257 | 2021-05-01 04:56:48 | ditches | 1 | 69583 | 11 | 1.313 | 52995.4 |
| 256 | 2021-04-21 02:56:37 | ditches | 1 | 69583 | 11 | 1.173 | 59320.5 |
| 255 | 2021-04-03 03:27:49 | ditches | 1 | 69583 | 11 | 1.173 | 59320.5 |
| 254 | 2021-03-23 17:28:55 | ditches | 1 | 69583 | 11 | 1.220 | 57035.2 |
| 253 | 2021-01-28 18:09:32 | ditches | 1 | 69583 | 11 | 1.093 | 63662.4 |
| 252 | 2021-01-26 14:01:52 | ditches | 1 | 69583 | 11 | 1.186 | 58670.3 |
| 251 | 2021-01-05 21:06:28 | ditches | 1 | 69583 | 11 | 1.233 | 56433.9 |
| 250 | 2020-11-02 19:58:33 | ditches | 1 | 69583 | 11 | 1.106 | 62914.1 |
| 249 | 2020-11-01 01:03:25 | ditches | 1 | 69583 | 11 | 1.093 | 63662.4 |
| 248 | 2020-10-29 10:05:18 | ditches | 1 | 69583 | 11 | 1.250 | 55666.4 |
| 247 | 2020-10-25 22:33:17 | ditches | 1 | 69583 | 11 | 1.186 | 58670.3 |
| 246 | 2020-10-08 05:26:56 | ditches | 1 | 69583 | 11 | 1.190 | 58473.1 |
| 245 | 2020-09-26 04:20:15 | ditches | 1 | 69583 | 11 | 1.046 | 66522.9 |
| 244 | 2020-08-14 10:17:08 | ditches | 1 | 69583 | 11 | 1.190 | 58473.1 |
| 243 | 2020-07-22 09:39:35 | ditches | 1 | 69583 | 11 | 1.216 | 57222.9 |
| 242 | 2020-05-19 05:17:13 | ditches | 1 | 69583 | 11 | 1.080 | 64428.7 |
| 241 | 2020-05-08 02:55:52 | ditches | 1 | 69583 | 11 | 1.063 | 65459.1 |
| 240 | 2020-04-20 11:23:31 | ditches | 1 | 69583 | 11 | 1.110 | 62687.4 |
| 239 | 2020-03-28 23:33:35 | ditches | 1 | 69583 | 11 | 1.076 | 64668.2 |
| 238 | 2020-03-25 07:33:38 | ditches | 1 | 69583 | 11 | 1.203 | 57841.2 |