History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"completing"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
271 | 2024-04-27 07:43:33 | completing | 1 | 67641 | 4 | 1.156 | 58513.0 |
270 | 2024-04-24 15:31:47 | completing | 3 | 140603 | 81 | 15.576 | 9026.9 |
269 | 2024-04-24 12:37:39 | completing | 3 | 140603 | 81 | 13.080 | 10749.5 |
268 | 2024-04-22 10:38:54 | completing | 3 | 140603 | 81 | 12.640 | 11123.7 |
267 | 2024-04-21 20:45:40 | completing | 2 | 108824 | 19 | 12.546 | 8674.0 |
266 | 2024-04-21 20:44:28 | completing | 3 | 140603 | 81 | 16.783 | 8377.7 |
265 | 2024-04-21 20:43:03 | completing | 1 | 67641 | 4 | 3.890 | 17388.4 |
264 | 2024-04-20 08:34:20 | completing | 2 | 108824 | 19 | 2.936 | 37065.4 |
263 | 2024-04-14 09:02:59 | completing | 4 | 161450 | 429 | 11.813 | 13667.1 |
262 | 2024-04-13 12:58:32 | completing | 1 | 67641 | 4 | 1.203 | 56226.9 |
261 | 2024-04-09 18:55:39 | completing | 1 | 67641 | 4 | 1.580 | 42810.8 |
260 | 2024-04-06 11:11:30 | completing | 4 | 161450 | 429 | 31.250 | 5166.4 |
259 | 2024-04-02 19:37:11 | completing | 1 | 67641 | 4 | 4.076 | 16594.9 |
258 | 2024-03-31 17:41:19 | completing | 3 | 140603 | 81 | 28.236 | 4979.6 |
257 | 2024-03-31 17:41:26 | completing | 2 | 108824 | 19 | 11.033 | 9863.5 |
256 | 2024-03-31 15:41:32 | completing | 1 | 67641 | 4 | 1.610 | 42013.0 |
255 | 2024-03-29 02:49:06 | completing | 1 | 67641 | 4 | 1.263 | 53555.8 |
254 | 2024-03-28 19:39:55 | completing | 4 | 161450 | 429 | 35.436 | 4556.1 |
253 | 2024-03-28 19:39:55 | completing | 2 | 108824 | 19 | 11.126 | 9781.1 |
252 | 2024-03-28 19:27:10 | completing | 1 | 67641 | 4 | 1.296 | 52192.1 |
251 | 2024-03-13 02:48:58 | completing | 3 | 140603 | 81 | 20.706 | 6790.4 |
250 | 2024-03-12 18:53:46 | completing | 3 | 140603 | 81 | 22.190 | 6336.3 |
249 | 2024-03-12 18:53:50 | completing | 2 | 108824 | 19 | 10.580 | 10285.8 |
248 | 2024-03-12 12:41:22 | completing | 3 | 140603 | 81 | 18.703 | 7517.7 |
247 | 2024-03-12 12:41:22 | completing | 2 | 108824 | 19 | 7.470 | 14568.1 |
246 | 2024-03-12 12:35:31 | completing | 1 | 67641 | 4 | 1.063 | 63632.2 |
245 | 2024-03-03 16:02:11 | completing | 4 | 161450 | 429 | 40.953 | 3942.3 |
244 | 2024-02-28 12:12:07 | completing | 1 | 67641 | 4 | 1.190 | 56841.2 |
243 | 2024-02-28 00:38:16 | completing | 1 | 67641 | 4 | 1.063 | 63632.2 |
242 | 2024-02-19 04:41:12 | completing | 4 | 161450 | 429 | 19.923 | 8103.7 |
241 | 2024-02-19 04:41:12 | completing | 2 | 108824 | 19 | 7.890 | 13792.6 |
240 | 2024-02-18 18:53:00 | completing | 1 | 67641 | 4 | 1.330 | 50857.9 |
239 | 2024-01-30 07:53:59 | completing | 1 | 67641 | 4 | 1.140 | 59334.2 |
238 | 2024-01-29 11:12:42 | completing | 1 | 67641 | 4 | 2.220 | 30468.9 |
237 | 2024-01-28 12:05:28 | completing | 1 | 67641 | 4 | 1.190 | 56841.2 |
236 | 2024-01-18 04:14:25 | completing | 3 | 140603 | 81 | 5.423 | 25927.2 |
235 | 2023-12-31 13:08:33 | completing | 1 | 67641 | 4 | 1.203 | 56226.9 |
234 | 2023-12-21 10:51:55 | completing | 1 | 67641 | 4 | 1.046 | 64666.3 |
233 | 2023-12-16 17:34:58 | completing | 2 | 108824 | 19 | 5.876 | 18520.1 |
232 | 2023-12-16 12:17:06 | completing | 1 | 67641 | 4 | 1.220 | 55443.4 |
231 | 2023-12-11 19:29:57 | completing | 1 | 67641 | 4 | 1.173 | 57665.0 |
230 | 2023-12-09 06:07:31 | completing | 4 | 161450 | 429 | 10.060 | 16048.7 |
229 | 2023-12-03 12:22:17 | completing | 3 | 140603 | 81 | 7.046 | 19955.0 |
228 | 2023-12-01 05:43:39 | completing | 3 | 140603 | 81 | 6.703 | 20976.1 |
227 | 2023-12-01 05:43:32 | completing | 4 | 161450 | 429 | 11.033 | 14633.4 |
226 | 2023-12-01 05:43:27 | completing | 2 | 108824 | 19 | 2.640 | 41221.2 |
225 | 2023-11-10 14:56:32 | completing | 1 | 67641 | 4 | 1.173 | 57665.0 |
224 | 2023-10-27 17:24:39 | completing | 3 | 140603 | 81 | 5.733 | 24525.2 |
223 | 2023-10-27 13:32:07 | completing | 1 | 67641 | 4 | 1.060 | 63812.3 |
222 | 2023-10-10 04:32:18 | completing | 1 | 67641 | 4 | 1.153 | 58665.2 |
221 | 2023-09-17 15:33:03 | completing | 2 | 108824 | 19 | 3.313 | 32847.6 |
220 | 2023-09-05 02:34:32 | completing | 4 | 161450 | 429 | 10.296 | 15680.8 |
219 | 2023-08-26 12:38:11 | completing | 4 | 161450 | 429 | 11.453 | 14096.7 |
218 | 2023-08-22 11:08:44 | completing | 1 | 67641 | 4 | 1.170 | 57812.8 |
217 | 2023-08-05 18:36:45 | completing | 1 | 67641 | 4 | 1.016 | 66575.8 |
216 | 2023-08-04 21:53:37 | completing | 3 | 140603 | 81 | 6.470 | 21731.5 |
215 | 2023-06-24 07:46:54 | completing | 2 | 108824 | 19 | 2.986 | 36444.7 |
214 | 2023-05-21 21:38:41 | completing | 4 | 161450 | 429 | 9.453 | 17079.2 |
213 | 2023-05-05 01:44:42 | completing | 1 | 67641 | 4 | 1.046 | 64666.3 |
212 | 2023-05-04 08:59:46 | completing | 1 | 67641 | 4 | 1.063 | 63632.2 |
211 | 2023-04-27 15:09:22 | completing | 1 | 67641 | 4 | 1.123 | 60232.4 |
210 | 2023-04-16 15:49:03 | completing | 3 | 140603 | 81 | 5.470 | 25704.4 |
209 | 2023-03-24 00:27:17 | completing | 1 | 67641 | 4 | 1.033 | 65480.2 |
208 | 2023-03-20 01:47:55 | completing | 2 | 108824 | 19 | 2.766 | 39343.5 |
207 | 2023-03-02 19:20:52 | completing | 4 | 161450 | 429 | 10.593 | 15241.2 |
206 | 2023-02-26 13:39:30 | completing | 1 | 67641 | 4 | 1.000 | 67641.0 |
205 | 2023-02-25 23:28:59 | completing | 4 | 161450 | 429 | 9.640 | 16747.9 |
204 | 2023-01-22 01:36:09 | completing | 3 | 140603 | 81 | 5.356 | 26251.5 |
203 | 2023-01-11 14:00:52 | completing | 1 | 67641 | 4 | 1.186 | 57032.9 |
202 | 2022-12-25 02:06:07 | completing | 1 | 67641 | 4 | 1.000 | 67641.0 |
201 | 2022-12-20 11:50:53 | completing | 2 | 108824 | 19 | 3.266 | 33320.3 |
200 | 2022-12-06 20:45:44 | completing | 4 | 161450 | 429 | 10.233 | 15777.4 |
199 | 2022-11-01 20:36:19 | completing | 3 | 140603 | 81 | 5.406 | 26008.7 |
198 | 2022-10-01 07:26:16 | completing | 1 | 67641 | 4 | 1.046 | 64666.3 |
197 | 2022-09-12 18:36:19 | completing | 1 | 67641 | 4 | 1.093 | 61885.6 |
196 | 2022-08-20 05:02:38 | completing | 2 | 108824 | 19 | 2.780 | 39145.3 |
195 | 2022-07-16 19:05:17 | completing | 1 | 67641 | 4 | 1.033 | 65480.2 |
194 | 2022-07-04 04:35:23 | completing | 4 | 161450 | 429 | 9.533 | 16935.9 |
193 | 2022-06-18 15:54:40 | completing | 4 | 161450 | 429 | 9.343 | 17280.3 |
192 | 2022-06-03 00:47:21 | completing | 3 | 140603 | 81 | 8.220 | 17105.0 |
191 | 2022-05-31 18:32:37 | completing | 3 | 140603 | 81 | 5.563 | 25274.7 |
190 | 2022-05-21 12:12:23 | completing | 1 | 67641 | 4 | 1.110 | 60937.8 |
189 | 2022-05-18 02:13:34 | completing | 1 | 67641 | 4 | 1.063 | 63632.2 |
188 | 2022-05-07 23:05:43 | completing | 4 | 161450 | 429 | 11.110 | 14532.0 |
187 | 2022-04-06 16:21:46 | completing | 4 | 161450 | 429 | 10.873 | 14848.7 |
186 | 2022-03-20 04:27:59 | completing | 2 | 108824 | 19 | 2.736 | 39774.9 |
185 | 2022-03-18 18:07:08 | completing | 1 | 67641 | 4 | 1.033 | 65480.2 |
184 | 2022-03-16 13:21:20 | completing | 1 | 67641 | 4 | 1.486 | 45518.8 |
183 | 2022-01-22 05:47:56 | completing | 3 | 140603 | 81 | 6.296 | 22332.1 |
182 | 2022-01-19 21:41:21 | completing | 1 | 67641 | 4 | 1.216 | 55625.8 |
181 | 2022-01-16 15:14:11 | completing | 1 | 67641 | 4 | 1.046 | 64666.3 |
180 | 2022-01-13 08:23:29 | completing | 1 | 67641 | 4 | 1.173 | 57665.0 |
179 | 2022-01-04 03:26:08 | completing | 4 | 161450 | 429 | 9.703 | 16639.2 |
178 | 2021-12-22 13:47:15 | completing | 1 | 67641 | 4 | 1.356 | 49882.7 |
177 | 2021-12-21 21:35:16 | completing | 2 | 108824 | 19 | 3.330 | 32679.9 |
176 | 2021-12-15 22:57:18 | completing | 4 | 161450 | 429 | 9.610 | 16800.2 |
175 | 2021-11-26 17:02:57 | completing | 1 | 67641 | 4 | 1.143 | 59178.5 |
174 | 2021-11-24 16:54:43 | completing | 4 | 161450 | 429 | 10.986 | 14696.0 |
173 | 2021-11-24 07:32:28 | completing | 4 | 161450 | 429 | 10.373 | 15564.4 |
172 | 2021-10-27 12:23:55 | completing | 1 | 67641 | 4 | 1.030 | 65670.9 |