History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subsidiary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 327 | 2025-06-18 18:46:30 | subsidiary | 1 | 67641 | 1 | 2.593 | 26086.0 |
| 326 | 2025-06-15 23:19:25 | subsidiary | 1 | 67641 | 1 | 5.406 | 12512.2 |
| 325 | 2025-06-07 19:45:20 | subsidiary | 1 | 67641 | 1 | 5.530 | 12231.6 |
| 324 | 2025-05-08 05:37:50 | subsidiary | 1 | 67641 | 1 | 4.843 | 13966.8 |
| 323 | 2025-05-06 13:56:44 | subsidiary | 1 | 67641 | 1 | 8.156 | 8293.4 |
| 322 | 2025-05-01 23:23:47 | subsidiary | 1 | 67641 | 1 | 7.470 | 9055.0 |
| 321 | 2025-04-22 08:52:38 | subsidiary | 1 | 67641 | 1 | 2.063 | 32787.7 |
| 320 | 2025-03-27 16:11:50 | subsidiary | 1 | 67641 | 1 | 8.376 | 8075.6 |
| 319 | 2025-03-20 15:28:40 | subsidiary | 1 | 67641 | 1 | 6.093 | 11101.4 |
| 318 | 2025-02-15 05:20:23 | subsidiary | 3 | 140603 | 18 | 29.533 | 4760.9 |
| 317 | 2025-02-06 17:17:12 | subsidiary | 3 | 140603 | 18 | 31.540 | 4457.9 |
| 316 | 2025-02-06 17:17:07 | subsidiary | 2 | 108824 | 3 | 17.130 | 6352.8 |
| 315 | 2025-02-06 17:14:22 | subsidiary | 1 | 67641 | 1 | 2.843 | 23792.1 |
| 314 | 2025-02-05 09:00:04 | subsidiary | 1 | 67641 | 1 | 5.720 | 11825.3 |
| 313 | 2025-01-16 14:16:20 | subsidiary | 1 | 67641 | 1 | 8.063 | 8389.1 |
| 312 | 2025-01-16 14:15:11 | subsidiary | 1 | 67641 | 1 | 5.673 | 11923.3 |
| 311 | 2025-01-16 14:14:45 | subsidiary | 2 | 108824 | 3 | 15.376 | 7077.5 |
| 310 | 2025-01-14 18:29:30 | subsidiary | 1 | 67641 | 1 | 2.626 | 25758.2 |
| 309 | 2025-01-12 13:39:50 | subsidiary | 2 | 108824 | 3 | 7.580 | 14356.7 |
| 308 | 2024-12-31 01:53:51 | subsidiary | 3 | 140603 | 18 | 36.893 | 3811.1 |
| 307 | 2024-12-29 06:27:04 | subsidiary | 4 | 161450 | 52 | 73.503 | 2196.5 |
| 306 | 2024-12-26 04:36:58 | subsidiary | 4 | 161450 | 52 | 58.846 | 2743.6 |
| 305 | 2024-12-25 05:33:00 | subsidiary | 3 | 140603 | 18 | 20.253 | 6942.3 |
| 304 | 2024-12-23 14:56:38 | subsidiary | 3 | 140603 | 18 | 29.830 | 4713.5 |
| 303 | 2024-12-23 05:32:08 | subsidiary | 3 | 140603 | 18 | 31.470 | 4467.8 |
| 302 | 2024-12-21 04:29:14 | subsidiary | 4 | 161450 | 52 | 73.143 | 2207.3 |
| 301 | 2024-12-19 12:13:51 | subsidiary | 3 | 140603 | 18 | 25.246 | 5569.3 |
| 300 | 2024-12-19 12:13:55 | subsidiary | 2 | 108824 | 3 | 21.216 | 5129.3 |
| 299 | 2024-12-19 12:12:42 | subsidiary | 4 | 161450 | 52 | 58.116 | 2778.1 |
| 298 | 2024-12-19 12:09:55 | subsidiary | 1 | 67641 | 1 | 2.313 | 29243.8 |
| 297 | 2024-12-04 03:04:01 | subsidiary | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 296 | 2024-11-29 16:14:38 | subsidiary | 4 | 161450 | 52 | 71.126 | 2269.9 |
| 295 | 2024-11-29 16:14:41 | subsidiary | 2 | 108824 | 3 | 10.533 | 10331.7 |
| 294 | 2024-11-29 14:50:09 | subsidiary | 1 | 67641 | 1 | 5.000 | 13528.2 |
| 293 | 2024-11-23 09:59:54 | subsidiary | 4 | 161450 | 52 | 62.390 | 2587.8 |
| 292 | 2024-11-22 14:22:27 | subsidiary | 4 | 161450 | 52 | 40.236 | 4012.6 |
| 291 | 2024-11-21 14:28:48 | subsidiary | 3 | 140603 | 18 | 16.160 | 8700.7 |
| 290 | 2024-11-19 04:02:24 | subsidiary | 1 | 67641 | 1 | 10.563 | 6403.6 |
| 289 | 2024-11-18 04:58:52 | subsidiary | 4 | 161450 | 52 | 65.113 | 2479.5 |
| 288 | 2024-11-18 04:58:42 | subsidiary | 3 | 140603 | 18 | 32.033 | 4389.3 |
| 287 | 2024-11-15 10:03:47 | subsidiary | 4 | 161450 | 52 | 50.266 | 3211.9 |
| 286 | 2024-11-15 06:06:56 | subsidiary | 2 | 108824 | 3 | 7.580 | 14356.7 |
| 285 | 2024-11-14 16:28:13 | subsidiary | 3 | 140603 | 18 | 22.986 | 6116.9 |
| 284 | 2024-11-01 18:12:20 | subsidiary | 3 | 140603 | 18 | 30.643 | 4588.4 |
| 283 | 2024-10-31 15:39:23 | subsidiary | 1 | 67641 | 1 | 4.466 | 15145.8 |
| 282 | 2024-10-21 05:24:16 | subsidiary | 1 | 67641 | 1 | 8.453 | 8002.0 |
| 281 | 2024-10-20 18:42:45 | subsidiary | 3 | 140603 | 18 | 25.703 | 5470.3 |
| 280 | 2024-10-16 05:16:21 | subsidiary | 3 | 140603 | 18 | 38.103 | 3690.1 |
| 279 | 2024-10-11 06:42:54 | subsidiary | 3 | 140603 | 18 | 47.173 | 2980.6 |
| 278 | 2024-10-11 06:42:58 | subsidiary | 2 | 108824 | 3 | 12.203 | 8917.8 |
| 277 | 2024-10-11 06:40:07 | subsidiary | 1 | 67641 | 1 | 3.140 | 21541.7 |
| 276 | 2024-10-10 02:32:41 | subsidiary | 4 | 161450 | 52 | 46.766 | 3452.3 |
| 275 | 2024-10-08 23:38:38 | subsidiary | 4 | 161450 | 52 | 41.283 | 3910.8 |
| 274 | 2024-10-08 23:38:37 | subsidiary | 2 | 108824 | 3 | 15.436 | 7050.0 |
| 273 | 2024-10-06 04:42:47 | subsidiary | 4 | 161450 | 52 | 79.690 | 2026.0 |
| 272 | 2024-10-04 05:53:48 | subsidiary | 2 | 108824 | 3 | 21.533 | 5053.8 |
| 271 | 2024-10-03 08:43:25 | subsidiary | 1 | 67641 | 1 | 12.470 | 5424.3 |
| 270 | 2024-09-19 04:36:34 | subsidiary | 4 | 161450 | 52 | 78.820 | 2048.3 |
| 269 | 2024-09-06 13:19:56 | subsidiary | 4 | 161450 | 52 | 71.836 | 2247.5 |
| 268 | 2024-09-05 09:04:44 | subsidiary | 4 | 161450 | 52 | 112.083 | 1440.5 |
| 267 | 2024-09-03 16:24:51 | subsidiary | 4 | 161450 | 52 | 121.930 | 1324.1 |
| 266 | 2024-09-02 08:01:59 | subsidiary | 1 | 67641 | 1 | 6.266 | 10794.9 |
| 265 | 2024-09-02 08:01:07 | subsidiary | 1 | 67641 | 1 | 10.016 | 6753.3 |
| 264 | 2024-09-02 08:01:02 | subsidiary | 1 | 67641 | 1 | 7.533 | 8979.3 |
| 263 | 2024-09-02 06:48:08 | subsidiary | 4 | 161450 | 52 | 47.580 | 3393.2 |
| 262 | 2024-08-19 16:31:44 | subsidiary | 4 | 161450 | 52 | 89.630 | 1801.3 |
| 261 | 2024-08-07 18:29:45 | subsidiary | 2 | 108824 | 3 | 10.223 | 10645.0 |
| 260 | 2024-08-07 17:27:56 | subsidiary | 1 | 67641 | 1 | 2.486 | 27208.8 |
| 259 | 2024-08-04 15:09:49 | subsidiary | 4 | 161450 | 52 | 48.550 | 3325.4 |
| 258 | 2024-08-04 08:57:57 | subsidiary | 4 | 161450 | 52 | 22.033 | 7327.6 |
| 257 | 2024-08-03 04:52:06 | subsidiary | 3 | 140603 | 18 | 23.343 | 6023.3 |
| 256 | 2024-08-02 22:38:17 | subsidiary | 4 | 161450 | 52 | 59.906 | 2695.1 |
| 255 | 2024-07-24 11:46:23 | subsidiary | 4 | 161450 | 52 | 43.270 | 3731.2 |
| 254 | 2024-07-24 11:46:24 | subsidiary | 2 | 108824 | 3 | 9.843 | 11056.0 |
| 253 | 2024-07-24 11:46:20 | subsidiary | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 252 | 2024-07-24 10:35:18 | subsidiary | 3 | 140603 | 18 | 18.953 | 7418.5 |
| 251 | 2024-07-23 19:51:41 | subsidiary | 4 | 161450 | 52 | 50.783 | 3179.2 |
| 250 | 2024-07-22 02:50:51 | subsidiary | 3 | 140603 | 18 | 28.766 | 4887.8 |
| 249 | 2024-07-22 02:49:09 | subsidiary | 4 | 161450 | 52 | 50.583 | 3191.8 |
| 248 | 2024-07-22 00:06:43 | subsidiary | 3 | 140603 | 18 | 12.123 | 11598.0 |
| 247 | 2024-07-21 12:50:48 | subsidiary | 3 | 140603 | 18 | 23.906 | 5881.5 |
| 246 | 2024-07-15 21:10:19 | subsidiary | 4 | 161450 | 52 | 51.473 | 3136.6 |
| 245 | 2024-07-03 16:28:57 | subsidiary | 3 | 140603 | 18 | 41.283 | 3405.8 |
| 244 | 2024-07-03 16:29:07 | subsidiary | 4 | 161450 | 52 | 25.250 | 6394.1 |
| 243 | 2024-07-03 16:28:48 | subsidiary | 2 | 108824 | 3 | 11.360 | 9579.6 |
| 242 | 2024-07-02 01:44:41 | subsidiary | 1 | 67641 | 1 | 4.546 | 14879.2 |
| 241 | 2024-06-17 07:32:01 | subsidiary | 4 | 161450 | 52 | 56.346 | 2865.3 |
| 240 | 2024-06-17 07:32:07 | subsidiary | 3 | 140603 | 18 | 20.376 | 6900.4 |
| 239 | 2024-06-16 17:21:50 | subsidiary | 3 | 140603 | 18 | 19.843 | 7085.8 |
| 238 | 2024-06-16 12:11:15 | subsidiary | 4 | 161450 | 52 | 38.563 | 4186.7 |
| 237 | 2024-06-15 23:21:41 | subsidiary | 4 | 161450 | 52 | 36.643 | 4406.0 |
| 236 | 2024-06-14 23:53:27 | subsidiary | 4 | 161450 | 52 | 39.596 | 4077.4 |
| 235 | 2024-06-14 21:19:26 | subsidiary | 4 | 161450 | 52 | 59.566 | 2710.4 |
| 234 | 2024-06-14 19:37:16 | subsidiary | 3 | 140603 | 18 | 25.826 | 5444.2 |
| 233 | 2024-06-14 17:19:54 | subsidiary | 3 | 140603 | 18 | 32.110 | 4378.8 |
| 232 | 2024-06-14 09:27:23 | subsidiary | 3 | 140603 | 18 | 32.500 | 4326.2 |
| 231 | 2024-06-14 09:27:12 | subsidiary | 4 | 161450 | 52 | 37.923 | 4257.3 |
| 230 | 2024-06-14 09:27:28 | subsidiary | 2 | 108824 | 3 | 13.066 | 8328.8 |
| 229 | 2024-06-14 09:21:44 | subsidiary | 1 | 67641 | 1 | 1.236 | 54725.7 |
| 228 | 2024-06-14 04:20:01 | subsidiary | 1 | 67641 | 1 | 3.156 | 21432.5 |