History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"identities"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
289 | 2024-05-23 18:05:50 | identities | 4 | 161450 | 256 | 29.953 | 5390.1 |
288 | 2024-05-20 15:21:03 | identities | 1 | 67641 | 2 | 2.593 | 26086.0 |
287 | 2024-05-20 12:01:05 | identities | 1 | 67641 | 2 | 2.733 | 24749.7 |
286 | 2024-05-20 12:00:24 | identities | 4 | 161450 | 256 | 20.516 | 7869.5 |
285 | 2024-05-20 04:31:36 | identities | 3 | 140603 | 45 | 15.673 | 8971.0 |
284 | 2024-05-19 20:21:22 | identities | 4 | 161450 | 256 | 37.003 | 4363.2 |
283 | 2024-05-19 20:20:33 | identities | 3 | 140603 | 45 | 22.330 | 6296.6 |
282 | 2024-05-18 19:33:12 | identities | 4 | 161450 | 256 | 26.063 | 6194.6 |
281 | 2024-05-18 00:20:45 | identities | 4 | 161450 | 256 | 14.376 | 11230.5 |
280 | 2024-05-18 00:20:52 | identities | 3 | 140603 | 45 | 7.843 | 17927.2 |
279 | 2024-05-18 00:20:48 | identities | 2 | 108824 | 9 | 11.016 | 9878.7 |
278 | 2024-05-18 00:19:37 | identities | 1 | 67641 | 2 | 3.906 | 17317.2 |
277 | 2024-05-14 05:06:29 | identities | 1 | 67641 | 2 | 1.250 | 54112.8 |
276 | 2024-05-02 19:40:36 | identities | 1 | 67641 | 2 | 2.516 | 26884.3 |
275 | 2024-04-28 03:37:03 | identities | 1 | 67641 | 2 | 2.516 | 26884.3 |
274 | 2024-04-19 00:55:25 | identities | 3 | 140603 | 45 | 13.830 | 10166.5 |
273 | 2024-04-19 00:54:29 | identities | 2 | 108824 | 9 | 12.300 | 8847.5 |
272 | 2024-04-19 00:40:40 | identities | 1 | 67641 | 2 | 1.280 | 52844.5 |
271 | 2024-04-17 23:52:16 | identities | 3 | 140603 | 45 | 13.500 | 10415.0 |
270 | 2024-04-16 13:05:43 | identities | 3 | 140603 | 45 | 12.313 | 11419.1 |
269 | 2024-04-16 12:54:43 | identities | 1 | 67641 | 2 | 1.156 | 58513.0 |
268 | 2024-04-15 20:22:46 | identities | 4 | 161450 | 256 | 35.330 | 4569.8 |
267 | 2024-04-15 20:22:44 | identities | 3 | 140603 | 45 | 22.953 | 6125.7 |
266 | 2024-04-15 18:07:02 | identities | 4 | 161450 | 256 | 28.923 | 5582.1 |
265 | 2024-04-15 18:07:03 | identities | 3 | 140603 | 45 | 20.126 | 6986.1 |
264 | 2024-04-15 18:07:05 | identities | 2 | 108824 | 9 | 13.796 | 7888.1 |
263 | 2024-04-15 18:03:24 | identities | 1 | 67641 | 2 | 1.810 | 37370.7 |
262 | 2024-03-31 09:26:22 | identities | 1 | 67641 | 2 | 1.453 | 46552.6 |
261 | 2024-03-30 11:36:04 | identities | 1 | 67641 | 2 | 1.123 | 60232.4 |
260 | 2024-03-28 05:46:17 | identities | 1 | 67641 | 2 | 1.123 | 60232.4 |
259 | 2024-03-23 11:24:20 | identities | 2 | 108824 | 9 | 10.593 | 10273.2 |
258 | 2024-03-23 09:58:48 | identities | 1 | 67641 | 2 | 1.186 | 57032.9 |
257 | 2024-03-16 04:10:34 | identities | 3 | 140603 | 45 | 22.610 | 6218.6 |
256 | 2024-03-15 16:30:54 | identities | 3 | 140603 | 45 | 25.563 | 5500.3 |
255 | 2024-03-15 02:30:46 | identities | 4 | 161450 | 256 | 38.113 | 4236.1 |
254 | 2024-03-14 03:44:07 | identities | 4 | 161450 | 256 | 33.703 | 4790.4 |
253 | 2024-03-14 03:44:01 | identities | 3 | 140603 | 45 | 22.890 | 6142.6 |
252 | 2024-03-14 03:44:01 | identities | 2 | 108824 | 9 | 9.156 | 11885.5 |
251 | 2024-03-14 03:41:58 | identities | 1 | 67641 | 2 | 2.423 | 27916.2 |
250 | 2024-02-29 03:38:02 | identities | 1 | 67641 | 2 | 2.343 | 28869.4 |
249 | 2024-02-27 04:40:42 | identities | 1 | 67641 | 2 | 2.530 | 26735.6 |
248 | 2024-02-18 04:09:03 | identities | 4 | 161450 | 256 | 15.843 | 10190.6 |
247 | 2024-02-17 04:56:29 | identities | 4 | 161450 | 256 | 23.110 | 6986.2 |
246 | 2024-02-13 11:46:38 | identities | 4 | 161450 | 256 | 27.110 | 5955.4 |
245 | 2024-02-13 11:46:46 | identities | 3 | 140603 | 45 | 16.156 | 8702.8 |
244 | 2024-02-12 14:43:57 | identities | 4 | 161450 | 256 | 32.080 | 5032.7 |
243 | 2024-02-12 14:43:57 | identities | 2 | 108824 | 9 | 7.046 | 15444.8 |
242 | 2024-02-12 14:43:57 | identities | 3 | 140603 | 45 | 8.220 | 17105.0 |
241 | 2024-02-12 13:23:26 | identities | 1 | 67641 | 2 | 2.156 | 31373.4 |
240 | 2024-02-06 16:45:37 | identities | 1 | 67641 | 2 | 1.236 | 54725.7 |
239 | 2024-02-02 10:01:59 | identities | 1 | 67641 | 2 | 1.000 | 67641.0 |
238 | 2024-01-26 03:00:43 | identities | 1 | 67641 | 2 | 1.140 | 59334.2 |
237 | 2024-01-21 11:10:46 | identities | 1 | 67641 | 2 | 1.093 | 61885.6 |
236 | 2024-01-13 07:22:23 | identities | 1 | 67641 | 2 | 2.093 | 32317.7 |
235 | 2023-12-23 04:41:44 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
234 | 2023-11-20 22:56:59 | identities | 1 | 67641 | 2 | 1.033 | 65480.2 |
233 | 2023-11-14 01:23:53 | identities | 1 | 67641 | 2 | 1.156 | 58513.0 |
232 | 2023-10-25 10:42:22 | identities | 1 | 67641 | 2 | 1.140 | 59334.2 |
231 | 2023-10-09 22:11:41 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
230 | 2023-08-06 01:06:41 | identities | 1 | 67641 | 2 | 1.000 | 67641.0 |
229 | 2023-07-15 23:28:40 | identities | 1 | 67641 | 2 | 1.033 | 65480.2 |
228 | 2023-05-07 16:08:41 | identities | 1 | 67641 | 2 | 0.970 | 69733.0 |
227 | 2023-05-03 02:38:50 | identities | 1 | 67641 | 2 | 1.000 | 67641.0 |
226 | 2023-03-24 12:21:50 | identities | 1 | 67641 | 2 | 0.970 | 69733.0 |
225 | 2023-03-19 18:55:42 | identities | 1 | 67641 | 2 | 1.076 | 62863.4 |
224 | 2023-02-22 11:35:22 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
223 | 2022-12-20 23:31:16 | identities | 1 | 67641 | 2 | 1.126 | 60071.9 |
222 | 2022-11-29 18:57:05 | identities | 1 | 67641 | 2 | 0.970 | 69733.0 |
221 | 2022-11-26 12:08:48 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
220 | 2022-08-30 20:09:58 | identities | 1 | 67641 | 2 | 1.000 | 67641.0 |
219 | 2022-07-26 22:07:57 | identities | 1 | 67641 | 2 | 1.110 | 60937.8 |
218 | 2022-07-16 11:37:17 | identities | 4 | 161450 | 256 | 9.763 | 16536.9 |
217 | 2022-05-20 12:35:11 | identities | 1 | 67641 | 2 | 1.063 | 63632.2 |
216 | 2022-04-30 14:30:10 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
215 | 2022-03-25 12:07:11 | identities | 1 | 67641 | 2 | 1.513 | 44706.5 |
214 | 2021-12-04 21:54:02 | identities | 1 | 67641 | 2 | 1.143 | 59178.5 |
213 | 2021-08-25 05:04:42 | identities | 1 | 67641 | 2 | 1.126 | 60071.9 |
212 | 2021-05-24 08:15:11 | identities | 1 | 67641 | 2 | 1.140 | 59334.2 |
211 | 2021-04-16 10:45:06 | identities | 1 | 67641 | 2 | 1.156 | 58513.0 |
210 | 2021-02-22 08:00:51 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
209 | 2021-02-11 07:58:16 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
208 | 2021-01-29 06:12:51 | identities | 1 | 67641 | 2 | 1.096 | 61716.2 |
207 | 2020-12-31 17:13:43 | identities | 1 | 67641 | 2 | 0.983 | 68810.8 |
206 | 2020-11-04 11:07:03 | identities | 1 | 67641 | 2 | 2.170 | 31171.0 |
205 | 2020-08-05 08:54:46 | identities | 1 | 67641 | 2 | 1.030 | 65670.9 |
204 | 2020-08-04 03:24:50 | identities | 1 | 67641 | 2 | 1.140 | 59334.2 |
203 | 2020-08-02 06:46:40 | identities | 1 | 67641 | 2 | 1.110 | 60937.8 |
202 | 2020-07-30 08:07:07 | identities | 1 | 67641 | 2 | 1.076 | 62863.4 |
201 | 2020-07-29 05:25:18 | identities | 1 | 67641 | 2 | 1.156 | 58513.0 |
200 | 2020-07-24 15:17:28 | identities | 1 | 67641 | 2 | 1.046 | 64666.3 |
199 | 2020-05-02 16:10:47 | identities | 1 | 67641 | 2 | 1.080 | 62630.6 |
198 | 2020-03-29 00:51:50 | identities | 1 | 67641 | 2 | 1.203 | 56226.9 |
197 | 2020-03-28 18:14:53 | identities | 1 | 67641 | 2 | 1.126 | 60071.9 |
196 | 2020-03-28 01:41:36 | identities | 1 | 67641 | 2 | 1.233 | 54858.9 |
195 | 2020-03-20 10:26:03 | identities | 1 | 67641 | 2 | 1.080 | 62630.6 |
194 | 2020-02-27 16:46:10 | identities | 4 | 161450 | 256 | 22.796 | 7082.4 |
193 | 2020-02-27 12:47:23 | identities | 4 | 161450 | 256 | 19.313 | 8359.7 |
192 | 2020-02-27 09:35:02 | identities | 4 | 161450 | 256 | 38.126 | 4234.6 |
191 | 2020-02-26 04:35:52 | identities | 1 | 67641 | 2 | 1.236 | 54725.7 |
190 | 2020-02-25 23:03:14 | identities | 4 | 161450 | 256 | 17.406 | 9275.5 |