History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apothecary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 329 | 2025-08-27 08:54:55 | apothecary | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 328 | 2025-08-25 03:17:36 | apothecary | 2 | 108824 | 1 | 9.733 | 11180.9 |
| 327 | 2025-07-25 09:27:29 | apothecary | 1 | 67641 | 1 | 3.560 | 19000.3 |
| 326 | 2025-07-25 04:48:08 | apothecary | 1 | 67641 | 1 | 5.000 | 13528.2 |
| 325 | 2025-07-25 01:22:37 | apothecary | 1 | 67641 | 1 | 2.706 | 24996.7 |
| 324 | 2025-07-16 19:15:14 | apothecary | 1 | 67641 | 1 | 1.233 | 54858.9 |
| 323 | 2025-06-16 11:08:15 | apothecary | 3 | 140603 | 7 | 25.046 | 5613.8 |
| 322 | 2025-06-16 06:33:43 | apothecary | 2 | 108824 | 1 | 16.406 | 6633.2 |
| 321 | 2025-06-16 03:38:38 | apothecary | 3 | 140603 | 7 | 33.893 | 4148.4 |
| 320 | 2025-06-15 22:28:53 | apothecary | 3 | 140603 | 7 | 35.850 | 3922.0 |
| 319 | 2025-06-15 09:28:14 | apothecary | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 318 | 2025-06-13 11:46:39 | apothecary | 3 | 140603 | 7 | 34.783 | 4042.3 |
| 317 | 2025-06-12 17:20:29 | apothecary | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 316 | 2025-06-10 11:48:17 | apothecary | 2 | 108824 | 1 | 21.373 | 5091.7 |
| 315 | 2025-06-09 22:02:57 | apothecary | 3 | 140603 | 7 | 29.406 | 4781.4 |
| 314 | 2025-06-09 00:08:20 | apothecary | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 313 | 2025-05-25 08:57:56 | apothecary | 1 | 67641 | 1 | 5.346 | 12652.6 |
| 312 | 2025-04-30 23:19:10 | apothecary | 1 | 67641 | 1 | 7.233 | 9351.7 |
| 311 | 2025-04-26 09:02:17 | apothecary | 1 | 67641 | 1 | 5.906 | 11452.9 |
| 310 | 2025-04-04 03:41:35 | apothecary | 2 | 108824 | 1 | 8.860 | 12282.6 |
| 309 | 2025-04-03 16:18:10 | apothecary | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 308 | 2025-03-23 01:23:37 | apothecary | 1 | 67641 | 1 | 3.580 | 18894.1 |
| 307 | 2025-03-07 15:22:54 | apothecary | 1 | 67641 | 1 | 3.373 | 20053.7 |
| 306 | 2025-02-17 20:52:08 | apothecary | 3 | 140603 | 7 | 32.160 | 4372.0 |
| 305 | 2025-02-17 20:52:00 | apothecary | 2 | 108824 | 1 | 7.690 | 14151.4 |
| 304 | 2025-02-17 20:50:46 | apothecary | 3 | 140603 | 7 | 46.580 | 3018.5 |
| 303 | 2025-02-17 20:50:46 | apothecary | 3 | 140603 | 7 | 30.156 | 4662.5 |
| 302 | 2025-02-17 20:47:12 | apothecary | 1 | 67641 | 1 | 5.813 | 11636.2 |
| 301 | 2025-02-11 06:44:53 | apothecary | 3 | 140603 | 7 | 56.843 | 2473.5 |
| 300 | 2025-02-11 06:44:53 | apothecary | 3 | 140603 | 7 | 55.856 | 2517.2 |
| 299 | 2025-02-11 06:45:19 | apothecary | 3 | 140603 | 7 | 26.110 | 5385.0 |
| 298 | 2025-02-11 06:45:23 | apothecary | 2 | 108824 | 1 | 15.576 | 6986.6 |
| 297 | 2025-02-11 06:42:21 | apothecary | 1 | 67641 | 1 | 5.203 | 13000.4 |
| 296 | 2025-02-10 09:44:12 | apothecary | 2 | 108824 | 1 | 21.646 | 5027.4 |
| 295 | 2025-02-10 09:02:09 | apothecary | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 294 | 2025-01-18 21:45:11 | apothecary | 1 | 67641 | 1 | 5.500 | 12298.4 |
| 293 | 2025-01-16 08:23:30 | apothecary | 3 | 140603 | 7 | 32.736 | 4295.1 |
| 292 | 2025-01-09 19:12:19 | apothecary | 1 | 67641 | 1 | 6.360 | 10635.4 |
| 291 | 2025-01-04 06:48:07 | apothecary | 3 | 140603 | 7 | 31.253 | 4498.9 |
| 290 | 2024-12-25 22:59:57 | apothecary | 1 | 67641 | 1 | 4.233 | 15979.4 |
| 289 | 2024-12-20 00:44:06 | apothecary | 3 | 140603 | 7 | 42.266 | 3326.6 |
| 288 | 2024-12-08 07:21:20 | apothecary | 3 | 140603 | 7 | 37.126 | 3787.2 |
| 287 | 2024-12-08 07:21:18 | apothecary | 3 | 140603 | 7 | 30.080 | 4674.3 |
| 286 | 2024-12-08 07:20:16 | apothecary | 2 | 108824 | 1 | 15.296 | 7114.5 |
| 285 | 2024-12-08 07:20:04 | apothecary | 1 | 67641 | 1 | 3.486 | 19403.6 |
| 284 | 2024-12-03 09:00:29 | apothecary | 3 | 140603 | 7 | 60.460 | 2325.6 |
| 283 | 2024-12-03 09:00:49 | apothecary | 3 | 140603 | 7 | 36.260 | 3877.6 |
| 282 | 2024-12-03 09:00:38 | apothecary | 3 | 140603 | 7 | 32.550 | 4319.6 |
| 281 | 2024-12-03 09:00:48 | apothecary | 2 | 108824 | 1 | 16.233 | 6703.9 |
| 280 | 2024-12-03 08:56:58 | apothecary | 1 | 67641 | 1 | 2.970 | 22774.7 |
| 279 | 2024-11-22 00:44:14 | apothecary | 1 | 67641 | 1 | 7.890 | 8573.0 |
| 278 | 2024-11-14 03:19:02 | apothecary | 3 | 140603 | 7 | 35.986 | 3907.2 |
| 277 | 2024-10-22 23:11:43 | apothecary | 3 | 140603 | 7 | 30.796 | 4565.6 |
| 276 | 2024-10-22 23:11:39 | apothecary | 3 | 140603 | 7 | 26.110 | 5385.0 |
| 275 | 2024-10-21 16:24:11 | apothecary | 3 | 140603 | 7 | 46.863 | 3000.3 |
| 274 | 2024-10-21 16:24:14 | apothecary | 3 | 140603 | 7 | 28.953 | 4856.2 |
| 273 | 2024-10-12 01:03:26 | apothecary | 3 | 140603 | 7 | 33.660 | 4177.2 |
| 272 | 2024-10-12 01:03:16 | apothecary | 3 | 140603 | 7 | 40.766 | 3449.0 |
| 271 | 2024-09-30 12:09:39 | apothecary | 1 | 67641 | 1 | 8.593 | 7871.6 |
| 270 | 2024-09-26 10:22:35 | apothecary | 4 | 161450 | 30 | 86.896 | 1858.0 |
| 269 | 2024-09-26 10:22:36 | apothecary | 3 | 140603 | 7 | 50.033 | 2810.2 |
| 268 | 2024-09-26 10:22:48 | apothecary | 2 | 108824 | 1 | 23.706 | 4590.6 |
| 267 | 2024-09-26 10:20:47 | apothecary | 1 | 67641 | 1 | 7.450 | 9079.3 |
| 266 | 2024-09-26 00:08:34 | apothecary | 1 | 67641 | 1 | 6.733 | 10046.2 |
| 265 | 2024-09-22 11:36:37 | apothecary | 1 | 67641 | 1 | 10.000 | 6764.1 |
| 264 | 2024-08-21 22:08:51 | apothecary | 1 | 67641 | 1 | 11.876 | 5695.6 |
| 263 | 2024-08-17 12:06:44 | apothecary | 1 | 67641 | 1 | 9.343 | 7239.8 |
| 262 | 2024-08-11 13:05:04 | apothecary | 4 | 161450 | 30 | 55.830 | 2891.8 |
| 261 | 2024-08-11 13:04:53 | apothecary | 3 | 140603 | 7 | 23.376 | 6014.8 |
| 260 | 2024-08-07 07:58:34 | apothecary | 4 | 161450 | 30 | 58.063 | 2780.6 |
| 259 | 2024-08-07 07:58:26 | apothecary | 3 | 140603 | 7 | 24.393 | 5764.1 |
| 258 | 2024-08-06 21:03:19 | apothecary | 4 | 161450 | 30 | 60.786 | 2656.0 |
| 257 | 2024-08-06 21:03:19 | apothecary | 3 | 140603 | 7 | 28.503 | 4932.9 |
| 256 | 2024-08-05 13:43:02 | apothecary | 4 | 161450 | 30 | 40.363 | 4000.0 |
| 255 | 2024-08-05 13:43:07 | apothecary | 2 | 108824 | 1 | 25.956 | 4192.6 |
| 254 | 2024-08-05 13:43:02 | apothecary | 3 | 140603 | 7 | 21.580 | 6515.4 |
| 253 | 2024-08-05 13:39:32 | apothecary | 1 | 67641 | 1 | 1.670 | 40503.6 |
| 252 | 2024-08-04 01:48:56 | apothecary | 1 | 67641 | 1 | 1.966 | 34405.4 |
| 251 | 2024-07-26 08:14:10 | apothecary | 1 | 67641 | 1 | 2.123 | 31861.0 |
| 250 | 2024-07-20 01:04:47 | apothecary | 1 | 67641 | 1 | 4.546 | 14879.2 |
| 249 | 2024-07-09 17:11:52 | apothecary | 3 | 140603 | 7 | 25.266 | 5564.9 |
| 248 | 2024-07-08 22:57:31 | apothecary | 3 | 140603 | 7 | 35.410 | 3970.7 |
| 247 | 2024-07-08 22:57:29 | apothecary | 4 | 161450 | 30 | 37.343 | 4323.4 |
| 246 | 2024-07-08 22:57:35 | apothecary | 2 | 108824 | 1 | 11.673 | 9322.7 |
| 245 | 2024-07-08 22:54:12 | apothecary | 1 | 67641 | 1 | 3.656 | 18501.4 |
| 244 | 2024-07-06 07:29:43 | apothecary | 4 | 161450 | 30 | 41.613 | 3879.8 |
| 243 | 2024-07-06 02:54:52 | apothecary | 1 | 67641 | 1 | 5.660 | 11950.7 |
| 242 | 2024-06-27 11:58:33 | apothecary | 1 | 67641 | 1 | 4.250 | 15915.5 |
| 241 | 2024-06-27 11:54:36 | apothecary | 1 | 67641 | 1 | 4.033 | 16771.9 |
| 240 | 2024-06-17 12:18:55 | apothecary | 4 | 161450 | 30 | 58.940 | 2739.2 |
| 239 | 2024-06-16 13:33:27 | apothecary | 4 | 161450 | 30 | 57.860 | 2790.4 |
| 238 | 2024-06-15 16:18:02 | apothecary | 4 | 161450 | 30 | 45.800 | 3525.1 |
| 237 | 2024-05-28 08:18:47 | apothecary | 4 | 161450 | 30 | 29.440 | 5484.0 |
| 236 | 2024-05-28 08:18:51 | apothecary | 2 | 108824 | 1 | 10.330 | 10534.8 |
| 235 | 2024-05-28 08:15:31 | apothecary | 1 | 67641 | 1 | 5.406 | 12512.2 |
| 234 | 2024-05-25 17:00:39 | apothecary | 1 | 67641 | 1 | 3.046 | 22206.5 |
| 233 | 2024-05-24 19:06:55 | apothecary | 1 | 67641 | 1 | 3.906 | 17317.2 |
| 232 | 2024-05-24 13:55:39 | apothecary | 1 | 67641 | 1 | 3.890 | 17388.4 |
| 231 | 2024-05-24 04:23:32 | apothecary | 3 | 140603 | 7 | 16.576 | 8482.3 |
| 230 | 2024-05-23 21:50:46 | apothecary | 1 | 67641 | 1 | 3.830 | 17660.8 |