History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transacting"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 341 | 2025-11-14 21:52:09 | transacting | 3 | 121633 | 34 | 6.406 | 18987.4 |
| 340 | 2025-10-24 05:49:21 | transacting | 1 | 49908 | 2 | 0.890 | 56076.4 |
| 339 | 2025-09-10 14:21:12 | transacting | 1 | 49908 | 2 | 0.920 | 54247.8 |
| 338 | 2025-08-18 22:54:33 | transacting | 1 | 49908 | 2 | 1.843 | 27079.8 |
| 337 | 2025-08-10 08:17:51 | transacting | 1 | 49908 | 2 | 1.483 | 33653.4 |
| 336 | 2025-08-09 13:32:04 | transacting | 1 | 49908 | 2 | 3.826 | 13044.4 |
| 335 | 2025-07-31 11:45:48 | transacting | 1 | 49908 | 2 | 2.406 | 20743.1 |
| 334 | 2025-07-22 12:33:18 | transacting | 1 | 49908 | 2 | 1.640 | 30431.7 |
| 333 | 2025-07-16 22:03:01 | transacting | 1 | 49908 | 2 | 1.983 | 25167.9 |
| 332 | 2025-07-07 13:13:37 | transacting | 1 | 49908 | 2 | 5.923 | 8426.1 |
| 331 | 2025-06-27 17:17:51 | transacting | 4 | 148819 | 121 | 50.893 | 2924.2 |
| 330 | 2025-06-26 07:49:22 | transacting | 1 | 49908 | 2 | 4.080 | 12232.4 |
| 329 | 2025-06-24 06:57:47 | transacting | 4 | 148819 | 121 | 54.343 | 2738.5 |
| 328 | 2025-06-20 20:27:20 | transacting | 1 | 49908 | 2 | 2.796 | 17849.8 |
| 327 | 2025-06-15 20:45:25 | transacting | 4 | 148819 | 121 | 66.300 | 2244.6 |
| 326 | 2025-06-15 13:30:36 | transacting | 1 | 49908 | 2 | 3.923 | 12721.9 |
| 325 | 2025-06-11 13:31:49 | transacting | 4 | 148819 | 121 | 62.510 | 2380.7 |
| 324 | 2025-06-11 02:14:54 | transacting | 4 | 148819 | 121 | 27.310 | 5449.2 |
| 323 | 2025-06-10 03:59:29 | transacting | 4 | 148819 | 121 | 51.440 | 2893.1 |
| 322 | 2025-06-09 02:31:57 | transacting | 4 | 148819 | 121 | 12.596 | 11814.8 |
| 321 | 2025-06-07 19:48:16 | transacting | 1 | 49908 | 2 | 2.736 | 18241.2 |
| 320 | 2025-06-04 13:19:13 | transacting | 1 | 49908 | 2 | 4.033 | 12374.9 |
| 319 | 2025-05-26 21:40:16 | transacting | 1 | 49908 | 2 | 4.470 | 11165.1 |
| 318 | 2025-05-15 11:56:05 | transacting | 4 | 148819 | 121 | 9.643 | 15432.9 |
| 317 | 2025-05-14 13:24:27 | transacting | 1 | 49908 | 2 | 4.330 | 11526.1 |
| 316 | 2025-05-12 20:04:12 | transacting | 4 | 148819 | 121 | 14.420 | 10320.3 |
| 315 | 2025-05-10 03:10:39 | transacting | 4 | 148819 | 121 | 37.896 | 3927.0 |
| 314 | 2025-05-06 18:55:39 | transacting | 4 | 148819 | 121 | 32.503 | 4578.6 |
| 313 | 2025-05-04 22:17:29 | transacting | 1 | 49908 | 2 | 2.186 | 22830.7 |
| 312 | 2025-05-04 01:17:00 | transacting | 3 | 121633 | 34 | 13.580 | 8956.8 |
| 311 | 2025-04-28 13:00:55 | transacting | 1 | 49908 | 2 | 3.876 | 12876.2 |
| 310 | 2025-04-26 08:43:08 | transacting | 3 | 121633 | 34 | 33.330 | 3649.4 |
| 309 | 2025-04-25 20:55:13 | transacting | 2 | 86808 | 9 | 18.156 | 4781.2 |
| 308 | 2025-04-25 07:44:37 | transacting | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 307 | 2025-04-12 17:57:09 | transacting | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 306 | 2025-04-11 14:51:10 | transacting | 2 | 86808 | 9 | 16.763 | 5178.5 |
| 305 | 2025-04-11 05:59:01 | transacting | 4 | 148819 | 121 | 35.593 | 4181.1 |
| 304 | 2025-04-09 17:39:01 | transacting | 2 | 86808 | 9 | 16.110 | 5388.5 |
| 303 | 2025-04-07 11:36:35 | transacting | 3 | 121633 | 34 | 13.813 | 8805.7 |
| 302 | 2025-04-06 20:17:46 | transacting | 4 | 148819 | 121 | 48.346 | 3078.2 |
| 301 | 2025-04-06 13:29:16 | transacting | 2 | 86808 | 9 | 6.390 | 13585.0 |
| 300 | 2025-04-06 13:09:51 | transacting | 1 | 49908 | 2 | 2.250 | 22181.3 |
| 299 | 2025-04-06 11:55:53 | transacting | 1 | 49908 | 2 | 4.170 | 11968.3 |
| 298 | 2025-04-05 07:22:02 | transacting | 4 | 148819 | 121 | 9.486 | 15688.3 |
| 297 | 2025-04-04 23:29:46 | transacting | 4 | 148819 | 121 | 42.220 | 3524.8 |
| 296 | 2025-03-31 08:18:24 | transacting | 3 | 121633 | 34 | 18.580 | 6546.4 |
| 295 | 2025-03-30 00:09:53 | transacting | 3 | 121633 | 34 | 34.880 | 3487.2 |
| 294 | 2025-03-28 09:33:56 | transacting | 3 | 121633 | 34 | 29.703 | 4095.0 |
| 293 | 2025-03-21 14:30:55 | transacting | 1 | 49908 | 2 | 2.000 | 24954.0 |
| 292 | 2025-03-20 15:19:59 | transacting | 1 | 49908 | 2 | 5.956 | 8379.4 |
| 291 | 2025-03-16 09:19:00 | transacting | 4 | 148819 | 121 | 50.220 | 2963.3 |
| 290 | 2025-03-16 09:18:53 | transacting | 3 | 121633 | 34 | 23.500 | 5175.9 |
| 289 | 2025-03-16 09:18:46 | transacting | 2 | 86808 | 9 | 6.236 | 13920.5 |
| 288 | 2025-03-16 09:16:34 | transacting | 1 | 49908 | 2 | 1.796 | 27788.4 |
| 287 | 2025-02-21 00:36:22 | transacting | 2 | 86808 | 9 | 17.140 | 5064.6 |
| 286 | 2025-02-21 00:35:09 | transacting | 1 | 49908 | 2 | 4.390 | 11368.6 |
| 285 | 2025-02-17 00:19:44 | transacting | 1 | 49908 | 2 | 6.156 | 8107.2 |
| 284 | 2025-02-15 00:42:08 | transacting | 1 | 49908 | 2 | 2.216 | 22521.7 |
| 283 | 2025-02-10 09:25:41 | transacting | 1 | 49908 | 2 | 5.046 | 9890.6 |
| 282 | 2025-02-03 13:27:40 | transacting | 3 | 121633 | 34 | 21.563 | 5640.8 |
| 281 | 2025-02-03 13:27:27 | transacting | 2 | 86808 | 9 | 18.703 | 4641.4 |
| 280 | 2025-02-02 15:19:16 | transacting | 3 | 121633 | 34 | 28.580 | 4255.9 |
| 279 | 2025-02-02 15:19:18 | transacting | 2 | 86808 | 9 | 7.486 | 11596.0 |
| 278 | 2025-02-02 15:18:54 | transacting | 1 | 49908 | 2 | 4.110 | 12143.1 |
| 277 | 2025-01-22 00:28:34 | transacting | 2 | 86808 | 9 | 10.800 | 8037.8 |
| 276 | 2025-01-20 06:13:09 | transacting | 4 | 148819 | 121 | 49.673 | 2996.0 |
| 275 | 2025-01-20 06:13:09 | transacting | 3 | 121633 | 34 | 31.456 | 3866.8 |
| 274 | 2025-01-19 18:46:32 | transacting | 3 | 121633 | 34 | 13.940 | 8725.5 |
| 273 | 2025-01-19 12:31:38 | transacting | 4 | 148819 | 121 | 39.360 | 3781.0 |
| 272 | 2025-01-19 12:31:40 | transacting | 3 | 121633 | 34 | 32.046 | 3795.6 |
| 271 | 2025-01-19 12:31:51 | transacting | 2 | 86808 | 9 | 8.983 | 9663.6 |
| 270 | 2025-01-19 12:29:58 | transacting | 1 | 49908 | 2 | 1.156 | 43173.0 |
| 269 | 2025-01-10 13:43:10 | transacting | 1 | 49908 | 2 | 4.310 | 11579.6 |
| 268 | 2024-12-18 01:39:31 | transacting | 2 | 86808 | 9 | 11.923 | 7280.7 |
| 267 | 2024-12-18 01:35:41 | transacting | 1 | 49908 | 2 | 1.313 | 38010.7 |
| 266 | 2024-12-15 21:44:24 | transacting | 1 | 49908 | 2 | 3.876 | 12876.2 |
| 265 | 2024-12-12 06:08:48 | transacting | 3 | 121633 | 34 | 24.890 | 4886.8 |
| 264 | 2024-12-11 16:02:09 | transacting | 3 | 121633 | 34 | 25.533 | 4763.8 |
| 263 | 2024-12-10 23:45:03 | transacting | 4 | 148819 | 121 | 55.410 | 2685.8 |
| 262 | 2024-12-10 23:45:00 | transacting | 2 | 86808 | 9 | 12.063 | 7196.2 |
| 261 | 2024-12-08 12:33:14 | transacting | 4 | 148819 | 121 | 65.066 | 2287.2 |
| 260 | 2024-12-05 19:36:18 | transacting | 4 | 148819 | 121 | 46.456 | 3203.4 |
| 259 | 2024-12-05 04:27:22 | transacting | 3 | 121633 | 34 | 26.373 | 4612.0 |
| 258 | 2024-12-05 03:50:30 | transacting | 3 | 121633 | 34 | 26.440 | 4600.3 |
| 257 | 2024-12-04 17:17:08 | transacting | 4 | 148819 | 121 | 38.903 | 3825.4 |
| 256 | 2024-12-04 17:17:12 | transacting | 3 | 121633 | 34 | 31.783 | 3827.0 |
| 255 | 2024-12-04 17:17:12 | transacting | 2 | 86808 | 9 | 18.250 | 4756.6 |
| 254 | 2024-12-04 17:11:27 | transacting | 1 | 49908 | 2 | 2.033 | 24548.9 |
| 253 | 2024-11-29 20:39:47 | transacting | 1 | 49908 | 2 | 2.453 | 20345.7 |
| 252 | 2024-11-11 02:24:56 | transacting | 3 | 121633 | 34 | 19.686 | 6178.7 |
| 251 | 2024-11-10 09:33:17 | transacting | 4 | 148819 | 121 | 14.890 | 9994.6 |
| 250 | 2024-11-08 06:50:15 | transacting | 1 | 49908 | 2 | 4.156 | 12008.7 |
| 249 | 2024-11-07 15:12:51 | transacting | 3 | 121633 | 34 | 28.660 | 4244.0 |
| 248 | 2024-11-07 12:45:06 | transacting | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 247 | 2024-10-31 12:16:06 | transacting | 4 | 148819 | 121 | 50.893 | 2924.2 |
| 246 | 2024-10-31 12:15:51 | transacting | 2 | 86808 | 9 | 11.796 | 7359.1 |
| 245 | 2024-10-29 12:28:28 | transacting | 2 | 86808 | 9 | 12.156 | 7141.2 |
| 244 | 2024-10-27 01:06:16 | transacting | 4 | 148819 | 121 | 20.160 | 7381.9 |
| 243 | 2024-10-27 01:06:14 | transacting | 2 | 86808 | 9 | 3.000 | 28936.0 |
| 242 | 2024-10-27 01:06:06 | transacting | 1 | 49908 | 2 | 0.923 | 54071.5 |