History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fruited"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 329 | 2024-04-25 20:41:40 | fruited | 1 | 69583 | 3 | 3.626 | 19190.0 |
| 328 | 2024-01-26 05:39:11 | fruited | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 327 | 2024-01-17 19:24:08 | fruited | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 326 | 2024-01-15 12:04:42 | fruited | 3 | 134027 | 482 | 6.360 | 21073.4 |
| 325 | 2024-01-15 12:04:44 | fruited | 2 | 107671 | 35 | 3.346 | 32179.0 |
| 324 | 2023-11-23 15:51:57 | fruited | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 323 | 2023-11-19 01:26:08 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 322 | 2023-11-16 15:16:47 | fruited | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 321 | 2023-11-05 20:43:49 | fruited | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 320 | 2023-11-04 07:58:17 | fruited | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 319 | 2023-10-23 16:06:39 | fruited | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 318 | 2023-10-05 08:45:55 | fruited | 3 | 134027 | 482 | 7.186 | 18651.1 |
| 317 | 2023-10-01 06:21:06 | fruited | 2 | 107671 | 35 | 3.530 | 30501.7 |
| 316 | 2023-10-01 02:39:18 | fruited | 3 | 134027 | 482 | 10.016 | 13381.3 |
| 315 | 2023-09-29 13:26:39 | fruited | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 314 | 2023-09-28 05:24:17 | fruited | 2 | 107671 | 35 | 3.236 | 33272.9 |
| 313 | 2023-09-28 05:24:13 | fruited | 3 | 134027 | 482 | 6.220 | 21547.7 |
| 312 | 2023-09-22 10:43:30 | fruited | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 311 | 2023-09-17 17:22:57 | fruited | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 310 | 2023-09-09 15:45:48 | fruited | 1 | 69583 | 3 | 1.013 | 68690.0 |
| 309 | 2023-06-16 11:18:01 | fruited | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 308 | 2023-06-03 20:57:32 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 307 | 2023-04-02 13:29:59 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 306 | 2023-02-18 23:37:00 | fruited | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 305 | 2023-01-17 06:19:55 | fruited | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 304 | 2022-11-13 21:29:02 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 303 | 2022-11-05 09:02:31 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 302 | 2022-11-01 21:09:58 | fruited | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 301 | 2022-07-19 01:07:53 | fruited | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 300 | 2022-07-15 18:44:52 | fruited | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 299 | 2022-07-04 00:57:21 | fruited | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 298 | 2022-03-15 03:29:47 | fruited | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 297 | 2022-03-04 12:44:41 | fruited | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 296 | 2021-12-21 08:38:20 | fruited | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 295 | 2021-12-01 10:42:34 | fruited | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 294 | 2021-10-26 07:41:02 | fruited | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 293 | 2021-10-01 12:41:38 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 292 | 2021-08-21 16:48:57 | fruited | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 291 | 2021-07-14 07:47:14 | fruited | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 290 | 2021-07-13 13:32:00 | fruited | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 289 | 2021-07-12 18:03:26 | fruited | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 288 | 2021-05-21 01:56:00 | fruited | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 287 | 2021-05-04 05:24:44 | fruited | 3 | 134027 | 482 | 6.530 | 20524.8 |
| 286 | 2021-04-02 09:09:44 | fruited | 3 | 134027 | 482 | 5.860 | 22871.5 |
| 285 | 2021-03-07 02:04:17 | fruited | 3 | 134027 | 482 | 5.876 | 22809.2 |
| 284 | 2021-02-19 08:38:34 | fruited | 2 | 107671 | 35 | 2.906 | 37051.3 |
| 283 | 2021-02-18 15:15:56 | fruited | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 282 | 2021-02-10 21:35:00 | fruited | 3 | 134027 | 482 | 6.966 | 19240.2 |
| 281 | 2020-12-18 09:15:18 | fruited | 3 | 134027 | 482 | 5.796 | 23124.1 |
| 280 | 2020-11-14 14:58:38 | fruited | 1 | 69583 | 3 | 1.876 | 37091.2 |
| 279 | 2020-11-09 06:27:52 | fruited | 2 | 107671 | 35 | 2.970 | 36252.9 |
| 278 | 2020-10-22 19:52:28 | fruited | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 277 | 2020-10-04 05:34:26 | fruited | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 276 | 2020-09-14 16:05:23 | fruited | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 275 | 2020-08-27 09:19:02 | fruited | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 274 | 2020-08-13 00:44:39 | fruited | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 273 | 2020-08-12 10:23:00 | fruited | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 272 | 2020-08-09 06:31:20 | fruited | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 271 | 2020-08-03 20:15:16 | fruited | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 270 | 2020-08-02 02:49:36 | fruited | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 269 | 2020-07-29 15:28:57 | fruited | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 268 | 2020-07-28 06:33:52 | fruited | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 267 | 2020-07-24 14:21:09 | fruited | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 266 | 2020-05-11 22:58:13 | fruited | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 265 | 2020-05-10 13:48:45 | fruited | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 264 | 2020-04-18 06:23:02 | fruited | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 263 | 2020-04-17 06:21:52 | fruited | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 262 | 2020-04-16 07:03:09 | fruited | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 261 | 2020-04-15 06:22:31 | fruited | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 260 | 2020-03-29 22:55:59 | fruited | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 259 | 2020-03-28 12:22:01 | fruited | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 258 | 2020-03-21 19:38:27 | fruited | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 257 | 2020-02-27 00:05:30 | fruited | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 256 | 2020-02-18 14:28:59 | fruited | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 255 | 2020-02-15 06:36:50 | fruited | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 254 | 2020-02-12 00:49:49 | fruited | 1 | 69583 | 3 | 1.310 | 53116.8 |
| 253 | 2020-02-10 02:12:49 | fruited | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 252 | 2020-02-09 08:21:56 | fruited | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 251 | 2020-02-05 22:58:13 | fruited | 1 | 69583 | 3 | 2.516 | 27656.2 |
| 250 | 2020-01-30 02:28:41 | fruited | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 249 | 2020-01-25 02:51:05 | fruited | 1 | 69583 | 3 | 2.706 | 25714.3 |
| 248 | 2020-01-20 17:41:38 | fruited | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 247 | 2020-01-20 16:15:04 | fruited | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 246 | 2020-01-19 04:00:41 | fruited | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 245 | 2020-01-14 14:32:11 | fruited | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 244 | 2020-01-14 13:37:59 | fruited | 1 | 69583 | 3 | 2.140 | 32515.4 |
| 243 | 2019-12-29 11:25:31 | fruited | 1 | 69583 | 3 | 2.360 | 29484.3 |
| 242 | 2019-12-29 04:06:25 | fruited | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 241 | 2019-12-29 00:23:10 | fruited | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 240 | 2019-12-28 22:45:08 | fruited | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 239 | 2019-11-08 22:22:10 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 238 | 2019-08-08 17:10:45 | fruited | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 237 | 2019-08-07 17:00:28 | fruited | 1 | 69583 | 3 | 1.000 | 69583.0 |
| 236 | 2019-05-07 19:56:18 | fruited | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 235 | 2019-02-13 19:37:46 | fruited | 1 | 69583 | 3 | 1.023 | 68018.6 |
| 234 | 2019-01-29 11:08:50 | fruited | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 233 | 2019-01-09 17:49:51 | fruited | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 232 | 2018-12-29 00:26:57 | fruited | 1 | 69583 | 3 | 1.013 | 68690.0 |
| 231 | 2018-12-15 20:30:17 | fruited | 1 | 69583 | 3 | 1.163 | 59830.6 |
| 230 | 2018-12-12 03:17:48 | fruited | 1 | 69583 | 3 | 1.156 | 60192.9 |