History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"melilite"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 342 | 2024-04-08 16:31:17 | melilite | 3 | 146162 | 99 | 19.420 | 7526.4 |
| 341 | 2024-04-08 10:39:03 | melilite | 3 | 146162 | 99 | 18.063 | 8091.8 |
| 340 | 2024-04-08 03:46:41 | melilite | 3 | 146162 | 99 | 15.470 | 9448.1 |
| 339 | 2024-04-07 21:15:12 | melilite | 4 | 161609 | 1060 | 45.753 | 3532.2 |
| 338 | 2024-04-07 16:46:47 | melilite | 1 | 82945 | 3 | 3.706 | 22381.3 |
| 337 | 2024-04-07 06:36:37 | melilite | 4 | 161609 | 1060 | 47.440 | 3406.6 |
| 336 | 2024-04-06 16:18:03 | melilite | 3 | 146162 | 99 | 19.563 | 7471.3 |
| 335 | 2024-04-06 16:17:58 | melilite | 4 | 161609 | 1060 | 20.906 | 7730.3 |
| 334 | 2024-04-06 09:54:04 | melilite | 3 | 146162 | 99 | 26.113 | 5597.3 |
| 333 | 2024-04-06 04:42:02 | melilite | 4 | 161609 | 1060 | 39.846 | 4055.8 |
| 332 | 2024-04-06 00:58:16 | melilite | 4 | 161609 | 1060 | 24.910 | 6487.7 |
| 331 | 2024-04-05 23:09:18 | melilite | 4 | 161609 | 1060 | 40.156 | 4024.5 |
| 330 | 2024-04-05 23:09:20 | melilite | 3 | 146162 | 99 | 25.860 | 5652.0 |
| 329 | 2024-04-05 23:09:21 | melilite | 2 | 121059 | 8 | 15.563 | 7778.6 |
| 328 | 2024-04-05 23:09:10 | melilite | 1 | 82945 | 3 | 2.123 | 39069.7 |
| 327 | 2024-03-31 20:26:12 | melilite | 1 | 82945 | 3 | 4.843 | 17126.8 |
| 326 | 2024-03-29 19:33:43 | melilite | 1 | 82945 | 3 | 3.280 | 25288.1 |
| 325 | 2024-03-28 23:57:32 | melilite | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 324 | 2024-03-06 22:48:05 | melilite | 4 | 161609 | 1060 | 21.063 | 7672.6 |
| 323 | 2024-03-06 01:56:24 | melilite | 4 | 161609 | 1060 | 24.876 | 6496.6 |
| 322 | 2024-03-01 14:06:55 | melilite | 1 | 82945 | 3 | 2.686 | 30880.5 |
| 321 | 2024-03-01 14:03:22 | melilite | 3 | 146162 | 99 | 20.343 | 7184.9 |
| 320 | 2024-03-01 14:03:21 | melilite | 2 | 121059 | 8 | 5.250 | 23058.9 |
| 319 | 2024-03-01 14:03:19 | melilite | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 318 | 2024-03-01 13:51:06 | melilite | 4 | 161609 | 1060 | 15.860 | 10189.7 |
| 317 | 2024-02-28 13:26:07 | melilite | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 316 | 2024-02-27 17:03:11 | melilite | 4 | 161609 | 1060 | 13.046 | 12387.6 |
| 315 | 2024-02-27 17:03:12 | melilite | 3 | 146162 | 99 | 7.906 | 18487.5 |
| 314 | 2024-02-27 17:03:08 | melilite | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 313 | 2024-02-05 07:21:03 | melilite | 2 | 121059 | 8 | 4.030 | 30039.5 |
| 312 | 2024-02-05 07:20:51 | melilite | 3 | 146162 | 99 | 8.703 | 16794.4 |
| 311 | 2024-02-05 00:06:35 | melilite | 4 | 161609 | 1060 | 22.330 | 7237.3 |
| 310 | 2024-01-29 11:12:03 | melilite | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 309 | 2024-01-29 08:10:34 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 308 | 2024-01-29 05:37:08 | melilite | 2 | 121059 | 8 | 3.766 | 32145.2 |
| 307 | 2024-01-27 01:13:47 | melilite | 2 | 121059 | 8 | 3.906 | 30993.1 |
| 306 | 2024-01-27 01:12:43 | melilite | 3 | 146162 | 99 | 8.390 | 17421.0 |
| 305 | 2024-01-24 13:29:45 | melilite | 4 | 161609 | 1060 | 14.563 | 11097.2 |
| 304 | 2024-01-23 15:03:24 | melilite | 4 | 161609 | 1060 | 14.190 | 11388.9 |
| 303 | 2024-01-23 15:03:22 | melilite | 2 | 121059 | 8 | 3.983 | 30393.9 |
| 302 | 2024-01-23 12:16:54 | melilite | 3 | 146162 | 99 | 8.046 | 18165.8 |
| 301 | 2024-01-23 03:36:40 | melilite | 3 | 146162 | 99 | 8.593 | 17009.4 |
| 300 | 2024-01-22 23:18:52 | melilite | 3 | 146162 | 99 | 7.330 | 19940.2 |
| 299 | 2023-12-24 01:33:29 | melilite | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 298 | 2023-12-09 15:07:32 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 297 | 2023-11-29 20:40:14 | melilite | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 296 | 2023-11-29 09:01:15 | melilite | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 295 | 2023-11-20 17:37:57 | melilite | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 294 | 2023-11-03 01:34:23 | melilite | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 293 | 2023-11-01 05:06:53 | melilite | 3 | 146162 | 99 | 7.376 | 19815.9 |
| 292 | 2023-10-30 18:57:20 | melilite | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 291 | 2023-09-23 10:19:19 | melilite | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 290 | 2023-08-07 15:17:53 | melilite | 3 | 146162 | 99 | 6.500 | 22486.5 |
| 289 | 2023-07-19 10:28:44 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 288 | 2023-07-14 19:32:00 | melilite | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 287 | 2023-04-17 05:38:57 | melilite | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 286 | 2023-04-13 20:55:44 | melilite | 3 | 146162 | 99 | 6.216 | 23513.8 |
| 285 | 2023-03-23 12:41:42 | melilite | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 284 | 2023-03-20 05:55:16 | melilite | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 283 | 2023-02-10 15:33:44 | melilite | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 282 | 2023-02-08 19:41:19 | melilite | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 281 | 2023-01-20 03:48:44 | melilite | 3 | 146162 | 99 | 7.123 | 20519.7 |
| 280 | 2022-12-23 00:58:35 | melilite | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 279 | 2022-12-06 17:33:37 | melilite | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 278 | 2022-11-28 18:21:35 | melilite | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 277 | 2022-11-06 19:38:36 | melilite | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 276 | 2022-11-06 19:08:03 | melilite | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 275 | 2022-11-02 07:00:47 | melilite | 3 | 146162 | 99 | 7.406 | 19735.6 |
| 274 | 2022-08-08 11:14:09 | melilite | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 273 | 2022-08-04 01:35:04 | melilite | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 272 | 2022-05-16 04:05:26 | melilite | 3 | 146162 | 99 | 7.563 | 19325.9 |
| 271 | 2022-04-14 04:59:20 | melilite | 1 | 82945 | 3 | 2.783 | 29804.2 |
| 270 | 2022-03-27 01:10:18 | melilite | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 269 | 2021-12-26 14:52:34 | melilite | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 268 | 2021-12-26 11:15:07 | melilite | 1 | 82945 | 3 | 1.920 | 43200.5 |
| 267 | 2021-10-29 07:45:32 | melilite | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 266 | 2021-10-02 12:16:41 | melilite | 1 | 82945 | 3 | 2.123 | 39069.7 |
| 265 | 2021-09-19 06:58:26 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 264 | 2021-06-19 09:37:53 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 263 | 2021-05-30 20:17:01 | melilite | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 262 | 2021-05-20 08:16:51 | melilite | 3 | 146162 | 99 | 6.673 | 21903.5 |
| 261 | 2021-05-08 03:34:11 | melilite | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 260 | 2021-04-30 07:10:10 | melilite | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 259 | 2021-04-27 12:12:15 | melilite | 2 | 121059 | 8 | 3.860 | 31362.4 |
| 258 | 2021-04-06 13:25:41 | melilite | 1 | 82945 | 3 | 2.220 | 37362.6 |
| 257 | 2021-03-24 15:34:27 | melilite | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 256 | 2021-03-23 19:41:45 | melilite | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 255 | 2021-03-23 06:27:52 | melilite | 3 | 146162 | 99 | 6.780 | 21557.8 |
| 254 | 2021-03-16 19:41:18 | melilite | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 253 | 2021-01-21 18:55:04 | melilite | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 252 | 2021-01-10 22:03:30 | melilite | 2 | 121059 | 8 | 3.470 | 34887.3 |
| 251 | 2021-01-05 05:33:43 | melilite | 3 | 146162 | 99 | 7.000 | 20880.3 |
| 250 | 2020-12-22 15:21:01 | melilite | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 249 | 2020-12-13 20:15:37 | melilite | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 248 | 2020-11-17 04:09:32 | melilite | 2 | 121059 | 8 | 3.340 | 36245.2 |
| 247 | 2020-11-13 06:42:23 | melilite | 3 | 146162 | 99 | 6.796 | 21507.1 |
| 246 | 2020-11-02 00:40:12 | melilite | 1 | 82945 | 3 | 1.550 | 53512.9 |
| 245 | 2020-10-27 12:15:19 | melilite | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 244 | 2020-10-23 06:02:11 | melilite | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 243 | 2020-10-16 20:28:57 | melilite | 1 | 82945 | 3 | 1.296 | 64000.8 |