History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whatnot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
229 | 2024-04-27 05:42:10 | whatnot | 4 | 151207 | 745 | 11.893 | 12713.9 |
228 | 2024-04-21 09:15:48 | whatnot | 4 | 151207 | 745 | 20.110 | 7519.0 |
227 | 2024-04-20 22:53:07 | whatnot | 4 | 151207 | 745 | 28.470 | 5311.1 |
226 | 2024-04-19 15:12:03 | whatnot | 4 | 151207 | 745 | 25.246 | 5989.3 |
225 | 2024-04-13 03:15:05 | whatnot | 4 | 151207 | 745 | 14.236 | 10621.5 |
224 | 2024-03-31 00:27:53 | whatnot | 1 | 69583 | 2 | 4.313 | 16133.3 |
223 | 2024-03-27 22:08:14 | whatnot | 3 | 134027 | 37 | 6.956 | 19267.8 |
222 | 2024-03-26 17:36:08 | whatnot | 2 | 107671 | 3 | 5.190 | 20745.9 |
221 | 2024-03-26 17:36:04 | whatnot | 3 | 134027 | 37 | 8.330 | 16089.7 |
220 | 2024-03-25 12:15:01 | whatnot | 2 | 107671 | 3 | 3.280 | 32826.5 |
219 | 2024-03-25 12:14:38 | whatnot | 3 | 134027 | 37 | 6.580 | 20368.8 |
218 | 2024-03-25 05:17:25 | whatnot | 4 | 151207 | 745 | 12.326 | 12267.3 |
217 | 2024-03-25 01:24:43 | whatnot | 2 | 107671 | 3 | 2.983 | 36094.9 |
216 | 2024-03-25 01:24:21 | whatnot | 3 | 134027 | 37 | 5.596 | 23950.5 |
215 | 2024-03-22 10:57:51 | whatnot | 4 | 151207 | 745 | 18.280 | 8271.7 |
214 | 2024-03-22 05:07:53 | whatnot | 4 | 151207 | 745 | 13.000 | 11631.3 |
213 | 2024-03-20 18:58:17 | whatnot | 2 | 107671 | 3 | 3.686 | 29210.8 |
212 | 2024-03-20 18:57:44 | whatnot | 3 | 134027 | 37 | 7.296 | 18369.9 |
211 | 2024-03-20 18:57:31 | whatnot | 4 | 151207 | 745 | 20.003 | 7559.2 |
210 | 2024-03-20 02:14:09 | whatnot | 4 | 151207 | 745 | 12.876 | 11743.3 |
209 | 2024-03-20 02:13:53 | whatnot | 4 | 151207 | 745 | 11.563 | 13076.8 |
208 | 2024-03-20 02:14:01 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
207 | 2024-03-20 02:13:54 | whatnot | 3 | 134027 | 37 | 6.763 | 19817.7 |
206 | 2024-03-20 02:13:58 | whatnot | 1 | 69583 | 2 | 1.170 | 59472.6 |
205 | 2024-03-20 02:13:50 | whatnot | 2 | 107671 | 3 | 4.810 | 22384.8 |
204 | 2024-02-29 08:27:50 | whatnot | 1 | 69583 | 2 | 1.253 | 55533.1 |
203 | 2024-02-22 15:10:05 | whatnot | 3 | 134027 | 37 | 7.813 | 17154.4 |
202 | 2024-02-19 03:31:04 | whatnot | 3 | 134027 | 37 | 9.390 | 14273.4 |
201 | 2024-02-17 20:02:14 | whatnot | 3 | 134027 | 37 | 23.750 | 5643.2 |
200 | 2024-02-17 12:37:22 | whatnot | 4 | 151207 | 745 | 10.076 | 15006.6 |
199 | 2024-02-13 15:07:48 | whatnot | 4 | 151207 | 745 | 28.626 | 5282.2 |
198 | 2024-02-11 18:17:41 | whatnot | 4 | 151207 | 745 | 30.673 | 4929.6 |
197 | 2024-02-11 11:51:10 | whatnot | 4 | 151207 | 745 | 21.330 | 7088.9 |
196 | 2024-02-10 13:10:05 | whatnot | 4 | 151207 | 745 | 11.736 | 12884.0 |
195 | 2024-02-10 13:10:05 | whatnot | 3 | 134027 | 37 | 12.266 | 10926.7 |
194 | 2024-02-10 13:10:01 | whatnot | 2 | 107671 | 3 | 3.470 | 31029.1 |
193 | 2024-02-10 12:17:28 | whatnot | 1 | 69583 | 2 | 1.096 | 63488.1 |
192 | 2024-01-03 08:34:55 | whatnot | 1 | 69583 | 2 | 1.046 | 66522.9 |
191 | 2023-12-03 01:59:07 | whatnot | 1 | 69583 | 2 | 1.076 | 64668.2 |
190 | 2023-11-21 12:10:20 | whatnot | 1 | 69583 | 2 | 1.233 | 56433.9 |
189 | 2023-11-03 00:05:48 | whatnot | 1 | 69583 | 2 | 1.033 | 67360.1 |
188 | 2023-10-30 17:36:23 | whatnot | 1 | 69583 | 2 | 1.173 | 59320.5 |
187 | 2023-10-24 20:23:26 | whatnot | 1 | 69583 | 2 | 1.233 | 56433.9 |
186 | 2023-10-17 01:36:11 | whatnot | 1 | 69583 | 2 | 1.296 | 53690.6 |
185 | 2023-09-29 14:55:16 | whatnot | 1 | 69583 | 2 | 1.296 | 53690.6 |
184 | 2023-09-26 12:08:26 | whatnot | 1 | 69583 | 2 | 1.110 | 62687.4 |
183 | 2023-08-18 22:45:02 | whatnot | 1 | 69583 | 2 | 1.140 | 61037.7 |
182 | 2023-05-20 16:25:04 | whatnot | 1 | 69583 | 2 | 1.033 | 67360.1 |
181 | 2022-12-21 19:03:45 | whatnot | 1 | 69583 | 2 | 1.013 | 68690.0 |
180 | 2022-06-30 23:34:21 | whatnot | 1 | 69583 | 2 | 1.033 | 67360.1 |
179 | 2022-01-21 05:18:39 | whatnot | 1 | 69583 | 2 | 1.033 | 67360.1 |
178 | 2022-01-17 22:50:58 | whatnot | 1 | 69583 | 2 | 1.156 | 60192.9 |
177 | 2022-01-14 16:00:09 | whatnot | 1 | 69583 | 2 | 1.173 | 59320.5 |
176 | 2021-09-03 00:29:01 | whatnot | 1 | 69583 | 2 | 1.110 | 62687.4 |
175 | 2021-05-31 00:05:31 | whatnot | 2 | 107671 | 3 | 3.376 | 31893.1 |
174 | 2021-05-05 17:39:42 | whatnot | 2 | 107671 | 3 | 6.720 | 16022.5 |
173 | 2021-05-05 05:02:50 | whatnot | 1 | 69583 | 2 | 1.170 | 59472.6 |
172 | 2021-05-03 03:34:54 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
171 | 2021-04-03 07:49:02 | whatnot | 1 | 69583 | 2 | 1.046 | 66522.9 |
170 | 2021-03-07 19:13:38 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
169 | 2021-02-12 05:03:44 | whatnot | 2 | 107671 | 3 | 2.750 | 39153.1 |
168 | 2021-01-21 06:56:34 | whatnot | 1 | 69583 | 2 | 1.060 | 65644.3 |
167 | 2020-10-29 09:09:38 | whatnot | 1 | 69583 | 2 | 1.720 | 40455.2 |
166 | 2020-10-03 10:41:49 | whatnot | 1 | 69583 | 2 | 1.033 | 67360.1 |
165 | 2020-05-29 08:24:14 | whatnot | 1 | 69583 | 2 | 1.126 | 61796.6 |
164 | 2020-03-28 22:29:06 | whatnot | 1 | 69583 | 2 | 1.016 | 68487.2 |
163 | 2020-03-28 01:19:59 | whatnot | 1 | 69583 | 2 | 1.403 | 49595.9 |
162 | 2020-03-27 17:10:11 | whatnot | 1 | 69583 | 2 | 1.046 | 66522.9 |
161 | 2020-03-22 17:06:47 | whatnot | 1 | 69583 | 2 | 1.140 | 61037.7 |
160 | 2020-03-04 14:47:37 | whatnot | 1 | 69583 | 2 | 1.140 | 61037.7 |
159 | 2020-02-13 16:41:05 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
158 | 2020-02-06 12:09:22 | whatnot | 1 | 69583 | 2 | 1.156 | 60192.9 |
157 | 2020-02-05 08:00:39 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
156 | 2020-02-02 13:56:03 | whatnot | 1 | 69583 | 2 | 1.173 | 59320.5 |
155 | 2020-01-31 00:40:39 | whatnot | 1 | 69583 | 2 | 1.186 | 58670.3 |
154 | 2020-01-27 22:31:49 | whatnot | 1 | 69583 | 2 | 1.876 | 37091.2 |
153 | 2020-01-22 12:30:59 | whatnot | 1 | 69583 | 2 | 3.500 | 19880.9 |
152 | 2020-01-16 02:21:43 | whatnot | 1 | 69583 | 2 | 1.420 | 49002.1 |
151 | 2020-01-04 05:23:42 | whatnot | 1 | 69583 | 2 | 1.233 | 56433.9 |
150 | 2020-01-01 02:21:13 | whatnot | 1 | 69583 | 2 | 1.203 | 57841.2 |
149 | 2019-11-24 08:35:30 | whatnot | 4 | 151207 | 745 | 10.300 | 14680.3 |
148 | 2019-10-26 06:38:57 | whatnot | 1 | 69583 | 2 | 1.216 | 57222.9 |
147 | 2019-10-23 00:41:24 | whatnot | 1 | 69583 | 2 | 1.173 | 59320.5 |
146 | 2019-06-22 15:14:47 | whatnot | 1 | 69583 | 2 | 1.146 | 60718.2 |
145 | 2019-03-18 16:57:07 | whatnot | 4 | 151207 | 745 | 10.880 | 13897.7 |
144 | 2019-02-16 12:29:26 | whatnot | 1 | 69583 | 2 | 1.183 | 58819.1 |
143 | 2019-01-16 00:28:03 | whatnot | 1 | 69583 | 2 | 1.200 | 57985.8 |
142 | 2018-12-18 10:41:18 | whatnot | 1 | 69583 | 2 | 0.993 | 70073.5 |
141 | 2018-12-01 12:56:01 | whatnot | 1 | 69583 | 2 | 1.093 | 63662.4 |
140 | 2018-10-24 02:37:42 | whatnot | 1 | 69583 | 2 | 0.983 | 70786.4 |
139 | 2018-10-22 10:57:01 | whatnot | 1 | 69583 | 2 | 1.010 | 68894.1 |
138 | 2018-10-04 05:20:21 | whatnot | 1 | 69583 | 2 | 1.130 | 61577.9 |
137 | 2018-09-27 14:22:25 | whatnot | 4 | 151207 | 745 | 10.106 | 14962.1 |
136 | 2018-09-19 14:02:08 | whatnot | 4 | 151207 | 745 | 10.360 | 14595.3 |
135 | 2018-09-19 06:07:39 | whatnot | 1 | 69583 | 2 | 1.010 | 68894.1 |
134 | 2018-09-16 05:04:11 | whatnot | 1 | 69583 | 2 | 0.993 | 70073.5 |
133 | 2018-09-15 03:19:55 | whatnot | 4 | 151207 | 745 | 10.856 | 13928.4 |
132 | 2018-09-15 01:50:39 | whatnot | 3 | 134027 | 37 | 5.700 | 23513.5 |
131 | 2018-09-14 15:25:03 | whatnot | 4 | 151207 | 745 | 12.016 | 12583.8 |
130 | 2018-08-31 13:02:23 | whatnot | 1 | 69583 | 2 | 1.110 | 62687.4 |