History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drainpipe"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 317 | 2025-08-19 14:50:32 | drainpipe | 2 | 121436 | 2 | 8.546 | 14209.7 |
| 316 | 2025-08-03 09:36:05 | drainpipe | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 315 | 2025-08-03 04:17:41 | drainpipe | 1 | 81242 | 2 | 3.376 | 24064.6 |
| 314 | 2025-08-02 13:28:41 | drainpipe | 4 | 165329 | 98 | 31.343 | 5274.8 |
| 313 | 2025-07-29 01:26:09 | drainpipe | 4 | 165329 | 98 | 49.230 | 3358.3 |
| 312 | 2025-07-28 17:12:06 | drainpipe | 3 | 148641 | 10 | 18.626 | 7980.3 |
| 311 | 2025-07-25 18:39:53 | drainpipe | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 310 | 2025-07-24 20:35:02 | drainpipe | 1 | 81242 | 2 | 6.906 | 11764.0 |
| 309 | 2025-07-19 05:23:03 | drainpipe | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 308 | 2025-07-07 23:42:39 | drainpipe | 3 | 148641 | 10 | 23.656 | 6283.4 |
| 307 | 2025-06-30 00:37:03 | drainpipe | 2 | 121436 | 2 | 15.033 | 8078.0 |
| 306 | 2025-06-29 19:50:54 | drainpipe | 3 | 148641 | 10 | 41.580 | 3574.8 |
| 305 | 2025-06-28 16:49:17 | drainpipe | 1 | 81242 | 2 | 7.033 | 11551.5 |
| 304 | 2025-06-14 14:49:58 | drainpipe | 4 | 165329 | 98 | 58.673 | 2817.8 |
| 303 | 2025-06-13 05:38:18 | drainpipe | 4 | 165329 | 98 | 53.236 | 3105.6 |
| 302 | 2025-06-08 13:28:48 | drainpipe | 4 | 165329 | 98 | 72.013 | 2295.8 |
| 301 | 2025-06-08 07:04:47 | drainpipe | 2 | 121436 | 2 | 12.613 | 9627.8 |
| 300 | 2025-06-07 17:32:07 | drainpipe | 1 | 81242 | 2 | 1.403 | 57905.9 |
| 299 | 2025-05-27 11:32:32 | drainpipe | 1 | 81242 | 2 | 3.796 | 21402.0 |
| 298 | 2025-05-18 16:53:30 | drainpipe | 1 | 81242 | 2 | 3.796 | 21402.0 |
| 297 | 2025-05-08 05:01:43 | drainpipe | 1 | 81242 | 2 | 4.970 | 16346.5 |
| 296 | 2025-04-26 11:33:20 | drainpipe | 1 | 81242 | 2 | 6.016 | 13504.3 |
| 295 | 2025-04-18 13:52:24 | drainpipe | 1 | 81242 | 2 | 5.250 | 15474.7 |
| 294 | 2025-04-13 00:11:10 | drainpipe | 1 | 81242 | 2 | 3.220 | 25230.4 |
| 293 | 2025-03-29 20:24:58 | drainpipe | 3 | 148641 | 10 | 28.330 | 5246.8 |
| 292 | 2025-03-29 14:41:11 | drainpipe | 3 | 148641 | 10 | 31.220 | 4761.1 |
| 291 | 2025-03-28 22:49:28 | drainpipe | 1 | 81242 | 2 | 4.656 | 17448.9 |
| 290 | 2025-03-15 23:21:34 | drainpipe | 1 | 81242 | 2 | 6.703 | 12120.2 |
| 289 | 2025-03-13 11:59:57 | drainpipe | 1 | 81242 | 2 | 8.750 | 9284.8 |
| 288 | 2025-02-28 08:39:20 | drainpipe | 1 | 81242 | 2 | 9.140 | 8888.6 |
| 287 | 2025-02-28 08:29:21 | drainpipe | 1 | 81242 | 2 | 4.406 | 18438.9 |
| 286 | 2025-02-26 00:39:42 | drainpipe | 2 | 121436 | 2 | 14.220 | 8539.8 |
| 285 | 2025-02-03 18:13:22 | drainpipe | 2 | 121436 | 2 | 19.956 | 6085.2 |
| 284 | 2025-02-03 18:13:21 | drainpipe | 2 | 121436 | 2 | 19.426 | 6251.2 |
| 283 | 2025-02-03 18:13:06 | drainpipe | 2 | 121436 | 2 | 18.470 | 6574.8 |
| 282 | 2025-02-03 18:13:12 | drainpipe | 2 | 121436 | 2 | 9.220 | 13170.9 |
| 281 | 2025-02-03 18:12:44 | drainpipe | 1 | 81242 | 2 | 5.860 | 13863.8 |
| 280 | 2025-01-28 01:53:05 | drainpipe | 1 | 81242 | 2 | 2.750 | 29542.5 |
| 279 | 2025-01-27 02:25:54 | drainpipe | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 278 | 2025-01-23 07:52:07 | drainpipe | 3 | 148641 | 10 | 37.016 | 4015.6 |
| 277 | 2025-01-23 07:51:52 | drainpipe | 2 | 121436 | 2 | 29.063 | 4178.4 |
| 276 | 2025-01-19 05:31:31 | drainpipe | 3 | 148641 | 10 | 42.580 | 3490.9 |
| 275 | 2025-01-19 05:31:29 | drainpipe | 3 | 148641 | 10 | 38.863 | 3824.7 |
| 274 | 2025-01-19 05:30:57 | drainpipe | 3 | 148641 | 10 | 31.973 | 4649.0 |
| 273 | 2025-01-19 05:31:01 | drainpipe | 2 | 121436 | 2 | 18.766 | 6471.1 |
| 272 | 2025-01-19 05:30:41 | drainpipe | 1 | 81242 | 2 | 5.953 | 13647.2 |
| 271 | 2024-12-30 20:39:57 | drainpipe | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 270 | 2024-12-27 12:53:18 | drainpipe | 1 | 81242 | 2 | 6.970 | 11656.0 |
| 269 | 2024-12-19 17:36:09 | drainpipe | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 268 | 2024-11-20 18:20:15 | drainpipe | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 267 | 2024-11-19 02:47:17 | drainpipe | 2 | 121436 | 2 | 11.296 | 10750.4 |
| 266 | 2024-11-19 02:20:14 | drainpipe | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 265 | 2024-11-14 05:25:02 | drainpipe | 3 | 148641 | 10 | 36.503 | 4072.0 |
| 264 | 2024-11-14 05:25:00 | drainpipe | 2 | 121436 | 2 | 18.283 | 6642.0 |
| 263 | 2024-11-01 14:05:20 | drainpipe | 1 | 81242 | 2 | 6.686 | 12151.1 |
| 262 | 2024-10-27 11:33:56 | drainpipe | 1 | 81242 | 2 | 10.610 | 7657.1 |
| 261 | 2024-10-25 16:23:00 | drainpipe | 3 | 148641 | 10 | 18.860 | 7881.3 |
| 260 | 2024-10-25 12:31:21 | drainpipe | 4 | 165329 | 98 | 64.316 | 2570.6 |
| 259 | 2024-10-25 12:31:16 | drainpipe | 4 | 165329 | 98 | 64.003 | 2583.1 |
| 258 | 2024-10-25 12:31:40 | drainpipe | 2 | 121436 | 2 | 26.986 | 4500.0 |
| 257 | 2024-10-25 12:31:27 | drainpipe | 3 | 148641 | 10 | 35.426 | 4195.8 |
| 256 | 2024-10-12 10:43:51 | drainpipe | 1 | 81242 | 2 | 6.936 | 11713.1 |
| 255 | 2024-09-20 06:12:36 | drainpipe | 1 | 81242 | 2 | 13.650 | 5951.8 |
| 254 | 2024-09-19 02:27:37 | drainpipe | 1 | 81242 | 2 | 7.466 | 10881.6 |
| 253 | 2024-08-07 03:51:18 | drainpipe | 3 | 148641 | 10 | 24.940 | 5959.9 |
| 252 | 2024-07-29 07:19:32 | drainpipe | 3 | 148641 | 10 | 37.923 | 3919.5 |
| 251 | 2024-07-29 07:19:32 | drainpipe | 2 | 121436 | 2 | 11.360 | 10689.8 |
| 250 | 2024-07-29 06:12:51 | drainpipe | 1 | 81242 | 2 | 1.450 | 56029.0 |
| 249 | 2024-07-28 12:32:57 | drainpipe | 3 | 148641 | 10 | 36.033 | 4125.1 |
| 248 | 2024-07-28 12:29:10 | drainpipe | 3 | 148641 | 10 | 52.693 | 2820.9 |
| 247 | 2024-07-13 08:32:37 | drainpipe | 1 | 81242 | 2 | 4.940 | 16445.7 |
| 246 | 2024-07-10 04:41:12 | drainpipe | 2 | 121436 | 2 | 12.250 | 9913.1 |
| 245 | 2024-07-10 04:40:58 | drainpipe | 3 | 148641 | 10 | 23.313 | 6375.9 |
| 244 | 2024-07-10 04:34:54 | drainpipe | 1 | 81242 | 2 | 2.470 | 32891.5 |
| 243 | 2024-07-06 23:17:10 | drainpipe | 1 | 81242 | 2 | 6.346 | 12802.1 |
| 242 | 2024-06-15 09:10:10 | drainpipe | 4 | 165329 | 98 | 62.610 | 2640.6 |
| 241 | 2024-06-13 14:09:52 | drainpipe | 4 | 165329 | 98 | 38.626 | 4280.3 |
| 240 | 2024-06-13 03:37:19 | drainpipe | 4 | 165329 | 98 | 54.973 | 3007.5 |
| 239 | 2024-06-13 00:18:48 | drainpipe | 3 | 148641 | 10 | 22.173 | 6703.7 |
| 238 | 2024-06-12 18:01:23 | drainpipe | 4 | 165329 | 98 | 49.456 | 3343.0 |
| 237 | 2024-06-12 18:01:23 | drainpipe | 3 | 148641 | 10 | 36.563 | 4065.3 |
| 236 | 2024-06-12 18:01:33 | drainpipe | 2 | 121436 | 2 | 19.410 | 6256.4 |
| 235 | 2024-06-12 18:00:06 | drainpipe | 1 | 81242 | 2 | 2.546 | 31909.7 |
| 234 | 2024-06-10 04:58:02 | drainpipe | 4 | 165329 | 98 | 46.390 | 3563.9 |
| 233 | 2024-06-09 13:03:24 | drainpipe | 4 | 165329 | 98 | 34.970 | 4727.7 |
| 232 | 2024-06-09 11:16:53 | drainpipe | 4 | 165329 | 98 | 43.876 | 3768.1 |
| 231 | 2024-06-09 08:58:29 | drainpipe | 4 | 165329 | 98 | 36.690 | 4506.1 |
| 230 | 2024-06-09 07:03:24 | drainpipe | 3 | 148641 | 10 | 21.223 | 7003.8 |
| 229 | 2024-06-09 02:54:45 | drainpipe | 4 | 165329 | 98 | 59.486 | 2779.3 |
| 228 | 2024-06-09 02:54:42 | drainpipe | 5 | 174418 | 1103 | 57.770 | 3019.2 |
| 227 | 2024-06-09 02:54:47 | drainpipe | 3 | 148641 | 10 | 33.876 | 4387.8 |
| 226 | 2024-06-09 02:54:52 | drainpipe | 2 | 121436 | 2 | 11.440 | 10615.0 |
| 225 | 2024-06-09 02:52:40 | drainpipe | 1 | 81242 | 2 | 5.063 | 16046.2 |
| 224 | 2024-06-06 13:43:01 | drainpipe | 1 | 81242 | 2 | 4.936 | 16459.1 |
| 223 | 2024-06-06 09:42:48 | drainpipe | 1 | 81242 | 2 | 3.673 | 22118.7 |
| 222 | 2024-05-11 06:22:00 | drainpipe | 1 | 81242 | 2 | 2.983 | 27235.0 |
| 221 | 2024-05-09 08:21:25 | drainpipe | 2 | 121436 | 2 | 10.483 | 11584.1 |
| 220 | 2024-05-09 08:21:17 | drainpipe | 3 | 148641 | 10 | 18.236 | 8151.0 |
| 219 | 2024-05-09 08:20:20 | drainpipe | 1 | 81242 | 2 | 2.250 | 36107.6 |
| 218 | 2024-05-09 03:07:02 | drainpipe | 4 | 165329 | 98 | 27.376 | 6039.2 |