History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
298 | 2024-04-24 11:58:11 | affiliation | 4 | 148819 | 114 | 28.813 | 5165.0 |
297 | 2024-04-24 11:51:40 | affiliation | 4 | 148819 | 114 | 13.656 | 10897.7 |
296 | 2024-04-24 05:34:07 | affiliation | 4 | 148819 | 114 | 36.470 | 4080.6 |
295 | 2024-04-23 10:36:58 | affiliation | 3 | 121633 | 24 | 19.436 | 6258.1 |
294 | 2024-04-23 10:35:58 | affiliation | 2 | 86808 | 8 | 5.143 | 16878.9 |
293 | 2024-04-23 10:15:06 | affiliation | 4 | 148819 | 114 | 20.970 | 7096.8 |
292 | 2024-04-22 13:54:36 | affiliation | 4 | 148819 | 114 | 37.863 | 3930.5 |
291 | 2024-04-22 11:19:52 | affiliation | 1 | 49908 | 2 | 3.690 | 13525.2 |
290 | 2024-04-22 11:17:24 | affiliation | 3 | 121633 | 24 | 10.020 | 12139.0 |
289 | 2024-04-22 11:17:09 | affiliation | 4 | 148819 | 114 | 23.376 | 6366.3 |
288 | 2024-04-22 11:17:14 | affiliation | 2 | 86808 | 8 | 2.686 | 32318.7 |
287 | 2024-04-22 11:16:52 | affiliation | 1 | 49908 | 2 | 1.236 | 40378.6 |
286 | 2024-04-15 14:56:23 | affiliation | 1 | 49908 | 2 | 2.530 | 19726.5 |
285 | 2024-03-28 00:03:51 | affiliation | 3 | 121633 | 24 | 11.796 | 10311.4 |
284 | 2024-03-28 00:03:31 | affiliation | 2 | 86808 | 8 | 7.720 | 11244.6 |
283 | 2024-03-27 22:25:15 | affiliation | 1 | 49908 | 2 | 0.736 | 67809.8 |
282 | 2024-03-22 07:30:43 | affiliation | 3 | 121633 | 24 | 11.796 | 10311.4 |
281 | 2024-03-22 07:30:45 | affiliation | 2 | 86808 | 8 | 7.966 | 10897.3 |
280 | 2024-03-22 07:25:08 | affiliation | 1 | 49908 | 2 | 1.686 | 29601.4 |
279 | 2024-03-21 16:34:26 | affiliation | 4 | 148819 | 114 | 33.736 | 4411.3 |
278 | 2024-03-16 17:43:56 | affiliation | 2 | 86808 | 8 | 5.920 | 14663.5 |
277 | 2024-03-16 06:13:23 | affiliation | 3 | 121633 | 24 | 17.420 | 6982.4 |
276 | 2024-03-16 06:13:25 | affiliation | 2 | 86808 | 8 | 3.656 | 23744.0 |
275 | 2024-03-16 06:06:14 | affiliation | 1 | 49908 | 2 | 1.623 | 30750.5 |
274 | 2024-03-15 23:34:04 | affiliation | 4 | 148819 | 114 | 21.750 | 6842.3 |
273 | 2024-03-14 21:28:59 | affiliation | 4 | 148819 | 114 | 11.406 | 13047.4 |
272 | 2024-03-14 05:09:44 | affiliation | 2 | 86808 | 8 | 5.983 | 14509.1 |
271 | 2024-03-14 04:57:49 | affiliation | 1 | 49908 | 2 | 1.093 | 45661.5 |
270 | 2024-03-14 04:29:40 | affiliation | 3 | 121633 | 24 | 17.173 | 7082.8 |
269 | 2024-03-14 00:37:50 | affiliation | 4 | 148819 | 114 | 29.173 | 5101.3 |
268 | 2024-03-13 13:34:00 | affiliation | 3 | 121633 | 24 | 15.343 | 7927.6 |
267 | 2024-03-13 11:49:47 | affiliation | 4 | 148819 | 114 | 26.093 | 5703.4 |
266 | 2024-03-13 10:25:30 | affiliation | 1 | 49908 | 2 | 1.780 | 28038.2 |
265 | 2024-03-13 10:22:54 | affiliation | 4 | 148819 | 114 | 8.750 | 17007.9 |
264 | 2024-03-13 10:22:54 | affiliation | 3 | 121633 | 24 | 6.326 | 19227.5 |
263 | 2024-03-13 10:22:53 | affiliation | 2 | 86808 | 8 | 3.920 | 22144.9 |
262 | 2024-03-13 09:33:04 | affiliation | 1 | 49908 | 2 | 0.953 | 52369.4 |
261 | 2024-02-29 09:48:08 | affiliation | 1 | 49908 | 2 | 0.813 | 61387.5 |
260 | 2024-02-28 16:53:23 | affiliation | 1 | 49908 | 2 | 0.890 | 56076.4 |
259 | 2024-02-28 01:13:55 | affiliation | 1 | 49908 | 2 | 1.186 | 42080.9 |
258 | 2024-02-27 05:53:14 | affiliation | 1 | 49908 | 2 | 0.893 | 55888.0 |
257 | 2024-02-26 07:30:54 | affiliation | 1 | 49908 | 2 | 1.403 | 35572.3 |
256 | 2024-02-25 19:23:03 | affiliation | 1 | 49908 | 2 | 1.220 | 40908.2 |
255 | 2024-02-23 20:58:00 | affiliation | 1 | 49908 | 2 | 0.826 | 60421.3 |
254 | 2024-02-23 01:40:20 | affiliation | 1 | 49908 | 2 | 0.750 | 66544.0 |
253 | 2024-02-22 01:19:02 | affiliation | 1 | 49908 | 2 | 0.716 | 69703.9 |
252 | 2024-02-21 01:20:25 | affiliation | 1 | 49908 | 2 | 0.856 | 58303.7 |
251 | 2024-02-20 06:35:56 | affiliation | 1 | 49908 | 2 | 1.470 | 33951.0 |
250 | 2024-02-19 14:57:23 | affiliation | 1 | 49908 | 2 | 0.906 | 55086.1 |
249 | 2024-02-18 20:54:58 | affiliation | 1 | 49908 | 2 | 0.893 | 55888.0 |
248 | 2024-02-18 01:37:20 | affiliation | 1 | 49908 | 2 | 0.906 | 55086.1 |
247 | 2024-02-16 20:54:42 | affiliation | 1 | 49908 | 2 | 1.796 | 27788.4 |
246 | 2024-02-16 04:12:48 | affiliation | 4 | 148819 | 114 | 31.783 | 4682.3 |
245 | 2024-02-16 04:12:44 | affiliation | 3 | 121633 | 24 | 12.063 | 10083.1 |
244 | 2024-02-16 04:12:43 | affiliation | 2 | 86808 | 8 | 7.796 | 11134.9 |
243 | 2024-02-16 01:55:21 | affiliation | 1 | 49908 | 2 | 0.890 | 56076.4 |
242 | 2024-02-15 19:35:45 | affiliation | 1 | 49908 | 2 | 1.830 | 27272.1 |
241 | 2024-02-15 01:58:01 | affiliation | 1 | 49908 | 2 | 0.716 | 69703.9 |
240 | 2024-02-13 08:22:54 | affiliation | 1 | 49908 | 2 | 0.783 | 63739.5 |
239 | 2024-02-13 03:52:09 | affiliation | 1 | 49908 | 2 | 0.736 | 67809.8 |
238 | 2024-02-12 13:37:21 | affiliation | 1 | 49908 | 2 | 0.826 | 60421.3 |
237 | 2024-02-12 12:28:37 | affiliation | 2 | 86808 | 8 | 5.326 | 16298.9 |
236 | 2024-02-12 12:19:49 | affiliation | 1 | 49908 | 2 | 0.906 | 55086.1 |
235 | 2024-02-12 11:49:47 | affiliation | 3 | 121633 | 24 | 12.003 | 10133.5 |
234 | 2024-02-11 23:18:29 | affiliation | 1 | 49908 | 2 | 1.533 | 32555.8 |
233 | 2024-02-11 05:22:55 | affiliation | 1 | 49908 | 2 | 0.783 | 63739.5 |
232 | 2024-02-10 21:25:09 | affiliation | 3 | 121633 | 24 | 5.766 | 21094.9 |
231 | 2024-02-10 21:25:11 | affiliation | 2 | 86808 | 8 | 2.750 | 31566.5 |
230 | 2024-02-10 20:06:29 | affiliation | 1 | 49908 | 2 | 0.940 | 53093.6 |
229 | 2024-02-09 05:49:40 | affiliation | 1 | 49908 | 2 | 0.860 | 58032.6 |
228 | 2024-02-08 05:17:42 | affiliation | 1 | 49908 | 2 | 0.720 | 69316.7 |
227 | 2024-02-07 05:30:57 | affiliation | 1 | 49908 | 2 | 0.750 | 66544.0 |
226 | 2024-02-06 05:18:40 | affiliation | 1 | 49908 | 2 | 0.890 | 56076.4 |
225 | 2024-02-05 01:27:08 | affiliation | 1 | 49908 | 2 | 0.893 | 55888.0 |
224 | 2024-02-04 10:19:11 | affiliation | 3 | 121633 | 24 | 6.893 | 17645.9 |
223 | 2024-02-04 10:19:14 | affiliation | 2 | 86808 | 8 | 2.610 | 33259.8 |
222 | 2024-02-04 10:19:05 | affiliation | 4 | 148819 | 114 | 11.016 | 13509.4 |
221 | 2024-02-04 10:17:53 | affiliation | 1 | 49908 | 2 | 0.830 | 60130.1 |
220 | 2024-01-07 22:36:00 | affiliation | 1 | 49908 | 2 | 0.830 | 60130.1 |
219 | 2023-12-15 13:26:27 | affiliation | 1 | 49908 | 2 | 0.800 | 62385.0 |
218 | 2023-12-11 06:54:50 | affiliation | 1 | 49908 | 2 | 0.720 | 69316.7 |
217 | 2023-12-11 00:55:13 | affiliation | 1 | 49908 | 2 | 0.720 | 69316.7 |
216 | 2023-12-05 21:13:32 | affiliation | 1 | 49908 | 2 | 0.843 | 59202.8 |
215 | 2023-12-05 19:29:28 | affiliation | 1 | 49908 | 2 | 0.733 | 68087.3 |
214 | 2023-12-04 14:11:04 | affiliation | 1 | 49908 | 2 | 0.813 | 61387.5 |
213 | 2023-12-02 00:12:57 | affiliation | 1 | 49908 | 2 | 0.796 | 62698.5 |
212 | 2023-11-24 16:17:01 | affiliation | 1 | 49908 | 2 | 0.796 | 62698.5 |
211 | 2023-10-07 12:44:11 | affiliation | 1 | 49908 | 2 | 0.813 | 61387.5 |
210 | 2023-09-20 21:58:49 | affiliation | 1 | 49908 | 2 | 0.830 | 60130.1 |
209 | 2023-09-16 14:52:22 | affiliation | 1 | 49908 | 2 | 0.796 | 62698.5 |
208 | 2023-08-11 15:02:13 | affiliation | 1 | 49908 | 2 | 0.826 | 60421.3 |
207 | 2023-07-31 13:11:00 | affiliation | 1 | 49908 | 2 | 0.763 | 65410.2 |
206 | 2023-07-28 18:45:11 | affiliation | 1 | 49908 | 2 | 0.733 | 68087.3 |
205 | 2023-07-27 01:28:56 | affiliation | 1 | 49908 | 2 | 0.720 | 69316.7 |
204 | 2023-07-26 01:09:21 | affiliation | 1 | 49908 | 2 | 0.720 | 69316.7 |
203 | 2023-07-23 22:35:02 | affiliation | 1 | 49908 | 2 | 0.843 | 59202.8 |
202 | 2023-07-22 19:37:24 | affiliation | 1 | 49908 | 2 | 0.733 | 68087.3 |
201 | 2023-07-21 08:03:41 | affiliation | 1 | 49908 | 2 | 0.766 | 65154.0 |
200 | 2023-07-19 13:30:48 | affiliation | 1 | 49908 | 2 | 0.750 | 66544.0 |
199 | 2023-07-04 21:07:58 | affiliation | 1 | 49908 | 2 | 0.843 | 59202.8 |