History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gain"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1331 | 2025-10-25 13:14:49 | gain | 2 | 29872 | 318 | 0.890 | 33564.0 |
| 1330 | 2025-10-09 20:53:33 | gain | 2 | 29872 | 318 | 1.000 | 29872.0 |
| 1329 | 2025-10-09 17:51:12 | gain | 2 | 29872 | 318 | 0.890 | 33564.0 |
| 1328 | 2025-10-07 10:03:43 | gain | 2 | 29872 | 318 | 0.923 | 32364.0 |
| 1327 | 2025-10-01 00:49:53 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1326 | 2025-09-30 04:12:34 | gain | 2 | 29872 | 318 | 0.766 | 38997.4 |
| 1325 | 2025-09-27 19:21:07 | gain | 2 | 29872 | 318 | 0.766 | 38997.4 |
| 1324 | 2025-09-22 15:24:56 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1323 | 2025-09-22 02:28:47 | gain | 2 | 29872 | 318 | 0.923 | 32364.0 |
| 1322 | 2025-09-19 23:08:30 | gain | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 1321 | 2025-09-19 16:55:04 | gain | 2 | 29872 | 318 | 0.876 | 34100.5 |
| 1320 | 2025-09-17 05:02:58 | gain | 2 | 29872 | 318 | 0.890 | 33564.0 |
| 1319 | 2025-09-16 02:49:52 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1318 | 2025-09-11 23:04:51 | gain | 2 | 29872 | 318 | 0.936 | 31914.5 |
| 1317 | 2025-09-11 09:57:44 | gain | 2 | 29872 | 318 | 0.890 | 33564.0 |
| 1316 | 2025-09-10 01:03:20 | gain | 2 | 29872 | 318 | 0.876 | 34100.5 |
| 1315 | 2025-09-09 12:09:05 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1314 | 2025-09-08 18:19:00 | gain | 2 | 29872 | 318 | 0.763 | 39150.7 |
| 1313 | 2025-09-01 22:39:27 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1312 | 2025-09-01 03:57:06 | gain | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 1311 | 2025-08-25 17:12:08 | gain | 1 | 13983 | 24 | 0.950 | 14718.9 |
| 1310 | 2025-08-19 15:45:11 | gain | 1 | 13983 | 24 | 1.093 | 12793.2 |
| 1309 | 2025-08-16 21:02:16 | gain | 1 | 13983 | 24 | 0.656 | 21315.5 |
| 1308 | 2025-08-14 07:02:04 | gain | 2 | 29872 | 318 | 0.906 | 32971.3 |
| 1307 | 2025-08-09 20:10:20 | gain | 2 | 29872 | 318 | 3.610 | 8274.8 |
| 1306 | 2025-08-09 03:23:10 | gain | 1 | 13983 | 24 | 0.673 | 20777.1 |
| 1305 | 2025-08-04 08:42:34 | gain | 1 | 13983 | 24 | 0.346 | 40413.3 |
| 1304 | 2025-08-04 02:18:18 | gain | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 1303 | 2025-08-02 02:02:39 | gain | 1 | 13983 | 24 | 1.146 | 12201.6 |
| 1302 | 2025-08-01 22:03:49 | gain | 1 | 13983 | 24 | 1.090 | 12828.4 |
| 1301 | 2025-08-01 10:20:05 | gain | 1 | 13983 | 24 | 1.546 | 9044.6 |
| 1300 | 2025-07-31 01:52:22 | gain | 1 | 13983 | 24 | 1.046 | 13368.1 |
| 1299 | 2025-07-29 03:43:30 | gain | 2 | 29872 | 318 | 2.486 | 12016.1 |
| 1298 | 2025-07-28 05:50:48 | gain | 2 | 29872 | 318 | 2.160 | 13829.6 |
| 1297 | 2025-07-28 05:50:47 | gain | 2 | 29872 | 318 | 1.593 | 18752.0 |
| 1296 | 2025-07-27 02:56:38 | gain | 2 | 29872 | 318 | 2.720 | 10982.4 |
| 1295 | 2025-07-27 02:56:37 | gain | 2 | 29872 | 318 | 2.546 | 11732.9 |
| 1294 | 2025-07-26 04:59:41 | gain | 1 | 13983 | 24 | 0.953 | 14672.6 |
| 1293 | 2025-07-25 23:58:02 | gain | 2 | 29872 | 318 | 4.186 | 7136.2 |
| 1292 | 2025-07-25 10:46:09 | gain | 2 | 29872 | 318 | 2.063 | 14479.9 |
| 1291 | 2025-07-23 23:47:37 | gain | 2 | 29872 | 318 | 2.580 | 11578.3 |
| 1290 | 2025-07-23 07:13:01 | gain | 2 | 29872 | 318 | 3.580 | 8344.1 |
| 1289 | 2025-07-22 20:36:20 | gain | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 1288 | 2025-07-21 14:17:02 | gain | 2 | 29872 | 318 | 0.780 | 38297.4 |
| 1287 | 2025-07-20 13:30:23 | gain | 2 | 29872 | 318 | 0.766 | 38997.4 |
| 1286 | 2025-07-17 20:11:51 | gain | 1 | 13983 | 24 | 1.156 | 12096.0 |
| 1285 | 2025-07-17 17:27:43 | gain | 1 | 13983 | 24 | 0.670 | 20870.1 |
| 1284 | 2025-07-16 03:45:51 | gain | 1 | 13983 | 24 | 0.203 | 68881.8 |
| 1283 | 2025-07-09 08:40:46 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1282 | 2025-07-09 02:50:37 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1281 | 2025-07-07 15:34:56 | gain | 1 | 13983 | 24 | 0.670 | 20870.1 |
| 1280 | 2025-07-03 02:03:56 | gain | 1 | 13983 | 24 | 0.893 | 15658.5 |
| 1279 | 2025-06-30 15:14:05 | gain | 1 | 13983 | 24 | 1.706 | 8196.4 |
| 1278 | 2025-06-28 07:46:56 | gain | 1 | 13983 | 24 | 0.953 | 14672.6 |
| 1277 | 2025-06-24 05:55:12 | gain | 1 | 13983 | 24 | 1.406 | 9945.2 |
| 1276 | 2025-06-18 04:22:07 | gain | 1 | 13983 | 24 | 0.673 | 20777.1 |
| 1275 | 2025-06-16 16:20:09 | gain | 1 | 13983 | 24 | 1.593 | 8777.8 |
| 1274 | 2025-06-15 15:01:18 | gain | 2 | 29872 | 318 | 4.376 | 6826.3 |
| 1273 | 2025-06-15 05:10:40 | gain | 1 | 13983 | 24 | 0.420 | 33292.9 |
| 1272 | 2025-06-13 19:14:20 | gain | 2 | 29872 | 318 | 1.453 | 20558.8 |
| 1271 | 2025-06-12 19:58:46 | gain | 2 | 29872 | 318 | 0.953 | 31345.2 |
| 1270 | 2025-06-09 21:00:41 | gain | 1 | 13983 | 24 | 0.953 | 14672.6 |
| 1269 | 2025-06-02 02:07:47 | gain | 1 | 13983 | 24 | 0.656 | 21315.5 |
| 1268 | 2025-05-29 10:18:01 | gain | 1 | 13983 | 24 | 0.970 | 14415.5 |
| 1267 | 2025-05-29 06:37:02 | gain | 1 | 13983 | 24 | 1.030 | 13575.7 |
| 1266 | 2025-05-28 00:58:36 | gain | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 1265 | 2025-05-27 22:10:26 | gain | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1264 | 2025-05-27 07:17:18 | gain | 1 | 13983 | 24 | 1.923 | 7271.5 |
| 1263 | 2025-05-24 20:21:11 | gain | 2 | 29872 | 318 | 7.080 | 4219.2 |
| 1262 | 2025-05-20 22:19:30 | gain | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1261 | 2025-05-18 17:38:03 | gain | 2 | 29872 | 318 | 2.063 | 14479.9 |
| 1260 | 2025-05-16 18:56:18 | gain | 2 | 29872 | 318 | 0.920 | 32469.6 |
| 1259 | 2025-05-16 16:50:35 | gain | 1 | 13983 | 24 | 0.686 | 20383.4 |
| 1258 | 2025-05-16 10:32:27 | gain | 1 | 13983 | 24 | 1.326 | 10545.2 |
| 1257 | 2025-05-16 05:51:45 | gain | 1 | 13983 | 24 | 1.843 | 7587.1 |
| 1256 | 2025-05-14 20:42:44 | gain | 1 | 13983 | 24 | 0.483 | 28950.3 |
| 1255 | 2025-05-12 04:34:01 | gain | 1 | 13983 | 24 | 1.173 | 11920.7 |
| 1254 | 2025-05-09 21:14:59 | gain | 1 | 13983 | 24 | 1.156 | 12096.0 |
| 1253 | 2025-05-09 13:02:57 | gain | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 1252 | 2025-05-08 03:02:47 | gain | 1 | 13983 | 24 | 0.720 | 19420.8 |
| 1251 | 2025-05-01 22:15:49 | gain | 2 | 29872 | 318 | 2.500 | 11948.8 |
| 1250 | 2025-05-01 20:31:30 | gain | 1 | 13983 | 24 | 0.703 | 19890.5 |
| 1249 | 2025-05-01 01:54:44 | gain | 1 | 13983 | 24 | 0.373 | 37487.9 |
| 1248 | 2025-04-30 07:42:33 | gain | 2 | 29872 | 318 | 6.736 | 4434.7 |
| 1247 | 2025-04-29 14:43:06 | gain | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 1246 | 2025-04-28 06:37:33 | gain | 1 | 13983 | 24 | 1.000 | 13983.0 |
| 1245 | 2025-04-27 01:32:25 | gain | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 1244 | 2025-04-21 18:28:42 | gain | 1 | 13983 | 24 | 1.106 | 12642.9 |
| 1243 | 2025-04-14 15:59:09 | gain | 1 | 13983 | 24 | 0.673 | 20777.1 |
| 1242 | 2025-04-08 21:14:37 | gain | 1 | 13983 | 24 | 1.453 | 9623.5 |
| 1241 | 2025-04-08 02:29:04 | gain | 1 | 13983 | 24 | 0.956 | 14626.6 |
| 1240 | 2025-03-27 16:57:49 | gain | 1 | 13983 | 24 | 0.856 | 16335.3 |
| 1239 | 2025-03-27 08:12:46 | gain | 1 | 13983 | 24 | 1.626 | 8599.6 |
| 1238 | 2025-03-18 15:50:55 | gain | 1 | 13983 | 24 | 0.673 | 20777.1 |
| 1237 | 2025-03-15 14:00:59 | gain | 1 | 13983 | 24 | 1.953 | 7159.8 |
| 1236 | 2025-03-14 21:54:48 | gain | 1 | 13983 | 24 | 0.466 | 30006.4 |
| 1235 | 2025-03-12 20:13:30 | gain | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 1234 | 2025-03-07 06:55:27 | gain | 2 | 29872 | 318 | 6.500 | 4595.7 |
| 1233 | 2025-03-07 04:36:28 | gain | 2 | 29872 | 318 | 4.093 | 7298.3 |
| 1232 | 2025-03-07 04:29:13 | gain | 1 | 13983 | 24 | 0.266 | 52567.7 |