History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"visitation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
261 | 2024-05-03 04:56:07 | visitation | 1 | 67641 | 2 | 1.093 | 61885.6 |
260 | 2024-05-03 04:55:38 | visitation | 4 | 161450 | 366 | 19.250 | 8387.0 |
259 | 2024-05-03 01:31:57 | visitation | 1 | 67641 | 2 | 1.143 | 59178.5 |
258 | 2024-04-24 17:04:37 | visitation | 1 | 67641 | 2 | 2.453 | 27574.8 |
257 | 2024-04-16 20:08:57 | visitation | 3 | 140603 | 56 | 16.986 | 8277.6 |
256 | 2024-04-16 11:12:13 | visitation | 2 | 108824 | 7 | 11.796 | 9225.5 |
255 | 2024-04-15 16:24:20 | visitation | 3 | 140603 | 56 | 26.893 | 5228.2 |
254 | 2024-04-15 16:24:20 | visitation | 2 | 108824 | 7 | 4.703 | 23139.3 |
253 | 2024-04-15 16:17:28 | visitation | 1 | 67641 | 2 | 1.106 | 61158.2 |
252 | 2024-04-14 11:38:58 | visitation | 2 | 108824 | 7 | 8.453 | 12874.0 |
251 | 2024-04-14 11:14:53 | visitation | 1 | 67641 | 2 | 1.126 | 60071.9 |
250 | 2024-04-07 09:12:28 | visitation | 4 | 161450 | 366 | 37.690 | 4283.6 |
249 | 2024-04-06 05:37:44 | visitation | 1 | 67641 | 2 | 1.123 | 60232.4 |
248 | 2024-04-05 18:26:11 | visitation | 4 | 161450 | 366 | 29.580 | 5458.1 |
247 | 2024-04-03 01:45:56 | visitation | 4 | 161450 | 366 | 28.813 | 5603.4 |
246 | 2024-04-02 12:04:28 | visitation | 4 | 161450 | 366 | 34.673 | 4656.4 |
245 | 2024-04-02 12:04:29 | visitation | 3 | 140603 | 56 | 15.626 | 8998.0 |
244 | 2024-04-02 12:04:29 | visitation | 2 | 108824 | 7 | 10.126 | 10747.0 |
243 | 2024-04-02 12:01:32 | visitation | 1 | 67641 | 2 | 1.156 | 58513.0 |
242 | 2024-03-26 01:00:50 | visitation | 3 | 140603 | 56 | 10.156 | 13844.3 |
241 | 2024-03-24 08:46:47 | visitation | 3 | 140603 | 56 | 10.736 | 13096.4 |
240 | 2024-03-23 13:15:45 | visitation | 3 | 140603 | 56 | 5.313 | 26464.0 |
239 | 2024-03-17 03:15:19 | visitation | 1 | 67641 | 2 | 1.173 | 57665.0 |
238 | 2024-03-14 23:46:36 | visitation | 1 | 67641 | 2 | 2.546 | 26567.6 |
237 | 2024-03-06 04:59:54 | visitation | 2 | 108824 | 7 | 10.720 | 10151.5 |
236 | 2024-03-06 04:57:21 | visitation | 1 | 67641 | 2 | 2.546 | 26567.6 |
235 | 2024-03-06 04:48:35 | visitation | 4 | 161450 | 366 | 18.156 | 8892.4 |
234 | 2024-03-05 01:46:42 | visitation | 3 | 140603 | 56 | 18.110 | 7763.8 |
233 | 2024-03-05 01:42:50 | visitation | 4 | 161450 | 366 | 25.190 | 6409.3 |
232 | 2024-03-05 01:42:50 | visitation | 2 | 108824 | 7 | 7.983 | 13632.0 |
231 | 2024-03-05 00:40:57 | visitation | 1 | 67641 | 2 | 3.720 | 18183.1 |
230 | 2024-03-03 14:53:42 | visitation | 3 | 140603 | 56 | 15.143 | 9285.0 |
229 | 2024-03-02 10:48:47 | visitation | 3 | 140603 | 56 | 22.673 | 6201.3 |
228 | 2024-03-02 10:48:46 | visitation | 2 | 108824 | 7 | 7.466 | 14575.9 |
227 | 2024-03-02 10:41:08 | visitation | 1 | 67641 | 2 | 1.283 | 52721.0 |
226 | 2024-02-25 20:15:19 | visitation | 1 | 67641 | 2 | 1.220 | 55443.4 |
225 | 2024-02-18 08:51:12 | visitation | 2 | 108824 | 7 | 7.250 | 15010.2 |
224 | 2024-02-18 07:22:12 | visitation | 4 | 161450 | 366 | 27.016 | 5976.1 |
223 | 2024-02-16 13:46:49 | visitation | 3 | 140603 | 56 | 23.253 | 6046.7 |
222 | 2024-02-15 08:40:28 | visitation | 3 | 140603 | 56 | 6.843 | 20547.0 |
221 | 2024-02-15 08:40:29 | visitation | 2 | 108824 | 7 | 3.283 | 33147.7 |
220 | 2024-02-15 08:40:20 | visitation | 1 | 67641 | 2 | 1.200 | 56367.5 |
219 | 2024-02-12 00:39:56 | visitation | 4 | 161450 | 366 | 30.250 | 5337.2 |
218 | 2024-02-12 00:40:01 | visitation | 2 | 108824 | 7 | 22.143 | 4914.6 |
217 | 2024-02-12 00:39:58 | visitation | 3 | 140603 | 56 | 10.750 | 13079.3 |
216 | 2024-02-11 17:32:34 | visitation | 1 | 67641 | 2 | 1.093 | 61885.6 |
215 | 2024-02-04 08:03:03 | visitation | 1 | 67641 | 2 | 1.766 | 38301.8 |
214 | 2024-01-31 06:13:23 | visitation | 1 | 67641 | 2 | 1.123 | 60232.4 |
213 | 2024-01-30 22:45:23 | visitation | 1 | 67641 | 2 | 1.156 | 58513.0 |
212 | 2024-01-30 22:45:19 | visitation | 1 | 67641 | 2 | 2.326 | 29080.4 |
211 | 2024-01-20 03:22:06 | visitation | 4 | 161450 | 366 | 9.403 | 17170.1 |
210 | 2024-01-14 09:08:13 | visitation | 2 | 108824 | 7 | 2.656 | 40972.9 |
209 | 2023-12-09 09:03:13 | visitation | 1 | 67641 | 2 | 0.966 | 70021.7 |
208 | 2023-12-05 06:10:56 | visitation | 1 | 67641 | 2 | 2.373 | 28504.4 |
207 | 2023-12-03 01:25:51 | visitation | 1 | 67641 | 2 | 1.156 | 58513.0 |
206 | 2023-12-01 04:21:13 | visitation | 3 | 140603 | 56 | 5.360 | 26231.9 |
205 | 2023-11-29 16:19:26 | visitation | 1 | 67641 | 2 | 1.000 | 67641.0 |
204 | 2023-10-30 08:48:09 | visitation | 4 | 161450 | 366 | 10.486 | 15396.7 |
203 | 2023-10-24 03:10:05 | visitation | 2 | 108824 | 7 | 3.110 | 34991.6 |
202 | 2023-10-05 00:11:19 | visitation | 1 | 67641 | 2 | 0.966 | 70021.7 |
201 | 2023-09-27 21:21:07 | visitation | 1 | 67641 | 2 | 0.983 | 68810.8 |
200 | 2023-09-24 22:32:03 | visitation | 1 | 67641 | 2 | 1.000 | 67641.0 |
199 | 2023-08-30 12:08:11 | visitation | 3 | 140603 | 56 | 5.533 | 25411.7 |
198 | 2023-08-07 08:28:05 | visitation | 4 | 161450 | 366 | 10.626 | 15193.9 |
197 | 2023-08-03 02:23:33 | visitation | 1 | 67641 | 2 | 1.110 | 60937.8 |
196 | 2023-08-02 03:07:11 | visitation | 2 | 108824 | 7 | 2.596 | 41919.9 |
195 | 2023-07-24 12:56:53 | visitation | 1 | 67641 | 2 | 0.970 | 69733.0 |
194 | 2023-05-16 04:27:04 | visitation | 3 | 140603 | 56 | 5.170 | 27195.9 |
193 | 2023-04-23 04:02:38 | visitation | 1 | 67641 | 2 | 0.970 | 69733.0 |
192 | 2023-04-19 03:01:16 | visitation | 4 | 161450 | 366 | 9.296 | 17367.7 |
191 | 2023-04-12 18:57:54 | visitation | 2 | 108824 | 7 | 2.593 | 41968.4 |
190 | 2023-04-10 23:14:19 | visitation | 1 | 67641 | 2 | 1.063 | 63632.2 |
189 | 2023-02-21 23:52:30 | visitation | 3 | 140603 | 56 | 8.110 | 17337.0 |
188 | 2023-02-13 17:30:18 | visitation | 1 | 67641 | 2 | 0.966 | 70021.7 |
187 | 2023-01-22 03:11:22 | visitation | 4 | 161450 | 366 | 10.000 | 16145.0 |
186 | 2023-01-18 17:26:11 | visitation | 2 | 108824 | 7 | 2.530 | 43013.4 |
185 | 2022-12-18 10:37:58 | visitation | 1 | 67641 | 2 | 1.076 | 62863.4 |
184 | 2022-12-10 21:27:27 | visitation | 1 | 67641 | 2 | 0.953 | 70976.9 |
183 | 2022-12-03 18:14:07 | visitation | 3 | 140603 | 56 | 5.203 | 27023.4 |
182 | 2022-11-02 23:16:48 | visitation | 4 | 161450 | 366 | 9.470 | 17048.6 |
181 | 2022-10-30 01:08:53 | visitation | 2 | 108824 | 7 | 2.546 | 42743.1 |
180 | 2022-08-15 01:15:12 | visitation | 1 | 67641 | 2 | 1.016 | 66575.8 |
179 | 2022-08-14 09:28:28 | visitation | 1 | 67641 | 2 | 0.983 | 68810.8 |
178 | 2022-08-12 01:03:01 | visitation | 1 | 67641 | 2 | 1.076 | 62863.4 |
177 | 2022-07-11 08:19:58 | visitation | 3 | 140603 | 56 | 5.516 | 25490.0 |
176 | 2022-06-03 23:40:49 | visitation | 4 | 161450 | 366 | 11.766 | 13721.7 |
175 | 2022-05-26 12:30:41 | visitation | 2 | 108824 | 7 | 2.530 | 43013.4 |
174 | 2022-04-30 02:03:14 | visitation | 1 | 67641 | 2 | 0.983 | 68810.8 |
173 | 2022-04-17 20:01:16 | visitation | 1 | 67641 | 2 | 0.966 | 70021.7 |
172 | 2022-04-15 14:56:10 | visitation | 1 | 67641 | 2 | 1.250 | 54112.8 |
171 | 2021-12-29 16:14:48 | visitation | 1 | 67641 | 2 | 1.250 | 54112.8 |
170 | 2021-09-12 23:00:47 | visitation | 1 | 67641 | 2 | 0.970 | 69733.0 |
169 | 2021-07-02 16:06:14 | visitation | 1 | 67641 | 2 | 1.110 | 60937.8 |
168 | 2021-06-25 10:19:59 | visitation | 1 | 67641 | 2 | 1.000 | 67641.0 |
167 | 2021-06-12 19:16:13 | visitation | 1 | 67641 | 2 | 1.140 | 59334.2 |
166 | 2021-05-17 13:56:20 | visitation | 1 | 67641 | 2 | 1.046 | 64666.3 |
165 | 2021-03-18 12:42:16 | visitation | 1 | 67641 | 2 | 1.000 | 67641.0 |
164 | 2021-03-13 09:42:05 | visitation | 1 | 67641 | 2 | 0.983 | 68810.8 |
163 | 2020-12-30 20:50:38 | visitation | 1 | 67641 | 2 | 1.030 | 65670.9 |
162 | 2020-12-18 10:09:24 | visitation | 2 | 108824 | 7 | 2.673 | 40712.3 |