History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sandfly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 257 | 2025-05-11 12:20:21 | sandfly | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 256 | 2025-05-10 01:29:52 | sandfly | 1 | 69583 | 1 | 8.890 | 7827.1 |
| 255 | 2025-05-05 09:19:49 | sandfly | 3 | 134027 | 150 | 6.873 | 19500.5 |
| 254 | 2025-04-20 16:04:07 | sandfly | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 253 | 2025-04-16 03:16:27 | sandfly | 1 | 69583 | 1 | 5.593 | 12441.1 |
| 252 | 2025-04-14 02:29:44 | sandfly | 1 | 69583 | 1 | 6.413 | 10850.3 |
| 251 | 2025-04-11 11:33:39 | sandfly | 1 | 69583 | 1 | 6.483 | 10733.1 |
| 250 | 2025-04-09 01:20:54 | sandfly | 1 | 69583 | 1 | 6.500 | 10705.1 |
| 249 | 2025-04-05 21:41:47 | sandfly | 3 | 134027 | 150 | 25.126 | 5334.2 |
| 248 | 2025-04-04 20:39:42 | sandfly | 3 | 134027 | 150 | 28.020 | 4783.3 |
| 247 | 2025-03-31 20:16:55 | sandfly | 3 | 134027 | 150 | 36.113 | 3711.3 |
| 246 | 2025-03-30 05:41:09 | sandfly | 3 | 134027 | 150 | 30.203 | 4437.5 |
| 245 | 2025-03-28 15:51:09 | sandfly | 3 | 134027 | 150 | 5.953 | 22514.2 |
| 244 | 2025-03-28 14:32:02 | sandfly | 2 | 107671 | 11 | 3.326 | 32372.5 |
| 243 | 2025-03-20 19:13:56 | sandfly | 1 | 69583 | 1 | 6.416 | 10845.2 |
| 242 | 2025-03-14 17:29:06 | sandfly | 1 | 69583 | 1 | 8.186 | 8500.2 |
| 241 | 2025-03-12 11:42:01 | sandfly | 1 | 69583 | 1 | 8.046 | 8648.1 |
| 240 | 2025-03-10 14:47:06 | sandfly | 2 | 107671 | 11 | 7.046 | 15281.2 |
| 239 | 2025-03-10 14:33:32 | sandfly | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 238 | 2025-03-10 10:15:43 | sandfly | 2 | 107671 | 11 | 8.220 | 13098.7 |
| 237 | 2025-03-10 08:33:45 | sandfly | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 236 | 2025-03-03 16:08:36 | sandfly | 3 | 134027 | 150 | 36.316 | 3690.6 |
| 235 | 2025-02-27 13:36:17 | sandfly | 1 | 69583 | 1 | 7.983 | 8716.4 |
| 234 | 2025-02-25 21:11:17 | sandfly | 3 | 134027 | 150 | 33.566 | 3992.9 |
| 233 | 2025-02-25 13:02:55 | sandfly | 1 | 69583 | 1 | 6.673 | 10427.5 |
| 232 | 2025-02-23 13:08:20 | sandfly | 3 | 134027 | 150 | 26.863 | 4989.3 |
| 231 | 2025-02-23 13:08:19 | sandfly | 2 | 107671 | 11 | 18.220 | 5909.5 |
| 230 | 2025-02-21 14:54:36 | sandfly | 3 | 134027 | 150 | 44.193 | 3032.8 |
| 229 | 2025-02-21 14:54:34 | sandfly | 2 | 107671 | 11 | 25.706 | 4188.6 |
| 228 | 2025-02-21 14:52:48 | sandfly | 1 | 69583 | 1 | 3.846 | 18092.3 |
| 227 | 2025-01-08 21:38:08 | sandfly | 1 | 69583 | 1 | 8.203 | 8482.6 |
| 226 | 2024-12-17 21:15:36 | sandfly | 1 | 69583 | 1 | 4.373 | 15912.0 |
| 225 | 2024-12-09 19:24:00 | sandfly | 1 | 69583 | 1 | 7.970 | 8730.6 |
| 224 | 2024-11-27 20:46:12 | sandfly | 1 | 69583 | 1 | 5.030 | 13833.6 |
| 223 | 2024-10-28 05:01:24 | sandfly | 1 | 69583 | 1 | 4.593 | 15149.8 |
| 222 | 2024-10-26 19:35:02 | sandfly | 1 | 69583 | 1 | 3.610 | 19275.1 |
| 221 | 2024-10-26 15:02:24 | sandfly | 1 | 69583 | 1 | 3.703 | 18791.0 |
| 220 | 2024-10-02 03:16:24 | sandfly | 1 | 69583 | 1 | 7.733 | 8998.2 |
| 219 | 2024-09-24 09:44:35 | sandfly | 1 | 69583 | 1 | 14.576 | 4773.8 |
| 218 | 2024-09-22 07:37:14 | sandfly | 1 | 69583 | 1 | 8.846 | 7866.0 |
| 217 | 2024-09-13 23:03:41 | sandfly | 1 | 69583 | 1 | 12.656 | 5498.0 |
| 216 | 2024-09-04 12:03:51 | sandfly | 1 | 69583 | 1 | 4.766 | 14599.9 |
| 215 | 2024-08-16 08:24:22 | sandfly | 1 | 69583 | 1 | 4.513 | 15418.3 |
| 214 | 2024-08-11 04:31:24 | sandfly | 1 | 69583 | 1 | 5.266 | 13213.6 |
| 213 | 2024-08-03 11:35:24 | sandfly | 1 | 69583 | 1 | 3.233 | 21522.7 |
| 212 | 2024-07-16 10:02:01 | sandfly | 1 | 69583 | 1 | 5.956 | 11682.8 |
| 211 | 2024-07-16 05:19:05 | sandfly | 1 | 69583 | 1 | 3.040 | 22889.1 |
| 210 | 2024-07-07 16:10:24 | sandfly | 1 | 69583 | 1 | 4.420 | 15742.8 |
| 209 | 2024-07-07 00:17:57 | sandfly | 1 | 69583 | 1 | 6.156 | 11303.3 |
| 208 | 2024-07-05 21:02:31 | sandfly | 1 | 69583 | 1 | 5.093 | 13662.5 |
| 207 | 2024-07-01 07:50:12 | sandfly | 1 | 69583 | 1 | 3.966 | 17544.9 |
| 206 | 2024-07-01 07:50:09 | sandfly | 1 | 69583 | 1 | 4.966 | 14011.9 |
| 205 | 2024-06-30 04:10:03 | sandfly | 1 | 69583 | 1 | 3.403 | 20447.5 |
| 204 | 2024-06-20 08:36:16 | sandfly | 1 | 69583 | 1 | 2.876 | 24194.4 |
| 203 | 2024-06-13 15:08:44 | sandfly | 1 | 69583 | 1 | 3.000 | 23194.3 |
| 202 | 2024-06-08 05:31:03 | sandfly | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 201 | 2024-05-11 16:40:12 | sandfly | 3 | 134027 | 150 | 18.483 | 7251.4 |
| 200 | 2024-05-11 08:00:44 | sandfly | 3 | 134027 | 150 | 10.826 | 12380.1 |
| 199 | 2024-05-10 00:03:46 | sandfly | 2 | 107671 | 11 | 3.673 | 29314.2 |
| 198 | 2024-05-10 00:03:33 | sandfly | 3 | 134027 | 150 | 7.750 | 17293.8 |
| 197 | 2024-05-09 16:56:31 | sandfly | 3 | 134027 | 150 | 18.093 | 7407.7 |
| 196 | 2024-05-08 17:16:47 | sandfly | 3 | 134027 | 150 | 24.533 | 5463.1 |
| 195 | 2024-05-08 07:19:17 | sandfly | 3 | 134027 | 150 | 15.546 | 8621.3 |
| 194 | 2024-05-08 07:19:18 | sandfly | 2 | 107671 | 11 | 8.093 | 13304.2 |
| 193 | 2024-05-08 07:18:56 | sandfly | 1 | 69583 | 1 | 1.596 | 43598.4 |
| 192 | 2024-05-05 20:14:28 | sandfly | 1 | 69583 | 1 | 2.956 | 23539.6 |
| 191 | 2024-04-01 18:23:15 | sandfly | 2 | 107671 | 11 | 15.126 | 7118.3 |
| 190 | 2024-04-01 16:51:53 | sandfly | 3 | 134027 | 150 | 24.436 | 5484.8 |
| 189 | 2024-04-01 15:34:31 | sandfly | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 188 | 2024-04-01 15:34:11 | sandfly | 3 | 134027 | 150 | 9.843 | 13616.5 |
| 187 | 2024-04-01 15:34:12 | sandfly | 2 | 107671 | 11 | 5.280 | 20392.2 |
| 186 | 2024-04-01 15:34:10 | sandfly | 1 | 69583 | 1 | 1.950 | 35683.6 |
| 185 | 2024-03-30 14:53:53 | sandfly | 1 | 69583 | 1 | 2.046 | 34009.3 |
| 184 | 2024-03-08 01:08:30 | sandfly | 1 | 69583 | 1 | 4.343 | 16021.9 |
| 183 | 2024-03-01 04:53:51 | sandfly | 1 | 69583 | 1 | 2.766 | 25156.5 |
| 182 | 2024-02-29 13:15:52 | sandfly | 1 | 69583 | 1 | 1.953 | 35628.8 |
| 181 | 2024-02-05 17:15:17 | sandfly | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 180 | 2024-02-05 17:11:25 | sandfly | 2 | 107671 | 11 | 3.720 | 28943.8 |
| 179 | 2024-02-05 17:11:21 | sandfly | 3 | 134027 | 150 | 7.610 | 17612.0 |
| 178 | 2024-02-05 07:41:03 | sandfly | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 177 | 2024-01-06 14:20:42 | sandfly | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 176 | 2023-12-14 19:14:20 | sandfly | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 175 | 2023-11-27 08:52:25 | sandfly | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 174 | 2023-11-23 16:59:32 | sandfly | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 173 | 2023-11-04 19:11:57 | sandfly | 1 | 69583 | 1 | 2.470 | 28171.3 |
| 172 | 2023-10-11 18:53:25 | sandfly | 1 | 69583 | 1 | 1.153 | 60349.5 |
| 171 | 2023-09-29 23:42:28 | sandfly | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 170 | 2023-09-29 21:58:06 | sandfly | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 169 | 2023-09-12 21:00:28 | sandfly | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 168 | 2023-05-29 11:15:15 | sandfly | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 167 | 2023-01-26 15:24:29 | sandfly | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 166 | 2022-09-20 16:32:09 | sandfly | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 165 | 2022-05-08 19:48:35 | sandfly | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 164 | 2022-04-26 22:48:31 | sandfly | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 163 | 2021-12-31 14:47:59 | sandfly | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 162 | 2021-09-08 10:16:56 | sandfly | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 161 | 2021-06-25 06:27:20 | sandfly | 1 | 69583 | 1 | 1.143 | 60877.5 |
| 160 | 2021-06-07 12:01:49 | sandfly | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 159 | 2021-06-04 07:21:30 | sandfly | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 158 | 2021-05-17 01:29:09 | sandfly | 1 | 69583 | 1 | 1.266 | 54962.9 |