History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"waggly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 352 | 2024-05-06 09:30:35 | waggly | 3 | 112716 | 377 | 11.470 | 9827.0 |
| 351 | 2024-05-06 09:30:31 | waggly | 2 | 82551 | 46 | 2.516 | 32810.4 |
| 350 | 2024-05-06 06:44:20 | waggly | 1 | 48755 | 3 | 1.516 | 32160.3 |
| 349 | 2024-05-01 22:32:40 | waggly | 3 | 112716 | 377 | 17.906 | 6294.9 |
| 348 | 2024-05-01 17:52:34 | waggly | 2 | 82551 | 46 | 2.813 | 29346.2 |
| 347 | 2024-05-01 09:50:31 | waggly | 2 | 82551 | 46 | 5.263 | 15685.2 |
| 346 | 2024-05-01 09:33:44 | waggly | 2 | 82551 | 46 | 5.626 | 14673.1 |
| 345 | 2024-05-01 09:33:40 | waggly | 3 | 112716 | 377 | 6.470 | 17421.3 |
| 344 | 2024-05-01 09:33:35 | waggly | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 343 | 2024-05-01 09:33:17 | waggly | 3 | 112716 | 377 | 6.906 | 16321.5 |
| 342 | 2024-05-01 07:03:49 | waggly | 3 | 112716 | 377 | 18.796 | 5996.8 |
| 341 | 2024-04-30 23:32:23 | waggly | 3 | 112716 | 377 | 5.406 | 20850.2 |
| 340 | 2024-04-27 16:09:08 | waggly | 1 | 48755 | 3 | 1.013 | 48129.3 |
| 339 | 2024-04-01 08:44:24 | waggly | 1 | 48755 | 3 | 1.826 | 26700.4 |
| 338 | 2024-04-01 08:44:17 | waggly | 2 | 82551 | 46 | 2.766 | 29844.9 |
| 337 | 2024-03-30 19:50:19 | waggly | 3 | 112716 | 377 | 12.280 | 9178.8 |
| 336 | 2024-03-30 07:45:24 | waggly | 1 | 48755 | 3 | 1.843 | 26454.2 |
| 335 | 2024-03-30 00:14:30 | waggly | 3 | 112716 | 377 | 12.046 | 9357.1 |
| 334 | 2024-03-29 22:01:34 | waggly | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 333 | 2024-03-28 18:50:35 | waggly | 2 | 82551 | 46 | 8.300 | 9945.9 |
| 332 | 2024-03-28 10:48:33 | waggly | 1 | 48755 | 3 | 1.050 | 46433.3 |
| 331 | 2024-03-28 10:48:23 | waggly | 3 | 112716 | 377 | 5.186 | 21734.7 |
| 330 | 2024-03-28 10:48:21 | waggly | 2 | 82551 | 46 | 2.563 | 32208.7 |
| 329 | 2024-03-28 10:48:21 | waggly | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 328 | 2024-03-05 22:29:43 | waggly | 1 | 48755 | 3 | 1.033 | 47197.5 |
| 327 | 2024-01-16 03:59:34 | waggly | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 326 | 2023-12-21 11:57:44 | waggly | 3 | 112716 | 377 | 4.766 | 23650.0 |
| 325 | 2023-12-08 02:35:03 | waggly | 3 | 112716 | 377 | 5.046 | 22337.7 |
| 324 | 2023-12-08 02:35:05 | waggly | 2 | 82551 | 46 | 2.390 | 34540.2 |
| 323 | 2023-12-06 01:46:26 | waggly | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 322 | 2023-11-26 03:39:39 | waggly | 2 | 82551 | 46 | 2.080 | 39688.0 |
| 321 | 2023-11-11 10:08:08 | waggly | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 320 | 2023-11-11 08:10:32 | waggly | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 319 | 2023-11-11 01:25:30 | waggly | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 318 | 2023-10-27 10:27:33 | waggly | 3 | 112716 | 377 | 5.876 | 19182.4 |
| 317 | 2023-10-25 10:10:22 | waggly | 3 | 112716 | 377 | 5.470 | 20606.2 |
| 316 | 2023-10-24 21:21:40 | waggly | 3 | 112716 | 377 | 5.750 | 19602.8 |
| 315 | 2023-10-24 09:50:45 | waggly | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 314 | 2023-10-19 00:36:20 | waggly | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 313 | 2023-10-17 21:44:34 | waggly | 3 | 112716 | 377 | 4.546 | 24794.5 |
| 312 | 2023-10-13 16:16:16 | waggly | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 311 | 2023-10-06 16:37:47 | waggly | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 310 | 2023-10-06 16:20:38 | waggly | 3 | 112716 | 377 | 12.766 | 8829.4 |
| 309 | 2023-09-30 07:07:03 | waggly | 3 | 112716 | 377 | 5.486 | 20546.1 |
| 308 | 2023-09-26 19:02:18 | waggly | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 307 | 2023-09-21 04:44:06 | waggly | 3 | 112716 | 377 | 5.170 | 21801.9 |
| 306 | 2023-09-20 13:53:20 | waggly | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 305 | 2023-09-20 02:48:20 | waggly | 3 | 112716 | 377 | 5.420 | 20796.3 |
| 304 | 2023-08-31 12:08:19 | waggly | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 303 | 2023-07-03 21:14:24 | waggly | 3 | 112716 | 377 | 5.390 | 20912.1 |
| 302 | 2023-06-29 20:24:30 | waggly | 3 | 112716 | 377 | 5.423 | 20784.8 |
| 301 | 2023-06-04 06:05:07 | waggly | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 300 | 2023-03-31 15:01:14 | waggly | 3 | 112716 | 377 | 4.560 | 24718.4 |
| 299 | 2023-03-30 17:23:39 | waggly | 3 | 112716 | 377 | 4.500 | 25048.0 |
| 298 | 2023-03-28 08:21:52 | waggly | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 297 | 2023-03-25 07:15:35 | waggly | 3 | 112716 | 377 | 4.516 | 24959.3 |
| 296 | 2023-01-11 10:16:01 | waggly | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 295 | 2022-12-23 18:04:15 | waggly | 3 | 112716 | 377 | 4.483 | 25143.0 |
| 294 | 2022-10-14 18:27:59 | waggly | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 293 | 2022-09-07 16:48:01 | waggly | 3 | 112716 | 377 | 4.610 | 24450.3 |
| 292 | 2022-08-22 15:18:13 | waggly | 3 | 112716 | 377 | 4.596 | 24524.8 |
| 291 | 2022-07-01 16:30:41 | waggly | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 290 | 2022-06-05 07:17:20 | waggly | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 289 | 2022-02-15 03:24:54 | waggly | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 288 | 2021-12-21 06:06:54 | waggly | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 287 | 2021-07-17 12:58:32 | waggly | 3 | 112716 | 377 | 4.593 | 24540.8 |
| 286 | 2020-09-07 22:19:00 | waggly | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 285 | 2020-07-18 04:04:31 | waggly | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 284 | 2020-04-18 06:30:53 | waggly | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 283 | 2020-04-17 06:49:49 | waggly | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 282 | 2020-04-16 07:07:50 | waggly | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 281 | 2020-04-15 06:29:37 | waggly | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 280 | 2020-03-31 11:43:36 | waggly | 3 | 112716 | 377 | 4.700 | 23982.1 |
| 279 | 2020-03-30 01:14:01 | waggly | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 278 | 2020-03-28 14:39:12 | waggly | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 277 | 2020-03-28 04:09:10 | waggly | 1 | 48755 | 3 | 1.546 | 31536.2 |
| 276 | 2020-03-26 17:14:02 | waggly | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 275 | 2020-03-24 02:33:37 | waggly | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 274 | 2020-03-23 19:06:09 | waggly | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 273 | 2020-03-18 09:04:02 | waggly | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 272 | 2020-03-12 09:18:51 | waggly | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 271 | 2020-02-28 00:44:05 | waggly | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 270 | 2020-02-25 02:28:27 | waggly | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 269 | 2020-02-22 10:05:13 | waggly | 1 | 48755 | 3 | 1.783 | 27344.4 |
| 268 | 2020-02-20 11:21:43 | waggly | 3 | 112716 | 377 | 5.063 | 22262.7 |
| 267 | 2020-02-19 17:02:12 | waggly | 3 | 112716 | 377 | 11.546 | 9762.3 |
| 266 | 2020-02-18 18:39:31 | waggly | 3 | 112716 | 377 | 5.656 | 19928.6 |
| 265 | 2020-02-18 03:38:04 | waggly | 3 | 112716 | 377 | 5.500 | 20493.8 |
| 264 | 2020-02-06 18:53:27 | waggly | 3 | 112716 | 377 | 6.360 | 17722.6 |
| 263 | 2020-02-06 08:15:22 | waggly | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 262 | 2020-02-05 23:54:30 | waggly | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 261 | 2020-02-05 23:03:53 | waggly | 1 | 48755 | 3 | 1.940 | 25131.4 |
| 260 | 2020-02-03 18:33:58 | waggly | 3 | 112716 | 377 | 16.046 | 7024.6 |
| 259 | 2020-01-29 01:14:16 | waggly | 1 | 48755 | 3 | 2.920 | 16696.9 |
| 258 | 2020-01-28 21:47:29 | waggly | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 257 | 2020-01-24 00:31:25 | waggly | 3 | 112716 | 377 | 10.453 | 10783.1 |
| 256 | 2020-01-23 17:07:26 | waggly | 3 | 112716 | 377 | 7.300 | 15440.5 |
| 255 | 2020-01-23 16:19:18 | waggly | 3 | 112716 | 377 | 5.576 | 20214.5 |
| 254 | 2020-01-23 11:29:30 | waggly | 3 | 112716 | 377 | 6.216 | 18133.2 |
| 253 | 2020-01-18 22:54:37 | waggly | 2 | 82551 | 46 | 2.296 | 35954.3 |