History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sancta"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-30 01:40:13 | sancta | 3 | 112716 | 360 | 8.983 | 12547.7 |
280 | 2024-04-24 18:14:10 | sancta | 2 | 82551 | 12 | 3.890 | 21221.3 |
279 | 2024-04-24 18:13:47 | sancta | 3 | 112716 | 360 | 8.813 | 12789.7 |
278 | 2024-04-23 07:46:41 | sancta | 3 | 112716 | 360 | 7.753 | 14538.4 |
277 | 2024-04-17 12:31:09 | sancta | 1 | 48755 | 1 | 0.830 | 58741.0 |
276 | 2024-04-17 12:09:30 | sancta | 1 | 48755 | 1 | 0.780 | 62506.4 |
275 | 2024-04-15 07:14:45 | sancta | 1 | 48755 | 1 | 1.000 | 48755.0 |
274 | 2024-04-03 09:17:05 | sancta | 3 | 112716 | 360 | 19.016 | 5927.4 |
273 | 2024-04-02 18:47:46 | sancta | 2 | 82551 | 12 | 9.376 | 8804.5 |
272 | 2024-04-02 03:18:06 | sancta | 2 | 82551 | 12 | 2.953 | 27955.0 |
271 | 2024-04-02 03:18:05 | sancta | 1 | 48755 | 1 | 1.920 | 25393.2 |
270 | 2024-04-02 03:17:49 | sancta | 3 | 112716 | 360 | 5.813 | 19390.3 |
269 | 2024-04-01 06:11:18 | sancta | 3 | 112716 | 360 | 13.203 | 8537.2 |
268 | 2024-04-01 06:11:22 | sancta | 2 | 82551 | 12 | 8.173 | 10100.5 |
267 | 2024-04-01 06:11:09 | sancta | 1 | 48755 | 1 | 1.000 | 48755.0 |
266 | 2024-01-14 01:35:25 | sancta | 3 | 112716 | 360 | 5.890 | 19136.8 |
265 | 2024-01-14 01:35:24 | sancta | 2 | 82551 | 12 | 2.686 | 30733.8 |
264 | 2024-01-12 21:23:48 | sancta | 2 | 82551 | 12 | 2.436 | 33887.9 |
263 | 2023-12-31 10:53:03 | sancta | 1 | 48755 | 1 | 0.813 | 59969.2 |
262 | 2023-12-21 15:34:54 | sancta | 3 | 112716 | 360 | 4.906 | 22975.1 |
261 | 2023-12-21 15:34:51 | sancta | 2 | 82551 | 12 | 2.233 | 36968.7 |
260 | 2023-12-17 20:13:13 | sancta | 3 | 112716 | 360 | 5.830 | 19333.8 |
259 | 2023-11-26 21:06:19 | sancta | 2 | 82551 | 12 | 2.576 | 32046.2 |
258 | 2023-11-17 05:21:16 | sancta | 1 | 48755 | 1 | 0.780 | 62506.4 |
257 | 2023-11-12 03:20:00 | sancta | 1 | 48755 | 1 | 1.576 | 30935.9 |
256 | 2023-11-04 01:44:29 | sancta | 1 | 48755 | 1 | 1.093 | 44606.6 |
255 | 2023-11-03 17:54:58 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
254 | 2023-10-28 07:54:42 | sancta | 1 | 48755 | 1 | 0.953 | 51159.5 |
253 | 2023-10-25 01:09:04 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
252 | 2023-10-21 07:01:36 | sancta | 1 | 48755 | 1 | 0.906 | 53813.5 |
251 | 2023-10-21 05:22:46 | sancta | 2 | 82551 | 12 | 6.220 | 13271.9 |
250 | 2023-10-16 01:02:23 | sancta | 1 | 48755 | 1 | 0.813 | 59969.2 |
249 | 2023-09-26 07:11:20 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
248 | 2023-09-22 17:57:48 | sancta | 3 | 112716 | 360 | 5.500 | 20493.8 |
247 | 2023-09-18 04:53:14 | sancta | 3 | 112716 | 360 | 4.843 | 23274.0 |
246 | 2023-09-15 14:41:26 | sancta | 1 | 48755 | 1 | 0.860 | 56691.9 |
245 | 2023-08-16 17:44:28 | sancta | 1 | 48755 | 1 | 0.766 | 63648.8 |
244 | 2023-06-26 23:17:20 | sancta | 1 | 48755 | 1 | 0.783 | 62266.9 |
243 | 2023-06-23 01:15:16 | sancta | 3 | 112716 | 360 | 5.546 | 20323.8 |
242 | 2023-05-20 06:26:23 | sancta | 1 | 48755 | 1 | 0.763 | 63899.1 |
241 | 2023-04-09 14:14:54 | sancta | 2 | 82551 | 12 | 2.250 | 36689.3 |
240 | 2023-03-18 19:02:16 | sancta | 3 | 112716 | 360 | 5.483 | 20557.4 |
239 | 2023-03-18 06:22:24 | sancta | 1 | 48755 | 1 | 0.750 | 65006.7 |
238 | 2023-02-22 07:06:02 | sancta | 1 | 48755 | 1 | 0.780 | 62506.4 |
237 | 2023-01-16 23:46:05 | sancta | 2 | 82551 | 12 | 2.203 | 37472.1 |
236 | 2023-01-06 03:50:23 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
235 | 2022-12-18 07:20:08 | sancta | 3 | 112716 | 360 | 4.720 | 23880.5 |
234 | 2022-11-28 07:44:47 | sancta | 3 | 112716 | 360 | 4.873 | 23130.7 |
233 | 2022-11-21 11:47:37 | sancta | 3 | 112716 | 360 | 5.736 | 19650.6 |
232 | 2022-10-28 13:31:23 | sancta | 3 | 112716 | 360 | 5.563 | 20261.7 |
231 | 2022-10-27 19:37:22 | sancta | 2 | 82551 | 12 | 2.563 | 32208.7 |
230 | 2022-10-18 10:15:24 | sancta | 1 | 48755 | 1 | 0.766 | 63648.8 |
229 | 2022-10-14 16:35:28 | sancta | 1 | 48755 | 1 | 0.763 | 63899.1 |
228 | 2022-10-01 16:19:58 | sancta | 1 | 48755 | 1 | 1.016 | 47987.2 |
227 | 2022-09-30 21:57:17 | sancta | 3 | 112716 | 360 | 4.783 | 23566.0 |
226 | 2022-09-24 11:24:34 | sancta | 3 | 112716 | 360 | 4.890 | 23050.3 |
225 | 2022-08-15 21:38:28 | sancta | 3 | 112716 | 360 | 4.923 | 22895.8 |
224 | 2022-06-09 14:22:31 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
223 | 2022-06-05 23:34:42 | sancta | 1 | 48755 | 1 | 0.876 | 55656.4 |
222 | 2022-05-27 17:13:54 | sancta | 2 | 82551 | 12 | 2.343 | 35233.0 |
221 | 2022-05-16 22:59:40 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
220 | 2022-05-14 18:33:14 | sancta | 1 | 48755 | 1 | 0.780 | 62506.4 |
219 | 2022-02-11 09:43:01 | sancta | 1 | 48755 | 1 | 1.080 | 45143.5 |
218 | 2022-01-25 20:43:02 | sancta | 1 | 48755 | 1 | 0.783 | 62266.9 |
217 | 2021-10-30 22:30:38 | sancta | 1 | 48755 | 1 | 0.920 | 52994.6 |
216 | 2021-10-29 21:10:33 | sancta | 1 | 48755 | 1 | 0.826 | 59025.4 |
215 | 2021-10-06 02:26:28 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
214 | 2021-09-22 03:24:58 | sancta | 1 | 48755 | 1 | 0.783 | 62266.9 |
213 | 2021-09-21 15:02:54 | sancta | 1 | 48755 | 1 | 0.876 | 55656.4 |
212 | 2021-09-15 06:22:53 | sancta | 1 | 48755 | 1 | 0.780 | 62506.4 |
211 | 2021-07-07 06:31:17 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
210 | 2021-07-03 17:09:13 | sancta | 1 | 48755 | 1 | 0.876 | 55656.4 |
209 | 2021-06-17 19:32:04 | sancta | 1 | 48755 | 1 | 0.903 | 53992.2 |
208 | 2021-05-12 14:39:14 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
207 | 2021-05-11 17:14:02 | sancta | 1 | 48755 | 1 | 0.920 | 52994.6 |
206 | 2021-05-09 20:54:58 | sancta | 1 | 48755 | 1 | 0.920 | 52994.6 |
205 | 2021-04-28 21:37:06 | sancta | 1 | 48755 | 1 | 0.920 | 52994.6 |
204 | 2021-03-30 01:04:03 | sancta | 1 | 48755 | 1 | 0.846 | 57630.0 |
203 | 2021-03-28 19:21:13 | sancta | 2 | 82551 | 12 | 2.406 | 34310.5 |
202 | 2021-03-26 19:57:14 | sancta | 1 | 48755 | 1 | 0.873 | 55847.7 |
201 | 2021-03-25 16:37:31 | sancta | 1 | 48755 | 1 | 0.876 | 55656.4 |
200 | 2021-03-25 09:36:35 | sancta | 1 | 48755 | 1 | 0.936 | 52088.7 |
199 | 2021-03-02 21:10:49 | sancta | 2 | 82551 | 12 | 2.546 | 32423.8 |
198 | 2021-01-25 22:34:56 | sancta | 2 | 82551 | 12 | 2.423 | 34069.7 |
197 | 2020-12-14 17:40:16 | sancta | 1 | 48755 | 1 | 0.813 | 59969.2 |
196 | 2020-11-18 22:50:55 | sancta | 1 | 48755 | 1 | 0.893 | 54596.9 |
195 | 2020-11-03 13:40:38 | sancta | 1 | 48755 | 1 | 0.970 | 50262.9 |
194 | 2020-10-24 17:54:35 | sancta | 1 | 48755 | 1 | 0.876 | 55656.4 |
193 | 2020-10-22 12:56:24 | sancta | 1 | 48755 | 1 | 0.890 | 54780.9 |
192 | 2020-10-20 10:09:20 | sancta | 1 | 48755 | 1 | 1.673 | 29142.3 |
191 | 2020-10-11 08:30:43 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
190 | 2020-09-04 09:44:35 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
189 | 2020-05-24 04:24:44 | sancta | 1 | 48755 | 1 | 0.860 | 56691.9 |
188 | 2020-03-28 19:11:20 | sancta | 1 | 48755 | 1 | 0.936 | 52088.7 |
187 | 2020-03-27 19:37:11 | sancta | 1 | 48755 | 1 | 0.873 | 55847.7 |
186 | 2020-03-25 01:05:24 | sancta | 1 | 48755 | 1 | 1.983 | 24586.5 |
185 | 2020-03-23 07:37:33 | sancta | 1 | 48755 | 1 | 0.936 | 52088.7 |
184 | 2020-03-22 09:09:36 | sancta | 1 | 48755 | 1 | 1.953 | 24964.2 |
183 | 2020-03-18 18:30:43 | sancta | 1 | 48755 | 1 | 0.796 | 61250.0 |
182 | 2020-03-01 07:36:31 | sancta | 1 | 48755 | 1 | 0.936 | 52088.7 |