History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiffier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
270 | 2024-05-08 14:08:23 | spiffier | 1 | 82945 | 4 | 1.640 | 50576.2 |
269 | 2024-04-29 02:54:10 | spiffier | 1 | 82945 | 4 | 5.453 | 15210.9 |
268 | 2024-04-19 13:19:49 | spiffier | 2 | 121059 | 26 | 18.736 | 6461.3 |
267 | 2024-04-19 13:19:00 | spiffier | 2 | 121059 | 26 | 4.893 | 24741.3 |
266 | 2024-04-08 03:22:12 | spiffier | 2 | 121059 | 26 | 7.610 | 15907.9 |
265 | 2024-04-06 15:34:29 | spiffier | 2 | 121059 | 26 | 3.860 | 31362.4 |
264 | 2024-04-05 21:28:08 | spiffier | 3 | 146162 | 167 | 11.080 | 13191.5 |
263 | 2024-04-05 21:28:08 | spiffier | 2 | 121059 | 26 | 7.500 | 16141.2 |
262 | 2024-04-05 21:28:06 | spiffier | 1 | 82945 | 4 | 2.936 | 28251.0 |
261 | 2024-04-01 06:01:02 | spiffier | 3 | 146162 | 167 | 18.296 | 7988.7 |
260 | 2024-03-29 21:05:17 | spiffier | 1 | 82945 | 4 | 4.393 | 18881.2 |
259 | 2024-03-29 05:46:39 | spiffier | 1 | 82945 | 4 | 4.966 | 16702.6 |
258 | 2024-03-23 07:48:26 | spiffier | 2 | 121059 | 26 | 3.610 | 33534.3 |
257 | 2024-03-23 07:45:46 | spiffier | 3 | 146162 | 167 | 7.656 | 19091.2 |
256 | 2024-03-22 14:23:25 | spiffier | 3 | 146162 | 167 | 7.813 | 18707.5 |
255 | 2024-03-22 14:23:23 | spiffier | 2 | 121059 | 26 | 7.466 | 16214.7 |
254 | 2024-03-22 14:23:16 | spiffier | 1 | 82945 | 4 | 1.576 | 52630.1 |
253 | 2024-03-07 03:14:08 | spiffier | 1 | 82945 | 4 | 4.830 | 17172.9 |
252 | 2024-03-06 16:06:47 | spiffier | 1 | 82945 | 4 | 1.516 | 54713.1 |
251 | 2024-02-28 13:41:06 | spiffier | 1 | 82945 | 4 | 1.390 | 59672.7 |
250 | 2024-02-18 06:08:54 | spiffier | 3 | 146162 | 167 | 16.046 | 9108.9 |
249 | 2024-02-18 06:08:54 | spiffier | 2 | 121059 | 26 | 5.013 | 24149.0 |
248 | 2024-02-18 01:33:04 | spiffier | 1 | 82945 | 4 | 1.516 | 54713.1 |
247 | 2024-02-14 20:36:53 | spiffier | 2 | 121059 | 26 | 3.766 | 32145.2 |
246 | 2024-02-14 20:36:41 | spiffier | 3 | 146162 | 167 | 7.813 | 18707.5 |
245 | 2024-02-09 18:15:36 | spiffier | 2 | 121059 | 26 | 6.593 | 18361.7 |
244 | 2024-02-08 08:41:44 | spiffier | 3 | 146162 | 167 | 15.890 | 9198.4 |
243 | 2024-02-06 03:34:58 | spiffier | 2 | 121059 | 26 | 3.263 | 37100.5 |
242 | 2024-02-06 03:34:34 | spiffier | 3 | 146162 | 167 | 7.186 | 20339.8 |
241 | 2024-02-05 07:14:30 | spiffier | 2 | 121059 | 26 | 4.000 | 30264.8 |
240 | 2024-02-05 07:14:26 | spiffier | 3 | 146162 | 167 | 6.920 | 21121.7 |
239 | 2024-02-05 07:14:22 | spiffier | 1 | 82945 | 4 | 1.483 | 55930.5 |
238 | 2024-01-29 11:41:58 | spiffier | 1 | 82945 | 4 | 1.533 | 54106.3 |
237 | 2024-01-18 06:22:30 | spiffier | 1 | 82945 | 4 | 1.390 | 59672.7 |
236 | 2024-01-15 19:06:28 | spiffier | 1 | 82945 | 4 | 1.670 | 49667.7 |
235 | 2023-12-15 18:27:36 | spiffier | 2 | 121059 | 26 | 3.203 | 37795.5 |
234 | 2023-12-13 04:06:23 | spiffier | 1 | 82945 | 4 | 1.343 | 61761.0 |
233 | 2023-11-23 19:51:03 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
232 | 2023-11-12 15:50:07 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
231 | 2023-11-09 22:03:42 | spiffier | 1 | 82945 | 4 | 1.313 | 63172.1 |
230 | 2023-11-04 04:09:07 | spiffier | 1 | 82945 | 4 | 1.436 | 57761.1 |
229 | 2023-10-22 08:44:01 | spiffier | 1 | 82945 | 4 | 1.280 | 64800.8 |
228 | 2023-09-25 23:04:57 | spiffier | 1 | 82945 | 4 | 1.283 | 64649.3 |
227 | 2023-09-14 10:17:35 | spiffier | 2 | 121059 | 26 | 3.140 | 38553.8 |
226 | 2023-09-01 08:01:31 | spiffier | 1 | 82945 | 4 | 1.453 | 57085.3 |
225 | 2023-06-11 18:48:09 | spiffier | 2 | 121059 | 26 | 3.420 | 35397.4 |
224 | 2023-06-11 06:04:10 | spiffier | 1 | 82945 | 4 | 1.266 | 65517.4 |
223 | 2023-06-05 03:15:33 | spiffier | 1 | 82945 | 4 | 1.373 | 60411.5 |
222 | 2023-03-27 03:40:17 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
221 | 2023-03-14 01:26:51 | spiffier | 2 | 121059 | 26 | 3.233 | 37444.8 |
220 | 2023-02-16 10:07:15 | spiffier | 1 | 82945 | 4 | 1.263 | 65673.0 |
219 | 2023-01-10 20:47:03 | spiffier | 1 | 82945 | 4 | 1.266 | 65517.4 |
218 | 2022-12-16 18:26:39 | spiffier | 2 | 121059 | 26 | 3.643 | 33230.6 |
217 | 2022-10-13 09:25:10 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
216 | 2022-10-04 19:03:06 | spiffier | 1 | 82945 | 4 | 1.343 | 61761.0 |
215 | 2022-08-07 22:34:01 | spiffier | 2 | 121059 | 26 | 3.080 | 39304.9 |
214 | 2022-08-03 05:05:06 | spiffier | 2 | 121059 | 26 | 3.233 | 37444.8 |
213 | 2022-06-02 15:28:51 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
212 | 2022-05-11 01:56:00 | spiffier | 1 | 82945 | 4 | 1.470 | 56425.2 |
211 | 2022-03-21 23:07:01 | spiffier | 2 | 121059 | 26 | 3.563 | 33976.7 |
210 | 2022-02-14 17:13:36 | spiffier | 1 | 82945 | 4 | 1.393 | 59544.1 |
209 | 2022-01-10 00:28:43 | spiffier | 1 | 82945 | 4 | 1.326 | 62552.8 |
208 | 2021-11-29 23:09:33 | spiffier | 1 | 82945 | 4 | 1.470 | 56425.2 |
207 | 2021-11-27 21:17:05 | spiffier | 1 | 82945 | 4 | 1.313 | 63172.1 |
206 | 2021-10-21 19:13:25 | spiffier | 1 | 82945 | 4 | 1.280 | 64800.8 |
205 | 2021-09-21 01:05:19 | spiffier | 1 | 82945 | 4 | 1.453 | 57085.3 |
204 | 2021-08-02 02:12:06 | spiffier | 1 | 82945 | 4 | 1.486 | 55817.6 |
203 | 2021-08-01 07:31:34 | spiffier | 1 | 82945 | 4 | 1.280 | 64800.8 |
202 | 2021-06-17 23:14:50 | spiffier | 1 | 82945 | 4 | 1.500 | 55296.7 |
201 | 2021-06-04 15:35:27 | spiffier | 2 | 121059 | 26 | 3.233 | 37444.8 |
200 | 2021-05-10 09:42:20 | spiffier | 2 | 121059 | 26 | 3.170 | 38189.0 |
199 | 2021-04-09 02:48:55 | spiffier | 2 | 121059 | 26 | 3.156 | 38358.4 |
198 | 2021-03-15 03:00:18 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
197 | 2021-03-13 07:03:11 | spiffier | 2 | 121059 | 26 | 3.156 | 38358.4 |
196 | 2021-02-16 15:27:19 | spiffier | 2 | 121059 | 26 | 3.296 | 36729.1 |
195 | 2020-12-12 02:26:34 | spiffier | 1 | 82945 | 4 | 1.343 | 61761.0 |
194 | 2020-11-07 05:02:28 | spiffier | 1 | 82945 | 4 | 1.343 | 61761.0 |
193 | 2020-10-26 04:52:35 | spiffier | 1 | 82945 | 4 | 1.373 | 60411.5 |
192 | 2020-09-05 09:25:29 | spiffier | 1 | 82945 | 4 | 1.406 | 58993.6 |
191 | 2020-08-14 16:36:53 | spiffier | 1 | 82945 | 4 | 1.373 | 60411.5 |
190 | 2020-05-22 00:42:42 | spiffier | 1 | 82945 | 4 | 1.330 | 62364.7 |
189 | 2020-05-18 21:16:32 | spiffier | 1 | 82945 | 4 | 1.296 | 64000.8 |
188 | 2020-05-08 17:16:53 | spiffier | 1 | 82945 | 4 | 1.343 | 61761.0 |
187 | 2020-03-28 16:47:38 | spiffier | 1 | 82945 | 4 | 1.606 | 51646.9 |
186 | 2020-03-01 01:42:26 | spiffier | 3 | 146162 | 167 | 15.906 | 9189.1 |
185 | 2020-02-29 23:22:13 | spiffier | 3 | 146162 | 167 | 12.876 | 11351.5 |
184 | 2020-02-29 11:55:03 | spiffier | 1 | 82945 | 4 | 2.343 | 35401.2 |
183 | 2020-02-29 03:08:28 | spiffier | 3 | 146162 | 167 | 8.936 | 16356.5 |
182 | 2020-02-28 22:29:46 | spiffier | 1 | 82945 | 4 | 1.643 | 50483.9 |
181 | 2020-02-28 22:17:52 | spiffier | 3 | 146162 | 167 | 8.876 | 16467.1 |
180 | 2020-02-26 00:07:06 | spiffier | 1 | 82945 | 4 | 1.513 | 54821.5 |
179 | 2020-02-21 06:38:07 | spiffier | 1 | 82945 | 4 | 3.220 | 25759.3 |
178 | 2020-02-13 21:46:47 | spiffier | 1 | 82945 | 4 | 3.233 | 25655.7 |
177 | 2020-02-13 00:32:47 | spiffier | 2 | 121059 | 26 | 3.326 | 36397.8 |
176 | 2020-02-12 23:32:47 | spiffier | 1 | 82945 | 4 | 2.766 | 29987.3 |
175 | 2020-02-09 19:06:12 | spiffier | 3 | 146162 | 167 | 6.376 | 22923.8 |
174 | 2020-02-07 03:34:18 | spiffier | 1 | 82945 | 4 | 1.470 | 56425.2 |
173 | 2020-02-03 15:19:58 | spiffier | 1 | 82945 | 4 | 3.140 | 26415.6 |
172 | 2020-01-28 06:37:11 | spiffier | 1 | 82945 | 4 | 1.313 | 63172.1 |
171 | 2020-01-27 03:18:20 | spiffier | 1 | 82945 | 4 | 3.783 | 21925.7 |