History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-04-28 03:06:17 | affiance | 4 | 161609 | 334 | 45.643 | 3540.7 |
305 | 2024-04-27 20:29:38 | affiance | 2 | 121059 | 11 | 6.780 | 17855.3 |
304 | 2024-04-27 14:06:41 | affiance | 3 | 146162 | 52 | 12.890 | 11339.2 |
303 | 2024-04-13 18:11:39 | affiance | 4 | 161609 | 334 | 28.753 | 5620.6 |
302 | 2024-04-13 13:01:31 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
301 | 2024-04-13 11:44:45 | affiance | 4 | 161609 | 334 | 12.110 | 13345.1 |
300 | 2024-04-13 05:48:36 | affiance | 4 | 161609 | 334 | 12.033 | 13430.5 |
299 | 2024-04-13 03:36:09 | affiance | 3 | 146162 | 52 | 14.800 | 9875.8 |
298 | 2024-04-13 03:36:05 | affiance | 4 | 161609 | 334 | 13.250 | 12196.9 |
297 | 2024-04-13 03:36:13 | affiance | 2 | 121059 | 11 | 4.203 | 28803.0 |
296 | 2024-04-13 03:36:01 | affiance | 1 | 82945 | 3 | 1.500 | 55296.7 |
295 | 2024-04-13 01:54:25 | affiance | 1 | 82945 | 3 | 1.453 | 57085.3 |
294 | 2024-04-12 20:29:33 | affiance | 3 | 146162 | 52 | 9.986 | 14636.7 |
293 | 2024-04-11 00:35:11 | affiance | 3 | 146162 | 52 | 9.156 | 15963.5 |
292 | 2024-04-10 04:47:31 | affiance | 3 | 146162 | 52 | 10.046 | 14549.3 |
291 | 2024-04-09 11:05:56 | affiance | 3 | 146162 | 52 | 14.153 | 10327.3 |
290 | 2024-04-09 03:27:04 | affiance | 3 | 146162 | 52 | 7.780 | 18786.9 |
289 | 2024-04-01 04:26:58 | affiance | 1 | 82945 | 3 | 3.750 | 22118.7 |
288 | 2024-03-28 05:22:51 | affiance | 1 | 82945 | 3 | 1.406 | 58993.6 |
287 | 2024-03-10 18:21:37 | affiance | 3 | 146162 | 52 | 21.953 | 6658.0 |
286 | 2024-03-10 12:27:59 | affiance | 3 | 146162 | 52 | 7.626 | 19166.3 |
285 | 2024-03-10 12:27:59 | affiance | 2 | 121059 | 11 | 4.046 | 29920.7 |
284 | 2024-03-10 03:31:01 | affiance | 2 | 121059 | 11 | 6.203 | 19516.2 |
283 | 2024-03-10 03:26:35 | affiance | 1 | 82945 | 3 | 1.610 | 51518.6 |
282 | 2024-03-10 03:24:21 | affiance | 3 | 146162 | 52 | 16.670 | 8768.0 |
281 | 2024-03-09 04:04:28 | affiance | 1 | 82945 | 3 | 1.530 | 54212.4 |
280 | 2024-03-09 04:04:13 | affiance | 3 | 146162 | 52 | 9.860 | 14823.7 |
279 | 2024-03-09 04:04:13 | affiance | 2 | 121059 | 11 | 3.940 | 30725.6 |
278 | 2024-03-09 04:03:45 | affiance | 1 | 82945 | 3 | 1.640 | 50576.2 |
277 | 2024-03-07 16:45:53 | affiance | 4 | 161609 | 334 | 13.766 | 11739.7 |
276 | 2024-03-05 23:45:58 | affiance | 4 | 161609 | 334 | 36.723 | 4400.8 |
275 | 2024-03-05 09:36:47 | affiance | 4 | 161609 | 334 | 20.813 | 7764.8 |
274 | 2024-03-04 20:58:58 | affiance | 4 | 161609 | 334 | 13.046 | 12387.6 |
273 | 2024-03-04 18:26:57 | affiance | 4 | 161609 | 334 | 19.300 | 8373.5 |
272 | 2024-03-04 16:34:06 | affiance | 4 | 161609 | 334 | 15.626 | 10342.3 |
271 | 2024-02-28 20:53:53 | affiance | 4 | 161609 | 334 | 15.330 | 10542.0 |
270 | 2024-02-26 05:16:34 | affiance | 1 | 82945 | 3 | 1.640 | 50576.2 |
269 | 2024-02-14 21:39:15 | affiance | 3 | 146162 | 52 | 10.453 | 13982.8 |
268 | 2024-02-05 08:01:03 | affiance | 3 | 146162 | 52 | 9.720 | 15037.2 |
267 | 2024-02-03 02:39:10 | affiance | 4 | 161609 | 334 | 11.860 | 13626.4 |
266 | 2024-02-03 00:01:05 | affiance | 2 | 121059 | 11 | 3.423 | 35366.3 |
265 | 2024-02-03 00:00:45 | affiance | 3 | 146162 | 52 | 6.750 | 21653.6 |
264 | 2024-02-02 23:24:41 | affiance | 4 | 161609 | 334 | 15.736 | 10270.0 |
263 | 2024-02-02 16:28:16 | affiance | 3 | 146162 | 52 | 6.486 | 22535.0 |
262 | 2024-02-02 16:28:00 | affiance | 4 | 161609 | 334 | 11.206 | 14421.6 |
261 | 2024-02-02 16:27:56 | affiance | 2 | 121059 | 11 | 3.140 | 38553.8 |
260 | 2024-02-02 16:27:52 | affiance | 1 | 82945 | 3 | 1.280 | 64800.8 |
259 | 2024-01-31 23:58:36 | affiance | 1 | 82945 | 3 | 1.530 | 54212.4 |
258 | 2024-01-29 19:36:54 | affiance | 1 | 82945 | 3 | 1.580 | 52496.8 |
257 | 2024-01-02 03:05:02 | affiance | 1 | 82945 | 3 | 1.296 | 64000.8 |
256 | 2023-12-29 04:11:09 | affiance | 1 | 82945 | 3 | 1.453 | 57085.3 |
255 | 2023-12-10 01:43:41 | affiance | 3 | 146162 | 52 | 5.936 | 24623.0 |
254 | 2023-11-25 03:45:25 | affiance | 4 | 161609 | 334 | 10.563 | 15299.5 |
253 | 2023-10-19 11:06:47 | affiance | 1 | 82945 | 3 | 1.546 | 53651.4 |
252 | 2023-09-28 01:18:37 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
251 | 2023-09-24 19:24:28 | affiance | 1 | 82945 | 3 | 1.440 | 57600.7 |
250 | 2023-09-15 12:30:21 | affiance | 1 | 82945 | 3 | 1.360 | 60989.0 |
249 | 2023-09-06 21:44:38 | affiance | 3 | 146162 | 52 | 5.923 | 24677.0 |
248 | 2023-08-24 11:59:44 | affiance | 4 | 161609 | 334 | 11.063 | 14608.1 |
247 | 2023-08-16 10:10:05 | affiance | 1 | 82945 | 3 | 1.330 | 62364.7 |
246 | 2023-05-28 23:03:36 | affiance | 1 | 82945 | 3 | 1.406 | 58993.6 |
245 | 2023-05-23 13:42:34 | affiance | 3 | 146162 | 52 | 5.843 | 25014.9 |
244 | 2023-05-18 21:23:33 | affiance | 1 | 82945 | 3 | 1.216 | 68211.3 |
243 | 2023-05-11 02:48:20 | affiance | 4 | 161609 | 334 | 10.436 | 15485.7 |
242 | 2023-03-14 10:42:14 | affiance | 1 | 82945 | 3 | 1.263 | 65673.0 |
241 | 2023-02-28 21:35:35 | affiance | 3 | 146162 | 52 | 5.796 | 25217.7 |
240 | 2023-02-18 06:18:54 | affiance | 4 | 161609 | 334 | 10.893 | 14836.0 |
239 | 2023-02-02 02:34:23 | affiance | 1 | 82945 | 3 | 1.266 | 65517.4 |
238 | 2023-01-03 04:08:02 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
237 | 2022-12-26 20:22:20 | affiance | 4 | 161609 | 334 | 12.533 | 12894.7 |
236 | 2022-12-10 10:09:40 | affiance | 3 | 146162 | 52 | 7.530 | 19410.6 |
235 | 2022-11-28 20:37:16 | affiance | 4 | 161609 | 334 | 10.046 | 16086.9 |
234 | 2022-11-10 06:45:05 | affiance | 4 | 161609 | 334 | 12.580 | 12846.5 |
233 | 2022-11-06 12:30:58 | affiance | 4 | 161609 | 334 | 12.280 | 13160.3 |
232 | 2022-11-01 21:59:43 | affiance | 4 | 161609 | 334 | 10.000 | 16160.9 |
231 | 2022-10-31 12:26:31 | affiance | 4 | 161609 | 334 | 12.656 | 12769.4 |
230 | 2022-10-27 13:58:06 | affiance | 4 | 161609 | 334 | 11.940 | 13535.1 |
229 | 2022-09-30 23:21:07 | affiance | 1 | 82945 | 3 | 1.233 | 67270.9 |
228 | 2022-09-26 03:30:23 | affiance | 4 | 161609 | 334 | 10.313 | 15670.4 |
227 | 2022-09-25 13:38:57 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
226 | 2022-09-22 18:11:01 | affiance | 4 | 161609 | 334 | 9.966 | 16216.0 |
225 | 2022-09-01 12:14:19 | affiance | 3 | 146162 | 52 | 5.940 | 24606.4 |
224 | 2022-08-26 20:44:49 | affiance | 4 | 161609 | 334 | 11.656 | 13864.9 |
223 | 2022-07-27 11:27:21 | affiance | 3 | 146162 | 52 | 5.936 | 24623.0 |
222 | 2022-07-07 02:20:41 | affiance | 4 | 161609 | 334 | 10.203 | 15839.4 |
221 | 2022-05-24 15:09:16 | affiance | 1 | 82945 | 3 | 1.436 | 57761.1 |
220 | 2022-05-09 08:13:17 | affiance | 1 | 82945 | 3 | 1.310 | 63316.8 |
219 | 2022-03-07 03:06:28 | affiance | 3 | 146162 | 52 | 5.956 | 24540.3 |
218 | 2022-01-28 08:14:17 | affiance | 1 | 82945 | 3 | 1.390 | 59672.7 |
217 | 2022-01-26 14:01:32 | affiance | 1 | 82945 | 3 | 1.436 | 57761.1 |
216 | 2021-12-06 02:27:29 | affiance | 1 | 82945 | 3 | 1.423 | 58288.8 |
215 | 2021-12-05 00:49:42 | affiance | 3 | 146162 | 52 | 5.906 | 24748.1 |
214 | 2021-10-09 23:59:34 | affiance | 1 | 82945 | 3 | 1.406 | 58993.6 |
213 | 2021-09-15 10:12:21 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
212 | 2021-07-30 14:37:35 | affiance | 1 | 82945 | 3 | 1.300 | 63803.8 |
211 | 2021-04-29 07:36:32 | affiance | 1 | 82945 | 3 | 2.890 | 28700.7 |
210 | 2021-04-28 12:04:55 | affiance | 1 | 82945 | 3 | 1.250 | 66356.0 |
209 | 2021-04-20 17:44:20 | affiance | 1 | 82945 | 3 | 1.296 | 64000.8 |
208 | 2021-04-08 07:25:04 | affiance | 1 | 82945 | 3 | 1.283 | 64649.3 |
207 | 2021-04-04 03:33:06 | affiance | 1 | 82945 | 3 | 1.440 | 57600.7 |