History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"beverage"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 313 | 2024-04-26 07:12:54 | beverage | 4 | 161609 | 603 | 28.390 | 5692.5 |
| 312 | 2024-04-25 21:30:20 | beverage | 4 | 161609 | 603 | 23.593 | 6849.9 |
| 311 | 2024-04-25 20:52:23 | beverage | 4 | 161609 | 603 | 29.720 | 5437.7 |
| 310 | 2024-04-25 17:12:12 | beverage | 3 | 146162 | 63 | 9.860 | 14823.7 |
| 309 | 2024-04-25 17:12:16 | beverage | 2 | 121059 | 11 | 4.236 | 28578.6 |
| 308 | 2024-04-25 17:12:08 | beverage | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 307 | 2024-04-25 17:11:53 | beverage | 3 | 146162 | 63 | 7.516 | 19446.8 |
| 306 | 2024-04-25 17:11:48 | beverage | 2 | 121059 | 11 | 3.890 | 31120.6 |
| 305 | 2024-04-25 17:11:44 | beverage | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 304 | 2024-04-25 16:21:37 | beverage | 4 | 161609 | 603 | 12.046 | 13416.0 |
| 303 | 2024-04-25 16:18:32 | beverage | 4 | 161609 | 603 | 13.596 | 11886.5 |
| 302 | 2024-04-19 19:24:42 | beverage | 4 | 161609 | 603 | 45.690 | 3537.1 |
| 301 | 2024-04-05 03:15:36 | beverage | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 300 | 2024-03-30 20:14:27 | beverage | 1 | 82945 | 3 | 2.140 | 38759.3 |
| 299 | 2024-03-29 22:44:03 | beverage | 3 | 146162 | 63 | 26.096 | 5600.9 |
| 298 | 2024-03-29 22:44:02 | beverage | 2 | 121059 | 11 | 11.610 | 10427.1 |
| 297 | 2024-03-29 22:13:38 | beverage | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 296 | 2024-03-27 09:49:43 | beverage | 3 | 146162 | 63 | 13.796 | 10594.5 |
| 295 | 2024-03-27 04:47:46 | beverage | 2 | 121059 | 11 | 3.326 | 36397.8 |
| 294 | 2024-03-27 04:47:14 | beverage | 4 | 161609 | 603 | 11.906 | 13573.7 |
| 293 | 2024-03-27 04:47:09 | beverage | 3 | 146162 | 63 | 7.046 | 20744.0 |
| 292 | 2024-03-26 21:03:29 | beverage | 4 | 161609 | 603 | 13.216 | 12228.3 |
| 291 | 2024-03-26 17:27:20 | beverage | 4 | 161609 | 603 | 13.033 | 12400.0 |
| 290 | 2024-03-26 11:10:42 | beverage | 4 | 161609 | 603 | 10.826 | 14927.9 |
| 289 | 2024-03-26 11:10:37 | beverage | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 288 | 2024-03-26 11:10:26 | beverage | 2 | 121059 | 11 | 6.406 | 18897.8 |
| 287 | 2024-03-26 11:10:22 | beverage | 3 | 146162 | 63 | 10.110 | 14457.2 |
| 286 | 2024-03-26 11:10:30 | beverage | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 285 | 2024-03-26 11:10:17 | beverage | 4 | 161609 | 603 | 12.440 | 12991.1 |
| 284 | 2024-02-29 10:03:46 | beverage | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 283 | 2024-02-29 10:00:59 | beverage | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 282 | 2024-02-29 01:12:04 | beverage | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 281 | 2024-02-28 14:29:02 | beverage | 2 | 121059 | 11 | 3.763 | 32170.9 |
| 280 | 2024-02-28 14:28:48 | beverage | 3 | 146162 | 63 | 7.860 | 18595.7 |
| 279 | 2024-02-28 10:15:02 | beverage | 3 | 146162 | 63 | 16.860 | 8669.2 |
| 278 | 2024-02-28 10:15:00 | beverage | 2 | 121059 | 11 | 15.783 | 7670.2 |
| 277 | 2024-02-28 07:23:27 | beverage | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 276 | 2024-02-14 19:35:48 | beverage | 3 | 146162 | 63 | 9.953 | 14685.2 |
| 275 | 2024-02-14 19:35:48 | beverage | 2 | 121059 | 11 | 4.236 | 28578.6 |
| 274 | 2024-02-14 19:35:16 | beverage | 4 | 161609 | 603 | 14.060 | 11494.2 |
| 273 | 2024-02-14 19:14:49 | beverage | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 272 | 2024-02-08 07:28:01 | beverage | 3 | 146162 | 63 | 17.923 | 8155.0 |
| 271 | 2024-02-07 22:22:07 | beverage | 4 | 161609 | 603 | 27.300 | 5919.7 |
| 270 | 2024-02-07 17:24:57 | beverage | 4 | 161609 | 603 | 16.610 | 9729.6 |
| 269 | 2024-02-07 16:37:38 | beverage | 4 | 161609 | 603 | 13.050 | 12383.8 |
| 268 | 2024-02-07 14:37:18 | beverage | 4 | 161609 | 603 | 15.830 | 10209.0 |
| 267 | 2024-02-06 20:01:03 | beverage | 4 | 161609 | 603 | 11.266 | 14344.8 |
| 266 | 2024-02-06 20:00:55 | beverage | 2 | 121059 | 11 | 3.483 | 34757.1 |
| 265 | 2024-02-06 20:00:52 | beverage | 3 | 146162 | 63 | 6.733 | 21708.3 |
| 264 | 2024-01-28 15:24:29 | beverage | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 263 | 2024-01-27 02:25:13 | beverage | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 262 | 2024-01-13 18:35:12 | beverage | 1 | 82945 | 3 | 1.890 | 43886.2 |
| 261 | 2023-12-19 04:20:04 | beverage | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 260 | 2023-12-07 12:42:22 | beverage | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 259 | 2023-12-03 01:43:49 | beverage | 3 | 146162 | 63 | 6.393 | 22862.8 |
| 258 | 2023-11-27 10:55:42 | beverage | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 257 | 2023-11-26 04:21:38 | beverage | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 256 | 2023-11-25 06:01:33 | beverage | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 255 | 2023-11-23 00:59:16 | beverage | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 254 | 2023-11-22 02:41:37 | beverage | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 253 | 2023-11-21 02:36:52 | beverage | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 252 | 2023-11-19 19:32:49 | beverage | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 251 | 2023-11-18 20:46:12 | beverage | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 250 | 2023-11-17 15:22:34 | beverage | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 249 | 2023-11-16 19:00:53 | beverage | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 248 | 2023-11-15 15:54:19 | beverage | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 247 | 2023-11-14 09:28:12 | beverage | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 246 | 2023-10-01 07:17:42 | beverage | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 245 | 2023-09-21 02:01:40 | beverage | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 244 | 2023-09-15 00:13:58 | beverage | 1 | 82945 | 3 | 2.500 | 33178.0 |
| 243 | 2023-09-10 01:34:22 | beverage | 1 | 82945 | 3 | 1.300 | 63803.8 |
| 242 | 2023-09-05 20:52:19 | beverage | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 241 | 2023-09-04 05:48:14 | beverage | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 240 | 2023-09-02 23:00:08 | beverage | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 239 | 2023-09-01 22:17:16 | beverage | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 238 | 2023-09-01 17:44:28 | beverage | 3 | 146162 | 63 | 6.203 | 23563.1 |
| 237 | 2023-08-31 23:52:05 | beverage | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 236 | 2023-08-09 18:32:57 | beverage | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 235 | 2023-08-08 20:56:03 | beverage | 1 | 82945 | 3 | 1.300 | 63803.8 |
| 234 | 2023-08-07 15:13:36 | beverage | 1 | 82945 | 3 | 1.720 | 48223.8 |
| 233 | 2023-07-16 21:39:46 | beverage | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 232 | 2023-07-15 08:18:22 | beverage | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 231 | 2023-07-14 15:49:59 | beverage | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 230 | 2023-07-13 15:42:24 | beverage | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 229 | 2023-06-15 08:43:56 | beverage | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 228 | 2023-05-20 15:39:27 | beverage | 3 | 146162 | 63 | 6.186 | 23627.9 |
| 227 | 2023-05-15 02:23:43 | beverage | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 226 | 2023-05-10 20:24:17 | beverage | 3 | 146162 | 63 | 6.940 | 21060.8 |
| 225 | 2023-04-01 05:36:40 | beverage | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 224 | 2023-03-28 21:46:31 | beverage | 3 | 146162 | 63 | 6.203 | 23563.1 |
| 223 | 2023-03-01 10:23:36 | beverage | 3 | 146162 | 63 | 6.170 | 23689.1 |
| 222 | 2023-01-29 07:11:12 | beverage | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 221 | 2023-01-14 06:34:06 | beverage | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 220 | 2022-12-09 08:07:06 | beverage | 3 | 146162 | 63 | 6.080 | 24039.8 |
| 219 | 2022-12-04 07:26:21 | beverage | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 218 | 2022-12-01 20:57:54 | beverage | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 217 | 2022-11-29 09:21:11 | beverage | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 216 | 2022-11-06 05:23:44 | beverage | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 215 | 2022-10-11 08:16:17 | beverage | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 214 | 2022-07-20 10:41:12 | beverage | 3 | 146162 | 63 | 7.046 | 20744.0 |