History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"obtect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
245 | 2024-04-20 14:55:34 | obtect | 2 | 82551 | 14 | 3.140 | 26290.1 |
244 | 2024-04-20 14:55:26 | obtect | 3 | 112716 | 185 | 6.843 | 16471.7 |
243 | 2024-04-20 14:55:08 | obtect | 1 | 48755 | 3 | 1.890 | 25796.3 |
242 | 2024-04-06 12:03:03 | obtect | 1 | 48755 | 3 | 0.920 | 52994.6 |
241 | 2024-04-02 22:00:46 | obtect | 3 | 112716 | 185 | 11.313 | 9963.4 |
240 | 2024-04-01 10:59:10 | obtect | 2 | 82551 | 14 | 3.450 | 23927.8 |
239 | 2024-04-01 10:59:03 | obtect | 3 | 112716 | 185 | 6.906 | 16321.5 |
238 | 2024-04-01 10:58:46 | obtect | 1 | 48755 | 3 | 1.970 | 24748.7 |
237 | 2024-03-23 17:11:04 | obtect | 2 | 82551 | 14 | 5.283 | 15625.8 |
236 | 2024-03-23 17:10:49 | obtect | 3 | 112716 | 185 | 5.156 | 21861.1 |
235 | 2024-03-19 19:15:54 | obtect | 2 | 82551 | 14 | 2.390 | 34540.2 |
234 | 2024-03-18 20:23:05 | obtect | 3 | 112716 | 185 | 5.483 | 20557.4 |
233 | 2024-03-18 20:23:07 | obtect | 2 | 82551 | 14 | 2.530 | 32628.9 |
232 | 2024-03-18 20:22:57 | obtect | 1 | 48755 | 3 | 1.830 | 26642.1 |
231 | 2024-03-01 01:26:53 | obtect | 3 | 112716 | 185 | 9.593 | 11749.8 |
230 | 2024-02-22 14:16:02 | obtect | 3 | 112716 | 185 | 13.266 | 8496.6 |
229 | 2024-02-17 06:02:14 | obtect | 3 | 112716 | 185 | 12.640 | 8917.4 |
228 | 2024-02-17 06:02:11 | obtect | 2 | 82551 | 14 | 5.906 | 13977.5 |
227 | 2024-02-17 01:06:02 | obtect | 1 | 48755 | 3 | 0.936 | 52088.7 |
226 | 2024-01-17 11:26:21 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
225 | 2024-01-16 21:02:20 | obtect | 1 | 48755 | 3 | 0.810 | 60191.4 |
224 | 2024-01-11 18:03:17 | obtect | 3 | 112716 | 185 | 5.656 | 19928.6 |
223 | 2024-01-11 18:03:16 | obtect | 2 | 82551 | 14 | 4.923 | 16768.4 |
222 | 2024-01-02 16:47:17 | obtect | 3 | 112716 | 185 | 5.360 | 21029.1 |
221 | 2024-01-02 16:47:14 | obtect | 2 | 82551 | 14 | 2.436 | 33887.9 |
220 | 2023-12-26 05:35:00 | obtect | 1 | 48755 | 3 | 0.783 | 62266.9 |
219 | 2023-11-17 03:02:56 | obtect | 1 | 48755 | 3 | 0.766 | 63648.8 |
218 | 2023-11-13 22:38:28 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
217 | 2023-11-10 17:46:08 | obtect | 1 | 48755 | 3 | 0.813 | 59969.2 |
216 | 2023-10-24 14:44:47 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
215 | 2023-10-16 11:18:21 | obtect | 1 | 48755 | 3 | 0.783 | 62266.9 |
214 | 2023-10-07 12:11:16 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
213 | 2023-09-29 19:05:19 | obtect | 1 | 48755 | 3 | 0.813 | 59969.2 |
212 | 2023-09-12 10:46:13 | obtect | 1 | 48755 | 3 | 0.856 | 56956.8 |
211 | 2023-08-29 16:02:38 | obtect | 1 | 48755 | 3 | 0.783 | 62266.9 |
210 | 2023-08-20 09:50:19 | obtect | 1 | 48755 | 3 | 0.796 | 61250.0 |
209 | 2023-06-02 02:15:36 | obtect | 1 | 48755 | 3 | 0.733 | 66514.3 |
208 | 2023-04-25 08:09:01 | obtect | 1 | 48755 | 3 | 0.843 | 57835.1 |
207 | 2023-03-26 15:45:58 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
206 | 2023-03-05 01:28:41 | obtect | 1 | 48755 | 3 | 0.796 | 61250.0 |
205 | 2023-01-10 08:55:28 | obtect | 1 | 48755 | 3 | 0.720 | 67715.3 |
204 | 2022-12-29 01:28:12 | obtect | 1 | 48755 | 3 | 0.716 | 68093.6 |
203 | 2022-12-15 21:29:25 | obtect | 1 | 48755 | 3 | 0.720 | 67715.3 |
202 | 2022-11-19 09:00:23 | obtect | 1 | 48755 | 3 | 0.813 | 59969.2 |
201 | 2022-10-17 22:52:36 | obtect | 1 | 48755 | 3 | 0.810 | 60191.4 |
200 | 2022-08-21 12:41:07 | obtect | 1 | 48755 | 3 | 1.470 | 33166.7 |
199 | 2022-07-11 10:33:15 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
198 | 2022-06-08 21:17:07 | obtect | 1 | 48755 | 3 | 0.750 | 65006.7 |
197 | 2022-04-20 22:36:40 | obtect | 1 | 48755 | 3 | 0.783 | 62266.9 |
196 | 2022-02-18 16:17:03 | obtect | 1 | 48755 | 3 | 1.016 | 47987.2 |
195 | 2022-02-08 02:56:13 | obtect | 1 | 48755 | 3 | 0.750 | 65006.7 |
194 | 2021-12-29 10:45:09 | obtect | 1 | 48755 | 3 | 0.906 | 53813.5 |
193 | 2021-12-12 03:55:54 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
192 | 2021-10-19 08:50:10 | obtect | 1 | 48755 | 3 | 0.736 | 66243.2 |
191 | 2021-09-30 16:26:00 | obtect | 1 | 48755 | 3 | 1.456 | 33485.6 |
190 | 2021-09-28 12:31:48 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
189 | 2021-09-15 22:03:28 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
188 | 2021-09-12 10:16:21 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
187 | 2021-09-05 09:48:32 | obtect | 1 | 48755 | 3 | 0.733 | 66514.3 |
186 | 2021-08-26 23:46:10 | obtect | 1 | 48755 | 3 | 0.733 | 66514.3 |
185 | 2021-08-14 17:20:03 | obtect | 1 | 48755 | 3 | 0.766 | 63648.8 |
184 | 2021-07-20 11:52:24 | obtect | 1 | 48755 | 3 | 0.733 | 66514.3 |
183 | 2021-06-29 21:52:20 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
182 | 2021-06-12 12:50:24 | obtect | 1 | 48755 | 3 | 1.000 | 48755.0 |
181 | 2021-06-07 08:52:28 | obtect | 1 | 48755 | 3 | 0.906 | 53813.5 |
180 | 2021-05-17 09:52:57 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
179 | 2021-04-30 02:58:02 | obtect | 1 | 48755 | 3 | 0.763 | 63899.1 |
178 | 2021-04-26 22:22:39 | obtect | 1 | 48755 | 3 | 0.953 | 51159.5 |
177 | 2021-03-13 02:48:11 | obtect | 1 | 48755 | 3 | 0.830 | 58741.0 |
176 | 2021-01-13 02:34:49 | obtect | 1 | 48755 | 3 | 0.733 | 66514.3 |
175 | 2020-12-06 00:30:02 | obtect | 1 | 48755 | 3 | 0.750 | 65006.7 |
174 | 2020-11-03 17:17:18 | obtect | 1 | 48755 | 3 | 0.750 | 65006.7 |
173 | 2020-10-31 16:07:27 | obtect | 1 | 48755 | 3 | 1.500 | 32503.3 |
172 | 2020-10-17 07:08:16 | obtect | 1 | 48755 | 3 | 1.623 | 30040.0 |
171 | 2020-09-30 10:09:06 | obtect | 1 | 48755 | 3 | 0.873 | 55847.7 |
170 | 2020-08-21 10:35:58 | obtect | 1 | 48755 | 3 | 0.826 | 59025.4 |
169 | 2020-07-22 14:02:01 | obtect | 1 | 48755 | 3 | 0.766 | 63648.8 |
168 | 2020-07-10 15:45:11 | obtect | 1 | 48755 | 3 | 0.780 | 62506.4 |
167 | 2020-05-10 22:26:01 | obtect | 1 | 48755 | 3 | 0.750 | 65006.7 |
166 | 2020-04-20 07:59:10 | obtect | 1 | 48755 | 3 | 0.843 | 57835.1 |
165 | 2020-03-28 18:56:30 | obtect | 1 | 48755 | 3 | 0.843 | 57835.1 |
164 | 2020-03-28 14:47:43 | obtect | 1 | 48755 | 3 | 0.860 | 56691.9 |
163 | 2020-03-24 11:40:53 | obtect | 1 | 48755 | 3 | 1.656 | 29441.4 |
162 | 2020-03-23 18:53:30 | obtect | 1 | 48755 | 3 | 0.780 | 62506.4 |
161 | 2020-03-19 22:54:49 | obtect | 1 | 48755 | 3 | 0.766 | 63648.8 |
160 | 2020-03-18 22:53:44 | obtect | 1 | 48755 | 3 | 0.843 | 57835.1 |
159 | 2020-02-25 23:41:47 | obtect | 1 | 48755 | 3 | 0.950 | 51321.1 |
158 | 2020-02-25 20:21:30 | obtect | 1 | 48755 | 3 | 0.873 | 55847.7 |
157 | 2020-02-22 22:28:57 | obtect | 1 | 48755 | 3 | 0.923 | 52822.3 |
156 | 2020-02-21 03:23:01 | obtect | 1 | 48755 | 3 | 1.140 | 42767.5 |
155 | 2020-02-10 00:37:35 | obtect | 1 | 48755 | 3 | 2.110 | 23106.6 |
154 | 2020-02-07 02:09:29 | obtect | 1 | 48755 | 3 | 0.826 | 59025.4 |
153 | 2020-02-07 01:50:27 | obtect | 1 | 48755 | 3 | 1.220 | 39963.1 |
152 | 2020-01-30 11:45:37 | obtect | 1 | 48755 | 3 | 0.720 | 67715.3 |
151 | 2020-01-28 02:11:18 | obtect | 1 | 48755 | 3 | 1.843 | 26454.2 |
150 | 2020-01-27 12:14:43 | obtect | 1 | 48755 | 3 | 0.936 | 52088.7 |
149 | 2020-01-24 17:46:58 | obtect | 1 | 48755 | 3 | 2.080 | 23439.9 |
148 | 2020-01-18 09:43:47 | obtect | 1 | 48755 | 3 | 1.873 | 26030.4 |
147 | 2020-01-14 03:32:21 | obtect | 1 | 48755 | 3 | 1.000 | 48755.0 |
146 | 2020-01-08 08:44:50 | obtect | 1 | 48755 | 3 | 2.313 | 21078.7 |