History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shammying"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 244 | 2024-05-06 11:56:01 | shammying | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 243 | 2024-04-29 09:57:25 | shammying | 1 | 81242 | 5 | 2.013 | 40358.7 |
| 242 | 2024-04-28 12:29:23 | shammying | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 241 | 2024-04-27 13:27:47 | shammying | 4 | 165329 | 663 | 46.943 | 3521.9 |
| 240 | 2024-04-26 01:13:22 | shammying | 4 | 165329 | 663 | 37.393 | 4421.4 |
| 239 | 2024-04-26 01:13:34 | shammying | 2 | 121436 | 13 | 16.846 | 7208.6 |
| 238 | 2024-04-26 01:13:33 | shammying | 3 | 148641 | 92 | 11.783 | 12614.9 |
| 237 | 2024-04-25 17:31:12 | shammying | 1 | 81242 | 5 | 3.060 | 26549.7 |
| 236 | 2024-04-05 20:09:58 | shammying | 1 | 81242 | 5 | 1.470 | 55266.7 |
| 235 | 2024-03-30 03:11:53 | shammying | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 234 | 2024-03-28 12:27:09 | shammying | 1 | 81242 | 5 | 1.606 | 50586.6 |
| 233 | 2024-03-13 16:54:48 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 232 | 2024-03-07 03:28:16 | shammying | 1 | 81242 | 5 | 4.733 | 17165.0 |
| 231 | 2024-03-06 09:54:09 | shammying | 1 | 81242 | 5 | 1.983 | 40969.2 |
| 230 | 2024-03-05 16:08:15 | shammying | 1 | 81242 | 5 | 1.340 | 60628.4 |
| 229 | 2024-02-28 12:07:17 | shammying | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 228 | 2024-02-27 05:46:42 | shammying | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 227 | 2024-02-12 16:35:53 | shammying | 4 | 165329 | 663 | 26.766 | 6176.8 |
| 226 | 2024-02-12 16:35:58 | shammying | 3 | 148641 | 92 | 8.766 | 16956.5 |
| 225 | 2024-02-12 16:35:56 | shammying | 2 | 121436 | 13 | 4.420 | 27474.2 |
| 224 | 2024-02-12 11:20:23 | shammying | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 223 | 2024-02-07 06:54:34 | shammying | 4 | 165329 | 663 | 33.156 | 4986.4 |
| 222 | 2024-02-07 00:04:07 | shammying | 4 | 165329 | 663 | 12.126 | 13634.3 |
| 221 | 2024-02-07 00:04:11 | shammying | 2 | 121436 | 13 | 3.826 | 31739.7 |
| 220 | 2024-02-07 00:01:15 | shammying | 3 | 148641 | 92 | 7.013 | 21195.1 |
| 219 | 2024-02-06 00:59:29 | shammying | 3 | 148641 | 92 | 24.656 | 6028.6 |
| 218 | 2024-02-05 15:54:55 | shammying | 3 | 148641 | 92 | 12.813 | 11600.8 |
| 217 | 2024-01-29 11:19:22 | shammying | 1 | 81242 | 5 | 2.953 | 27511.7 |
| 216 | 2024-01-21 06:42:11 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 215 | 2024-01-05 22:49:31 | shammying | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 214 | 2024-01-01 08:55:17 | shammying | 3 | 148641 | 92 | 7.483 | 19863.8 |
| 213 | 2023-12-18 12:13:09 | shammying | 3 | 148641 | 92 | 7.110 | 20905.9 |
| 212 | 2023-11-30 07:28:43 | shammying | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 211 | 2023-11-22 05:19:48 | shammying | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 210 | 2023-11-16 15:50:35 | shammying | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 209 | 2023-11-12 04:13:04 | shammying | 3 | 148641 | 92 | 8.500 | 17487.2 |
| 208 | 2023-11-04 22:20:26 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 207 | 2023-11-04 02:42:41 | shammying | 1 | 81242 | 5 | 2.330 | 34867.8 |
| 206 | 2023-10-07 03:56:16 | shammying | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 205 | 2023-09-03 13:20:09 | shammying | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 204 | 2023-08-14 21:02:26 | shammying | 3 | 148641 | 92 | 6.876 | 21617.4 |
| 203 | 2023-07-30 00:22:38 | shammying | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 202 | 2023-04-26 08:20:45 | shammying | 3 | 148641 | 92 | 5.966 | 24914.7 |
| 201 | 2023-03-23 06:27:05 | shammying | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 200 | 2023-02-01 11:15:31 | shammying | 3 | 148641 | 92 | 8.033 | 18503.8 |
| 199 | 2023-01-20 17:14:53 | shammying | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 198 | 2023-01-08 03:36:59 | shammying | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 197 | 2022-11-11 01:41:48 | shammying | 3 | 148641 | 92 | 6.063 | 24516.1 |
| 196 | 2022-10-01 14:09:07 | shammying | 1 | 81242 | 5 | 1.216 | 66810.9 |
| 195 | 2022-06-18 07:53:06 | shammying | 4 | 165329 | 663 | 10.173 | 16251.7 |
| 194 | 2022-05-26 16:39:15 | shammying | 3 | 148641 | 92 | 6.063 | 24516.1 |
| 193 | 2022-05-16 20:38:07 | shammying | 1 | 81242 | 5 | 1.953 | 41598.6 |
| 192 | 2022-05-15 05:13:40 | shammying | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 191 | 2022-02-09 09:47:13 | shammying | 4 | 165329 | 663 | 10.343 | 15984.6 |
| 190 | 2022-02-06 07:59:19 | shammying | 4 | 165329 | 663 | 11.186 | 14780.0 |
| 189 | 2022-02-01 00:43:43 | shammying | 1 | 81242 | 5 | 1.440 | 56418.1 |
| 188 | 2021-11-27 03:45:27 | shammying | 1 | 81242 | 5 | 1.356 | 59913.0 |
| 187 | 2021-10-23 04:04:08 | shammying | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 186 | 2021-05-26 09:44:49 | shammying | 1 | 81242 | 5 | 1.546 | 52549.8 |
| 185 | 2021-05-17 13:44:50 | shammying | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 184 | 2021-05-06 11:52:54 | shammying | 3 | 148641 | 92 | 7.690 | 19329.1 |
| 183 | 2021-04-17 14:16:36 | shammying | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 182 | 2021-01-19 23:55:08 | shammying | 3 | 148641 | 92 | 6.173 | 24079.2 |
| 181 | 2021-01-02 01:48:59 | shammying | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 180 | 2020-11-07 23:27:40 | shammying | 1 | 81242 | 5 | 2.266 | 35852.6 |
| 179 | 2020-10-30 23:30:56 | shammying | 3 | 148641 | 92 | 7.250 | 20502.2 |
| 178 | 2020-10-21 12:00:14 | shammying | 1 | 81242 | 5 | 1.220 | 66591.8 |
| 177 | 2020-10-15 10:58:29 | shammying | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 176 | 2020-06-01 12:50:27 | shammying | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 175 | 2020-05-14 01:14:09 | shammying | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 174 | 2020-05-13 06:13:49 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 173 | 2020-05-12 06:57:22 | shammying | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 172 | 2020-05-11 07:37:53 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 171 | 2020-05-10 06:55:43 | shammying | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 170 | 2020-05-09 06:52:43 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 169 | 2020-05-08 06:54:54 | shammying | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 168 | 2020-05-07 06:15:02 | shammying | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 167 | 2020-05-06 06:56:36 | shammying | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 166 | 2020-05-05 06:15:57 | shammying | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 165 | 2020-05-04 06:18:45 | shammying | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 164 | 2020-05-03 06:21:38 | shammying | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 163 | 2020-05-02 06:52:50 | shammying | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 162 | 2020-05-01 06:14:16 | shammying | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 161 | 2020-04-30 06:23:14 | shammying | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 160 | 2020-04-22 06:07:06 | shammying | 1 | 81242 | 5 | 1.310 | 62016.8 |
| 159 | 2020-04-18 11:15:06 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 158 | 2020-04-17 12:02:27 | shammying | 1 | 81242 | 5 | 1.343 | 60492.9 |
| 157 | 2020-04-16 12:01:30 | shammying | 1 | 81242 | 5 | 1.356 | 59913.0 |
| 156 | 2020-04-15 11:18:18 | shammying | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 155 | 2020-03-23 14:29:18 | shammying | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 154 | 2020-03-13 12:55:07 | shammying | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 153 | 2020-03-12 13:16:39 | shammying | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 152 | 2020-03-11 20:18:17 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 151 | 2020-03-11 12:36:36 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 150 | 2020-03-09 06:13:44 | shammying | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 149 | 2020-02-28 16:52:43 | shammying | 1 | 81242 | 5 | 1.610 | 50460.9 |
| 148 | 2020-02-28 05:36:40 | shammying | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 147 | 2020-02-28 03:51:31 | shammying | 1 | 81242 | 5 | 3.076 | 26411.6 |
| 146 | 2020-02-26 07:57:36 | shammying | 1 | 81242 | 5 | 1.686 | 48186.2 |
| 145 | 2020-02-26 02:08:43 | shammying | 1 | 81242 | 5 | 1.576 | 51549.5 |