History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coalfish"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 251 | 2024-04-26 17:15:37 | coalfish | 3 | 146162 | 105 | 11.956 | 12225.0 |
| 250 | 2024-04-26 17:15:36 | coalfish | 2 | 121059 | 18 | 4.250 | 28484.5 |
| 249 | 2024-04-26 17:15:12 | coalfish | 3 | 146162 | 105 | 7.890 | 18525.0 |
| 248 | 2024-04-18 23:53:44 | coalfish | 3 | 146162 | 105 | 14.516 | 10069.0 |
| 247 | 2024-04-13 01:37:01 | coalfish | 3 | 146162 | 105 | 8.500 | 17195.5 |
| 246 | 2024-04-11 11:11:37 | coalfish | 3 | 146162 | 105 | 7.483 | 19532.5 |
| 245 | 2024-04-11 11:11:38 | coalfish | 2 | 121059 | 18 | 3.906 | 30993.1 |
| 244 | 2024-04-11 11:11:32 | coalfish | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 243 | 2024-04-08 09:02:37 | coalfish | 1 | 82945 | 1 | 4.876 | 17010.9 |
| 242 | 2024-04-03 07:41:13 | coalfish | 2 | 121059 | 18 | 3.686 | 32842.9 |
| 241 | 2024-03-31 22:29:45 | coalfish | 2 | 121059 | 18 | 6.253 | 19360.1 |
| 240 | 2024-03-31 22:29:23 | coalfish | 1 | 82945 | 1 | 2.016 | 41143.4 |
| 239 | 2024-03-31 07:01:40 | coalfish | 3 | 146162 | 105 | 19.343 | 7556.3 |
| 238 | 2024-03-31 07:01:46 | coalfish | 1 | 82945 | 1 | 1.720 | 48223.8 |
| 237 | 2024-03-31 07:01:38 | coalfish | 2 | 121059 | 18 | 6.843 | 17690.9 |
| 236 | 2024-03-28 11:47:38 | coalfish | 1 | 82945 | 1 | 1.486 | 55817.6 |
| 235 | 2024-03-21 19:59:02 | coalfish | 3 | 146162 | 105 | 26.673 | 5479.8 |
| 234 | 2024-03-19 17:24:02 | coalfish | 3 | 146162 | 105 | 23.890 | 6118.1 |
| 233 | 2024-03-15 23:28:38 | coalfish | 1 | 82945 | 1 | 1.720 | 48223.8 |
| 232 | 2024-03-13 16:57:24 | coalfish | 3 | 146162 | 105 | 9.593 | 15236.3 |
| 231 | 2024-03-12 06:55:00 | coalfish | 3 | 146162 | 105 | 8.656 | 16885.6 |
| 230 | 2024-03-12 06:06:25 | coalfish | 3 | 146162 | 105 | 9.300 | 15716.3 |
| 229 | 2024-03-12 06:06:26 | coalfish | 2 | 121059 | 18 | 4.186 | 28920.0 |
| 228 | 2024-03-12 06:06:21 | coalfish | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 227 | 2024-03-12 06:06:14 | coalfish | 2 | 121059 | 18 | 4.033 | 30017.1 |
| 226 | 2024-03-12 06:05:59 | coalfish | 1 | 82945 | 1 | 1.580 | 52496.8 |
| 225 | 2024-03-09 13:12:42 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 224 | 2024-03-07 11:37:41 | coalfish | 1 | 82945 | 1 | 2.546 | 32578.6 |
| 223 | 2024-03-05 00:23:14 | coalfish | 1 | 82945 | 1 | 3.610 | 22976.5 |
| 222 | 2024-02-28 04:43:44 | coalfish | 1 | 82945 | 1 | 1.656 | 50087.6 |
| 221 | 2024-02-15 00:13:42 | coalfish | 1 | 82945 | 1 | 1.673 | 49578.6 |
| 220 | 2024-01-22 10:18:37 | coalfish | 3 | 146162 | 105 | 7.440 | 19645.4 |
| 219 | 2023-12-04 17:01:56 | coalfish | 2 | 121059 | 18 | 3.296 | 36729.1 |
| 218 | 2023-12-03 07:48:29 | coalfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 217 | 2023-12-02 04:39:16 | coalfish | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 216 | 2023-11-26 17:36:04 | coalfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 215 | 2023-11-23 03:25:50 | coalfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 214 | 2023-11-18 12:28:28 | coalfish | 3 | 146162 | 105 | 7.123 | 20519.7 |
| 213 | 2023-11-18 12:28:26 | coalfish | 2 | 121059 | 18 | 3.423 | 35366.3 |
| 212 | 2023-11-08 17:34:39 | coalfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 211 | 2023-11-06 03:34:02 | coalfish | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 210 | 2023-11-04 12:37:14 | coalfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 209 | 2023-10-13 13:44:40 | coalfish | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 208 | 2023-10-07 15:59:00 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 207 | 2023-09-17 04:53:45 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 206 | 2023-09-01 09:47:01 | coalfish | 2 | 121059 | 18 | 3.250 | 37248.9 |
| 205 | 2023-07-30 06:43:35 | coalfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 204 | 2023-07-07 19:32:35 | coalfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 203 | 2023-05-15 11:20:03 | coalfish | 2 | 121059 | 18 | 3.203 | 37795.5 |
| 202 | 2023-04-17 09:33:54 | coalfish | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 201 | 2023-04-07 07:30:46 | coalfish | 1 | 82945 | 1 | 3.000 | 27648.3 |
| 200 | 2023-02-21 12:44:40 | coalfish | 2 | 121059 | 18 | 3.406 | 35542.9 |
| 199 | 2023-02-09 05:34:18 | coalfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 198 | 2022-12-15 05:19:16 | coalfish | 1 | 82945 | 1 | 1.410 | 58826.2 |
| 197 | 2022-12-08 03:31:51 | coalfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 196 | 2022-12-03 10:19:48 | coalfish | 2 | 121059 | 18 | 3.686 | 32842.9 |
| 195 | 2022-11-25 15:52:54 | coalfish | 3 | 146162 | 105 | 6.390 | 22873.6 |
| 194 | 2022-10-30 13:20:30 | coalfish | 3 | 146162 | 105 | 7.906 | 18487.5 |
| 193 | 2022-08-11 19:55:51 | coalfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 192 | 2022-08-06 07:40:21 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 191 | 2022-08-03 23:43:36 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 190 | 2022-07-18 23:17:30 | coalfish | 3 | 146162 | 105 | 6.563 | 22270.6 |
| 189 | 2022-07-11 04:03:31 | coalfish | 2 | 121059 | 18 | 3.390 | 35710.6 |
| 188 | 2022-04-14 07:54:31 | coalfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 187 | 2022-03-29 02:36:05 | coalfish | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 186 | 2021-12-30 18:14:10 | coalfish | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 185 | 2021-12-28 15:51:18 | coalfish | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 184 | 2021-12-26 13:30:32 | coalfish | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 183 | 2021-11-12 15:31:14 | coalfish | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 182 | 2021-09-26 18:29:36 | coalfish | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 181 | 2021-09-22 14:51:58 | coalfish | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 180 | 2021-09-12 22:46:03 | coalfish | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 179 | 2021-07-14 08:42:00 | coalfish | 1 | 82945 | 1 | 1.563 | 53067.8 |
| 178 | 2021-06-12 19:17:06 | coalfish | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 177 | 2021-05-21 18:43:20 | coalfish | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 176 | 2021-04-22 10:36:23 | coalfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 175 | 2021-04-05 18:23:06 | coalfish | 1 | 82945 | 1 | 1.486 | 55817.6 |
| 174 | 2021-03-13 09:23:20 | coalfish | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 173 | 2021-02-27 01:16:40 | coalfish | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 172 | 2021-02-20 16:10:38 | coalfish | 1 | 82945 | 1 | 1.466 | 56579.1 |
| 171 | 2020-12-02 03:53:33 | coalfish | 1 | 82945 | 1 | 1.356 | 61168.9 |
| 170 | 2020-11-08 00:13:37 | coalfish | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 169 | 2020-08-24 20:34:32 | coalfish | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 168 | 2020-05-20 09:04:35 | coalfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 167 | 2020-03-23 14:43:02 | coalfish | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 166 | 2020-02-28 23:30:03 | coalfish | 1 | 82945 | 1 | 2.486 | 33364.8 |
| 165 | 2020-02-24 01:33:19 | coalfish | 1 | 82945 | 1 | 1.560 | 53169.9 |
| 164 | 2020-02-23 06:11:26 | coalfish | 1 | 82945 | 1 | 3.093 | 26817.0 |
| 163 | 2020-02-14 11:21:53 | coalfish | 1 | 82945 | 1 | 1.593 | 52068.4 |
| 162 | 2020-02-06 00:51:28 | coalfish | 1 | 82945 | 1 | 2.860 | 29001.7 |
| 161 | 2020-02-03 17:45:00 | coalfish | 1 | 82945 | 1 | 1.596 | 51970.6 |
| 160 | 2020-01-29 01:54:35 | coalfish | 1 | 82945 | 1 | 1.330 | 62364.7 |
| 159 | 2020-01-28 05:57:43 | coalfish | 1 | 82945 | 1 | 5.126 | 16181.2 |
| 158 | 2020-01-24 17:55:05 | coalfish | 1 | 82945 | 1 | 1.810 | 45826.0 |
| 157 | 2020-01-18 07:40:27 | coalfish | 1 | 82945 | 1 | 1.610 | 51518.6 |
| 156 | 2020-01-13 13:47:20 | coalfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 155 | 2020-01-02 00:08:17 | coalfish | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 154 | 2019-12-31 02:21:55 | coalfish | 1 | 82945 | 1 | 1.576 | 52630.1 |
| 153 | 2019-11-14 12:13:50 | coalfish | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 152 | 2019-08-13 03:53:08 | coalfish | 1 | 82945 | 1 | 1.413 | 58701.3 |