History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfamily"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 277 | 2025-11-18 14:13:37 | subfamily | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 276 | 2025-11-18 01:27:47 | subfamily | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 275 | 2025-11-12 02:19:51 | subfamily | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 274 | 2025-11-09 02:45:42 | subfamily | 4 | 165329 | 119 | 11.703 | 14127.1 |
| 273 | 2025-11-07 08:32:51 | subfamily | 1 | 81242 | 1 | 1.906 | 42624.3 |
| 272 | 2025-10-25 17:57:23 | subfamily | 1 | 81242 | 1 | 1.530 | 53099.3 |
| 271 | 2025-10-24 20:48:06 | subfamily | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 270 | 2025-10-18 19:04:31 | subfamily | 1 | 81242 | 1 | 3.673 | 22118.7 |
| 269 | 2025-10-18 01:11:11 | subfamily | 4 | 165329 | 119 | 10.296 | 16057.6 |
| 268 | 2025-10-17 02:37:44 | subfamily | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 267 | 2025-10-14 18:06:04 | subfamily | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 266 | 2025-10-12 13:10:11 | subfamily | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 265 | 2025-10-10 06:18:57 | subfamily | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 264 | 2025-10-09 12:41:10 | subfamily | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 263 | 2025-10-05 07:49:29 | subfamily | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 262 | 2025-10-05 02:54:21 | subfamily | 4 | 165329 | 119 | 11.486 | 14394.0 |
| 261 | 2025-10-02 23:19:57 | subfamily | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 260 | 2025-09-16 22:07:36 | subfamily | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 259 | 2025-09-08 17:57:32 | subfamily | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 258 | 2025-09-03 03:30:25 | subfamily | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 257 | 2025-08-28 17:04:18 | subfamily | 2 | 121436 | 1 | 15.346 | 7913.2 |
| 256 | 2025-08-27 12:24:45 | subfamily | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 255 | 2025-08-19 13:34:15 | subfamily | 3 | 148641 | 16 | 20.406 | 7284.2 |
| 254 | 2025-08-19 04:56:00 | subfamily | 3 | 148641 | 16 | 18.093 | 8215.4 |
| 253 | 2025-08-18 03:21:09 | subfamily | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 252 | 2025-08-06 23:02:50 | subfamily | 1 | 81242 | 1 | 3.923 | 20709.2 |
| 251 | 2025-07-30 22:50:45 | subfamily | 1 | 81242 | 1 | 3.563 | 22801.6 |
| 250 | 2025-07-25 04:21:30 | subfamily | 1 | 81242 | 1 | 3.673 | 22118.7 |
| 249 | 2025-07-22 04:48:58 | subfamily | 1 | 81242 | 1 | 1.410 | 57618.4 |
| 248 | 2025-07-17 14:40:40 | subfamily | 1 | 81242 | 1 | 3.310 | 24544.4 |
| 247 | 2025-06-25 21:48:41 | subfamily | 1 | 81242 | 1 | 7.453 | 10900.6 |
| 246 | 2025-06-20 06:50:34 | subfamily | 1 | 81242 | 1 | 7.310 | 11113.8 |
| 245 | 2025-06-10 14:00:00 | subfamily | 1 | 81242 | 1 | 6.330 | 12834.4 |
| 244 | 2025-06-03 05:44:03 | subfamily | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 243 | 2025-06-01 07:03:24 | subfamily | 1 | 81242 | 1 | 6.923 | 11735.1 |
| 242 | 2025-06-01 02:59:38 | subfamily | 1 | 81242 | 1 | 3.250 | 24997.5 |
| 241 | 2025-05-31 20:30:27 | subfamily | 1 | 81242 | 1 | 9.423 | 8621.7 |
| 240 | 2025-05-30 03:50:20 | subfamily | 1 | 81242 | 1 | 6.390 | 12713.9 |
| 239 | 2025-05-07 04:50:10 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 238 | 2025-04-06 13:49:35 | subfamily | 1 | 81242 | 1 | 6.330 | 12834.4 |
| 237 | 2025-03-21 04:54:30 | subfamily | 3 | 148641 | 16 | 35.266 | 4214.9 |
| 236 | 2025-03-20 21:44:35 | subfamily | 1 | 81242 | 1 | 3.783 | 21475.5 |
| 235 | 2025-03-17 07:41:39 | subfamily | 3 | 148641 | 16 | 45.273 | 3283.2 |
| 234 | 2025-03-17 07:41:34 | subfamily | 3 | 148641 | 16 | 36.163 | 4110.3 |
| 233 | 2025-03-17 07:41:37 | subfamily | 2 | 121436 | 1 | 26.440 | 4592.9 |
| 232 | 2025-03-17 07:37:23 | subfamily | 1 | 81242 | 1 | 3.140 | 25873.2 |
| 231 | 2025-02-19 23:59:21 | subfamily | 1 | 81242 | 1 | 6.923 | 11735.1 |
| 230 | 2025-02-02 13:13:12 | subfamily | 1 | 81242 | 1 | 6.233 | 13034.2 |
| 229 | 2025-01-29 15:30:51 | subfamily | 1 | 81242 | 1 | 6.436 | 12623.1 |
| 228 | 2025-01-25 18:15:08 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 227 | 2025-01-06 13:27:29 | subfamily | 3 | 148641 | 16 | 47.020 | 3161.2 |
| 226 | 2025-01-02 23:55:10 | subfamily | 3 | 148641 | 16 | 35.500 | 4187.1 |
| 225 | 2025-01-02 01:46:48 | subfamily | 1 | 81242 | 1 | 10.300 | 7887.6 |
| 224 | 2024-12-29 08:56:33 | subfamily | 1 | 81242 | 1 | 7.343 | 11063.9 |
| 223 | 2024-12-20 17:28:13 | subfamily | 1 | 81242 | 1 | 9.940 | 8173.2 |
| 222 | 2024-11-23 18:10:14 | subfamily | 2 | 121436 | 1 | 14.126 | 8596.6 |
| 221 | 2024-11-23 18:08:07 | subfamily | 1 | 81242 | 1 | 7.190 | 11299.3 |
| 220 | 2024-11-17 22:27:05 | subfamily | 2 | 121436 | 1 | 14.453 | 8402.1 |
| 219 | 2024-11-17 22:21:27 | subfamily | 1 | 81242 | 1 | 1.576 | 51549.5 |
| 218 | 2024-11-17 05:52:14 | subfamily | 3 | 148641 | 16 | 50.533 | 2941.5 |
| 217 | 2024-11-09 14:17:21 | subfamily | 1 | 81242 | 1 | 9.030 | 8996.9 |
| 216 | 2024-11-08 01:38:46 | subfamily | 3 | 148641 | 16 | 35.923 | 4137.8 |
| 215 | 2024-11-01 07:32:17 | subfamily | 1 | 81242 | 1 | 6.530 | 12441.3 |
| 214 | 2024-10-26 15:03:30 | subfamily | 3 | 148641 | 16 | 50.893 | 2920.7 |
| 213 | 2024-10-21 11:18:59 | subfamily | 3 | 148641 | 16 | 35.753 | 4157.4 |
| 212 | 2024-10-21 06:56:18 | subfamily | 3 | 148641 | 16 | 53.630 | 2771.6 |
| 211 | 2024-10-21 06:56:01 | subfamily | 3 | 148641 | 16 | 35.423 | 4196.2 |
| 210 | 2024-10-21 02:45:58 | subfamily | 4 | 165329 | 119 | 64.533 | 2561.9 |
| 209 | 2024-10-21 02:46:09 | subfamily | 3 | 148641 | 16 | 48.143 | 3087.5 |
| 208 | 2024-10-21 02:46:01 | subfamily | 2 | 121436 | 1 | 19.110 | 6354.6 |
| 207 | 2024-10-21 01:37:35 | subfamily | 1 | 81242 | 1 | 3.686 | 22040.7 |
| 206 | 2024-09-23 03:56:56 | subfamily | 1 | 81242 | 1 | 13.593 | 5976.8 |
| 205 | 2024-09-09 06:32:05 | subfamily | 1 | 81242 | 1 | 4.830 | 16820.3 |
| 204 | 2024-08-05 22:23:51 | subfamily | 1 | 81242 | 1 | 8.470 | 9591.7 |
| 203 | 2024-07-29 17:08:26 | subfamily | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 202 | 2024-07-14 22:07:44 | subfamily | 3 | 148641 | 16 | 26.580 | 5592.2 |
| 201 | 2024-07-14 22:07:49 | subfamily | 2 | 121436 | 1 | 13.203 | 9197.6 |
| 200 | 2024-07-14 22:04:02 | subfamily | 1 | 81242 | 1 | 5.280 | 15386.7 |
| 199 | 2024-07-08 20:11:56 | subfamily | 3 | 148641 | 16 | 34.016 | 4369.7 |
| 198 | 2024-07-08 20:11:58 | subfamily | 3 | 148641 | 16 | 13.956 | 10650.7 |
| 197 | 2024-07-08 06:45:08 | subfamily | 4 | 165329 | 119 | 42.143 | 3923.0 |
| 196 | 2024-07-08 06:45:07 | subfamily | 3 | 148641 | 16 | 33.550 | 4430.4 |
| 195 | 2024-07-08 05:45:42 | subfamily | 4 | 165329 | 119 | 75.266 | 2196.6 |
| 194 | 2024-07-07 04:44:00 | subfamily | 4 | 165329 | 119 | 47.436 | 3485.3 |
| 193 | 2024-07-07 04:44:03 | subfamily | 3 | 148641 | 16 | 29.143 | 5100.4 |
| 192 | 2024-07-07 04:44:10 | subfamily | 2 | 121436 | 1 | 18.390 | 6603.4 |
| 191 | 2024-07-07 04:43:42 | subfamily | 1 | 81242 | 1 | 4.483 | 18122.2 |
| 190 | 2024-07-05 06:38:08 | subfamily | 1 | 81242 | 1 | 2.093 | 38816.1 |
| 189 | 2024-07-05 06:36:34 | subfamily | 1 | 81242 | 1 | 4.690 | 17322.4 |
| 188 | 2024-07-01 05:11:11 | subfamily | 1 | 81242 | 1 | 3.406 | 23852.6 |
| 187 | 2024-05-20 20:41:12 | subfamily | 2 | 121436 | 1 | 5.763 | 21071.7 |
| 186 | 2024-05-20 20:36:14 | subfamily | 1 | 81242 | 1 | 3.170 | 25628.4 |
| 185 | 2024-05-09 08:55:37 | subfamily | 4 | 165329 | 119 | 40.456 | 4086.6 |
| 184 | 2024-05-09 08:55:38 | subfamily | 3 | 148641 | 16 | 20.906 | 7110.0 |
| 183 | 2024-05-09 08:55:40 | subfamily | 2 | 121436 | 1 | 12.093 | 10041.8 |
| 182 | 2024-05-09 08:55:15 | subfamily | 2 | 121436 | 1 | 5.986 | 20286.7 |
| 181 | 2024-05-09 08:55:06 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 180 | 2024-05-09 08:54:59 | subfamily | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 179 | 2024-05-03 13:48:35 | subfamily | 3 | 148641 | 16 | 7.280 | 20417.7 |
| 178 | 2024-05-03 13:48:31 | subfamily | 2 | 121436 | 1 | 3.560 | 34111.2 |