History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"storewide"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 260 | 2025-11-23 15:43:46 | storewide | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 259 | 2025-11-18 01:13:06 | storewide | 2 | 121436 | 3 | 12.360 | 9824.9 |
| 258 | 2025-11-17 23:22:09 | storewide | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 257 | 2025-11-06 02:25:58 | storewide | 2 | 121436 | 3 | 3.390 | 35821.8 |
| 256 | 2025-11-04 19:35:15 | storewide | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 255 | 2025-11-01 18:43:32 | storewide | 3 | 148641 | 19 | 7.453 | 19943.8 |
| 254 | 2025-10-30 05:43:36 | storewide | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 253 | 2025-10-27 14:47:48 | storewide | 3 | 148641 | 19 | 6.970 | 21325.8 |
| 252 | 2025-10-24 20:29:22 | storewide | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 251 | 2025-10-24 14:57:01 | storewide | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 250 | 2025-10-18 10:15:24 | storewide | 1 | 81242 | 1 | 3.750 | 21664.5 |
| 249 | 2025-10-18 08:33:56 | storewide | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 248 | 2025-10-12 12:08:01 | storewide | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 247 | 2025-10-05 20:22:32 | storewide | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 246 | 2025-10-01 01:51:51 | storewide | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 245 | 2025-09-30 07:49:39 | storewide | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 244 | 2025-09-24 18:05:32 | storewide | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 243 | 2025-09-18 04:29:51 | storewide | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 242 | 2025-09-12 20:10:34 | storewide | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 241 | 2025-09-08 21:56:07 | storewide | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 240 | 2025-09-01 16:06:46 | storewide | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 239 | 2025-08-26 21:50:34 | storewide | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 238 | 2025-08-26 15:45:00 | storewide | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 237 | 2025-08-22 09:15:21 | storewide | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 236 | 2025-08-20 13:33:52 | storewide | 1 | 81242 | 1 | 1.263 | 64324.6 |
| 235 | 2025-08-19 19:00:04 | storewide | 1 | 81242 | 1 | 7.140 | 11378.4 |
| 234 | 2025-08-08 03:46:04 | storewide | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 233 | 2025-08-02 01:05:26 | storewide | 1 | 81242 | 1 | 3.016 | 26937.0 |
| 232 | 2025-07-27 04:37:15 | storewide | 1 | 81242 | 1 | 5.720 | 14203.1 |
| 231 | 2025-07-18 23:17:40 | storewide | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 230 | 2025-07-07 20:22:33 | storewide | 3 | 148641 | 19 | 45.393 | 3274.5 |
| 229 | 2025-07-07 17:58:50 | storewide | 3 | 148641 | 19 | 33.376 | 4453.5 |
| 228 | 2025-07-07 17:33:30 | storewide | 2 | 121436 | 3 | 22.610 | 5370.9 |
| 227 | 2025-07-05 22:47:53 | storewide | 1 | 81242 | 1 | 1.263 | 64324.6 |
| 226 | 2025-06-23 21:31:28 | storewide | 3 | 148641 | 19 | 36.596 | 4061.7 |
| 225 | 2025-06-09 01:21:14 | storewide | 3 | 148641 | 19 | 7.796 | 19066.3 |
| 224 | 2025-05-31 09:41:11 | storewide | 2 | 121436 | 3 | 13.353 | 9094.3 |
| 223 | 2025-05-31 09:28:08 | storewide | 2 | 121436 | 3 | 13.190 | 9206.7 |
| 222 | 2025-05-28 09:53:49 | storewide | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 221 | 2025-05-05 06:57:10 | storewide | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 220 | 2025-04-01 21:58:50 | storewide | 1 | 81242 | 1 | 6.923 | 11735.1 |
| 219 | 2025-03-31 11:00:45 | storewide | 1 | 81242 | 1 | 5.190 | 15653.6 |
| 218 | 2025-03-25 00:16:56 | storewide | 3 | 148641 | 19 | 35.186 | 4224.4 |
| 217 | 2025-03-20 06:11:10 | storewide | 1 | 81242 | 1 | 4.813 | 16879.7 |
| 216 | 2025-03-03 13:33:01 | storewide | 3 | 148641 | 19 | 42.096 | 3531.0 |
| 215 | 2025-03-01 12:49:32 | storewide | 3 | 148641 | 19 | 20.640 | 7201.6 |
| 214 | 2025-02-24 23:08:04 | storewide | 3 | 148641 | 19 | 55.723 | 2667.5 |
| 213 | 2025-02-24 23:08:26 | storewide | 2 | 121436 | 3 | 19.410 | 6256.4 |
| 212 | 2025-02-24 23:07:23 | storewide | 1 | 81242 | 1 | 3.983 | 20397.2 |
| 211 | 2025-02-20 02:19:23 | storewide | 3 | 148641 | 19 | 47.626 | 3121.0 |
| 210 | 2025-02-16 18:53:32 | storewide | 3 | 148641 | 19 | 43.016 | 3455.5 |
| 209 | 2025-02-14 21:52:26 | storewide | 3 | 148641 | 19 | 31.280 | 4752.0 |
| 208 | 2025-02-14 21:52:19 | storewide | 2 | 121436 | 3 | 14.780 | 8216.2 |
| 207 | 2025-02-14 21:50:09 | storewide | 1 | 81242 | 1 | 3.560 | 22820.8 |
| 206 | 2025-01-17 07:17:44 | storewide | 1 | 81242 | 1 | 10.190 | 7972.7 |
| 205 | 2025-01-14 01:29:04 | storewide | 1 | 81242 | 1 | 6.220 | 13061.4 |
| 204 | 2025-01-05 11:27:52 | storewide | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 203 | 2024-12-24 10:18:10 | storewide | 2 | 121436 | 3 | 17.016 | 7136.6 |
| 202 | 2024-12-14 06:53:47 | storewide | 1 | 81242 | 1 | 5.470 | 14852.3 |
| 201 | 2024-12-12 04:50:30 | storewide | 1 | 81242 | 1 | 7.156 | 11353.0 |
| 200 | 2024-12-11 23:48:46 | storewide | 2 | 121436 | 3 | 16.126 | 7530.4 |
| 199 | 2024-12-11 23:47:31 | storewide | 1 | 81242 | 1 | 4.720 | 17212.3 |
| 198 | 2024-11-26 00:31:02 | storewide | 1 | 81242 | 1 | 3.280 | 24768.9 |
| 197 | 2024-11-04 02:46:44 | storewide | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 196 | 2024-10-27 19:57:55 | storewide | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 195 | 2024-10-11 15:40:32 | storewide | 2 | 121436 | 3 | 30.456 | 3987.3 |
| 194 | 2024-10-11 15:40:21 | storewide | 2 | 121436 | 3 | 23.816 | 5098.9 |
| 193 | 2024-10-11 15:40:27 | storewide | 2 | 121436 | 3 | 13.406 | 9058.3 |
| 192 | 2024-10-02 20:34:03 | storewide | 1 | 81242 | 1 | 10.096 | 8046.9 |
| 191 | 2024-09-30 05:21:30 | storewide | 1 | 81242 | 1 | 12.296 | 6607.2 |
| 190 | 2024-09-26 21:21:14 | storewide | 2 | 121436 | 3 | 41.316 | 2939.2 |
| 189 | 2024-09-24 02:52:29 | storewide | 2 | 121436 | 3 | 26.893 | 4515.5 |
| 188 | 2024-09-24 02:49:39 | storewide | 1 | 81242 | 1 | 7.576 | 10723.6 |
| 187 | 2024-09-10 02:50:45 | storewide | 3 | 148641 | 19 | 68.113 | 2182.3 |
| 186 | 2024-09-02 04:45:36 | storewide | 3 | 148641 | 19 | 88.820 | 1673.5 |
| 185 | 2024-08-22 20:19:01 | storewide | 3 | 148641 | 19 | 42.690 | 3481.9 |
| 184 | 2024-08-15 11:38:13 | storewide | 3 | 148641 | 19 | 76.723 | 1937.4 |
| 183 | 2024-08-14 22:14:18 | storewide | 4 | 165329 | 205 | 94.770 | 1744.5 |
| 182 | 2024-08-14 19:43:48 | storewide | 4 | 165329 | 205 | 123.100 | 1343.0 |
| 181 | 2024-08-09 11:25:36 | storewide | 2 | 121436 | 3 | 18.986 | 6396.1 |
| 180 | 2024-08-09 11:21:09 | storewide | 1 | 81242 | 1 | 6.453 | 12589.8 |
| 179 | 2024-08-04 00:18:11 | storewide | 3 | 148641 | 19 | 13.890 | 10701.3 |
| 178 | 2024-07-28 20:57:03 | storewide | 3 | 148641 | 19 | 45.660 | 3255.4 |
| 177 | 2024-07-28 07:30:24 | storewide | 4 | 165329 | 205 | 47.830 | 3456.6 |
| 176 | 2024-07-27 21:29:57 | storewide | 4 | 165329 | 205 | 25.780 | 6413.1 |
| 175 | 2024-07-27 20:48:19 | storewide | 4 | 165329 | 205 | 63.243 | 2614.2 |
| 174 | 2024-07-27 20:48:20 | storewide | 3 | 148641 | 19 | 24.676 | 6023.7 |
| 173 | 2024-07-27 20:48:27 | storewide | 2 | 121436 | 3 | 17.223 | 7050.8 |
| 172 | 2024-07-27 20:47:24 | storewide | 1 | 81242 | 1 | 4.936 | 16459.1 |
| 171 | 2024-07-23 13:26:52 | storewide | 1 | 81242 | 1 | 3.830 | 21212.0 |
| 170 | 2024-07-13 19:32:26 | storewide | 1 | 81242 | 1 | 4.216 | 19269.9 |
| 169 | 2024-07-07 23:27:34 | storewide | 1 | 81242 | 1 | 2.796 | 29056.5 |
| 168 | 2024-07-03 05:04:30 | storewide | 1 | 81242 | 1 | 1.686 | 48186.2 |
| 167 | 2024-06-16 18:07:13 | storewide | 4 | 165329 | 205 | 42.940 | 3850.2 |
| 166 | 2024-06-13 21:16:50 | storewide | 4 | 165329 | 205 | 37.143 | 4451.1 |
| 165 | 2024-06-12 10:23:59 | storewide | 3 | 148641 | 19 | 27.456 | 5413.8 |
| 164 | 2024-06-11 01:31:34 | storewide | 3 | 148641 | 19 | 39.656 | 3748.3 |
| 163 | 2024-06-10 19:13:13 | storewide | 3 | 148641 | 19 | 26.923 | 5521.0 |
| 162 | 2024-06-10 00:16:08 | storewide | 3 | 148641 | 19 | 35.750 | 4157.8 |
| 161 | 2024-06-09 10:43:57 | storewide | 4 | 165329 | 205 | 38.546 | 4289.1 |