History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prepack"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 349 | 2024-04-27 23:41:44 | prepack | 2 | 107671 | 22 | 12.046 | 8938.3 |
| 348 | 2024-04-26 19:22:46 | prepack | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 347 | 2024-04-26 09:04:23 | prepack | 2 | 107671 | 22 | 5.093 | 21141.0 |
| 346 | 2024-04-21 09:33:44 | prepack | 1 | 69583 | 3 | 4.236 | 16426.6 |
| 345 | 2024-04-20 15:42:57 | prepack | 2 | 107671 | 22 | 5.876 | 18323.9 |
| 344 | 2024-04-20 15:42:48 | prepack | 1 | 69583 | 3 | 1.500 | 46388.7 |
| 343 | 2024-04-09 07:44:33 | prepack | 3 | 134027 | 170 | 6.220 | 21547.7 |
| 342 | 2024-04-07 01:22:26 | prepack | 1 | 69583 | 3 | 4.593 | 15149.8 |
| 341 | 2024-04-04 02:09:08 | prepack | 3 | 134027 | 170 | 19.186 | 6985.7 |
| 340 | 2024-04-03 15:59:37 | prepack | 3 | 134027 | 170 | 23.266 | 5760.6 |
| 339 | 2024-04-03 14:38:13 | prepack | 3 | 134027 | 170 | 23.296 | 5753.2 |
| 338 | 2024-03-28 20:57:51 | prepack | 1 | 69583 | 3 | 1.466 | 47464.5 |
| 337 | 2024-03-28 19:47:48 | prepack | 3 | 134027 | 170 | 11.206 | 11960.3 |
| 336 | 2024-03-28 17:13:02 | prepack | 3 | 134027 | 170 | 7.470 | 17942.0 |
| 335 | 2024-03-18 22:41:53 | prepack | 1 | 69583 | 3 | 4.143 | 16795.3 |
| 334 | 2024-03-06 06:17:55 | prepack | 1 | 69583 | 3 | 3.250 | 21410.2 |
| 333 | 2024-03-02 14:27:29 | prepack | 3 | 134027 | 170 | 20.050 | 6684.6 |
| 332 | 2024-03-02 06:51:06 | prepack | 3 | 134027 | 170 | 17.780 | 7538.1 |
| 331 | 2024-02-28 10:25:56 | prepack | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 330 | 2024-02-28 09:00:54 | prepack | 3 | 134027 | 170 | 17.250 | 7769.7 |
| 329 | 2024-02-23 07:09:17 | prepack | 2 | 107671 | 22 | 3.670 | 29338.1 |
| 328 | 2024-02-23 07:09:00 | prepack | 3 | 134027 | 170 | 7.423 | 18055.6 |
| 327 | 2024-02-18 01:04:21 | prepack | 3 | 134027 | 170 | 17.800 | 7529.6 |
| 326 | 2024-02-18 01:04:20 | prepack | 2 | 107671 | 22 | 6.716 | 16032.0 |
| 325 | 2024-02-17 18:59:07 | prepack | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 324 | 2024-01-22 10:05:59 | prepack | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 323 | 2024-01-15 02:29:50 | prepack | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 322 | 2023-12-21 20:40:05 | prepack | 2 | 107671 | 22 | 3.376 | 31893.1 |
| 321 | 2023-12-10 21:20:35 | prepack | 3 | 134027 | 170 | 7.186 | 18651.1 |
| 320 | 2023-11-26 17:33:54 | prepack | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 319 | 2023-11-24 23:21:07 | prepack | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 318 | 2023-11-19 04:16:15 | prepack | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 317 | 2023-11-18 10:11:38 | prepack | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 316 | 2023-11-01 01:42:27 | prepack | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 315 | 2023-10-14 02:32:06 | prepack | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 314 | 2023-10-12 00:49:56 | prepack | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 313 | 2023-10-08 08:53:52 | prepack | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 312 | 2023-09-30 23:04:05 | prepack | 3 | 134027 | 170 | 15.720 | 8525.9 |
| 311 | 2023-09-25 16:37:43 | prepack | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 310 | 2023-09-24 23:20:14 | prepack | 3 | 134027 | 170 | 6.766 | 19808.9 |
| 309 | 2023-09-23 03:41:56 | prepack | 2 | 107671 | 22 | 4.610 | 23356.0 |
| 308 | 2023-09-21 18:20:35 | prepack | 3 | 134027 | 170 | 6.190 | 21652.2 |
| 307 | 2023-09-14 19:33:12 | prepack | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 306 | 2023-09-14 14:14:14 | prepack | 3 | 134027 | 170 | 8.093 | 16560.9 |
| 305 | 2023-09-07 20:55:05 | prepack | 3 | 134027 | 170 | 6.406 | 20922.1 |
| 304 | 2023-09-04 09:18:23 | prepack | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 303 | 2023-07-02 20:28:59 | prepack | 2 | 107671 | 22 | 3.330 | 32333.6 |
| 302 | 2023-06-17 00:20:14 | prepack | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 301 | 2023-05-25 03:16:20 | prepack | 3 | 134027 | 170 | 5.813 | 23056.4 |
| 300 | 2023-04-09 04:33:23 | prepack | 3 | 134027 | 170 | 6.766 | 19808.9 |
| 299 | 2023-03-26 01:34:36 | prepack | 2 | 107671 | 22 | 2.906 | 37051.3 |
| 298 | 2023-03-04 16:03:54 | prepack | 3 | 134027 | 170 | 6.126 | 21878.4 |
| 297 | 2023-02-22 09:54:22 | prepack | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 296 | 2023-01-22 06:23:42 | prepack | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 295 | 2022-12-24 00:17:27 | prepack | 2 | 107671 | 22 | 2.780 | 38730.6 |
| 294 | 2022-12-13 08:23:15 | prepack | 3 | 134027 | 170 | 6.000 | 22337.8 |
| 293 | 2022-11-19 12:12:15 | prepack | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 292 | 2022-10-25 16:08:45 | prepack | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 291 | 2022-10-19 09:39:38 | prepack | 3 | 134027 | 170 | 6.250 | 21444.3 |
| 290 | 2022-08-23 01:05:45 | prepack | 2 | 107671 | 22 | 3.110 | 34620.9 |
| 289 | 2022-07-30 01:24:33 | prepack | 3 | 134027 | 170 | 5.890 | 22755.0 |
| 288 | 2022-07-12 04:16:29 | prepack | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 287 | 2022-06-20 18:43:20 | prepack | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 286 | 2022-03-27 14:35:03 | prepack | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 285 | 2022-02-15 23:59:39 | prepack | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 284 | 2021-11-21 12:38:54 | prepack | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 283 | 2021-11-19 10:41:57 | prepack | 1 | 69583 | 3 | 1.310 | 53116.8 |
| 282 | 2021-11-03 07:15:11 | prepack | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 281 | 2021-10-25 13:35:13 | prepack | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 280 | 2021-10-14 18:12:08 | prepack | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 279 | 2021-10-13 22:10:28 | prepack | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 278 | 2021-10-12 13:58:29 | prepack | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 277 | 2021-10-11 16:54:37 | prepack | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 276 | 2021-10-10 13:50:37 | prepack | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 275 | 2021-10-03 01:45:22 | prepack | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 274 | 2021-09-24 07:45:48 | prepack | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 273 | 2021-09-23 15:02:03 | prepack | 1 | 69583 | 3 | 2.610 | 26660.2 |
| 272 | 2021-09-22 22:14:16 | prepack | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 271 | 2021-09-16 21:10:18 | prepack | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 270 | 2021-09-16 00:46:15 | prepack | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 269 | 2021-07-18 13:14:49 | prepack | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 268 | 2021-05-09 07:10:31 | prepack | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 267 | 2021-05-05 00:57:09 | prepack | 3 | 134027 | 170 | 7.376 | 18170.7 |
| 266 | 2021-04-15 20:26:59 | prepack | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 265 | 2021-04-12 00:13:12 | prepack | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 264 | 2021-04-09 03:45:50 | prepack | 3 | 134027 | 170 | 6.280 | 21341.9 |
| 263 | 2021-04-07 20:52:41 | prepack | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 262 | 2021-02-16 15:36:30 | prepack | 3 | 134027 | 170 | 5.920 | 22639.7 |
| 261 | 2021-01-22 21:29:52 | prepack | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 260 | 2021-01-19 14:43:13 | prepack | 3 | 134027 | 170 | 6.156 | 21771.8 |
| 259 | 2020-12-25 08:44:16 | prepack | 3 | 134027 | 170 | 6.640 | 20184.8 |
| 258 | 2020-12-22 09:07:30 | prepack | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 257 | 2020-11-27 15:57:30 | prepack | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 256 | 2020-11-01 17:06:50 | prepack | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 255 | 2020-10-27 03:28:00 | prepack | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 254 | 2020-10-16 03:14:33 | prepack | 3 | 134027 | 170 | 6.780 | 19768.0 |
| 253 | 2020-10-09 00:27:10 | prepack | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 252 | 2020-09-22 04:24:02 | prepack | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 251 | 2020-09-17 02:08:36 | prepack | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 250 | 2020-09-04 14:15:21 | prepack | 1 | 69583 | 3 | 1.236 | 56296.9 |