History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"poultry"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 340 | 2024-05-04 03:34:00 | poultry | 1 | 69583 | 1 | 1.326 | 52475.9 |
| 339 | 2024-05-03 15:54:31 | poultry | 2 | 107671 | 13 | 3.033 | 35499.8 |
| 338 | 2024-05-03 15:54:16 | poultry | 3 | 134027 | 115 | 8.360 | 16031.9 |
| 337 | 2024-05-03 08:19:03 | poultry | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 336 | 2024-05-03 05:29:12 | poultry | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 335 | 2024-04-01 16:02:05 | poultry | 1 | 69583 | 1 | 3.250 | 21410.2 |
| 334 | 2024-03-31 13:45:25 | poultry | 1 | 69583 | 1 | 2.736 | 25432.4 |
| 333 | 2024-03-31 06:01:40 | poultry | 1 | 69583 | 1 | 2.953 | 23563.5 |
| 332 | 2024-03-31 06:01:07 | poultry | 1 | 69583 | 1 | 4.156 | 16742.8 |
| 331 | 2024-03-31 00:14:15 | poultry | 1 | 69583 | 1 | 2.720 | 25582.0 |
| 330 | 2024-03-02 14:39:43 | poultry | 1 | 69583 | 1 | 4.080 | 17054.7 |
| 329 | 2024-02-28 04:14:23 | poultry | 1 | 69583 | 1 | 3.373 | 20629.4 |
| 328 | 2024-02-26 23:29:41 | poultry | 2 | 107671 | 13 | 3.563 | 30219.2 |
| 327 | 2024-02-05 17:03:20 | poultry | 3 | 134027 | 115 | 16.596 | 8075.9 |
| 326 | 2024-02-05 15:14:14 | poultry | 3 | 134027 | 115 | 9.626 | 13923.4 |
| 325 | 2024-02-05 13:17:35 | poultry | 3 | 134027 | 115 | 7.283 | 18402.7 |
| 324 | 2024-02-05 10:54:54 | poultry | 2 | 107671 | 13 | 3.720 | 28943.8 |
| 323 | 2024-02-05 10:53:10 | poultry | 3 | 134027 | 115 | 7.750 | 17293.8 |
| 322 | 2024-02-05 01:42:50 | poultry | 2 | 107671 | 13 | 2.953 | 36461.6 |
| 321 | 2024-02-05 01:35:38 | poultry | 3 | 134027 | 115 | 7.300 | 18359.9 |
| 320 | 2024-01-15 07:25:00 | poultry | 3 | 134027 | 115 | 6.873 | 19500.5 |
| 319 | 2024-01-15 07:25:02 | poultry | 2 | 107671 | 13 | 3.436 | 31336.1 |
| 318 | 2023-12-23 13:20:54 | poultry | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 317 | 2023-12-21 16:32:19 | poultry | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 316 | 2023-11-20 20:06:32 | poultry | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 315 | 2023-11-20 14:23:21 | poultry | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 314 | 2023-11-16 07:04:22 | poultry | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 313 | 2023-10-24 21:31:57 | poultry | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 312 | 2023-10-09 05:28:38 | poultry | 1 | 69583 | 1 | 2.033 | 34226.8 |
| 311 | 2023-10-09 01:24:27 | poultry | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 310 | 2023-09-30 13:43:06 | poultry | 3 | 134027 | 115 | 7.126 | 18808.2 |
| 309 | 2023-09-30 13:43:04 | poultry | 2 | 107671 | 13 | 3.250 | 33129.5 |
| 308 | 2023-09-25 20:49:56 | poultry | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 307 | 2023-09-24 22:09:00 | poultry | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 306 | 2023-08-07 04:28:23 | poultry | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 305 | 2023-08-05 12:37:26 | poultry | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 304 | 2023-05-02 23:30:39 | poultry | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 303 | 2023-04-03 20:46:07 | poultry | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 302 | 2023-02-27 09:31:10 | poultry | 1 | 69583 | 1 | 1.876 | 37091.2 |
| 301 | 2022-12-27 00:32:25 | poultry | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 300 | 2022-11-25 20:28:21 | poultry | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 299 | 2022-09-13 02:02:37 | poultry | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 298 | 2022-07-18 21:27:42 | poultry | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 297 | 2022-07-17 17:19:43 | poultry | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 296 | 2022-03-15 08:05:28 | poultry | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 295 | 2022-03-11 03:50:24 | poultry | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 294 | 2021-12-25 12:35:37 | poultry | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 293 | 2021-11-11 16:22:10 | poultry | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 292 | 2021-10-31 12:57:19 | poultry | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 291 | 2021-07-17 20:39:11 | poultry | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 290 | 2021-05-18 15:53:01 | poultry | 3 | 134027 | 115 | 13.280 | 10092.4 |
| 289 | 2021-05-17 17:29:15 | poultry | 3 | 134027 | 115 | 5.826 | 23005.0 |
| 288 | 2021-05-16 21:12:28 | poultry | 3 | 134027 | 115 | 5.656 | 23696.4 |
| 287 | 2021-05-16 05:18:08 | poultry | 3 | 134027 | 115 | 6.580 | 20368.8 |
| 286 | 2021-05-15 00:54:10 | poultry | 3 | 134027 | 115 | 5.766 | 23244.4 |
| 285 | 2021-05-13 00:20:22 | poultry | 3 | 134027 | 115 | 5.813 | 23056.4 |
| 284 | 2021-05-10 08:20:20 | poultry | 3 | 134027 | 115 | 6.750 | 19855.9 |
| 283 | 2021-04-30 15:16:26 | poultry | 3 | 134027 | 115 | 6.983 | 19193.3 |
| 282 | 2021-04-29 23:00:19 | poultry | 3 | 134027 | 115 | 6.533 | 20515.4 |
| 281 | 2021-04-29 04:47:43 | poultry | 1 | 69583 | 1 | 2.346 | 29660.3 |
| 280 | 2021-04-28 05:47:20 | poultry | 3 | 134027 | 115 | 6.986 | 19185.1 |
| 279 | 2021-04-27 18:40:52 | poultry | 3 | 134027 | 115 | 6.046 | 22167.9 |
| 278 | 2021-04-26 04:12:23 | poultry | 3 | 134027 | 115 | 7.173 | 18684.9 |
| 277 | 2021-04-24 20:19:35 | poultry | 3 | 134027 | 115 | 9.406 | 14249.1 |
| 276 | 2021-04-24 00:17:12 | poultry | 3 | 134027 | 115 | 6.783 | 19759.3 |
| 275 | 2021-04-22 14:01:06 | poultry | 3 | 134027 | 115 | 6.873 | 19500.5 |
| 274 | 2021-04-20 00:44:54 | poultry | 3 | 134027 | 115 | 7.106 | 18861.1 |
| 273 | 2021-04-18 15:18:04 | poultry | 3 | 134027 | 115 | 6.686 | 20045.9 |
| 272 | 2021-04-17 16:19:03 | poultry | 3 | 134027 | 115 | 6.486 | 20664.0 |
| 271 | 2021-04-15 02:10:39 | poultry | 1 | 69583 | 1 | 2.406 | 28920.6 |
| 270 | 2021-04-11 19:29:10 | poultry | 3 | 134027 | 115 | 11.220 | 11945.4 |
| 269 | 2021-04-10 14:18:40 | poultry | 3 | 134027 | 115 | 6.656 | 20136.3 |
| 268 | 2021-04-09 13:21:15 | poultry | 3 | 134027 | 115 | 10.626 | 12613.1 |
| 267 | 2021-04-06 23:22:51 | poultry | 3 | 134027 | 115 | 6.826 | 19634.8 |
| 266 | 2021-04-05 20:22:03 | poultry | 3 | 134027 | 115 | 5.953 | 22514.2 |
| 265 | 2021-04-04 20:27:03 | poultry | 3 | 134027 | 115 | 6.576 | 20381.2 |
| 264 | 2021-03-28 20:10:03 | poultry | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 263 | 2021-01-12 14:57:14 | poultry | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 262 | 2021-01-09 11:41:34 | poultry | 3 | 134027 | 115 | 5.970 | 22450.1 |
| 261 | 2021-01-01 12:16:03 | poultry | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 260 | 2020-10-23 08:14:33 | poultry | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 259 | 2020-10-23 04:48:27 | poultry | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 258 | 2020-09-30 02:38:22 | poultry | 1 | 69583 | 1 | 1.050 | 66269.5 |
| 257 | 2020-09-27 23:46:33 | poultry | 3 | 134027 | 115 | 5.733 | 23378.2 |
| 256 | 2020-09-25 10:24:30 | poultry | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 255 | 2020-07-31 21:03:17 | poultry | 3 | 134027 | 115 | 6.390 | 20974.5 |
| 254 | 2020-07-27 20:19:45 | poultry | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 253 | 2020-07-16 09:14:18 | poultry | 3 | 134027 | 115 | 6.893 | 19443.9 |
| 252 | 2020-07-15 14:15:24 | poultry | 3 | 134027 | 115 | 6.470 | 20715.1 |
| 251 | 2020-06-19 09:39:34 | poultry | 3 | 134027 | 115 | 5.983 | 22401.3 |
| 250 | 2020-06-16 09:35:29 | poultry | 3 | 134027 | 115 | 5.796 | 23124.1 |
| 249 | 2020-06-16 08:00:19 | poultry | 3 | 134027 | 115 | 5.940 | 22563.5 |
| 248 | 2020-06-13 01:51:05 | poultry | 3 | 134027 | 115 | 7.050 | 19010.9 |
| 247 | 2020-06-11 05:51:08 | poultry | 3 | 134027 | 115 | 5.860 | 22871.5 |
| 246 | 2020-06-07 08:28:09 | poultry | 3 | 134027 | 115 | 5.826 | 23005.0 |
| 245 | 2020-06-06 08:25:54 | poultry | 3 | 134027 | 115 | 6.610 | 20276.4 |
| 244 | 2020-06-05 08:36:02 | poultry | 3 | 134027 | 115 | 6.656 | 20136.3 |
| 243 | 2020-06-03 08:29:14 | poultry | 3 | 134027 | 115 | 5.873 | 22820.9 |
| 242 | 2020-06-01 21:13:54 | poultry | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 241 | 2020-05-31 07:28:19 | poultry | 3 | 134027 | 115 | 7.140 | 18771.3 |