History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 270 | 2024-04-26 22:34:56 | affiliates | 3 | 140603 | 28 | 16.766 | 8386.2 |
| 269 | 2024-04-26 10:10:28 | affiliates | 1 | 67641 | 3 | 2.906 | 23276.3 |
| 268 | 2024-04-08 18:16:20 | affiliates | 4 | 161450 | 169 | 40.986 | 3939.1 |
| 267 | 2024-04-08 18:16:20 | affiliates | 3 | 140603 | 28 | 25.330 | 5550.8 |
| 266 | 2024-04-08 18:15:14 | affiliates | 2 | 108824 | 5 | 12.830 | 8482.0 |
| 265 | 2024-04-08 18:12:34 | affiliates | 1 | 67641 | 3 | 2.580 | 26217.4 |
| 264 | 2024-04-01 09:49:08 | affiliates | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 263 | 2024-03-29 21:14:14 | affiliates | 4 | 161450 | 169 | 14.236 | 11341.0 |
| 262 | 2024-03-27 20:30:37 | affiliates | 4 | 161450 | 169 | 35.676 | 4525.5 |
| 261 | 2024-03-27 18:22:31 | affiliates | 3 | 140603 | 28 | 9.373 | 15000.9 |
| 260 | 2024-03-27 18:22:24 | affiliates | 4 | 161450 | 169 | 13.033 | 12387.8 |
| 259 | 2024-03-27 18:22:22 | affiliates | 2 | 108824 | 5 | 3.453 | 31515.8 |
| 258 | 2024-03-27 16:36:37 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 257 | 2024-03-12 08:15:53 | affiliates | 1 | 67641 | 3 | 3.733 | 18119.7 |
| 256 | 2024-03-10 12:35:14 | affiliates | 1 | 67641 | 3 | 3.876 | 17451.2 |
| 255 | 2024-03-08 21:48:41 | affiliates | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 254 | 2024-03-05 12:01:47 | affiliates | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 253 | 2024-03-02 05:21:48 | affiliates | 1 | 67641 | 3 | 3.783 | 17880.3 |
| 252 | 2024-02-18 03:28:06 | affiliates | 3 | 140603 | 28 | 9.750 | 14420.8 |
| 251 | 2024-02-16 04:13:39 | affiliates | 4 | 161450 | 169 | 46.156 | 3497.9 |
| 250 | 2024-02-16 04:13:41 | affiliates | 3 | 140603 | 28 | 18.330 | 7670.6 |
| 249 | 2024-02-14 07:53:55 | affiliates | 4 | 161450 | 169 | 10.686 | 15108.6 |
| 248 | 2024-02-13 08:45:42 | affiliates | 4 | 161450 | 169 | 12.673 | 12739.7 |
| 247 | 2024-02-13 08:45:44 | affiliates | 3 | 140603 | 28 | 10.673 | 13173.7 |
| 246 | 2024-02-13 08:45:45 | affiliates | 2 | 108824 | 5 | 3.440 | 31634.9 |
| 245 | 2024-02-13 05:08:22 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 244 | 2024-02-06 18:46:09 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 243 | 2024-01-31 14:05:07 | affiliates | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 242 | 2024-01-06 07:06:28 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 241 | 2023-12-08 04:29:20 | affiliates | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 240 | 2023-11-28 06:34:35 | affiliates | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 239 | 2023-11-25 02:44:10 | affiliates | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 238 | 2023-10-28 05:10:26 | affiliates | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 237 | 2023-09-27 13:49:59 | affiliates | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 236 | 2023-09-14 12:40:49 | affiliates | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 235 | 2023-08-21 13:37:13 | affiliates | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 234 | 2023-06-20 12:50:15 | affiliates | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 233 | 2023-04-30 06:21:27 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 232 | 2023-04-01 17:57:17 | affiliates | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 231 | 2023-01-16 06:11:20 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 230 | 2022-12-30 07:22:23 | affiliates | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 229 | 2022-08-29 17:35:08 | affiliates | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 228 | 2022-06-06 13:38:10 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 227 | 2022-04-22 02:32:26 | affiliates | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 226 | 2022-02-14 05:54:31 | affiliates | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 225 | 2022-01-05 21:30:54 | affiliates | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 224 | 2022-01-02 16:18:14 | affiliates | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 223 | 2021-12-07 19:29:18 | affiliates | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 222 | 2021-10-25 09:35:08 | affiliates | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 221 | 2021-10-23 09:31:52 | affiliates | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 220 | 2021-09-23 10:04:16 | affiliates | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 219 | 2021-09-13 11:45:04 | affiliates | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 218 | 2021-08-24 17:43:55 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 217 | 2021-06-20 07:49:32 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 216 | 2021-06-17 01:48:53 | affiliates | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 215 | 2021-03-14 06:52:33 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 214 | 2021-02-25 20:28:44 | affiliates | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 213 | 2020-12-03 07:25:10 | affiliates | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 212 | 2020-10-24 19:00:55 | affiliates | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 211 | 2020-08-19 07:50:40 | affiliates | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 210 | 2020-08-16 22:31:49 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 209 | 2020-08-14 00:42:26 | affiliates | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 208 | 2020-05-14 21:42:53 | affiliates | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 207 | 2020-05-14 14:40:49 | affiliates | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 206 | 2020-03-26 11:39:22 | affiliates | 1 | 67641 | 3 | 1.873 | 36113.7 |
| 205 | 2020-03-24 05:22:37 | affiliates | 1 | 67641 | 3 | 2.253 | 30022.6 |
| 204 | 2020-03-05 22:35:30 | affiliates | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 203 | 2020-02-15 04:48:42 | affiliates | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 202 | 2020-02-11 00:15:26 | affiliates | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 201 | 2020-02-08 20:32:36 | affiliates | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 200 | 2020-02-06 09:40:14 | affiliates | 1 | 67641 | 3 | 2.423 | 27916.2 |
| 199 | 2020-01-31 14:10:05 | affiliates | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 198 | 2020-01-29 05:29:23 | affiliates | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 197 | 2020-01-26 22:26:08 | affiliates | 1 | 67641 | 3 | 1.206 | 56087.1 |
| 196 | 2020-01-19 19:19:54 | affiliates | 1 | 67641 | 3 | 3.813 | 17739.6 |
| 195 | 2020-01-18 17:10:31 | affiliates | 1 | 67641 | 3 | 1.826 | 37043.3 |
| 194 | 2020-01-18 16:08:32 | affiliates | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 193 | 2020-01-03 21:45:18 | affiliates | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 192 | 2020-01-01 19:36:17 | affiliates | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 191 | 2019-11-23 10:17:01 | affiliates | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 190 | 2019-11-02 15:35:22 | affiliates | 1 | 67641 | 3 | 1.160 | 58311.2 |
| 189 | 2019-10-12 07:41:23 | affiliates | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 188 | 2019-08-04 14:49:51 | affiliates | 1 | 67641 | 3 | 1.103 | 61324.6 |
| 187 | 2019-06-04 08:01:10 | affiliates | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 186 | 2019-04-28 09:11:42 | affiliates | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 185 | 2019-02-18 13:52:39 | affiliates | 1 | 67641 | 3 | 1.136 | 59543.1 |
| 184 | 2019-01-26 09:15:46 | affiliates | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 183 | 2019-01-05 12:32:11 | affiliates | 1 | 67641 | 3 | 1.150 | 58818.3 |
| 182 | 2019-01-03 14:04:20 | affiliates | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 181 | 2018-12-05 06:53:43 | affiliates | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 180 | 2018-11-30 20:47:34 | affiliates | 1 | 67641 | 3 | 0.953 | 70976.9 |
| 179 | 2018-10-18 18:39:13 | affiliates | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 178 | 2018-09-14 06:01:52 | affiliates | 1 | 67641 | 3 | 0.960 | 70459.4 |
| 177 | 2018-09-14 06:01:42 | affiliates | 1 | 67641 | 3 | 0.976 | 69304.3 |
| 176 | 2018-09-08 11:59:08 | affiliates | 1 | 67641 | 3 | 1.103 | 61324.6 |
| 175 | 2018-08-06 07:23:00 | affiliates | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 174 | 2018-07-09 02:07:28 | affiliates | 1 | 67641 | 3 | 0.980 | 69021.4 |
| 173 | 2018-06-29 23:48:27 | affiliates | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 172 | 2018-06-23 17:32:14 | affiliates | 1 | 67641 | 3 | 1.196 | 56556.0 |
| 171 | 2018-06-08 04:05:02 | affiliates | 1 | 67641 | 3 | 2.280 | 29667.1 |