History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vanward"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
218 | 2024-04-27 17:05:11 | vanward | 1 | 69583 | 3 | 1.390 | 50059.7 |
217 | 2024-04-27 07:25:59 | vanward | 1 | 69583 | 3 | 3.453 | 20151.5 |
216 | 2024-03-30 17:30:10 | vanward | 1 | 69583 | 3 | 4.093 | 17000.5 |
215 | 2024-03-06 23:19:51 | vanward | 3 | 134027 | 125 | 15.330 | 8742.8 |
214 | 2024-03-06 07:00:05 | vanward | 3 | 134027 | 125 | 9.970 | 13443.0 |
213 | 2024-03-05 17:27:59 | vanward | 3 | 134027 | 125 | 11.283 | 11878.7 |
212 | 2024-03-04 12:56:25 | vanward | 3 | 134027 | 125 | 21.720 | 6170.7 |
211 | 2024-03-01 10:00:38 | vanward | 1 | 69583 | 3 | 5.483 | 12690.7 |
210 | 2024-03-01 04:40:25 | vanward | 3 | 134027 | 125 | 6.830 | 19623.3 |
209 | 2024-01-30 08:19:19 | vanward | 1 | 69583 | 3 | 1.266 | 54962.9 |
208 | 2024-01-02 13:15:36 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
207 | 2023-12-30 01:48:01 | vanward | 1 | 69583 | 3 | 1.143 | 60877.5 |
206 | 2023-12-22 18:56:27 | vanward | 1 | 69583 | 3 | 1.296 | 53690.6 |
205 | 2023-11-26 22:40:02 | vanward | 1 | 69583 | 3 | 1.110 | 62687.4 |
204 | 2023-11-23 16:10:46 | vanward | 1 | 69583 | 3 | 1.060 | 65644.3 |
203 | 2023-11-21 16:37:55 | vanward | 3 | 134027 | 125 | 6.890 | 19452.4 |
202 | 2023-11-03 13:42:08 | vanward | 1 | 69583 | 3 | 1.486 | 46825.7 |
201 | 2023-09-29 14:58:03 | vanward | 1 | 69583 | 3 | 1.156 | 60192.9 |
200 | 2023-09-23 23:09:25 | vanward | 1 | 69583 | 3 | 1.076 | 64668.2 |
199 | 2023-09-10 01:13:42 | vanward | 1 | 69583 | 3 | 1.080 | 64428.7 |
198 | 2023-08-22 01:03:55 | vanward | 3 | 134027 | 125 | 5.623 | 23835.5 |
197 | 2023-07-30 17:48:30 | vanward | 1 | 69583 | 3 | 1.060 | 65644.3 |
196 | 2023-06-16 07:24:29 | vanward | 1 | 69583 | 3 | 1.046 | 66522.9 |
195 | 2023-05-05 15:11:33 | vanward | 3 | 134027 | 125 | 5.953 | 22514.2 |
194 | 2023-03-30 21:34:23 | vanward | 1 | 69583 | 3 | 1.140 | 61037.7 |
193 | 2023-03-17 10:13:05 | vanward | 1 | 69583 | 3 | 1.030 | 67556.3 |
192 | 2023-02-10 06:08:37 | vanward | 3 | 134027 | 125 | 5.580 | 24019.2 |
191 | 2023-01-13 12:30:55 | vanward | 1 | 69583 | 3 | 1.110 | 62687.4 |
190 | 2022-11-22 15:10:19 | vanward | 3 | 134027 | 125 | 5.873 | 22820.9 |
189 | 2022-10-30 08:56:49 | vanward | 1 | 69583 | 3 | 1.043 | 66714.3 |
188 | 2022-10-25 03:58:59 | vanward | 1 | 69583 | 3 | 1.046 | 66522.9 |
187 | 2022-06-27 02:41:26 | vanward | 3 | 134027 | 125 | 6.940 | 19312.2 |
186 | 2022-06-18 17:52:47 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
185 | 2022-06-16 13:16:16 | vanward | 1 | 69583 | 3 | 1.080 | 64428.7 |
184 | 2022-06-02 05:50:22 | vanward | 1 | 69583 | 3 | 1.140 | 61037.7 |
183 | 2022-05-30 01:57:04 | vanward | 1 | 69583 | 3 | 1.156 | 60192.9 |
182 | 2022-02-19 16:29:37 | vanward | 1 | 69583 | 3 | 1.170 | 59472.6 |
181 | 2022-02-17 13:28:37 | vanward | 1 | 69583 | 3 | 1.203 | 57841.2 |
180 | 2022-01-05 11:06:50 | vanward | 1 | 69583 | 3 | 1.296 | 53690.6 |
179 | 2021-12-21 12:03:24 | vanward | 1 | 69583 | 3 | 1.233 | 56433.9 |
178 | 2021-09-03 14:23:35 | vanward | 1 | 69583 | 3 | 1.046 | 66522.9 |
177 | 2021-07-28 01:31:22 | vanward | 1 | 69583 | 3 | 1.173 | 59320.5 |
176 | 2021-05-23 21:23:29 | vanward | 1 | 69583 | 3 | 1.203 | 57841.2 |
175 | 2021-05-19 03:14:32 | vanward | 1 | 69583 | 3 | 1.283 | 54234.6 |
174 | 2021-04-19 03:33:09 | vanward | 1 | 69583 | 3 | 1.170 | 59472.6 |
173 | 2021-03-22 00:23:17 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
172 | 2021-01-31 21:11:25 | vanward | 1 | 69583 | 3 | 1.173 | 59320.5 |
171 | 2021-01-26 05:02:13 | vanward | 3 | 134027 | 125 | 6.750 | 19855.9 |
170 | 2021-01-03 19:17:21 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
169 | 2020-11-18 11:41:23 | vanward | 1 | 69583 | 3 | 1.140 | 61037.7 |
168 | 2020-10-26 19:37:45 | vanward | 1 | 69583 | 3 | 1.173 | 59320.5 |
167 | 2020-10-18 17:06:06 | vanward | 1 | 69583 | 3 | 1.076 | 64668.2 |
166 | 2020-10-14 03:46:10 | vanward | 1 | 69583 | 3 | 1.060 | 65644.3 |
165 | 2020-06-20 14:12:08 | vanward | 1 | 69583 | 3 | 1.123 | 61961.7 |
164 | 2020-06-16 21:17:18 | vanward | 1 | 69583 | 3 | 1.096 | 63488.1 |
163 | 2020-03-29 14:56:40 | vanward | 1 | 69583 | 3 | 1.233 | 56433.9 |
162 | 2020-03-29 14:50:26 | vanward | 1 | 69583 | 3 | 1.280 | 54361.7 |
161 | 2020-03-27 10:23:52 | vanward | 1 | 69583 | 3 | 1.033 | 67360.1 |
160 | 2020-03-26 01:28:00 | vanward | 1 | 69583 | 3 | 1.250 | 55666.4 |
159 | 2020-03-24 00:36:53 | vanward | 1 | 69583 | 3 | 2.623 | 26528.0 |
158 | 2020-03-20 21:42:01 | vanward | 1 | 69583 | 3 | 1.076 | 64668.2 |
157 | 2020-03-06 10:18:07 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
156 | 2020-02-25 15:39:41 | vanward | 1 | 69583 | 3 | 1.250 | 55666.4 |
155 | 2020-02-25 13:46:35 | vanward | 1 | 69583 | 3 | 3.160 | 22019.9 |
154 | 2020-02-24 22:06:13 | vanward | 1 | 69583 | 3 | 1.236 | 56296.9 |
153 | 2020-02-11 17:48:35 | vanward | 1 | 69583 | 3 | 3.516 | 19790.4 |
152 | 2020-02-06 07:35:41 | vanward | 1 | 69583 | 3 | 1.140 | 61037.7 |
151 | 2020-02-06 02:10:33 | vanward | 1 | 69583 | 3 | 1.313 | 52995.4 |
150 | 2020-01-30 09:47:51 | vanward | 3 | 134027 | 125 | 12.796 | 10474.1 |
149 | 2020-01-29 23:01:28 | vanward | 3 | 134027 | 125 | 14.423 | 9292.6 |
148 | 2020-01-28 23:22:11 | vanward | 1 | 69583 | 3 | 2.563 | 27149.0 |
147 | 2020-01-27 19:37:26 | vanward | 1 | 69583 | 3 | 1.266 | 54962.9 |
146 | 2020-01-27 11:50:19 | vanward | 1 | 69583 | 3 | 1.310 | 53116.8 |
145 | 2020-01-16 04:14:37 | vanward | 2 | 107671 | 19 | 3.656 | 29450.5 |
144 | 2020-01-16 02:13:01 | vanward | 3 | 134027 | 125 | 6.970 | 19229.1 |
143 | 2020-01-15 22:36:00 | vanward | 2 | 107671 | 19 | 3.890 | 27678.9 |
142 | 2020-01-15 22:35:13 | vanward | 3 | 134027 | 125 | 7.656 | 17506.1 |
141 | 2020-01-15 21:40:59 | vanward | 1 | 69583 | 3 | 1.390 | 50059.7 |
140 | 2020-01-15 07:15:47 | vanward | 1 | 69583 | 3 | 1.673 | 41591.8 |
139 | 2020-01-07 22:47:53 | vanward | 1 | 69583 | 3 | 1.356 | 51314.9 |
138 | 2020-01-07 15:46:52 | vanward | 1 | 69583 | 3 | 1.360 | 51164.0 |
137 | 2020-01-07 04:30:56 | vanward | 1 | 69583 | 3 | 1.140 | 61037.7 |
136 | 2020-01-07 00:38:15 | vanward | 1 | 69583 | 3 | 3.343 | 20814.5 |
135 | 2019-12-29 17:26:31 | vanward | 1 | 69583 | 3 | 1.250 | 55666.4 |
134 | 2019-11-30 14:00:56 | vanward | 1 | 69583 | 3 | 1.170 | 59472.6 |
133 | 2019-09-01 04:19:13 | vanward | 1 | 69583 | 3 | 1.026 | 67819.7 |
132 | 2019-08-29 01:51:07 | vanward | 1 | 69583 | 3 | 0.990 | 70285.9 |
131 | 2019-07-13 08:43:39 | vanward | 1 | 69583 | 3 | 1.166 | 59676.7 |
130 | 2019-06-27 21:31:05 | vanward | 2 | 107671 | 19 | 3.396 | 31705.2 |
129 | 2019-06-27 19:00:20 | vanward | 3 | 134027 | 125 | 6.810 | 19680.9 |
128 | 2019-06-27 02:05:41 | vanward | 1 | 69583 | 3 | 1.063 | 65459.1 |
127 | 2019-05-16 21:58:11 | vanward | 1 | 69583 | 3 | 1.130 | 61577.9 |
126 | 2019-02-08 02:21:45 | vanward | 1 | 69583 | 3 | 1.006 | 69168.0 |
125 | 2019-02-02 20:16:05 | vanward | 1 | 69583 | 3 | 1.020 | 68218.6 |
124 | 2019-01-28 14:24:26 | vanward | 1 | 69583 | 3 | 1.036 | 67165.1 |
123 | 2019-01-23 07:09:29 | vanward | 1 | 69583 | 3 | 1.013 | 68690.0 |
122 | 2019-01-19 10:53:19 | vanward | 1 | 69583 | 3 | 1.203 | 57841.2 |
121 | 2018-11-10 09:02:15 | vanward | 1 | 69583 | 3 | 1.013 | 68690.0 |
120 | 2018-09-17 00:41:19 | vanward | 1 | 69583 | 3 | 1.160 | 59985.3 |
119 | 2018-06-28 00:38:44 | vanward | 1 | 69583 | 3 | 1.356 | 51314.9 |