History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collateral"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 371 | 2024-04-27 14:21:23 | collateral | 4 | 161450 | 105 | 25.160 | 6416.9 |
| 370 | 2024-04-27 14:21:20 | collateral | 3 | 140603 | 17 | 18.326 | 7672.3 |
| 369 | 2024-04-27 12:31:02 | collateral | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 368 | 2024-04-26 17:56:03 | collateral | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 367 | 2024-04-26 02:52:24 | collateral | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 366 | 2024-04-16 12:54:58 | collateral | 1 | 67641 | 2 | 1.610 | 42013.0 |
| 365 | 2024-04-07 01:40:06 | collateral | 1 | 67641 | 2 | 5.000 | 13528.2 |
| 364 | 2024-04-07 01:38:51 | collateral | 3 | 140603 | 17 | 17.173 | 8187.4 |
| 363 | 2024-04-07 01:38:32 | collateral | 1 | 67641 | 2 | 1.563 | 43276.4 |
| 362 | 2024-03-27 12:28:01 | collateral | 3 | 140603 | 17 | 22.050 | 6376.6 |
| 361 | 2024-03-27 12:27:55 | collateral | 2 | 108824 | 3 | 15.096 | 7208.8 |
| 360 | 2024-03-27 11:44:20 | collateral | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 359 | 2024-03-27 06:07:38 | collateral | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 358 | 2024-03-18 06:58:55 | collateral | 1 | 67641 | 2 | 1.216 | 55625.8 |
| 357 | 2024-03-11 13:34:11 | collateral | 4 | 161450 | 105 | 48.440 | 3333.0 |
| 356 | 2024-03-11 01:40:40 | collateral | 4 | 161450 | 105 | 26.223 | 6156.8 |
| 355 | 2024-03-09 22:10:14 | collateral | 4 | 161450 | 105 | 39.736 | 4063.1 |
| 354 | 2024-03-09 16:04:36 | collateral | 3 | 140603 | 17 | 20.110 | 6991.7 |
| 353 | 2024-03-09 15:50:34 | collateral | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 352 | 2024-03-09 15:50:16 | collateral | 2 | 108824 | 3 | 5.626 | 19343.1 |
| 351 | 2024-03-08 19:40:35 | collateral | 4 | 161450 | 105 | 23.016 | 7014.7 |
| 350 | 2024-03-07 08:02:02 | collateral | 4 | 161450 | 105 | 37.503 | 4305.0 |
| 349 | 2024-03-07 08:02:02 | collateral | 3 | 140603 | 17 | 16.466 | 8539.0 |
| 348 | 2024-03-07 08:02:05 | collateral | 2 | 108824 | 3 | 9.266 | 11744.4 |
| 347 | 2024-03-07 04:58:57 | collateral | 1 | 67641 | 2 | 1.220 | 55443.4 |
| 346 | 2024-02-20 03:53:01 | collateral | 3 | 140603 | 17 | 14.170 | 9922.6 |
| 345 | 2024-02-20 03:53:04 | collateral | 2 | 108824 | 3 | 8.360 | 13017.2 |
| 344 | 2024-02-19 21:12:48 | collateral | 1 | 67641 | 2 | 1.813 | 37308.9 |
| 343 | 2024-02-05 22:56:37 | collateral | 1 | 67641 | 2 | 2.610 | 25916.1 |
| 342 | 2024-02-05 02:52:14 | collateral | 1 | 67641 | 2 | 1.263 | 53555.8 |
| 341 | 2024-01-11 19:10:51 | collateral | 4 | 161450 | 105 | 10.686 | 15108.6 |
| 340 | 2024-01-11 19:10:54 | collateral | 3 | 140603 | 17 | 6.423 | 21890.5 |
| 339 | 2024-01-11 19:10:53 | collateral | 2 | 108824 | 3 | 3.266 | 33320.3 |
| 338 | 2024-01-01 16:22:51 | collateral | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 337 | 2023-12-09 08:31:57 | collateral | 1 | 67641 | 2 | 1.013 | 66773.0 |
| 336 | 2023-11-29 14:08:37 | collateral | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 335 | 2023-11-15 04:31:21 | collateral | 1 | 67641 | 2 | 1.266 | 53428.9 |
| 334 | 2023-10-23 01:37:05 | collateral | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 333 | 2023-08-18 02:26:38 | collateral | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 332 | 2023-05-20 23:37:19 | collateral | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 331 | 2023-03-16 19:06:56 | collateral | 1 | 67641 | 2 | 1.013 | 66773.0 |
| 330 | 2023-01-05 00:22:29 | collateral | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 329 | 2022-10-03 15:40:28 | collateral | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 328 | 2022-05-20 03:33:12 | collateral | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 327 | 2022-02-08 01:08:00 | collateral | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 326 | 2022-02-06 21:23:08 | collateral | 3 | 140603 | 17 | 6.890 | 20406.8 |
| 325 | 2022-02-06 11:25:21 | collateral | 3 | 140603 | 17 | 6.326 | 22226.2 |
| 324 | 2022-02-05 14:36:42 | collateral | 3 | 140603 | 17 | 5.813 | 24187.7 |
| 323 | 2022-02-04 18:24:37 | collateral | 3 | 140603 | 17 | 6.080 | 23125.5 |
| 322 | 2022-02-04 04:24:47 | collateral | 3 | 140603 | 17 | 5.750 | 24452.7 |
| 321 | 2022-02-03 16:47:21 | collateral | 3 | 140603 | 17 | 5.466 | 25723.2 |
| 320 | 2022-02-03 05:27:16 | collateral | 3 | 140603 | 17 | 5.500 | 25564.2 |
| 319 | 2022-02-02 22:31:10 | collateral | 3 | 140603 | 17 | 7.753 | 18135.3 |
| 318 | 2022-02-02 07:23:30 | collateral | 3 | 140603 | 17 | 5.376 | 26153.8 |
| 317 | 2022-02-01 22:57:02 | collateral | 3 | 140603 | 17 | 5.610 | 25062.9 |
| 316 | 2022-02-01 13:20:24 | collateral | 3 | 140603 | 17 | 6.890 | 20406.8 |
| 315 | 2022-02-01 02:29:20 | collateral | 3 | 140603 | 17 | 5.453 | 25784.5 |
| 314 | 2022-01-31 10:51:46 | collateral | 3 | 140603 | 17 | 5.563 | 25274.7 |
| 313 | 2022-01-30 21:21:19 | collateral | 3 | 140603 | 17 | 6.263 | 22449.8 |
| 312 | 2022-01-30 07:58:59 | collateral | 3 | 140603 | 17 | 6.360 | 22107.4 |
| 311 | 2022-01-29 15:23:46 | collateral | 3 | 140603 | 17 | 5.440 | 25846.1 |
| 310 | 2021-12-25 23:05:36 | collateral | 3 | 140603 | 17 | 5.576 | 25215.7 |
| 309 | 2021-12-24 23:33:46 | collateral | 3 | 140603 | 17 | 6.423 | 21890.5 |
| 308 | 2021-12-18 13:20:30 | collateral | 1 | 67641 | 2 | 1.080 | 62630.6 |
| 307 | 2021-12-17 07:58:59 | collateral | 3 | 140603 | 17 | 8.233 | 17078.0 |
| 306 | 2021-12-17 00:36:48 | collateral | 3 | 140603 | 17 | 6.376 | 22051.9 |
| 305 | 2021-12-16 12:19:17 | collateral | 3 | 140603 | 17 | 6.313 | 22272.0 |
| 304 | 2021-12-16 10:49:41 | collateral | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 303 | 2021-12-16 01:29:35 | collateral | 3 | 140603 | 17 | 6.126 | 22951.8 |
| 302 | 2021-12-15 07:59:25 | collateral | 3 | 140603 | 17 | 5.813 | 24187.7 |
| 301 | 2021-12-14 23:22:36 | collateral | 3 | 140603 | 17 | 6.826 | 20598.2 |
| 300 | 2021-12-14 11:55:01 | collateral | 3 | 140603 | 17 | 13.660 | 10293.0 |
| 299 | 2021-12-11 12:44:07 | collateral | 3 | 140603 | 17 | 5.486 | 25629.4 |
| 298 | 2021-12-10 14:07:56 | collateral | 3 | 140603 | 17 | 6.686 | 21029.5 |
| 297 | 2021-12-10 04:55:45 | collateral | 3 | 140603 | 17 | 6.873 | 20457.3 |
| 296 | 2021-12-09 19:03:51 | collateral | 3 | 140603 | 17 | 5.500 | 25564.2 |
| 295 | 2021-12-09 02:59:28 | collateral | 3 | 140603 | 17 | 6.796 | 20689.1 |
| 294 | 2021-12-08 16:05:38 | collateral | 3 | 140603 | 17 | 5.423 | 25927.2 |
| 293 | 2021-11-15 16:30:43 | collateral | 3 | 140603 | 17 | 5.750 | 24452.7 |
| 292 | 2021-11-15 03:11:31 | collateral | 3 | 140603 | 17 | 6.530 | 21531.9 |
| 291 | 2021-11-14 16:40:51 | collateral | 3 | 140603 | 17 | 6.720 | 20923.1 |
| 290 | 2021-11-14 02:05:34 | collateral | 3 | 140603 | 17 | 5.503 | 25550.2 |
| 289 | 2021-11-13 17:29:15 | collateral | 3 | 140603 | 17 | 5.596 | 25125.6 |
| 288 | 2021-11-13 03:28:03 | collateral | 3 | 140603 | 17 | 6.593 | 21326.1 |
| 287 | 2021-11-12 17:25:46 | collateral | 3 | 140603 | 17 | 6.063 | 23190.3 |
| 286 | 2021-11-11 20:17:42 | collateral | 3 | 140603 | 17 | 5.940 | 23670.5 |
| 285 | 2021-11-11 09:24:23 | collateral | 3 | 140603 | 17 | 5.530 | 25425.5 |
| 284 | 2021-10-26 18:36:00 | collateral | 3 | 140603 | 17 | 5.940 | 23670.5 |
| 283 | 2021-10-26 08:02:04 | collateral | 3 | 140603 | 17 | 5.406 | 26008.7 |
| 282 | 2021-10-25 14:25:42 | collateral | 3 | 140603 | 17 | 6.593 | 21326.1 |
| 281 | 2021-10-25 08:27:55 | collateral | 3 | 140603 | 17 | 5.516 | 25490.0 |
| 280 | 2021-10-24 20:32:07 | collateral | 3 | 140603 | 17 | 5.500 | 25564.2 |
| 279 | 2021-10-24 12:32:26 | collateral | 3 | 140603 | 17 | 6.326 | 22226.2 |
| 278 | 2021-10-24 02:05:49 | collateral | 3 | 140603 | 17 | 6.516 | 21578.1 |
| 277 | 2021-10-23 20:25:24 | collateral | 3 | 140603 | 17 | 6.593 | 21326.1 |
| 276 | 2021-10-23 10:20:06 | collateral | 3 | 140603 | 17 | 5.783 | 24313.2 |
| 275 | 2021-10-23 02:04:11 | collateral | 3 | 140603 | 17 | 5.406 | 26008.7 |
| 274 | 2021-10-22 16:03:14 | collateral | 3 | 140603 | 17 | 5.560 | 25288.3 |
| 273 | 2021-09-26 22:09:52 | collateral | 4 | 161450 | 105 | 10.266 | 15726.7 |
| 272 | 2021-09-26 08:12:33 | collateral | 4 | 161450 | 105 | 9.690 | 16661.5 |