History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"firefly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 380 | 2025-11-03 22:24:56 | firefly | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 379 | 2025-10-30 11:11:58 | firefly | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 378 | 2025-10-25 18:35:21 | firefly | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 377 | 2025-10-21 01:06:11 | firefly | 1 | 69583 | 1 | 2.623 | 26528.0 |
| 376 | 2025-10-21 01:06:06 | firefly | 1 | 69583 | 1 | 5.813 | 11970.2 |
| 375 | 2025-10-08 06:21:36 | firefly | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 374 | 2025-10-04 08:21:03 | firefly | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 373 | 2025-09-30 09:32:39 | firefly | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 372 | 2025-09-27 01:44:01 | firefly | 1 | 69583 | 1 | 1.200 | 57985.8 |
| 371 | 2025-09-18 15:33:51 | firefly | 1 | 69583 | 1 | 1.153 | 60349.5 |
| 370 | 2025-09-12 02:48:55 | firefly | 2 | 107671 | 13 | 3.360 | 32044.9 |
| 369 | 2025-09-11 22:16:40 | firefly | 2 | 107671 | 13 | 3.623 | 29718.7 |
| 368 | 2025-09-11 06:56:42 | firefly | 3 | 134027 | 129 | 6.283 | 21331.7 |
| 367 | 2025-09-07 18:50:39 | firefly | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 366 | 2025-09-07 01:12:44 | firefly | 3 | 134027 | 129 | 6.983 | 19193.3 |
| 365 | 2025-09-05 00:56:41 | firefly | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 364 | 2025-08-27 01:11:27 | firefly | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 363 | 2025-08-21 09:42:54 | firefly | 1 | 69583 | 1 | 1.906 | 36507.3 |
| 362 | 2025-08-05 03:21:17 | firefly | 1 | 69583 | 1 | 2.813 | 24736.2 |
| 361 | 2025-07-31 16:57:19 | firefly | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 360 | 2025-07-30 22:44:34 | firefly | 1 | 69583 | 1 | 5.783 | 12032.3 |
| 359 | 2025-07-25 04:25:02 | firefly | 1 | 69583 | 1 | 2.626 | 26497.7 |
| 358 | 2025-07-23 05:51:05 | firefly | 1 | 69583 | 1 | 2.593 | 26834.9 |
| 357 | 2025-07-22 14:12:55 | firefly | 1 | 69583 | 1 | 3.610 | 19275.1 |
| 356 | 2025-07-22 04:20:52 | firefly | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 355 | 2025-07-20 18:13:16 | firefly | 3 | 134027 | 129 | 6.846 | 19577.4 |
| 354 | 2025-07-20 03:02:47 | firefly | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 353 | 2025-07-20 02:56:20 | firefly | 2 | 107671 | 13 | 3.470 | 31029.1 |
| 352 | 2025-07-18 13:39:32 | firefly | 1 | 69583 | 1 | 3.140 | 22160.2 |
| 351 | 2025-07-12 13:21:49 | firefly | 2 | 107671 | 13 | 3.250 | 33129.5 |
| 350 | 2025-07-08 06:25:20 | firefly | 2 | 107671 | 13 | 12.770 | 8431.6 |
| 349 | 2025-07-07 14:59:39 | firefly | 1 | 69583 | 1 | 3.816 | 18234.5 |
| 348 | 2025-07-07 12:58:16 | firefly | 2 | 107671 | 13 | 7.486 | 14383.0 |
| 347 | 2025-07-07 08:46:07 | firefly | 3 | 134027 | 129 | 49.720 | 2695.6 |
| 346 | 2025-07-06 03:30:35 | firefly | 3 | 134027 | 129 | 7.330 | 18284.7 |
| 345 | 2025-07-04 23:17:00 | firefly | 3 | 134027 | 129 | 29.186 | 4592.2 |
| 344 | 2025-07-04 09:41:52 | firefly | 3 | 134027 | 129 | 17.813 | 7524.1 |
| 343 | 2025-07-04 01:19:51 | firefly | 2 | 107671 | 13 | 15.313 | 7031.3 |
| 342 | 2025-07-02 20:21:27 | firefly | 3 | 134027 | 129 | 34.686 | 3864.0 |
| 341 | 2025-07-02 11:01:12 | firefly | 2 | 107671 | 13 | 12.453 | 8646.2 |
| 340 | 2025-07-01 22:37:23 | firefly | 3 | 134027 | 129 | 27.126 | 4940.9 |
| 339 | 2025-07-01 02:40:41 | firefly | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 338 | 2025-06-24 05:36:35 | firefly | 1 | 69583 | 1 | 2.576 | 27012.0 |
| 337 | 2025-06-19 10:25:50 | firefly | 2 | 107671 | 13 | 10.250 | 10504.5 |
| 336 | 2025-06-18 18:36:05 | firefly | 2 | 107671 | 13 | 5.623 | 19148.3 |
| 335 | 2025-06-18 13:21:58 | firefly | 1 | 69583 | 1 | 5.936 | 11722.2 |
| 334 | 2025-06-18 09:15:50 | firefly | 1 | 69583 | 1 | 7.300 | 9531.9 |
| 333 | 2025-06-16 13:20:29 | firefly | 2 | 107671 | 13 | 24.036 | 4479.6 |
| 332 | 2025-06-15 02:17:18 | firefly | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 331 | 2025-06-04 14:40:23 | firefly | 1 | 69583 | 1 | 4.360 | 15959.4 |
| 330 | 2025-05-30 05:09:02 | firefly | 2 | 107671 | 13 | 14.940 | 7206.9 |
| 329 | 2025-05-27 18:21:47 | firefly | 2 | 107671 | 13 | 3.266 | 32967.2 |
| 328 | 2025-05-25 19:47:31 | firefly | 1 | 69583 | 1 | 2.106 | 33040.4 |
| 327 | 2025-05-25 09:56:10 | firefly | 3 | 134027 | 129 | 17.190 | 7796.8 |
| 326 | 2025-05-23 22:56:06 | firefly | 3 | 134027 | 129 | 24.706 | 5424.9 |
| 325 | 2025-05-23 05:39:50 | firefly | 1 | 69583 | 1 | 5.906 | 11781.7 |
| 324 | 2025-05-22 08:31:16 | firefly | 3 | 134027 | 129 | 37.910 | 3535.4 |
| 323 | 2025-05-19 23:32:22 | firefly | 3 | 134027 | 129 | 36.643 | 3657.6 |
| 322 | 2025-05-19 11:58:33 | firefly | 1 | 69583 | 1 | 3.203 | 21724.3 |
| 321 | 2025-05-18 16:22:18 | firefly | 3 | 134027 | 129 | 48.753 | 2749.1 |
| 320 | 2025-05-12 03:03:39 | firefly | 1 | 69583 | 1 | 3.016 | 23071.3 |
| 319 | 2025-05-10 12:36:26 | firefly | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 318 | 2025-05-07 13:08:56 | firefly | 1 | 69583 | 1 | 1.560 | 44604.5 |
| 317 | 2025-04-24 19:46:15 | firefly | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 316 | 2025-04-23 05:09:01 | firefly | 1 | 69583 | 1 | 4.563 | 15249.4 |
| 315 | 2025-04-23 01:33:19 | firefly | 1 | 69583 | 1 | 5.580 | 12470.1 |
| 314 | 2025-04-16 13:21:04 | firefly | 1 | 69583 | 1 | 8.576 | 8113.7 |
| 313 | 2025-04-16 08:50:06 | firefly | 1 | 69583 | 1 | 3.906 | 17814.4 |
| 312 | 2025-04-12 04:53:29 | firefly | 1 | 69583 | 1 | 7.876 | 8834.8 |
| 311 | 2025-04-11 23:01:40 | firefly | 3 | 134027 | 129 | 25.843 | 5186.2 |
| 310 | 2025-04-09 21:39:21 | firefly | 3 | 134027 | 129 | 12.470 | 10748.0 |
| 309 | 2025-04-08 01:37:19 | firefly | 1 | 69583 | 1 | 6.940 | 10026.4 |
| 308 | 2025-04-01 04:46:25 | firefly | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 307 | 2025-03-30 11:30:56 | firefly | 3 | 134027 | 129 | 7.360 | 18210.2 |
| 306 | 2025-03-27 12:20:24 | firefly | 2 | 107671 | 13 | 15.470 | 6960.0 |
| 305 | 2025-03-26 03:48:31 | firefly | 1 | 69583 | 1 | 5.516 | 12614.8 |
| 304 | 2025-03-23 06:45:46 | firefly | 1 | 69583 | 1 | 6.453 | 10783.0 |
| 303 | 2025-03-21 09:02:56 | firefly | 3 | 134027 | 129 | 35.533 | 3771.9 |
| 302 | 2025-03-16 03:47:15 | firefly | 1 | 69583 | 1 | 4.736 | 14692.4 |
| 301 | 2025-03-13 22:33:59 | firefly | 1 | 69583 | 1 | 5.593 | 12441.1 |
| 300 | 2025-03-13 17:54:38 | firefly | 3 | 134027 | 129 | 27.283 | 4912.5 |
| 299 | 2025-03-12 12:28:45 | firefly | 3 | 134027 | 129 | 32.033 | 4184.0 |
| 298 | 2025-03-10 16:22:37 | firefly | 2 | 107671 | 13 | 16.033 | 6715.6 |
| 297 | 2025-03-09 21:24:23 | firefly | 2 | 107671 | 13 | 15.546 | 6926.0 |
| 296 | 2025-03-08 18:20:26 | firefly | 1 | 69583 | 1 | 3.500 | 19880.9 |
| 295 | 2025-02-28 01:48:45 | firefly | 1 | 69583 | 1 | 5.890 | 11813.8 |
| 294 | 2025-02-24 02:06:31 | firefly | 3 | 134027 | 129 | 33.486 | 4002.5 |
| 293 | 2025-02-23 13:09:19 | firefly | 1 | 69583 | 1 | 2.610 | 26660.2 |
| 292 | 2025-02-23 12:57:14 | firefly | 3 | 134027 | 129 | 17.703 | 7570.9 |
| 291 | 2025-02-21 05:58:22 | firefly | 3 | 134027 | 129 | 33.173 | 4040.2 |
| 290 | 2025-02-21 05:58:22 | firefly | 2 | 107671 | 13 | 8.300 | 12972.4 |
| 289 | 2025-02-21 05:58:10 | firefly | 1 | 69583 | 1 | 2.703 | 25742.9 |
| 288 | 2025-01-20 01:35:06 | firefly | 1 | 69583 | 1 | 6.326 | 10999.5 |
| 287 | 2025-01-06 06:56:15 | firefly | 2 | 107671 | 13 | 14.030 | 7674.3 |
| 286 | 2025-01-06 06:56:09 | firefly | 1 | 69583 | 1 | 5.733 | 12137.3 |
| 285 | 2025-01-01 18:31:34 | firefly | 3 | 134027 | 129 | 38.220 | 3506.7 |
| 284 | 2025-01-01 11:13:41 | firefly | 3 | 134027 | 129 | 34.376 | 3898.9 |
| 283 | 2024-12-31 13:28:29 | firefly | 3 | 134027 | 129 | 34.710 | 3861.3 |
| 282 | 2024-12-31 02:42:10 | firefly | 3 | 134027 | 129 | 35.890 | 3734.4 |
| 281 | 2024-12-31 02:42:11 | firefly | 2 | 107671 | 13 | 15.140 | 7111.7 |