History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pothouse"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 320 | 2024-04-24 23:19:07 | pothouse | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 319 | 2024-04-07 09:32:03 | pothouse | 4 | 161609 | 619 | 49.660 | 3254.3 |
| 318 | 2024-04-07 07:08:43 | pothouse | 4 | 161609 | 619 | 39.753 | 4065.3 |
| 317 | 2024-04-04 23:25:29 | pothouse | 4 | 161609 | 619 | 23.126 | 6988.2 |
| 316 | 2024-04-04 23:25:31 | pothouse | 3 | 146162 | 93 | 8.940 | 16349.2 |
| 315 | 2024-04-04 21:41:20 | pothouse | 1 | 82945 | 3 | 1.986 | 41764.9 |
| 314 | 2024-04-04 21:41:06 | pothouse | 3 | 146162 | 93 | 13.970 | 10462.6 |
| 313 | 2024-04-04 21:41:07 | pothouse | 2 | 121059 | 17 | 4.470 | 27082.6 |
| 312 | 2024-04-04 21:40:49 | pothouse | 4 | 161609 | 619 | 13.360 | 12096.5 |
| 311 | 2024-04-04 21:41:00 | pothouse | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 310 | 2024-04-03 16:07:03 | pothouse | 1 | 82945 | 3 | 2.893 | 28670.9 |
| 309 | 2024-04-01 12:30:24 | pothouse | 1 | 82945 | 3 | 1.673 | 49578.6 |
| 308 | 2024-03-30 13:49:38 | pothouse | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 307 | 2024-03-27 07:12:53 | pothouse | 2 | 121059 | 17 | 4.626 | 26169.3 |
| 306 | 2024-03-26 17:28:20 | pothouse | 2 | 121059 | 17 | 3.313 | 36540.6 |
| 305 | 2024-03-26 07:23:29 | pothouse | 4 | 161609 | 619 | 14.360 | 11254.1 |
| 304 | 2024-03-26 07:23:22 | pothouse | 2 | 121059 | 17 | 3.623 | 33414.0 |
| 303 | 2024-03-26 07:17:45 | pothouse | 3 | 146162 | 93 | 15.830 | 9233.2 |
| 302 | 2024-03-24 16:39:30 | pothouse | 3 | 146162 | 93 | 8.233 | 17753.2 |
| 301 | 2024-03-24 16:39:28 | pothouse | 2 | 121059 | 17 | 3.860 | 31362.4 |
| 300 | 2024-03-24 16:39:22 | pothouse | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 299 | 2024-03-07 20:57:37 | pothouse | 3 | 146162 | 93 | 13.843 | 10558.5 |
| 298 | 2024-03-07 16:53:30 | pothouse | 4 | 161609 | 619 | 15.766 | 10250.5 |
| 297 | 2024-03-06 01:21:52 | pothouse | 2 | 121059 | 17 | 5.893 | 20542.8 |
| 296 | 2024-03-06 01:18:40 | pothouse | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 295 | 2024-03-05 02:06:22 | pothouse | 3 | 146162 | 93 | 21.376 | 6837.7 |
| 294 | 2024-03-04 20:43:36 | pothouse | 3 | 146162 | 93 | 12.503 | 11690.2 |
| 293 | 2024-03-04 20:43:24 | pothouse | 4 | 161609 | 619 | 24.033 | 6724.5 |
| 292 | 2024-03-04 20:43:41 | pothouse | 1 | 82945 | 3 | 3.076 | 26965.2 |
| 291 | 2024-03-04 20:43:25 | pothouse | 2 | 121059 | 17 | 7.986 | 15158.9 |
| 290 | 2024-03-04 20:43:13 | pothouse | 1 | 82945 | 3 | 2.923 | 28376.7 |
| 289 | 2024-03-03 06:28:32 | pothouse | 3 | 146162 | 93 | 25.986 | 5624.6 |
| 288 | 2024-02-29 07:23:02 | pothouse | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 287 | 2024-02-28 23:29:18 | pothouse | 2 | 121059 | 17 | 4.126 | 29340.5 |
| 286 | 2024-02-26 11:39:56 | pothouse | 4 | 161609 | 619 | 12.876 | 12551.2 |
| 285 | 2024-02-22 23:32:08 | pothouse | 3 | 146162 | 93 | 8.500 | 17195.5 |
| 284 | 2024-02-21 10:42:35 | pothouse | 4 | 161609 | 619 | 39.876 | 4052.8 |
| 283 | 2024-02-21 10:42:45 | pothouse | 3 | 146162 | 93 | 14.500 | 10080.1 |
| 282 | 2024-02-21 10:42:39 | pothouse | 2 | 121059 | 17 | 8.766 | 13810.1 |
| 281 | 2024-02-09 21:30:50 | pothouse | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 280 | 2024-02-07 01:55:23 | pothouse | 2 | 121059 | 17 | 7.890 | 15343.3 |
| 279 | 2024-02-07 01:50:19 | pothouse | 3 | 146162 | 93 | 6.766 | 21602.4 |
| 278 | 2024-02-04 17:09:29 | pothouse | 4 | 161609 | 619 | 14.626 | 11049.4 |
| 277 | 2024-02-04 02:11:03 | pothouse | 2 | 121059 | 17 | 3.390 | 35710.6 |
| 276 | 2024-02-03 04:03:46 | pothouse | 4 | 161609 | 619 | 14.576 | 11087.3 |
| 275 | 2024-02-03 04:03:50 | pothouse | 3 | 146162 | 93 | 9.953 | 14685.2 |
| 274 | 2024-02-03 04:03:42 | pothouse | 2 | 121059 | 17 | 7.970 | 15189.3 |
| 273 | 2024-02-03 03:56:26 | pothouse | 4 | 161609 | 619 | 12.483 | 12946.3 |
| 272 | 2024-02-03 03:56:22 | pothouse | 3 | 146162 | 93 | 7.533 | 19402.9 |
| 271 | 2024-02-03 03:56:18 | pothouse | 2 | 121059 | 17 | 4.516 | 26806.7 |
| 270 | 2024-02-03 03:56:14 | pothouse | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 269 | 2024-01-08 21:22:08 | pothouse | 1 | 82945 | 3 | 1.750 | 47397.1 |
| 268 | 2024-01-03 16:31:15 | pothouse | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 267 | 2023-12-25 13:43:30 | pothouse | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 266 | 2023-12-21 23:29:56 | pothouse | 1 | 82945 | 3 | 1.410 | 58826.2 |
| 265 | 2023-11-20 11:32:14 | pothouse | 2 | 121059 | 17 | 3.220 | 37596.0 |
| 264 | 2023-11-20 08:40:31 | pothouse | 4 | 161609 | 619 | 11.203 | 14425.5 |
| 263 | 2023-11-18 20:08:50 | pothouse | 3 | 146162 | 93 | 8.220 | 17781.3 |
| 262 | 2023-10-14 23:45:56 | pothouse | 1 | 82945 | 3 | 1.656 | 50087.6 |
| 261 | 2023-10-09 08:34:00 | pothouse | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 260 | 2023-09-28 11:55:43 | pothouse | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 259 | 2023-09-27 18:38:58 | pothouse | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 258 | 2023-08-21 07:57:52 | pothouse | 2 | 121059 | 17 | 3.190 | 37949.5 |
| 257 | 2023-08-20 06:28:17 | pothouse | 4 | 161609 | 619 | 10.983 | 14714.5 |
| 256 | 2023-08-19 22:46:01 | pothouse | 3 | 146162 | 93 | 6.830 | 21400.0 |
| 255 | 2023-08-05 09:48:36 | pothouse | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 254 | 2023-07-12 18:28:03 | pothouse | 4 | 161609 | 619 | 11.703 | 13809.2 |
| 253 | 2023-06-29 09:28:40 | pothouse | 4 | 161609 | 619 | 12.173 | 13276.0 |
| 252 | 2023-06-01 04:47:16 | pothouse | 4 | 161609 | 619 | 10.703 | 15099.4 |
| 251 | 2023-05-22 17:00:53 | pothouse | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 250 | 2023-05-06 10:31:03 | pothouse | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 249 | 2023-05-05 07:45:58 | pothouse | 3 | 146162 | 93 | 7.126 | 20511.1 |
| 248 | 2023-05-05 00:22:17 | pothouse | 2 | 121059 | 17 | 3.093 | 39139.7 |
| 247 | 2023-05-01 10:07:00 | pothouse | 4 | 161609 | 619 | 10.326 | 15650.7 |
| 246 | 2023-04-12 18:18:24 | pothouse | 4 | 161609 | 619 | 10.563 | 15299.5 |
| 245 | 2023-02-28 02:28:23 | pothouse | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 244 | 2023-02-23 08:05:09 | pothouse | 3 | 146162 | 93 | 6.750 | 21653.6 |
| 243 | 2023-02-18 20:49:53 | pothouse | 4 | 161609 | 619 | 10.753 | 15029.2 |
| 242 | 2023-02-11 20:35:18 | pothouse | 3 | 146162 | 93 | 6.206 | 23551.7 |
| 241 | 2023-02-11 08:51:19 | pothouse | 2 | 121059 | 17 | 3.140 | 38553.8 |
| 240 | 2023-02-09 06:12:17 | pothouse | 4 | 161609 | 619 | 11.123 | 14529.3 |
| 239 | 2023-02-06 19:37:34 | pothouse | 4 | 161609 | 619 | 10.346 | 15620.4 |
| 238 | 2023-01-26 17:06:48 | pothouse | 3 | 146162 | 93 | 7.653 | 19098.7 |
| 237 | 2023-01-24 12:58:27 | pothouse | 4 | 161609 | 619 | 14.173 | 11402.6 |
| 236 | 2023-01-23 14:47:43 | pothouse | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 235 | 2023-01-22 20:56:47 | pothouse | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 234 | 2022-12-30 15:39:56 | pothouse | 4 | 161609 | 619 | 11.643 | 13880.4 |
| 233 | 2022-12-24 20:44:55 | pothouse | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 232 | 2022-12-16 23:33:16 | pothouse | 3 | 146162 | 93 | 6.923 | 21112.5 |
| 231 | 2022-12-09 10:30:56 | pothouse | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 230 | 2022-11-27 04:51:25 | pothouse | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 229 | 2022-11-26 01:58:11 | pothouse | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 228 | 2022-11-23 13:53:53 | pothouse | 2 | 121059 | 17 | 3.296 | 36729.1 |
| 227 | 2022-11-22 11:55:39 | pothouse | 3 | 146162 | 93 | 7.860 | 18595.7 |
| 226 | 2022-11-19 00:58:38 | pothouse | 4 | 161609 | 619 | 10.486 | 15411.9 |
| 225 | 2022-11-16 10:00:30 | pothouse | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 224 | 2022-11-08 09:18:03 | pothouse | 1 | 82945 | 3 | 1.690 | 49079.9 |
| 223 | 2022-09-16 22:54:36 | pothouse | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 222 | 2022-09-12 22:13:01 | pothouse | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 221 | 2022-06-28 23:32:56 | pothouse | 4 | 161609 | 619 | 10.500 | 15391.3 |