History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drummers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 360 | 2024-04-22 17:47:27 | drummers | 1 | 82945 | 3 | 4.873 | 17021.3 |
| 359 | 2024-04-02 13:00:02 | drummers | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 358 | 2024-04-01 18:41:41 | drummers | 1 | 82945 | 3 | 1.873 | 44284.6 |
| 357 | 2024-03-31 03:49:06 | drummers | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 356 | 2024-03-30 02:01:04 | drummers | 1 | 82945 | 3 | 3.390 | 24467.6 |
| 355 | 2024-03-29 20:01:21 | drummers | 1 | 82945 | 3 | 4.893 | 16951.8 |
| 354 | 2024-03-29 17:13:41 | drummers | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 353 | 2024-03-28 00:32:02 | drummers | 1 | 82945 | 3 | 3.250 | 25521.5 |
| 352 | 2024-03-27 01:02:49 | drummers | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 351 | 2024-03-23 08:11:57 | drummers | 1 | 82945 | 3 | 5.846 | 14188.3 |
| 350 | 2024-03-19 20:03:35 | drummers | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 349 | 2024-03-18 08:37:55 | drummers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 348 | 2024-03-17 09:47:56 | drummers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 347 | 2024-02-29 08:18:00 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 346 | 2024-02-29 01:10:04 | drummers | 3 | 146162 | 235 | 7.220 | 20244.0 |
| 345 | 2024-02-28 12:10:31 | drummers | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 344 | 2024-02-28 11:55:55 | drummers | 3 | 146162 | 235 | 24.533 | 5957.8 |
| 343 | 2024-02-28 11:55:56 | drummers | 2 | 121059 | 32 | 8.016 | 15102.2 |
| 342 | 2024-02-28 09:14:20 | drummers | 3 | 146162 | 235 | 14.503 | 10078.1 |
| 341 | 2024-02-28 09:14:23 | drummers | 2 | 121059 | 32 | 7.486 | 16171.4 |
| 340 | 2024-02-28 08:06:41 | drummers | 1 | 82945 | 3 | 1.766 | 46967.7 |
| 339 | 2024-02-27 01:42:21 | drummers | 1 | 82945 | 3 | 4.703 | 17636.6 |
| 338 | 2024-02-26 04:23:36 | drummers | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 337 | 2024-02-25 15:38:11 | drummers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 336 | 2024-02-24 20:27:02 | drummers | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 335 | 2024-02-23 05:06:50 | drummers | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 334 | 2024-02-22 15:46:25 | drummers | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 333 | 2024-02-22 02:50:03 | drummers | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 332 | 2024-02-21 21:45:00 | drummers | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 331 | 2024-02-20 02:02:19 | drummers | 1 | 82945 | 3 | 12.050 | 6883.4 |
| 330 | 2024-02-19 07:26:36 | drummers | 1 | 82945 | 3 | 1.810 | 45826.0 |
| 329 | 2024-02-18 13:06:55 | drummers | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 328 | 2024-02-17 20:58:34 | drummers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 327 | 2024-02-16 02:04:08 | drummers | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 326 | 2024-02-14 23:43:00 | drummers | 1 | 82945 | 3 | 4.843 | 17126.8 |
| 325 | 2024-02-13 22:05:37 | drummers | 1 | 82945 | 3 | 4.923 | 16848.5 |
| 324 | 2024-02-13 06:01:01 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 323 | 2024-01-27 09:24:47 | drummers | 2 | 121059 | 32 | 3.563 | 33976.7 |
| 322 | 2024-01-27 09:23:59 | drummers | 3 | 146162 | 235 | 7.390 | 19778.3 |
| 321 | 2024-01-27 08:13:41 | drummers | 3 | 146162 | 235 | 7.046 | 20744.0 |
| 320 | 2024-01-25 20:39:18 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 319 | 2024-01-24 21:49:07 | drummers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 318 | 2024-01-23 08:44:15 | drummers | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 317 | 2024-01-14 17:14:56 | drummers | 3 | 146162 | 235 | 7.516 | 19446.8 |
| 316 | 2024-01-14 17:14:58 | drummers | 2 | 121059 | 32 | 3.876 | 31233.0 |
| 315 | 2024-01-09 07:56:58 | drummers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 314 | 2023-12-19 04:12:11 | drummers | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 313 | 2023-12-19 02:02:21 | drummers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 312 | 2023-12-18 18:39:38 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 311 | 2023-12-18 06:20:28 | drummers | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 310 | 2023-12-17 20:55:09 | drummers | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 309 | 2023-12-17 19:00:20 | drummers | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 308 | 2023-12-17 06:03:48 | drummers | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 307 | 2023-12-16 18:40:53 | drummers | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 306 | 2023-12-15 19:04:51 | drummers | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 305 | 2023-12-09 15:54:46 | drummers | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 304 | 2023-12-08 17:53:27 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 303 | 2023-12-08 08:16:32 | drummers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 302 | 2023-12-07 16:10:42 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 301 | 2023-12-07 08:32:08 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 300 | 2023-12-06 17:09:55 | drummers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 299 | 2023-12-06 08:35:12 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 298 | 2023-12-05 02:01:22 | drummers | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 297 | 2023-11-28 15:14:58 | drummers | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 296 | 2023-11-28 01:29:02 | drummers | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 295 | 2023-11-27 15:29:56 | drummers | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 294 | 2023-11-26 15:25:23 | drummers | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 293 | 2023-11-19 10:02:00 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 292 | 2023-11-16 14:37:54 | drummers | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 291 | 2023-11-06 05:43:28 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 290 | 2023-11-05 11:25:23 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 289 | 2023-09-30 01:14:20 | drummers | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 288 | 2023-07-26 00:42:50 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 287 | 2023-04-10 13:05:26 | drummers | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 286 | 2023-04-06 20:36:45 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 285 | 2022-12-18 01:13:24 | drummers | 1 | 82945 | 3 | 2.486 | 33364.8 |
| 284 | 2022-09-04 03:34:49 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 283 | 2022-08-17 20:28:50 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 282 | 2022-08-15 04:10:29 | drummers | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 281 | 2022-08-06 19:46:16 | drummers | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 280 | 2022-07-28 02:40:12 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 279 | 2022-04-24 06:31:27 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 278 | 2022-03-27 01:53:54 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 277 | 2022-02-09 08:34:48 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 276 | 2022-01-11 04:20:33 | drummers | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 275 | 2021-12-28 16:36:10 | drummers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 274 | 2021-10-29 08:19:50 | drummers | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 273 | 2021-10-27 06:34:00 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 272 | 2021-10-08 03:30:47 | drummers | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 271 | 2021-10-04 22:31:41 | drummers | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 270 | 2021-09-30 09:14:54 | drummers | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 269 | 2021-09-21 00:36:21 | drummers | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 268 | 2021-09-20 07:32:14 | drummers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 267 | 2021-09-19 15:49:03 | drummers | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 266 | 2021-09-13 13:04:22 | drummers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 265 | 2021-07-02 10:03:36 | drummers | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 264 | 2021-06-28 23:41:07 | drummers | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 263 | 2021-05-31 20:16:36 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 262 | 2021-05-06 15:13:20 | drummers | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 261 | 2021-04-04 20:32:42 | drummers | 1 | 82945 | 3 | 1.376 | 60279.8 |