History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spottily"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 230 | 2024-05-01 18:41:42 | spottily | 3 | 146162 | 109 | 11.186 | 13066.5 |
| 229 | 2024-04-30 12:05:28 | spottily | 2 | 121059 | 15 | 7.706 | 15709.7 |
| 228 | 2024-04-30 12:05:03 | spottily | 3 | 146162 | 109 | 14.906 | 9805.6 |
| 227 | 2024-04-30 12:04:37 | spottily | 3 | 146162 | 109 | 15.640 | 9345.4 |
| 226 | 2024-04-30 12:04:43 | spottily | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 225 | 2024-04-30 12:04:33 | spottily | 2 | 121059 | 15 | 5.986 | 20223.7 |
| 224 | 2024-04-08 04:50:48 | spottily | 1 | 82945 | 3 | 1.873 | 44284.6 |
| 223 | 2024-04-06 12:22:12 | spottily | 1 | 82945 | 3 | 4.876 | 17010.9 |
| 222 | 2024-04-06 07:53:42 | spottily | 3 | 146162 | 109 | 21.093 | 6929.4 |
| 221 | 2024-04-05 06:29:25 | spottily | 3 | 146162 | 109 | 22.376 | 6532.1 |
| 220 | 2024-04-05 06:29:23 | spottily | 2 | 121059 | 15 | 7.283 | 16622.1 |
| 219 | 2024-04-05 06:28:38 | spottily | 1 | 82945 | 3 | 3.656 | 22687.4 |
| 218 | 2024-04-02 08:56:45 | spottily | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 217 | 2024-04-01 09:20:18 | spottily | 3 | 146162 | 109 | 9.893 | 14774.3 |
| 216 | 2024-03-30 03:17:49 | spottily | 2 | 121059 | 15 | 7.860 | 15401.9 |
| 215 | 2024-03-30 03:17:54 | spottily | 1 | 82945 | 3 | 3.076 | 26965.2 |
| 214 | 2024-03-30 00:23:58 | spottily | 3 | 146162 | 109 | 13.763 | 10619.9 |
| 213 | 2024-03-29 09:08:03 | spottily | 1 | 82945 | 3 | 1.843 | 45005.4 |
| 212 | 2024-03-29 09:07:42 | spottily | 3 | 146162 | 109 | 9.830 | 14869.0 |
| 211 | 2024-03-29 09:07:41 | spottily | 2 | 121059 | 15 | 8.233 | 14704.1 |
| 210 | 2024-03-29 09:07:36 | spottily | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 209 | 2024-03-20 08:58:11 | spottily | 3 | 146162 | 109 | 6.423 | 22756.0 |
| 208 | 2024-03-07 03:40:38 | spottily | 1 | 82945 | 3 | 1.656 | 50087.6 |
| 207 | 2024-03-04 22:05:30 | spottily | 3 | 146162 | 109 | 18.423 | 7933.7 |
| 206 | 2024-03-04 22:05:31 | spottily | 2 | 121059 | 15 | 8.970 | 13496.0 |
| 205 | 2024-03-04 21:16:29 | spottily | 1 | 82945 | 3 | 3.280 | 25288.1 |
| 204 | 2024-03-03 13:34:36 | spottily | 2 | 121059 | 15 | 4.033 | 30017.1 |
| 203 | 2024-03-01 06:11:45 | spottily | 2 | 121059 | 15 | 4.670 | 25922.7 |
| 202 | 2024-03-01 06:11:24 | spottily | 3 | 146162 | 109 | 8.030 | 18202.0 |
| 201 | 2024-02-29 05:54:33 | spottily | 2 | 121059 | 15 | 3.813 | 31749.0 |
| 200 | 2024-02-29 05:54:20 | spottily | 3 | 146162 | 109 | 7.110 | 20557.2 |
| 199 | 2024-02-28 22:11:08 | spottily | 3 | 146162 | 109 | 7.860 | 18595.7 |
| 198 | 2024-02-28 01:25:19 | spottily | 2 | 121059 | 15 | 6.970 | 17368.6 |
| 197 | 2024-02-28 01:24:42 | spottily | 3 | 146162 | 109 | 13.533 | 10800.4 |
| 196 | 2024-02-28 01:24:33 | spottily | 1 | 82945 | 3 | 4.233 | 19594.8 |
| 195 | 2024-02-01 03:18:36 | spottily | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 194 | 2024-01-29 17:30:21 | spottily | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 193 | 2024-01-29 13:52:03 | spottily | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 192 | 2024-01-17 00:43:37 | spottily | 2 | 121059 | 15 | 3.203 | 37795.5 |
| 191 | 2023-12-27 16:04:31 | spottily | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 190 | 2023-12-21 09:40:37 | spottily | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 189 | 2023-12-19 12:05:26 | spottily | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 188 | 2023-12-19 03:24:18 | spottily | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 187 | 2023-12-09 00:53:22 | spottily | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 186 | 2023-11-30 02:15:32 | spottily | 3 | 146162 | 109 | 6.326 | 23105.0 |
| 185 | 2023-10-27 17:42:58 | spottily | 2 | 121059 | 15 | 3.406 | 35542.9 |
| 184 | 2023-10-08 22:07:28 | spottily | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 183 | 2023-08-28 08:20:49 | spottily | 3 | 146162 | 109 | 6.170 | 23689.1 |
| 182 | 2023-08-04 14:06:22 | spottily | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 181 | 2023-08-04 07:43:43 | spottily | 2 | 121059 | 15 | 3.250 | 37248.9 |
| 180 | 2023-08-02 02:08:30 | spottily | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 179 | 2023-05-12 22:27:36 | spottily | 3 | 146162 | 109 | 6.576 | 22226.6 |
| 178 | 2023-05-01 17:15:34 | spottily | 1 | 82945 | 3 | 1.300 | 63803.8 |
| 177 | 2023-04-18 05:20:23 | spottily | 2 | 121059 | 15 | 3.203 | 37795.5 |
| 176 | 2023-04-02 14:33:31 | spottily | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 175 | 2023-02-22 10:05:21 | spottily | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 174 | 2023-02-19 18:23:11 | spottily | 3 | 146162 | 109 | 6.486 | 22535.0 |
| 173 | 2023-01-24 17:53:55 | spottily | 2 | 121059 | 15 | 3.623 | 33414.0 |
| 172 | 2023-01-20 07:02:34 | spottily | 3 | 146162 | 109 | 6.280 | 23274.2 |
| 171 | 2022-12-18 11:34:49 | spottily | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 170 | 2022-12-09 13:54:17 | spottily | 3 | 146162 | 109 | 6.220 | 23498.7 |
| 169 | 2022-12-06 07:11:28 | spottily | 3 | 146162 | 109 | 7.936 | 18417.6 |
| 168 | 2022-12-01 08:06:13 | spottily | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 167 | 2022-11-30 23:55:11 | spottily | 3 | 146162 | 109 | 6.110 | 23921.8 |
| 166 | 2022-11-28 01:08:22 | spottily | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 165 | 2022-11-09 16:20:08 | spottily | 3 | 146162 | 109 | 7.406 | 19735.6 |
| 164 | 2022-11-06 14:57:25 | spottily | 2 | 121059 | 15 | 3.533 | 34265.2 |
| 163 | 2022-11-01 09:07:48 | spottily | 3 | 146162 | 109 | 6.673 | 21903.5 |
| 162 | 2022-09-27 05:51:47 | spottily | 3 | 146162 | 109 | 7.483 | 19532.5 |
| 161 | 2022-09-05 05:48:46 | spottily | 3 | 146162 | 109 | 6.250 | 23385.9 |
| 160 | 2022-08-30 04:55:30 | spottily | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 159 | 2022-08-27 16:47:30 | spottily | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 158 | 2022-07-21 07:34:11 | spottily | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 157 | 2022-07-19 13:38:47 | spottily | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 156 | 2022-07-17 14:41:10 | spottily | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 155 | 2022-07-07 09:41:36 | spottily | 3 | 146162 | 109 | 6.250 | 23385.9 |
| 154 | 2022-05-07 13:13:34 | spottily | 2 | 121059 | 15 | 3.283 | 36874.5 |
| 153 | 2022-04-27 18:26:04 | spottily | 1 | 82945 | 3 | 1.983 | 41828.0 |
| 152 | 2022-03-03 05:19:19 | spottily | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 151 | 2021-11-02 20:11:49 | spottily | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 150 | 2021-07-16 16:39:05 | spottily | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 149 | 2021-07-01 13:54:13 | spottily | 3 | 146162 | 109 | 6.423 | 22756.0 |
| 148 | 2021-05-16 15:29:34 | spottily | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 147 | 2021-05-13 22:46:53 | spottily | 2 | 121059 | 15 | 3.530 | 34294.3 |
| 146 | 2021-04-17 14:02:16 | spottily | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 145 | 2021-04-16 09:35:46 | spottily | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 144 | 2021-04-01 06:56:49 | spottily | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 143 | 2021-03-16 06:51:19 | spottily | 3 | 146162 | 109 | 6.373 | 22934.6 |
| 142 | 2021-02-13 12:18:15 | spottily | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 141 | 2021-01-29 06:11:31 | spottily | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 140 | 2021-01-26 17:24:00 | spottily | 2 | 121059 | 15 | 3.593 | 33693.0 |
| 139 | 2021-01-04 01:44:28 | spottily | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 138 | 2020-12-01 01:59:52 | spottily | 3 | 146162 | 109 | 8.030 | 18202.0 |
| 137 | 2020-11-04 21:05:55 | spottily | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 136 | 2020-11-02 16:21:56 | spottily | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 135 | 2020-10-24 11:01:32 | spottily | 2 | 121059 | 15 | 3.716 | 32577.8 |
| 134 | 2020-10-14 09:34:09 | spottily | 3 | 146162 | 109 | 6.626 | 22058.9 |
| 133 | 2020-10-12 19:52:52 | spottily | 3 | 146162 | 109 | 6.563 | 22270.6 |
| 132 | 2020-10-12 00:25:09 | spottily | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 131 | 2020-10-03 17:56:32 | spottily | 1 | 82945 | 3 | 1.313 | 63172.1 |