History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subarid"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 275 | 2024-04-27 16:00:31 | subarid | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 274 | 2024-04-05 11:55:20 | subarid | 1 | 69583 | 3 | 2.720 | 25582.0 |
| 273 | 2024-03-31 12:09:08 | subarid | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 272 | 2024-02-27 15:22:30 | subarid | 1 | 69583 | 3 | 2.076 | 33517.8 |
| 271 | 2023-12-22 16:15:13 | subarid | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 270 | 2023-12-22 05:03:00 | subarid | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 269 | 2023-12-11 00:00:43 | subarid | 1 | 69583 | 3 | 2.550 | 27287.5 |
| 268 | 2023-12-03 19:23:46 | subarid | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 267 | 2023-11-06 11:53:57 | subarid | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 266 | 2023-10-12 05:09:58 | subarid | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 265 | 2023-10-10 13:20:50 | subarid | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 264 | 2023-09-29 14:57:06 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 263 | 2023-09-17 02:43:50 | subarid | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 262 | 2023-08-07 10:37:29 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 261 | 2023-08-04 03:34:40 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 260 | 2023-05-05 07:38:51 | subarid | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 259 | 2023-04-08 09:03:11 | subarid | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 258 | 2023-02-27 01:57:53 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 257 | 2022-12-25 04:52:51 | subarid | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 256 | 2022-12-16 03:20:54 | subarid | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 255 | 2022-09-12 23:20:54 | subarid | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 254 | 2022-08-09 10:56:24 | subarid | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 253 | 2022-07-18 03:18:39 | subarid | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 252 | 2022-07-16 21:56:14 | subarid | 2 | 107671 | 9 | 3.360 | 32044.9 |
| 251 | 2022-07-15 19:45:07 | subarid | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 250 | 2022-03-28 23:29:06 | subarid | 1 | 69583 | 3 | 1.530 | 45479.1 |
| 249 | 2022-03-17 19:05:56 | subarid | 1 | 69583 | 3 | 2.266 | 30707.4 |
| 248 | 2022-01-11 23:08:13 | subarid | 1 | 69583 | 3 | 2.486 | 27989.9 |
| 247 | 2021-12-01 13:21:01 | subarid | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 246 | 2021-11-07 19:08:01 | subarid | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 245 | 2021-08-15 04:15:09 | subarid | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 244 | 2021-06-15 09:47:07 | subarid | 1 | 69583 | 3 | 2.373 | 29322.8 |
| 243 | 2021-05-04 06:52:09 | subarid | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 242 | 2021-04-30 17:03:28 | subarid | 1 | 69583 | 3 | 2.596 | 26803.9 |
| 241 | 2021-03-25 21:31:00 | subarid | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 240 | 2021-01-09 03:41:27 | subarid | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 239 | 2021-01-02 06:19:51 | subarid | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 238 | 2020-10-23 05:10:59 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 237 | 2020-10-22 03:58:31 | subarid | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 236 | 2020-10-18 18:32:00 | subarid | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 235 | 2020-09-27 15:45:28 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 234 | 2020-09-26 04:25:10 | subarid | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 233 | 2020-09-06 22:50:04 | subarid | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 232 | 2020-08-24 06:11:02 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 231 | 2020-06-11 09:39:49 | subarid | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 230 | 2020-03-28 21:28:36 | subarid | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 229 | 2020-03-25 00:40:16 | subarid | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 228 | 2020-03-24 17:26:14 | subarid | 1 | 69583 | 3 | 2.560 | 27180.9 |
| 227 | 2020-03-20 17:30:55 | subarid | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 226 | 2020-03-09 19:03:26 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 225 | 2020-02-29 21:59:00 | subarid | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 224 | 2020-02-23 18:27:48 | subarid | 1 | 69583 | 3 | 2.436 | 28564.4 |
| 223 | 2020-02-20 13:24:40 | subarid | 1 | 69583 | 3 | 2.673 | 26031.8 |
| 222 | 2020-02-09 22:40:09 | subarid | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 221 | 2020-02-06 07:54:39 | subarid | 1 | 69583 | 3 | 3.280 | 21214.3 |
| 220 | 2020-02-03 10:15:54 | subarid | 1 | 69583 | 3 | 2.596 | 26803.9 |
| 219 | 2020-02-01 08:36:25 | subarid | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 218 | 2020-01-27 13:42:59 | subarid | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 217 | 2020-01-27 11:54:31 | subarid | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 216 | 2020-01-25 06:01:06 | subarid | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 215 | 2020-01-17 00:15:24 | subarid | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 214 | 2020-01-12 21:36:14 | subarid | 1 | 69583 | 3 | 1.356 | 51314.9 |
| 213 | 2020-01-12 17:14:13 | subarid | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 212 | 2020-01-08 17:51:22 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 211 | 2020-01-06 16:31:38 | subarid | 1 | 69583 | 3 | 1.890 | 36816.4 |
| 210 | 2020-01-01 23:27:38 | subarid | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 209 | 2019-12-27 05:11:47 | subarid | 1 | 69583 | 3 | 1.670 | 41666.5 |
| 208 | 2019-12-27 00:08:39 | subarid | 1 | 69583 | 3 | 1.560 | 44604.5 |
| 207 | 2019-12-06 20:04:41 | subarid | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 206 | 2019-11-15 09:55:36 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 205 | 2019-11-14 09:52:07 | subarid | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 204 | 2019-11-14 09:49:41 | subarid | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 203 | 2019-11-13 07:31:58 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 202 | 2019-11-11 05:40:14 | subarid | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 201 | 2019-11-10 08:46:25 | subarid | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 200 | 2019-11-05 03:59:34 | subarid | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 199 | 2019-11-03 10:44:31 | subarid | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 198 | 2019-09-20 05:06:55 | subarid | 1 | 69583 | 3 | 1.000 | 69583.0 |
| 197 | 2019-09-09 01:56:53 | subarid | 1 | 69583 | 3 | 1.136 | 61252.6 |
| 196 | 2019-09-08 02:44:38 | subarid | 1 | 69583 | 3 | 1.003 | 69374.9 |
| 195 | 2019-09-07 01:49:14 | subarid | 1 | 69583 | 3 | 1.013 | 68690.0 |
| 194 | 2019-09-04 18:25:59 | subarid | 1 | 69583 | 3 | 1.136 | 61252.6 |
| 193 | 2019-09-03 11:00:57 | subarid | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 192 | 2019-09-02 11:13:39 | subarid | 1 | 69583 | 3 | 1.026 | 67819.7 |
| 191 | 2019-08-30 01:04:07 | subarid | 1 | 69583 | 3 | 1.053 | 66080.7 |
| 190 | 2019-08-28 01:07:37 | subarid | 1 | 69583 | 3 | 1.053 | 66080.7 |
| 189 | 2019-08-25 09:31:40 | subarid | 1 | 69583 | 3 | 1.086 | 64072.7 |
| 188 | 2019-08-23 08:02:24 | subarid | 1 | 69583 | 3 | 1.036 | 67165.1 |
| 187 | 2019-08-20 19:21:14 | subarid | 1 | 69583 | 3 | 1.176 | 59169.2 |
| 186 | 2019-08-18 19:50:07 | subarid | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 185 | 2019-08-17 04:28:17 | subarid | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 184 | 2019-08-13 15:34:49 | subarid | 1 | 69583 | 3 | 1.056 | 65893.0 |
| 183 | 2019-08-12 01:11:52 | subarid | 1 | 69583 | 3 | 1.056 | 65893.0 |
| 182 | 2019-08-09 09:11:37 | subarid | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 181 | 2019-08-07 06:29:45 | subarid | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 180 | 2019-08-02 22:42:14 | subarid | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 179 | 2019-07-30 19:30:32 | subarid | 1 | 69583 | 3 | 1.116 | 62350.4 |
| 178 | 2019-07-28 19:12:16 | subarid | 1 | 69583 | 3 | 1.576 | 44151.6 |
| 177 | 2019-07-27 15:04:23 | subarid | 1 | 69583 | 3 | 1.053 | 66080.7 |
| 176 | 2019-07-25 16:31:02 | subarid | 1 | 69583 | 3 | 1.180 | 58968.6 |