History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spoused"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-03-21 19:34:05 | spoused | 1 | 69583 | 6 | 1.310 | 53116.8 |
275 | 2024-03-06 22:46:31 | spoused | 3 | 134027 | 508 | 16.830 | 7963.6 |
274 | 2024-03-06 22:46:35 | spoused | 2 | 107671 | 57 | 7.280 | 14790.0 |
273 | 2024-03-06 19:00:49 | spoused | 1 | 69583 | 6 | 1.780 | 39091.6 |
272 | 2024-03-01 16:39:26 | spoused | 2 | 107671 | 57 | 7.466 | 14421.5 |
271 | 2024-02-28 15:20:05 | spoused | 2 | 107671 | 57 | 3.876 | 27778.9 |
270 | 2024-02-28 08:35:14 | spoused | 3 | 134027 | 508 | 16.750 | 8001.6 |
269 | 2024-02-27 00:56:03 | spoused | 2 | 107671 | 57 | 3.280 | 32826.5 |
268 | 2024-02-27 00:55:59 | spoused | 3 | 134027 | 508 | 6.750 | 19855.9 |
267 | 2024-02-27 00:56:00 | spoused | 1 | 69583 | 6 | 1.283 | 54234.6 |
266 | 2024-01-14 20:53:23 | spoused | 2 | 107671 | 57 | 3.186 | 33795.0 |
265 | 2024-01-11 14:07:43 | spoused | 3 | 134027 | 508 | 7.440 | 18014.4 |
264 | 2024-01-09 14:18:00 | spoused | 3 | 134027 | 508 | 6.610 | 20276.4 |
263 | 2024-01-06 17:20:42 | spoused | 1 | 69583 | 6 | 1.203 | 57841.2 |
262 | 2023-11-22 12:36:49 | spoused | 2 | 107671 | 57 | 3.140 | 34290.1 |
261 | 2023-11-20 12:33:48 | spoused | 1 | 69583 | 6 | 2.550 | 27287.5 |
260 | 2023-11-16 06:07:07 | spoused | 1 | 69583 | 6 | 1.203 | 57841.2 |
259 | 2023-11-16 01:35:17 | spoused | 3 | 134027 | 508 | 6.143 | 21817.8 |
258 | 2023-11-11 11:29:25 | spoused | 1 | 69583 | 6 | 1.203 | 57841.2 |
257 | 2023-10-26 18:51:51 | spoused | 3 | 134027 | 508 | 6.953 | 19276.1 |
256 | 2023-10-26 18:51:46 | spoused | 2 | 107671 | 57 | 3.250 | 33129.5 |
255 | 2023-10-19 19:48:40 | spoused | 1 | 69583 | 6 | 1.143 | 60877.5 |
254 | 2023-10-19 16:19:12 | spoused | 1 | 69583 | 6 | 1.140 | 61037.7 |
253 | 2023-09-29 07:14:29 | spoused | 1 | 69583 | 6 | 1.060 | 65644.3 |
252 | 2023-09-27 09:49:27 | spoused | 1 | 69583 | 6 | 2.483 | 28023.8 |
251 | 2023-09-11 10:12:49 | spoused | 3 | 134027 | 508 | 9.406 | 14249.1 |
250 | 2023-09-11 10:12:49 | spoused | 2 | 107671 | 57 | 3.250 | 33129.5 |
249 | 2023-09-10 11:56:12 | spoused | 1 | 69583 | 6 | 1.080 | 64428.7 |
248 | 2023-05-31 14:00:05 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
247 | 2023-01-25 10:22:09 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
246 | 2023-01-21 18:01:13 | spoused | 1 | 69583 | 6 | 1.076 | 64668.2 |
245 | 2022-09-16 07:31:42 | spoused | 1 | 69583 | 6 | 1.076 | 64668.2 |
244 | 2022-09-15 21:30:33 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
243 | 2022-07-16 22:23:45 | spoused | 3 | 134027 | 508 | 5.750 | 23309.0 |
242 | 2022-07-01 04:06:47 | spoused | 1 | 69583 | 6 | 1.126 | 61796.6 |
241 | 2022-05-02 23:15:33 | spoused | 1 | 69583 | 6 | 1.216 | 57222.9 |
240 | 2022-03-01 17:33:03 | spoused | 1 | 69583 | 6 | 1.563 | 44518.9 |
239 | 2022-02-27 14:32:43 | spoused | 1 | 69583 | 6 | 2.063 | 33729.0 |
238 | 2022-01-09 04:06:57 | spoused | 1 | 69583 | 6 | 1.110 | 62687.4 |
237 | 2021-12-12 09:18:10 | spoused | 1 | 69583 | 6 | 1.123 | 61961.7 |
236 | 2021-10-19 13:55:59 | spoused | 1 | 69583 | 6 | 1.096 | 63488.1 |
235 | 2021-09-23 10:20:15 | spoused | 1 | 69583 | 6 | 1.313 | 52995.4 |
234 | 2021-09-11 16:05:15 | spoused | 1 | 69583 | 6 | 1.080 | 64428.7 |
233 | 2021-08-22 21:19:09 | spoused | 1 | 69583 | 6 | 1.076 | 64668.2 |
232 | 2021-08-20 16:46:31 | spoused | 1 | 69583 | 6 | 1.393 | 49951.9 |
231 | 2021-06-20 08:00:45 | spoused | 1 | 69583 | 6 | 1.220 | 57035.2 |
230 | 2021-06-17 01:59:24 | spoused | 1 | 69583 | 6 | 1.110 | 62687.4 |
229 | 2021-06-15 05:15:53 | spoused | 1 | 69583 | 6 | 1.236 | 56296.9 |
228 | 2021-06-14 18:22:57 | spoused | 1 | 69583 | 6 | 1.360 | 51164.0 |
227 | 2021-05-08 14:03:11 | spoused | 1 | 69583 | 6 | 2.720 | 25582.0 |
226 | 2021-04-07 01:00:23 | spoused | 1 | 69583 | 6 | 2.190 | 31773.1 |
225 | 2021-03-14 07:00:08 | spoused | 1 | 69583 | 6 | 1.203 | 57841.2 |
224 | 2021-01-27 13:36:28 | spoused | 1 | 69583 | 6 | 1.203 | 57841.2 |
223 | 2021-01-22 04:05:47 | spoused | 1 | 69583 | 6 | 1.076 | 64668.2 |
222 | 2020-11-28 21:40:54 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
221 | 2020-11-26 23:27:58 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
220 | 2020-11-01 06:34:01 | spoused | 1 | 69583 | 6 | 2.296 | 30306.2 |
219 | 2020-10-02 20:54:22 | spoused | 1 | 69583 | 6 | 1.186 | 58670.3 |
218 | 2020-08-25 21:32:10 | spoused | 1 | 69583 | 6 | 1.110 | 62687.4 |
217 | 2020-08-19 20:16:54 | spoused | 1 | 69583 | 6 | 1.173 | 59320.5 |
216 | 2020-08-19 15:13:08 | spoused | 1 | 69583 | 6 | 1.156 | 60192.9 |
215 | 2020-08-10 04:04:25 | spoused | 1 | 69583 | 6 | 1.186 | 58670.3 |
214 | 2020-06-16 12:21:57 | spoused | 1 | 69583 | 6 | 1.233 | 56433.9 |
213 | 2020-05-29 17:54:54 | spoused | 1 | 69583 | 6 | 1.080 | 64428.7 |
212 | 2020-05-08 23:20:16 | spoused | 1 | 69583 | 6 | 1.063 | 65459.1 |
211 | 2020-03-24 17:26:11 | spoused | 1 | 69583 | 6 | 1.360 | 51164.0 |
210 | 2020-03-20 09:36:37 | spoused | 1 | 69583 | 6 | 1.343 | 51811.6 |
209 | 2020-03-07 00:44:32 | spoused | 1 | 69583 | 6 | 1.093 | 63662.4 |
208 | 2020-02-29 20:36:56 | spoused | 1 | 69583 | 6 | 1.376 | 50569.0 |
207 | 2020-02-25 16:08:37 | spoused | 1 | 69583 | 6 | 1.703 | 40859.1 |
206 | 2020-02-22 07:46:55 | spoused | 1 | 69583 | 6 | 1.326 | 52475.9 |
205 | 2020-02-20 03:12:00 | spoused | 1 | 69583 | 6 | 1.376 | 50569.0 |
204 | 2020-02-08 11:49:37 | spoused | 1 | 69583 | 6 | 2.763 | 25183.9 |
203 | 2020-02-06 09:39:01 | spoused | 1 | 69583 | 6 | 1.153 | 60349.5 |
202 | 2020-02-05 14:11:40 | spoused | 1 | 69583 | 6 | 2.753 | 25275.3 |
201 | 2020-02-04 23:31:40 | spoused | 1 | 69583 | 6 | 2.533 | 27470.6 |
200 | 2020-01-29 02:52:18 | spoused | 1 | 69583 | 6 | 1.783 | 39025.8 |
199 | 2020-01-25 12:49:18 | spoused | 1 | 69583 | 6 | 2.216 | 31400.3 |
198 | 2020-01-19 11:13:04 | spoused | 1 | 69583 | 6 | 1.390 | 50059.7 |
197 | 2020-01-16 20:17:38 | spoused | 1 | 69583 | 6 | 1.623 | 42873.1 |
196 | 2020-01-13 20:13:49 | spoused | 2 | 107671 | 57 | 11.610 | 9274.0 |
195 | 2020-01-13 18:31:59 | spoused | 1 | 69583 | 6 | 1.356 | 51314.9 |
194 | 2020-01-08 08:40:54 | spoused | 1 | 69583 | 6 | 3.716 | 18725.2 |
193 | 2019-12-29 11:33:24 | spoused | 1 | 69583 | 6 | 1.186 | 58670.3 |
192 | 2019-12-29 06:53:03 | spoused | 1 | 69583 | 6 | 2.530 | 27503.2 |
191 | 2019-12-28 14:08:29 | spoused | 1 | 69583 | 6 | 1.093 | 63662.4 |
190 | 2019-12-27 17:06:21 | spoused | 1 | 69583 | 6 | 1.843 | 37755.3 |
189 | 2019-12-26 20:51:22 | spoused | 1 | 69583 | 6 | 2.076 | 33517.8 |
188 | 2019-11-02 15:29:27 | spoused | 1 | 69583 | 6 | 1.093 | 63662.4 |
187 | 2019-08-27 02:44:53 | spoused | 1 | 69583 | 6 | 1.250 | 55666.4 |
186 | 2019-08-01 11:35:25 | spoused | 1 | 69583 | 6 | 1.070 | 65030.8 |
185 | 2019-06-03 14:31:34 | spoused | 1 | 69583 | 6 | 1.150 | 60507.0 |
184 | 2019-05-30 02:35:07 | spoused | 1 | 69583 | 6 | 1.083 | 64250.2 |
183 | 2019-04-25 05:17:26 | spoused | 1 | 69583 | 6 | 1.090 | 63837.6 |
182 | 2019-03-13 03:06:33 | spoused | 1 | 69583 | 6 | 1.090 | 63837.6 |
181 | 2019-02-21 19:33:31 | spoused | 1 | 69583 | 6 | 1.116 | 62350.4 |
180 | 2019-01-11 15:52:56 | spoused | 1 | 69583 | 6 | 1.066 | 65274.9 |
179 | 2019-01-09 20:31:58 | spoused | 1 | 69583 | 6 | 1.173 | 59320.5 |
178 | 2019-01-01 23:38:30 | spoused | 1 | 69583 | 6 | 1.066 | 65274.9 |
177 | 2018-12-29 21:15:01 | spoused | 1 | 69583 | 6 | 1.243 | 55979.9 |