History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harlequin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
228 | 2024-06-03 10:51:10 | harlequin | 5 | 174418 | 658 | 20.890 | 8349.4 |
227 | 2024-05-27 10:42:42 | harlequin | 1 | 81242 | 2 | 3.606 | 22529.7 |
226 | 2024-05-25 21:43:42 | harlequin | 2 | 121436 | 2 | 13.626 | 8912.1 |
225 | 2024-05-25 21:43:27 | harlequin | 1 | 81242 | 2 | 1.576 | 51549.5 |
224 | 2024-05-25 04:10:24 | harlequin | 3 | 148641 | 8 | 22.093 | 6728.0 |
223 | 2024-05-25 03:06:04 | harlequin | 5 | 174418 | 658 | 46.080 | 3785.1 |
222 | 2024-05-24 14:07:34 | harlequin | 5 | 174418 | 658 | 34.470 | 5060.0 |
221 | 2024-05-24 11:19:12 | harlequin | 5 | 174418 | 658 | 70.973 | 2457.5 |
220 | 2024-05-24 11:19:15 | harlequin | 3 | 148641 | 8 | 27.983 | 5311.8 |
219 | 2024-05-24 11:19:14 | harlequin | 2 | 121436 | 2 | 9.563 | 12698.5 |
218 | 2024-05-24 11:19:10 | harlequin | 1 | 81242 | 2 | 4.063 | 19995.6 |
217 | 2024-05-23 21:22:01 | harlequin | 3 | 148641 | 8 | 19.173 | 7752.6 |
216 | 2024-05-23 21:21:58 | harlequin | 2 | 121436 | 2 | 7.940 | 15294.2 |
215 | 2024-05-23 21:21:30 | harlequin | 4 | 165329 | 57 | 24.986 | 6616.9 |
214 | 2024-05-23 21:21:20 | harlequin | 4 | 165329 | 57 | 32.330 | 5113.8 |
213 | 2024-05-23 21:20:54 | harlequin | 1 | 81242 | 2 | 2.640 | 30773.5 |
212 | 2024-05-21 20:52:47 | harlequin | 3 | 148641 | 8 | 16.486 | 9016.2 |
211 | 2024-05-21 20:52:49 | harlequin | 2 | 121436 | 2 | 12.436 | 9764.9 |
210 | 2024-05-21 20:52:39 | harlequin | 1 | 81242 | 2 | 1.593 | 50999.4 |
209 | 2024-05-15 07:38:31 | harlequin | 4 | 165329 | 57 | 44.143 | 3745.3 |
208 | 2024-05-12 15:59:49 | harlequin | 4 | 165329 | 57 | 39.036 | 4235.3 |
207 | 2024-05-11 03:33:11 | harlequin | 2 | 121436 | 2 | 9.593 | 12658.8 |
206 | 2024-05-11 03:31:53 | harlequin | 1 | 81242 | 2 | 3.326 | 24426.3 |
205 | 2024-05-11 00:14:13 | harlequin | 3 | 148641 | 8 | 9.890 | 15029.4 |
204 | 2024-05-08 18:07:06 | harlequin | 3 | 148641 | 8 | 6.686 | 22231.7 |
203 | 2024-05-08 15:27:52 | harlequin | 4 | 165329 | 57 | 55.283 | 2990.6 |
202 | 2024-05-03 19:03:18 | harlequin | 4 | 165329 | 57 | 22.676 | 7290.9 |
201 | 2024-05-03 17:12:10 | harlequin | 5 | 174418 | 658 | 19.640 | 8880.8 |
200 | 2024-05-02 02:10:36 | harlequin | 2 | 121436 | 2 | 3.860 | 31460.1 |
199 | 2024-05-01 07:42:58 | harlequin | 3 | 148641 | 8 | 7.423 | 20024.4 |
198 | 2024-04-26 20:59:28 | harlequin | 3 | 148641 | 8 | 12.016 | 12370.3 |
197 | 2024-04-26 20:52:59 | harlequin | 2 | 121436 | 2 | 15.893 | 7640.8 |
196 | 2024-04-26 18:27:21 | harlequin | 1 | 81242 | 2 | 1.423 | 57092.1 |
195 | 2024-04-19 02:33:34 | harlequin | 4 | 165329 | 57 | 14.140 | 11692.3 |
194 | 2024-04-16 17:11:50 | harlequin | 2 | 121436 | 2 | 11.690 | 10388.0 |
193 | 2024-04-16 17:11:15 | harlequin | 1 | 81242 | 2 | 3.123 | 26014.1 |
192 | 2024-04-16 17:03:42 | harlequin | 4 | 165329 | 57 | 44.190 | 3741.3 |
191 | 2024-04-16 08:35:09 | harlequin | 3 | 148641 | 8 | 16.266 | 9138.1 |
190 | 2024-04-15 15:07:39 | harlequin | 2 | 121436 | 2 | 8.623 | 14082.8 |
189 | 2024-04-15 15:04:57 | harlequin | 1 | 81242 | 2 | 2.720 | 29868.4 |
188 | 2024-04-15 12:00:13 | harlequin | 2 | 121436 | 2 | 14.860 | 8172.0 |
187 | 2024-04-15 11:59:44 | harlequin | 1 | 81242 | 2 | 3.733 | 21763.2 |
186 | 2024-04-15 07:56:33 | harlequin | 3 | 148641 | 8 | 11.720 | 12682.7 |
185 | 2024-04-14 14:23:47 | harlequin | 5 | 174418 | 658 | 68.786 | 2535.7 |
184 | 2024-04-14 00:04:08 | harlequin | 3 | 148641 | 8 | 20.906 | 7110.0 |
183 | 2024-04-13 18:28:03 | harlequin | 5 | 174418 | 658 | 39.690 | 4394.5 |
182 | 2024-04-12 05:38:32 | harlequin | 5 | 174418 | 658 | 45.863 | 3803.0 |
181 | 2024-04-12 05:18:38 | harlequin | 5 | 174418 | 658 | 60.016 | 2906.2 |
180 | 2024-04-12 05:18:39 | harlequin | 3 | 148641 | 8 | 31.300 | 4748.9 |
179 | 2024-04-12 05:18:41 | harlequin | 2 | 121436 | 2 | 9.063 | 13399.1 |
178 | 2024-04-12 05:18:19 | harlequin | 1 | 81242 | 2 | 3.076 | 26411.6 |
177 | 2024-04-11 11:43:04 | harlequin | 1 | 81242 | 2 | 2.296 | 35384.1 |
176 | 2024-04-11 09:44:30 | harlequin | 2 | 121436 | 2 | 4.156 | 29219.4 |
175 | 2024-04-08 08:45:58 | harlequin | 4 | 165329 | 57 | 28.610 | 5778.7 |
174 | 2024-04-03 08:25:32 | harlequin | 4 | 165329 | 57 | 19.563 | 8451.1 |
173 | 2024-04-02 20:13:55 | harlequin | 4 | 165329 | 57 | 10.953 | 15094.4 |
172 | 2024-03-25 20:23:01 | harlequin | 3 | 148641 | 8 | 8.983 | 16546.9 |
171 | 2024-03-25 20:22:48 | harlequin | 2 | 121436 | 2 | 6.003 | 20229.2 |
170 | 2024-03-25 18:33:05 | harlequin | 1 | 81242 | 2 | 1.483 | 54782.2 |
169 | 2024-03-14 15:16:00 | harlequin | 4 | 165329 | 57 | 16.703 | 9898.2 |
168 | 2024-03-14 15:05:26 | harlequin | 3 | 148641 | 8 | 27.203 | 5464.1 |
167 | 2024-03-13 03:30:32 | harlequin | 4 | 165329 | 57 | 26.876 | 6151.5 |
166 | 2024-03-11 12:54:09 | harlequin | 1 | 81242 | 2 | 1.796 | 45235.0 |
165 | 2024-03-11 12:53:57 | harlequin | 2 | 121436 | 2 | 7.046 | 17234.7 |
164 | 2024-03-11 12:51:58 | harlequin | 3 | 148641 | 8 | 18.656 | 7967.5 |
163 | 2024-03-08 16:04:19 | harlequin | 2 | 121436 | 2 | 11.546 | 10517.6 |
162 | 2024-03-08 16:00:47 | harlequin | 1 | 81242 | 2 | 2.393 | 33949.9 |
161 | 2024-03-08 15:57:02 | harlequin | 4 | 165329 | 57 | 30.393 | 5439.7 |
160 | 2024-03-06 20:57:33 | harlequin | 4 | 165329 | 57 | 30.626 | 5398.3 |
159 | 2024-03-06 20:57:32 | harlequin | 5 | 174418 | 658 | 24.423 | 7141.5 |
158 | 2024-03-06 20:57:34 | harlequin | 3 | 148641 | 8 | 18.220 | 8158.1 |
157 | 2024-03-06 20:57:37 | harlequin | 2 | 121436 | 2 | 13.190 | 9206.7 |
156 | 2024-03-06 18:28:47 | harlequin | 1 | 81242 | 2 | 1.300 | 62493.8 |
155 | 2024-03-01 00:19:20 | harlequin | 1 | 81242 | 2 | 1.313 | 61875.1 |
154 | 2024-02-29 18:15:17 | harlequin | 1 | 81242 | 2 | 1.436 | 56575.2 |
153 | 2024-02-19 01:00:41 | harlequin | 1 | 81242 | 2 | 3.140 | 25873.2 |
152 | 2024-02-10 13:44:38 | harlequin | 4 | 165329 | 57 | 22.660 | 7296.1 |
151 | 2024-02-10 03:18:35 | harlequin | 4 | 165329 | 57 | 26.643 | 6205.3 |
150 | 2024-02-10 03:18:20 | harlequin | 3 | 148641 | 8 | 18.576 | 8001.8 |
149 | 2024-01-30 21:07:47 | harlequin | 1 | 81242 | 2 | 1.220 | 66591.8 |
148 | 2024-01-27 10:52:11 | harlequin | 1 | 81242 | 2 | 2.500 | 32496.8 |
147 | 2024-01-27 10:48:23 | harlequin | 1 | 81242 | 2 | 2.796 | 29056.5 |
146 | 2024-01-08 23:59:18 | harlequin | 1 | 81242 | 2 | 1.500 | 54161.3 |
145 | 2023-12-27 23:25:46 | harlequin | 1 | 81242 | 2 | 1.390 | 58447.5 |
144 | 2023-12-23 04:26:14 | harlequin | 3 | 148641 | 8 | 6.550 | 22693.3 |
143 | 2023-12-14 13:35:46 | harlequin | 1 | 81242 | 2 | 2.466 | 32944.8 |
142 | 2023-12-11 06:48:49 | harlequin | 2 | 121436 | 2 | 3.110 | 39046.9 |
141 | 2023-12-08 09:09:44 | harlequin | 4 | 165329 | 57 | 12.143 | 13615.2 |
140 | 2023-11-02 02:29:10 | harlequin | 1 | 81242 | 2 | 2.830 | 28707.4 |
139 | 2023-10-18 22:03:24 | harlequin | 1 | 81242 | 2 | 1.220 | 66591.8 |
138 | 2023-10-04 01:26:05 | harlequin | 1 | 81242 | 2 | 1.233 | 65889.7 |
137 | 2023-09-23 04:26:36 | harlequin | 3 | 148641 | 8 | 6.610 | 22487.3 |
136 | 2023-09-09 06:15:41 | harlequin | 2 | 121436 | 2 | 3.173 | 38271.7 |
135 | 2023-09-06 02:29:11 | harlequin | 4 | 165329 | 57 | 11.763 | 14055.0 |
134 | 2023-08-14 20:49:05 | harlequin | 1 | 81242 | 2 | 1.393 | 58321.6 |
133 | 2023-08-06 09:16:33 | harlequin | 1 | 81242 | 2 | 1.216 | 66810.9 |
132 | 2023-07-02 00:34:04 | harlequin | 3 | 148641 | 8 | 6.500 | 22867.8 |
131 | 2023-06-05 18:37:16 | harlequin | 2 | 121436 | 2 | 3.563 | 34082.5 |
130 | 2023-05-21 00:00:04 | harlequin | 4 | 165329 | 57 | 12.046 | 13724.8 |
129 | 2023-05-15 15:01:14 | harlequin | 1 | 81242 | 2 | 1.296 | 62686.7 |