History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"creditors"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 264 | 2024-05-12 23:27:27 | creditors | 1 | 81242 | 3 | 2.970 | 27354.2 |
| 263 | 2024-05-11 15:52:57 | creditors | 4 | 165329 | 443 | 26.783 | 6172.9 |
| 262 | 2024-05-11 09:04:46 | creditors | 1 | 81242 | 3 | 3.253 | 24974.5 |
| 261 | 2024-05-10 01:41:11 | creditors | 3 | 148641 | 56 | 22.266 | 6675.7 |
| 260 | 2024-05-10 01:41:08 | creditors | 2 | 121436 | 10 | 10.703 | 11346.0 |
| 259 | 2024-05-10 01:40:34 | creditors | 1 | 81242 | 3 | 3.263 | 24897.9 |
| 258 | 2024-05-08 05:19:48 | creditors | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 257 | 2024-05-04 14:01:22 | creditors | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 256 | 2024-05-03 07:32:30 | creditors | 4 | 165329 | 443 | 25.410 | 6506.5 |
| 255 | 2024-05-03 07:32:28 | creditors | 3 | 148641 | 56 | 27.280 | 5448.7 |
| 254 | 2024-05-03 07:32:25 | creditors | 2 | 121436 | 10 | 6.513 | 18645.2 |
| 253 | 2024-05-03 03:28:23 | creditors | 1 | 81242 | 3 | 3.076 | 26411.6 |
| 252 | 2024-04-21 02:41:43 | creditors | 4 | 165329 | 443 | 42.550 | 3885.5 |
| 251 | 2024-04-20 23:54:07 | creditors | 4 | 165329 | 443 | 30.050 | 5501.8 |
| 250 | 2024-04-20 14:05:52 | creditors | 4 | 165329 | 443 | 49.753 | 3323.0 |
| 249 | 2024-04-20 14:05:49 | creditors | 3 | 148641 | 56 | 26.796 | 5547.1 |
| 248 | 2024-04-20 12:07:50 | creditors | 4 | 165329 | 443 | 24.890 | 6642.4 |
| 247 | 2024-04-19 19:04:14 | creditors | 1 | 81242 | 3 | 4.030 | 20159.3 |
| 246 | 2024-04-19 16:56:10 | creditors | 4 | 165329 | 443 | 40.113 | 4121.6 |
| 245 | 2024-04-19 16:56:10 | creditors | 3 | 148641 | 56 | 20.376 | 7294.9 |
| 244 | 2024-04-19 16:56:08 | creditors | 2 | 121436 | 10 | 10.186 | 11921.9 |
| 243 | 2024-04-19 14:51:43 | creditors | 1 | 81242 | 3 | 2.920 | 27822.6 |
| 242 | 2024-04-09 23:50:41 | creditors | 1 | 81242 | 3 | 3.250 | 24997.5 |
| 241 | 2024-03-31 23:29:43 | creditors | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 240 | 2024-03-28 22:37:22 | creditors | 1 | 81242 | 3 | 1.530 | 53099.3 |
| 239 | 2024-03-10 19:14:06 | creditors | 3 | 148641 | 56 | 15.470 | 9608.3 |
| 238 | 2024-03-10 05:26:27 | creditors | 3 | 148641 | 56 | 17.156 | 8664.1 |
| 237 | 2024-03-10 01:11:59 | creditors | 3 | 148641 | 56 | 36.863 | 4032.3 |
| 236 | 2024-03-10 00:13:38 | creditors | 4 | 165329 | 443 | 47.050 | 3513.9 |
| 235 | 2024-03-10 00:13:29 | creditors | 3 | 148641 | 56 | 35.066 | 4238.9 |
| 234 | 2024-03-10 00:13:32 | creditors | 2 | 121436 | 10 | 11.750 | 10335.0 |
| 233 | 2024-03-10 00:09:38 | creditors | 1 | 81242 | 3 | 4.423 | 18368.1 |
| 232 | 2024-03-09 12:29:30 | creditors | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 231 | 2024-03-06 10:55:30 | creditors | 1 | 81242 | 3 | 3.486 | 23305.2 |
| 230 | 2024-03-02 02:15:45 | creditors | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 229 | 2024-02-29 16:19:29 | creditors | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 228 | 2024-02-27 09:19:51 | creditors | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 227 | 2024-01-30 05:08:54 | creditors | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 226 | 2024-01-26 20:24:19 | creditors | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 225 | 2024-01-16 22:16:35 | creditors | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 224 | 2024-01-07 01:25:30 | creditors | 4 | 165329 | 443 | 12.110 | 13652.3 |
| 223 | 2023-12-24 16:19:31 | creditors | 3 | 148641 | 56 | 7.626 | 19491.3 |
| 222 | 2023-12-22 02:56:54 | creditors | 4 | 165329 | 443 | 16.123 | 10254.2 |
| 221 | 2023-11-19 18:30:41 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 220 | 2023-11-13 00:53:21 | creditors | 2 | 121436 | 10 | 3.533 | 34371.9 |
| 219 | 2023-11-13 00:53:09 | creditors | 4 | 165329 | 443 | 12.753 | 12963.9 |
| 218 | 2023-11-13 00:53:04 | creditors | 3 | 148641 | 56 | 7.270 | 20445.8 |
| 217 | 2023-11-11 05:13:13 | creditors | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 216 | 2023-11-07 19:00:51 | creditors | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 215 | 2023-10-23 16:16:18 | creditors | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 214 | 2023-10-15 22:56:06 | creditors | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 213 | 2023-10-14 07:58:48 | creditors | 4 | 165329 | 443 | 12.970 | 12747.0 |
| 212 | 2023-08-30 15:31:28 | creditors | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 211 | 2023-08-12 11:34:09 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 210 | 2023-07-26 10:26:45 | creditors | 1 | 81242 | 3 | 2.436 | 33350.6 |
| 209 | 2023-07-26 10:16:22 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 208 | 2023-07-24 16:01:44 | creditors | 4 | 165329 | 443 | 11.050 | 14961.9 |
| 207 | 2023-06-15 20:16:57 | creditors | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 206 | 2023-06-02 08:13:15 | creditors | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 205 | 2023-05-11 00:04:20 | creditors | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 204 | 2023-04-27 14:24:08 | creditors | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 203 | 2023-04-05 02:30:36 | creditors | 4 | 165329 | 443 | 10.800 | 15308.2 |
| 202 | 2023-03-30 18:17:07 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 201 | 2023-03-26 20:12:10 | creditors | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 200 | 2023-03-21 02:22:41 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 199 | 2023-03-05 11:44:42 | creditors | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 198 | 2023-02-22 04:03:27 | creditors | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 197 | 2023-01-13 10:20:56 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 196 | 2023-01-10 11:36:13 | creditors | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 195 | 2023-01-04 01:03:58 | creditors | 4 | 165329 | 443 | 12.110 | 13652.3 |
| 194 | 2023-01-01 20:19:48 | creditors | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 193 | 2022-11-29 07:12:59 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 192 | 2022-11-28 20:02:04 | creditors | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 191 | 2022-11-17 12:52:14 | creditors | 1 | 81242 | 3 | 1.576 | 51549.5 |
| 190 | 2022-10-19 15:34:59 | creditors | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 189 | 2022-10-12 23:57:49 | creditors | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 188 | 2022-10-02 07:35:56 | creditors | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 187 | 2022-09-10 08:07:04 | creditors | 4 | 165329 | 443 | 11.673 | 14163.4 |
| 186 | 2022-08-31 02:23:07 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 185 | 2022-08-19 11:10:46 | creditors | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 184 | 2022-08-01 22:01:03 | creditors | 1 | 81242 | 3 | 1.643 | 49447.4 |
| 183 | 2022-07-10 11:45:34 | creditors | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 182 | 2022-06-28 19:45:38 | creditors | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 181 | 2022-06-08 21:56:14 | creditors | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 180 | 2022-05-23 02:20:31 | creditors | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 179 | 2022-05-11 11:11:02 | creditors | 1 | 81242 | 3 | 1.936 | 41963.8 |
| 178 | 2022-04-23 16:05:02 | creditors | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 177 | 2022-04-21 11:55:08 | creditors | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 176 | 2022-04-04 07:34:15 | creditors | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 175 | 2022-03-31 10:21:35 | creditors | 1 | 81242 | 3 | 1.813 | 44810.8 |
| 174 | 2022-03-23 17:48:31 | creditors | 1 | 81242 | 3 | 1.856 | 43772.6 |
| 173 | 2022-01-10 19:42:40 | creditors | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 172 | 2021-12-10 12:11:09 | creditors | 1 | 81242 | 3 | 2.220 | 36595.5 |
| 171 | 2021-12-04 16:30:26 | creditors | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 170 | 2021-11-23 08:50:20 | creditors | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 169 | 2021-11-01 21:08:24 | creditors | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 168 | 2021-10-21 16:17:07 | creditors | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 167 | 2021-10-11 08:18:37 | creditors | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 166 | 2021-08-31 18:48:30 | creditors | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 165 | 2021-08-27 13:52:18 | creditors | 1 | 81242 | 3 | 1.236 | 65729.8 |