History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detergent"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 291 | 2024-04-14 11:26:47 | detergent | 2 | 121436 | 17 | 17.750 | 6841.5 |
| 290 | 2024-04-14 11:19:07 | detergent | 1 | 81242 | 4 | 2.750 | 29542.5 |
| 289 | 2024-04-11 19:38:37 | detergent | 4 | 165329 | 294 | 26.423 | 6257.0 |
| 288 | 2024-04-10 19:09:41 | detergent | 3 | 148641 | 49 | 20.550 | 7233.1 |
| 287 | 2024-04-10 16:24:04 | detergent | 3 | 148641 | 49 | 31.736 | 4683.7 |
| 286 | 2024-04-10 16:23:58 | detergent | 4 | 165329 | 294 | 34.080 | 4851.2 |
| 285 | 2024-04-10 16:23:58 | detergent | 2 | 121436 | 17 | 13.500 | 8995.3 |
| 284 | 2024-04-10 16:23:52 | detergent | 1 | 81242 | 4 | 3.346 | 24280.3 |
| 283 | 2024-04-04 13:59:40 | detergent | 3 | 148641 | 49 | 12.546 | 11847.7 |
| 282 | 2024-04-04 13:58:04 | detergent | 1 | 81242 | 4 | 3.190 | 25467.7 |
| 281 | 2024-04-02 07:57:23 | detergent | 3 | 148641 | 49 | 18.266 | 8137.6 |
| 280 | 2024-04-01 09:52:22 | detergent | 4 | 165329 | 294 | 24.126 | 6852.7 |
| 279 | 2024-04-01 09:52:20 | detergent | 2 | 121436 | 17 | 13.656 | 8892.5 |
| 278 | 2024-04-01 09:52:18 | detergent | 3 | 148641 | 49 | 15.406 | 9648.3 |
| 277 | 2024-04-01 09:51:00 | detergent | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 276 | 2024-03-18 04:18:47 | detergent | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 275 | 2024-03-17 07:59:06 | detergent | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 274 | 2024-03-11 05:14:39 | detergent | 4 | 165329 | 294 | 29.970 | 5516.5 |
| 273 | 2024-03-07 18:54:40 | detergent | 1 | 81242 | 4 | 2.923 | 27794.0 |
| 272 | 2024-03-06 11:54:00 | detergent | 4 | 165329 | 294 | 26.783 | 6172.9 |
| 271 | 2024-03-04 21:06:28 | detergent | 1 | 81242 | 4 | 2.970 | 27354.2 |
| 270 | 2024-03-02 09:11:59 | detergent | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 269 | 2024-02-27 13:19:22 | detergent | 1 | 81242 | 4 | 1.266 | 64172.2 |
| 268 | 2024-02-06 09:51:17 | detergent | 4 | 165329 | 294 | 15.030 | 10999.9 |
| 267 | 2024-02-06 09:51:21 | detergent | 2 | 121436 | 17 | 3.953 | 30720.0 |
| 266 | 2024-02-06 09:51:14 | detergent | 3 | 148641 | 49 | 8.063 | 18434.9 |
| 265 | 2024-02-06 04:20:26 | detergent | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 264 | 2024-01-31 08:04:32 | detergent | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 263 | 2024-01-27 11:34:35 | detergent | 1 | 81242 | 4 | 1.423 | 57092.1 |
| 262 | 2024-01-07 04:09:06 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 261 | 2023-12-17 22:52:06 | detergent | 1 | 81242 | 4 | 1.393 | 58321.6 |
| 260 | 2023-12-06 14:49:21 | detergent | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 259 | 2023-11-24 06:38:19 | detergent | 4 | 165329 | 294 | 10.830 | 15265.8 |
| 258 | 2023-10-04 22:55:40 | detergent | 1 | 81242 | 4 | 1.593 | 50999.4 |
| 257 | 2023-08-24 09:01:29 | detergent | 4 | 165329 | 294 | 13.436 | 12304.9 |
| 256 | 2023-08-03 07:01:47 | detergent | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 255 | 2023-07-31 22:52:05 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 254 | 2023-05-17 17:41:23 | detergent | 4 | 165329 | 294 | 11.016 | 15008.1 |
| 253 | 2023-05-10 19:37:46 | detergent | 4 | 165329 | 294 | 10.653 | 15519.5 |
| 252 | 2023-04-28 13:21:59 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 251 | 2023-04-11 03:09:23 | detergent | 1 | 81242 | 4 | 1.356 | 59913.0 |
| 250 | 2023-02-21 15:13:15 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 249 | 2023-02-16 04:46:26 | detergent | 4 | 165329 | 294 | 10.466 | 15796.8 |
| 248 | 2022-12-19 02:23:56 | detergent | 1 | 81242 | 4 | 1.236 | 65729.8 |
| 247 | 2022-12-12 05:37:53 | detergent | 1 | 81242 | 4 | 1.356 | 59913.0 |
| 246 | 2022-11-25 21:37:26 | detergent | 4 | 165329 | 294 | 10.593 | 15607.4 |
| 245 | 2022-09-02 06:53:43 | detergent | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 244 | 2022-08-11 23:46:32 | detergent | 1 | 81242 | 4 | 1.266 | 64172.2 |
| 243 | 2022-04-22 23:29:42 | detergent | 4 | 165329 | 294 | 12.860 | 12856.1 |
| 242 | 2022-04-21 23:17:35 | detergent | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 241 | 2022-04-18 00:05:52 | detergent | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 240 | 2022-01-17 16:20:24 | detergent | 1 | 81242 | 4 | 1.236 | 65729.8 |
| 239 | 2021-12-26 17:05:01 | detergent | 1 | 81242 | 4 | 1.423 | 57092.1 |
| 238 | 2021-12-14 21:16:09 | detergent | 3 | 148641 | 49 | 7.970 | 18650.1 |
| 237 | 2021-12-12 20:38:37 | detergent | 3 | 148641 | 49 | 7.140 | 20818.1 |
| 236 | 2021-12-07 00:46:00 | detergent | 3 | 148641 | 49 | 9.533 | 15592.3 |
| 235 | 2021-12-06 01:21:27 | detergent | 3 | 148641 | 49 | 6.563 | 22648.3 |
| 234 | 2021-12-05 00:10:26 | detergent | 3 | 148641 | 49 | 8.030 | 18510.7 |
| 233 | 2021-12-02 15:30:17 | detergent | 3 | 148641 | 49 | 7.530 | 19739.8 |
| 232 | 2021-12-01 16:42:14 | detergent | 3 | 148641 | 49 | 6.360 | 23371.2 |
| 231 | 2021-11-30 20:45:09 | detergent | 3 | 148641 | 49 | 8.016 | 18543.0 |
| 230 | 2021-11-29 16:40:17 | detergent | 3 | 148641 | 49 | 6.593 | 22545.3 |
| 229 | 2021-11-26 23:16:28 | detergent | 3 | 148641 | 49 | 7.893 | 18832.0 |
| 228 | 2021-11-25 15:50:12 | detergent | 3 | 148641 | 49 | 7.516 | 19776.6 |
| 227 | 2021-11-11 08:03:44 | detergent | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 226 | 2021-10-13 15:53:13 | detergent | 1 | 81242 | 4 | 2.626 | 30937.5 |
| 225 | 2021-09-13 02:36:15 | detergent | 1 | 81242 | 4 | 1.310 | 62016.8 |
| 224 | 2021-06-23 23:42:05 | detergent | 3 | 148641 | 49 | 7.826 | 18993.2 |
| 223 | 2021-06-08 23:04:27 | detergent | 1 | 81242 | 4 | 1.330 | 61084.2 |
| 222 | 2021-05-01 01:31:10 | detergent | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 221 | 2021-04-05 03:29:38 | detergent | 1 | 81242 | 4 | 2.563 | 31698.0 |
| 220 | 2021-04-04 22:47:36 | detergent | 3 | 148641 | 49 | 6.470 | 22973.9 |
| 219 | 2021-03-09 13:03:30 | detergent | 1 | 81242 | 4 | 1.266 | 64172.2 |
| 218 | 2021-03-06 16:31:02 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 217 | 2021-02-24 17:53:53 | detergent | 2 | 121436 | 17 | 3.156 | 38477.8 |
| 216 | 2021-02-13 03:20:14 | detergent | 3 | 148641 | 49 | 6.296 | 23608.8 |
| 215 | 2020-12-20 21:52:37 | detergent | 3 | 148641 | 49 | 6.750 | 22020.9 |
| 214 | 2020-11-27 22:53:29 | detergent | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 213 | 2020-10-31 14:59:00 | detergent | 1 | 81242 | 4 | 1.393 | 58321.6 |
| 212 | 2020-08-15 13:11:59 | detergent | 1 | 81242 | 4 | 1.373 | 59171.2 |
| 211 | 2020-08-11 19:40:21 | detergent | 1 | 81242 | 4 | 1.403 | 57905.9 |
| 210 | 2020-08-11 06:19:53 | detergent | 3 | 148641 | 49 | 7.330 | 20278.4 |
| 209 | 2020-05-11 08:34:42 | detergent | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 208 | 2020-05-08 22:25:38 | detergent | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 207 | 2020-03-24 15:37:11 | detergent | 1 | 81242 | 4 | 1.890 | 42985.2 |
| 206 | 2020-03-05 15:35:15 | detergent | 1 | 81242 | 4 | 1.686 | 48186.2 |
| 205 | 2020-02-27 18:23:26 | detergent | 4 | 165329 | 294 | 21.486 | 7694.7 |
| 204 | 2020-02-27 09:50:22 | detergent | 4 | 165329 | 294 | 36.143 | 4574.3 |
| 203 | 2020-02-26 19:11:03 | detergent | 1 | 81242 | 4 | 2.656 | 30588.1 |
| 202 | 2020-02-26 16:04:53 | detergent | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 201 | 2020-02-25 23:02:22 | detergent | 4 | 165329 | 294 | 20.826 | 7938.6 |
| 200 | 2020-02-25 01:24:01 | detergent | 4 | 165329 | 294 | 15.063 | 10975.8 |
| 199 | 2020-02-22 18:22:28 | detergent | 1 | 81242 | 4 | 3.030 | 26812.5 |
| 198 | 2020-02-21 14:48:29 | detergent | 4 | 165329 | 294 | 27.923 | 5920.9 |
| 197 | 2020-02-19 03:58:21 | detergent | 4 | 165329 | 294 | 25.113 | 6583.4 |
| 196 | 2020-02-18 04:39:21 | detergent | 3 | 148641 | 49 | 9.296 | 15989.8 |
| 195 | 2020-02-11 02:23:39 | detergent | 1 | 81242 | 4 | 3.250 | 24997.5 |
| 194 | 2020-02-10 17:41:59 | detergent | 1 | 81242 | 4 | 1.940 | 41877.3 |
| 193 | 2020-02-08 18:02:20 | detergent | 1 | 81242 | 4 | 3.093 | 26266.4 |
| 192 | 2020-02-07 18:22:59 | detergent | 4 | 165329 | 294 | 14.076 | 11745.5 |