History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"debit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2320 | 2024-03-28 00:39:26 | debit | 1 | 28756 | 5 | 0.530 | 54256.6 |
2319 | 2024-03-22 16:21:32 | debit | 2 | 53800 | 78 | 3.783 | 14221.5 |
2318 | 2024-03-22 16:21:32 | debit | 1 | 28756 | 5 | 1.703 | 16885.5 |
2317 | 2024-03-22 16:20:37 | debit | 3 | 83667 | 922 | 4.346 | 19251.5 |
2316 | 2024-03-21 22:57:35 | debit | 3 | 83667 | 922 | 5.940 | 14085.4 |
2315 | 2024-03-21 06:29:00 | debit | 3 | 83667 | 922 | 11.956 | 6997.9 |
2314 | 2024-03-07 18:52:12 | debit | 3 | 83667 | 922 | 3.860 | 21675.4 |
2313 | 2024-03-06 08:04:50 | debit | 3 | 83667 | 922 | 9.393 | 8907.4 |
2312 | 2024-02-29 23:37:59 | debit | 3 | 83667 | 922 | 4.046 | 20678.9 |
2311 | 2024-02-28 17:10:33 | debit | 3 | 83667 | 922 | 3.250 | 25743.7 |
2310 | 2024-02-28 11:54:04 | debit | 2 | 53800 | 78 | 3.143 | 17117.4 |
2309 | 2024-02-28 11:53:44 | debit | 3 | 83667 | 922 | 4.330 | 19322.6 |
2308 | 2024-02-28 02:14:01 | debit | 3 | 83667 | 922 | 4.343 | 19264.8 |
2307 | 2024-02-27 20:13:51 | debit | 1 | 28756 | 5 | 0.516 | 55728.7 |
2306 | 2024-02-26 18:55:53 | debit | 3 | 83667 | 922 | 8.923 | 9376.6 |
2305 | 2024-02-26 04:37:43 | debit | 1 | 28756 | 5 | 0.563 | 51076.4 |
2304 | 2024-02-25 23:23:50 | debit | 3 | 83667 | 922 | 4.953 | 16892.2 |
2303 | 2024-02-15 21:19:06 | debit | 3 | 83667 | 922 | 12.686 | 6595.2 |
2302 | 2024-02-14 18:13:26 | debit | 3 | 83667 | 922 | 9.360 | 8938.8 |
2301 | 2024-02-13 15:26:15 | debit | 3 | 83667 | 922 | 5.376 | 15563.1 |
2300 | 2024-02-11 21:43:37 | debit | 3 | 83667 | 922 | 5.016 | 16680.0 |
2299 | 2024-02-01 07:46:41 | debit | 1 | 28756 | 5 | 0.513 | 56054.6 |
2298 | 2024-01-28 23:44:21 | debit | 1 | 28756 | 5 | 0.483 | 59536.2 |
2297 | 2024-01-21 22:25:41 | debit | 1 | 28756 | 5 | 0.486 | 59168.7 |
2296 | 2024-01-20 05:04:00 | debit | 1 | 28756 | 5 | 0.530 | 54256.6 |
2295 | 2024-01-19 20:59:49 | debit | 2 | 53800 | 78 | 1.376 | 39098.8 |
2294 | 2024-01-18 03:32:05 | debit | 3 | 83667 | 922 | 3.733 | 22412.8 |
2293 | 2024-01-12 12:46:01 | debit | 3 | 83667 | 922 | 8.110 | 10316.5 |
2292 | 2024-01-11 14:23:06 | debit | 2 | 53800 | 78 | 1.643 | 32745.0 |
2291 | 2024-01-05 16:54:07 | debit | 3 | 83667 | 922 | 3.686 | 22698.6 |
2290 | 2024-01-02 01:37:21 | debit | 3 | 83667 | 922 | 3.373 | 24804.9 |
2289 | 2023-12-25 12:55:37 | debit | 1 | 28756 | 5 | 0.483 | 59536.2 |
2288 | 2023-12-22 18:13:02 | debit | 3 | 83667 | 922 | 3.920 | 21343.6 |
2287 | 2023-12-09 23:03:25 | debit | 3 | 83667 | 922 | 3.500 | 23904.9 |
2286 | 2023-12-04 11:25:48 | debit | 3 | 83667 | 922 | 4.483 | 18663.2 |
2285 | 2023-12-04 02:44:37 | debit | 3 | 83667 | 922 | 3.470 | 24111.5 |
2284 | 2023-12-04 02:44:38 | debit | 2 | 53800 | 78 | 1.593 | 33772.8 |
2283 | 2023-11-22 05:18:56 | debit | 3 | 83667 | 922 | 4.250 | 19686.4 |
2282 | 2023-11-17 01:25:53 | debit | 1 | 28756 | 5 | 0.483 | 59536.2 |
2281 | 2023-11-15 15:38:37 | debit | 3 | 83667 | 922 | 3.970 | 21074.8 |
2280 | 2023-11-10 12:29:59 | debit | 1 | 28756 | 5 | 0.420 | 68466.7 |
2279 | 2023-11-03 08:33:48 | debit | 1 | 28756 | 5 | 0.453 | 63479.0 |
2278 | 2023-11-02 08:34:38 | debit | 1 | 28756 | 5 | 1.000 | 28756.0 |
2277 | 2023-10-30 11:39:48 | debit | 2 | 53800 | 78 | 1.533 | 35094.6 |
2276 | 2023-10-29 10:40:54 | debit | 3 | 83667 | 922 | 3.953 | 21165.4 |
2275 | 2023-10-22 07:59:30 | debit | 3 | 83667 | 922 | 3.453 | 24230.2 |
2274 | 2023-10-22 07:59:32 | debit | 2 | 53800 | 78 | 1.546 | 34799.5 |
2273 | 2023-10-20 07:27:00 | debit | 1 | 28756 | 5 | 0.580 | 49579.3 |
2272 | 2023-10-17 00:33:54 | debit | 1 | 28756 | 5 | 0.440 | 65354.5 |
2271 | 2023-10-12 17:15:17 | debit | 1 | 28756 | 5 | 0.466 | 61708.2 |
2270 | 2023-10-11 04:55:51 | debit | 1 | 28756 | 5 | 0.486 | 59168.7 |
2269 | 2023-10-07 10:42:40 | debit | 1 | 28756 | 5 | 0.470 | 61183.0 |
2268 | 2023-10-05 16:24:33 | debit | 1 | 28756 | 5 | 0.436 | 65954.1 |
2267 | 2023-09-26 19:23:13 | debit | 1 | 28756 | 5 | 0.516 | 55728.7 |
2266 | 2023-09-24 13:53:07 | debit | 3 | 83667 | 922 | 3.626 | 23074.2 |
2265 | 2023-09-23 14:42:09 | debit | 1 | 28756 | 5 | 0.436 | 65954.1 |
2264 | 2023-09-17 07:12:00 | debit | 3 | 83667 | 922 | 3.330 | 25125.2 |
2263 | 2023-08-31 11:59:50 | debit | 3 | 83667 | 922 | 3.516 | 23796.1 |
2262 | 2023-08-09 07:03:16 | debit | 1 | 28756 | 5 | 0.466 | 61708.2 |
2261 | 2023-08-06 22:52:48 | debit | 2 | 53800 | 78 | 1.546 | 34799.5 |
2260 | 2023-08-05 00:26:44 | debit | 3 | 83667 | 922 | 3.186 | 26260.8 |
2259 | 2023-06-27 09:14:38 | debit | 1 | 28756 | 5 | 0.486 | 59168.7 |
2258 | 2023-06-23 17:35:09 | debit | 1 | 28756 | 5 | 0.546 | 52666.7 |
2257 | 2023-06-06 19:36:10 | debit | 1 | 28756 | 5 | 0.436 | 65954.1 |
2256 | 2023-06-06 18:10:50 | debit | 3 | 83667 | 922 | 3.670 | 22797.5 |
2255 | 2023-06-06 05:34:07 | debit | 3 | 83667 | 922 | 3.220 | 25983.5 |
2254 | 2023-06-05 10:42:23 | debit | 3 | 83667 | 922 | 3.173 | 26368.4 |
2253 | 2023-06-04 20:35:57 | debit | 3 | 83667 | 922 | 3.203 | 26121.4 |
2252 | 2023-06-02 22:40:58 | debit | 3 | 83667 | 922 | 3.233 | 25879.1 |
2251 | 2023-06-01 11:39:57 | debit | 3 | 83667 | 922 | 3.986 | 20990.2 |
2250 | 2023-05-28 20:39:57 | debit | 3 | 83667 | 922 | 3.673 | 22778.9 |
2249 | 2023-05-27 20:01:45 | debit | 3 | 83667 | 922 | 3.940 | 21235.3 |
2248 | 2023-05-12 01:22:57 | debit | 1 | 28756 | 5 | 0.440 | 65354.5 |
2247 | 2023-04-22 18:46:20 | debit | 1 | 28756 | 5 | 0.516 | 55728.7 |
2246 | 2023-04-17 10:26:28 | debit | 2 | 53800 | 78 | 1.343 | 40059.6 |
2245 | 2023-04-13 16:58:09 | debit | 3 | 83667 | 922 | 3.203 | 26121.4 |
2244 | 2023-03-21 10:13:49 | debit | 1 | 28756 | 5 | 0.483 | 59536.2 |
2243 | 2023-03-04 09:08:31 | debit | 1 | 28756 | 5 | 0.470 | 61183.0 |
2242 | 2023-01-22 08:14:52 | debit | 2 | 53800 | 78 | 1.330 | 40451.1 |
2241 | 2023-01-21 03:30:08 | debit | 3 | 83667 | 922 | 3.673 | 22778.9 |
2240 | 2022-12-28 10:15:55 | debit | 1 | 28756 | 5 | 0.453 | 63479.0 |
2239 | 2022-12-19 13:55:35 | debit | 1 | 28756 | 5 | 0.470 | 61183.0 |
2238 | 2022-11-26 00:25:54 | debit | 1 | 28756 | 5 | 0.440 | 65354.5 |
2237 | 2022-11-11 04:49:38 | debit | 3 | 83667 | 922 | 3.173 | 26368.4 |
2236 | 2022-11-09 11:50:48 | debit | 3 | 83667 | 922 | 3.796 | 22040.8 |
2235 | 2022-11-08 17:23:20 | debit | 3 | 83667 | 922 | 4.233 | 19765.4 |
2234 | 2022-11-07 22:14:42 | debit | 3 | 83667 | 922 | 3.203 | 26121.4 |
2233 | 2022-11-01 23:07:48 | debit | 2 | 53800 | 78 | 1.330 | 40451.1 |
2232 | 2022-10-31 20:50:13 | debit | 3 | 83667 | 922 | 3.203 | 26121.4 |
2231 | 2022-10-06 12:13:59 | debit | 3 | 83667 | 922 | 3.203 | 26121.4 |
2230 | 2022-09-29 08:38:36 | debit | 3 | 83667 | 922 | 3.546 | 23594.8 |
2229 | 2022-09-16 02:56:22 | debit | 3 | 83667 | 922 | 3.873 | 21602.6 |
2228 | 2022-09-16 00:11:34 | debit | 1 | 28756 | 5 | 0.470 | 61183.0 |
2227 | 2022-09-15 06:45:12 | debit | 3 | 83667 | 922 | 6.733 | 12426.4 |
2226 | 2022-09-14 04:58:03 | debit | 3 | 83667 | 922 | 3.893 | 21491.7 |
2225 | 2022-09-13 17:00:49 | debit | 3 | 83667 | 922 | 3.673 | 22778.9 |
2224 | 2022-09-12 05:20:10 | debit | 1 | 28756 | 5 | 0.436 | 65954.1 |
2223 | 2022-09-12 02:26:46 | debit | 3 | 83667 | 922 | 4.033 | 20745.6 |
2222 | 2022-09-11 02:52:09 | debit | 3 | 83667 | 922 | 3.873 | 21602.6 |
2221 | 2022-09-10 09:40:01 | debit | 3 | 83667 | 922 | 3.910 | 21398.2 |