History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"excavated"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 352 | 2024-06-04 19:34:32 | excavated | 2 | 121436 | 5 | 6.390 | 19004.1 |
| 351 | 2024-06-04 19:08:50 | excavated | 1 | 81242 | 3 | 5.190 | 15653.6 |
| 350 | 2024-06-04 13:01:39 | excavated | 4 | 165329 | 290 | 15.626 | 10580.4 |
| 349 | 2024-06-02 20:54:56 | excavated | 2 | 121436 | 5 | 12.186 | 9965.2 |
| 348 | 2024-06-02 20:54:45 | excavated | 3 | 148641 | 36 | 15.220 | 9766.2 |
| 347 | 2024-06-02 19:31:07 | excavated | 1 | 81242 | 3 | 2.533 | 32073.4 |
| 346 | 2024-06-01 01:55:03 | excavated | 2 | 121436 | 5 | 17.923 | 6775.4 |
| 345 | 2024-06-01 01:39:16 | excavated | 1 | 81242 | 3 | 4.143 | 19609.5 |
| 344 | 2024-05-30 18:17:26 | excavated | 2 | 121436 | 5 | 3.250 | 37364.9 |
| 343 | 2024-05-13 02:21:40 | excavated | 3 | 148641 | 36 | 23.423 | 6345.9 |
| 342 | 2024-05-11 21:21:05 | excavated | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 341 | 2024-05-11 10:40:17 | excavated | 4 | 165329 | 290 | 35.846 | 4612.2 |
| 340 | 2024-05-11 04:45:42 | excavated | 4 | 165329 | 290 | 39.360 | 4200.4 |
| 339 | 2024-05-11 04:45:36 | excavated | 3 | 148641 | 36 | 8.533 | 17419.5 |
| 338 | 2024-05-09 22:55:10 | excavated | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 337 | 2024-05-09 07:08:56 | excavated | 4 | 165329 | 290 | 35.643 | 4638.5 |
| 336 | 2024-05-09 07:08:56 | excavated | 3 | 148641 | 36 | 14.593 | 10185.8 |
| 335 | 2024-05-09 07:08:54 | excavated | 2 | 121436 | 5 | 10.000 | 12143.6 |
| 334 | 2024-05-09 04:52:55 | excavated | 1 | 81242 | 3 | 2.813 | 28880.9 |
| 333 | 2024-05-03 13:59:04 | excavated | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 332 | 2024-05-01 20:05:05 | excavated | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 331 | 2024-05-01 08:13:27 | excavated | 3 | 148641 | 36 | 7.300 | 20361.8 |
| 330 | 2024-04-25 18:45:54 | excavated | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 329 | 2024-04-12 00:18:17 | excavated | 4 | 165329 | 290 | 45.643 | 3622.2 |
| 328 | 2024-04-11 05:28:49 | excavated | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 327 | 2024-04-09 03:39:18 | excavated | 3 | 148641 | 36 | 28.813 | 5158.8 |
| 326 | 2024-04-08 23:06:37 | excavated | 4 | 165329 | 290 | 15.346 | 10773.4 |
| 325 | 2024-04-08 12:58:08 | excavated | 4 | 165329 | 290 | 29.923 | 5525.1 |
| 324 | 2024-04-08 09:10:11 | excavated | 4 | 165329 | 290 | 30.016 | 5508.0 |
| 323 | 2024-04-08 09:10:13 | excavated | 3 | 148641 | 36 | 16.686 | 8908.1 |
| 322 | 2024-04-08 09:10:12 | excavated | 2 | 121436 | 5 | 8.080 | 15029.2 |
| 321 | 2024-04-08 06:46:35 | excavated | 1 | 81242 | 3 | 1.640 | 49537.8 |
| 320 | 2024-03-25 05:52:45 | excavated | 3 | 148641 | 36 | 7.420 | 20032.5 |
| 319 | 2024-03-25 05:52:47 | excavated | 2 | 121436 | 5 | 3.486 | 34835.3 |
| 318 | 2024-03-25 05:52:11 | excavated | 1 | 81242 | 3 | 1.190 | 68270.6 |
| 317 | 2024-03-12 04:01:34 | excavated | 1 | 81242 | 3 | 3.076 | 26411.6 |
| 316 | 2024-03-11 15:53:17 | excavated | 1 | 81242 | 3 | 1.953 | 41598.6 |
| 315 | 2024-03-11 07:48:34 | excavated | 4 | 165329 | 290 | 27.190 | 6080.5 |
| 314 | 2024-03-10 09:00:39 | excavated | 4 | 165329 | 290 | 43.833 | 3771.8 |
| 313 | 2024-03-09 07:38:19 | excavated | 2 | 121436 | 5 | 15.766 | 7702.4 |
| 312 | 2024-03-09 06:46:40 | excavated | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 311 | 2024-03-08 19:27:39 | excavated | 4 | 165329 | 290 | 15.546 | 10634.8 |
| 310 | 2024-03-08 18:08:35 | excavated | 4 | 165329 | 290 | 35.253 | 4689.8 |
| 309 | 2024-03-08 18:08:15 | excavated | 3 | 148641 | 36 | 22.096 | 6727.1 |
| 308 | 2024-03-08 18:08:16 | excavated | 2 | 121436 | 5 | 11.766 | 10320.9 |
| 307 | 2024-03-08 01:13:58 | excavated | 4 | 165329 | 290 | 36.500 | 4529.6 |
| 306 | 2024-03-08 01:13:54 | excavated | 3 | 148641 | 36 | 8.563 | 17358.5 |
| 305 | 2024-03-08 01:13:53 | excavated | 2 | 121436 | 5 | 4.063 | 29888.3 |
| 304 | 2024-03-07 21:38:41 | excavated | 1 | 81242 | 3 | 2.673 | 30393.6 |
| 303 | 2024-02-26 21:38:38 | excavated | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 302 | 2024-02-07 23:34:24 | excavated | 4 | 165329 | 290 | 38.580 | 4285.4 |
| 301 | 2024-02-07 23:34:23 | excavated | 3 | 148641 | 36 | 25.373 | 5858.2 |
| 300 | 2024-02-06 15:28:54 | excavated | 4 | 165329 | 290 | 11.423 | 14473.3 |
| 299 | 2024-02-06 15:28:57 | excavated | 3 | 148641 | 36 | 7.030 | 21143.8 |
| 298 | 2024-02-06 15:28:01 | excavated | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 297 | 2024-02-06 03:49:05 | excavated | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 296 | 2024-02-05 10:22:58 | excavated | 1 | 81242 | 3 | 2.813 | 28880.9 |
| 295 | 2024-02-02 18:56:27 | excavated | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 294 | 2024-01-18 19:04:04 | excavated | 2 | 121436 | 5 | 3.016 | 40263.9 |
| 293 | 2024-01-07 04:38:36 | excavated | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 292 | 2024-01-04 17:05:03 | excavated | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 291 | 2023-12-26 08:10:32 | excavated | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 290 | 2023-12-22 08:22:05 | excavated | 3 | 148641 | 36 | 5.890 | 25236.2 |
| 289 | 2023-12-08 03:54:44 | excavated | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 288 | 2023-10-29 02:10:27 | excavated | 1 | 81242 | 3 | 2.060 | 39437.9 |
| 287 | 2023-10-28 10:20:21 | excavated | 2 | 121436 | 5 | 3.140 | 38673.9 |
| 286 | 2023-10-16 23:12:30 | excavated | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 285 | 2023-09-23 09:02:38 | excavated | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 284 | 2023-09-22 16:42:02 | excavated | 3 | 148641 | 36 | 8.876 | 16746.4 |
| 283 | 2023-08-04 17:25:42 | excavated | 2 | 121436 | 5 | 3.296 | 36843.4 |
| 282 | 2023-07-20 06:19:10 | excavated | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 281 | 2023-07-02 07:03:29 | excavated | 3 | 148641 | 36 | 6.940 | 21418.0 |
| 280 | 2023-06-03 03:52:56 | excavated | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 279 | 2023-05-30 21:16:21 | excavated | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 278 | 2023-04-20 06:05:17 | excavated | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 277 | 2023-04-18 23:30:18 | excavated | 2 | 121436 | 5 | 2.936 | 41361.0 |
| 276 | 2023-03-23 09:29:29 | excavated | 3 | 148641 | 36 | 6.626 | 22433.0 |
| 275 | 2023-02-07 18:14:13 | excavated | 1 | 81242 | 3 | 1.170 | 69437.6 |
| 274 | 2023-01-20 22:58:03 | excavated | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 273 | 2023-01-20 09:43:20 | excavated | 2 | 121436 | 5 | 2.940 | 41304.8 |
| 272 | 2022-12-21 08:56:38 | excavated | 3 | 148641 | 36 | 6.766 | 21968.8 |
| 271 | 2022-12-05 23:56:23 | excavated | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 270 | 2022-10-31 16:49:03 | excavated | 2 | 121436 | 5 | 3.700 | 32820.5 |
| 269 | 2022-09-07 23:03:41 | excavated | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 268 | 2022-09-01 15:34:44 | excavated | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 267 | 2022-08-19 05:54:24 | excavated | 3 | 148641 | 36 | 5.876 | 25296.3 |
| 266 | 2022-08-16 20:00:31 | excavated | 3 | 148641 | 36 | 5.846 | 25426.1 |
| 265 | 2022-08-06 09:44:23 | excavated | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 264 | 2022-07-12 17:28:03 | excavated | 4 | 165329 | 290 | 10.190 | 16224.6 |
| 263 | 2022-06-02 16:12:18 | excavated | 2 | 121436 | 5 | 3.250 | 37364.9 |
| 262 | 2022-05-31 10:19:15 | excavated | 2 | 121436 | 5 | 2.940 | 41304.8 |
| 261 | 2022-04-24 20:57:19 | excavated | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 260 | 2022-04-02 11:18:31 | excavated | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 259 | 2022-03-12 21:13:29 | excavated | 3 | 148641 | 36 | 7.423 | 20024.4 |
| 258 | 2022-03-10 18:12:11 | excavated | 3 | 148641 | 36 | 7.220 | 20587.4 |
| 257 | 2022-02-03 22:37:31 | excavated | 2 | 121436 | 5 | 3.033 | 40038.2 |
| 256 | 2022-01-06 05:54:21 | excavated | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 255 | 2022-01-04 02:34:42 | excavated | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 254 | 2021-12-23 12:43:57 | excavated | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 253 | 2021-12-14 18:51:53 | excavated | 3 | 148641 | 36 | 6.733 | 22076.5 |