History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"marmite"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 368 | 2024-05-06 10:05:58 | marmite | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 367 | 2024-05-02 16:20:21 | marmite | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 366 | 2024-04-27 12:14:12 | marmite | 1 | 69583 | 3 | 3.376 | 20611.1 |
| 365 | 2024-03-07 11:56:53 | marmite | 1 | 69583 | 3 | 3.563 | 19529.3 |
| 364 | 2024-01-27 04:42:09 | marmite | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 363 | 2024-01-26 08:06:19 | marmite | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 362 | 2024-01-11 23:11:56 | marmite | 3 | 134027 | 299 | 10.813 | 12395.0 |
| 361 | 2024-01-11 23:11:58 | marmite | 2 | 107671 | 20 | 3.796 | 28364.3 |
| 360 | 2024-01-05 11:27:34 | marmite | 2 | 107671 | 20 | 3.703 | 29076.7 |
| 359 | 2024-01-05 11:27:30 | marmite | 3 | 134027 | 299 | 7.203 | 18607.1 |
| 358 | 2023-12-19 19:33:14 | marmite | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 357 | 2023-11-22 16:59:57 | marmite | 1 | 69583 | 3 | 2.186 | 31831.2 |
| 356 | 2023-11-22 12:36:59 | marmite | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 355 | 2023-11-17 00:27:04 | marmite | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 354 | 2023-11-14 08:51:55 | marmite | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 353 | 2023-10-28 17:41:55 | marmite | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 352 | 2023-10-16 05:35:49 | marmite | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 351 | 2023-10-01 13:35:34 | marmite | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 350 | 2023-09-29 21:56:24 | marmite | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 349 | 2023-09-28 07:41:38 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 348 | 2023-09-17 01:41:54 | marmite | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 347 | 2023-09-09 09:15:20 | marmite | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 346 | 2023-06-19 18:44:12 | marmite | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 345 | 2023-06-07 23:32:45 | marmite | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 344 | 2023-04-05 23:44:59 | marmite | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 343 | 2023-02-26 13:45:58 | marmite | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 342 | 2023-01-19 11:04:44 | marmite | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 341 | 2022-11-25 15:45:18 | marmite | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 340 | 2022-11-17 05:21:03 | marmite | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 339 | 2022-11-09 17:53:20 | marmite | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 338 | 2022-11-06 08:31:06 | marmite | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 337 | 2022-07-30 09:28:52 | marmite | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 336 | 2022-07-20 11:51:17 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 335 | 2022-07-16 18:34:25 | marmite | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 334 | 2022-07-07 11:05:52 | marmite | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 333 | 2022-03-22 22:41:45 | marmite | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 332 | 2022-03-12 05:50:53 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 331 | 2022-01-16 00:41:20 | marmite | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 330 | 2021-12-24 17:41:45 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 329 | 2021-12-18 08:46:33 | marmite | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 328 | 2021-12-08 23:01:16 | marmite | 1 | 69583 | 3 | 1.610 | 43219.3 |
| 327 | 2021-11-18 14:08:55 | marmite | 1 | 69583 | 3 | 1.796 | 38743.3 |
| 326 | 2021-11-17 18:17:10 | marmite | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 325 | 2021-11-12 22:11:20 | marmite | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 324 | 2021-09-01 14:10:22 | marmite | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 323 | 2021-07-29 02:15:19 | marmite | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 322 | 2021-05-31 21:38:36 | marmite | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 321 | 2021-05-26 16:27:02 | marmite | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 320 | 2021-04-30 17:03:39 | marmite | 1 | 69583 | 3 | 2.423 | 28717.7 |
| 319 | 2021-04-13 18:52:00 | marmite | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 318 | 2021-04-12 16:20:19 | marmite | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 317 | 2021-03-01 16:32:35 | marmite | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 316 | 2021-01-13 15:58:08 | marmite | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 315 | 2020-12-14 18:16:15 | marmite | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 314 | 2020-11-30 02:21:31 | marmite | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 313 | 2020-11-11 23:44:03 | marmite | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 312 | 2020-11-01 17:09:48 | marmite | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 311 | 2020-10-31 14:56:27 | marmite | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 310 | 2020-10-26 04:37:26 | marmite | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 309 | 2020-10-26 03:51:57 | marmite | 1 | 69583 | 3 | 1.843 | 37755.3 |
| 308 | 2020-08-26 12:30:22 | marmite | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 307 | 2020-05-18 21:44:27 | marmite | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 306 | 2020-05-15 17:29:38 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 305 | 2020-03-28 12:44:21 | marmite | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 304 | 2020-03-24 12:30:55 | marmite | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 303 | 2020-03-23 05:37:52 | marmite | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 302 | 2020-03-20 00:46:39 | marmite | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 301 | 2020-03-18 21:53:18 | marmite | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 300 | 2020-03-15 17:36:01 | marmite | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 299 | 2020-02-28 09:10:54 | marmite | 3 | 134027 | 299 | 14.626 | 9163.6 |
| 298 | 2020-02-28 07:49:46 | marmite | 3 | 134027 | 299 | 16.953 | 7905.8 |
| 297 | 2020-02-28 05:56:28 | marmite | 3 | 134027 | 299 | 7.830 | 17117.1 |
| 296 | 2020-02-27 22:06:06 | marmite | 3 | 134027 | 299 | 17.220 | 7783.2 |
| 295 | 2020-02-27 19:07:00 | marmite | 3 | 134027 | 299 | 25.720 | 5211.0 |
| 294 | 2020-02-27 16:05:40 | marmite | 3 | 134027 | 299 | 12.203 | 10983.1 |
| 293 | 2020-02-27 14:51:45 | marmite | 3 | 134027 | 299 | 17.860 | 7504.3 |
| 292 | 2020-02-26 06:50:35 | marmite | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 291 | 2020-02-19 03:59:47 | marmite | 1 | 69583 | 3 | 2.846 | 24449.4 |
| 290 | 2020-02-13 00:56:45 | marmite | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 289 | 2020-02-12 13:53:36 | marmite | 1 | 69583 | 3 | 1.983 | 35089.8 |
| 288 | 2020-02-05 02:24:30 | marmite | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 287 | 2020-02-05 00:40:19 | marmite | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 286 | 2020-02-03 20:30:40 | marmite | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 285 | 2020-01-31 02:09:39 | marmite | 1 | 69583 | 3 | 2.856 | 24363.8 |
| 284 | 2020-01-26 16:23:26 | marmite | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 283 | 2020-01-22 10:03:23 | marmite | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 282 | 2020-01-15 07:34:54 | marmite | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 281 | 2020-01-15 05:13:58 | marmite | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 280 | 2020-01-12 13:05:50 | marmite | 2 | 107671 | 20 | 8.140 | 13227.4 |
| 279 | 2020-01-12 11:16:42 | marmite | 2 | 107671 | 20 | 7.873 | 13676.0 |
| 278 | 2020-01-12 08:35:48 | marmite | 3 | 134027 | 299 | 7.656 | 17506.1 |
| 277 | 2020-01-12 07:05:25 | marmite | 3 | 134027 | 299 | 8.703 | 15400.1 |
| 276 | 2020-01-12 07:03:15 | marmite | 2 | 107671 | 20 | 3.813 | 28237.9 |
| 275 | 2020-01-12 03:12:48 | marmite | 3 | 134027 | 299 | 11.096 | 12078.9 |
| 274 | 2020-01-11 22:21:22 | marmite | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 273 | 2020-01-07 11:55:51 | marmite | 1 | 69583 | 3 | 3.700 | 18806.2 |
| 272 | 2019-12-27 04:17:33 | marmite | 1 | 69583 | 3 | 1.640 | 42428.7 |
| 271 | 2019-12-27 03:37:19 | marmite | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 270 | 2019-12-26 22:13:11 | marmite | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 269 | 2019-12-26 15:20:51 | marmite | 1 | 69583 | 3 | 1.313 | 52995.4 |