History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"halfpenny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
224 | 2025-10-07 01:34:12 | halfpenny | 1 | 81242 | 1 | 3.093 | 26266.4 |
223 | 2025-08-09 10:37:32 | halfpenny | 1 | 81242 | 1 | 4.546 | 17871.1 |
222 | 2025-07-25 06:29:27 | halfpenny | 1 | 81242 | 1 | 5.140 | 15805.8 |
221 | 2025-07-25 04:11:27 | halfpenny | 1 | 81242 | 1 | 3.033 | 26786.0 |
220 | 2025-07-24 12:56:44 | halfpenny | 1 | 81242 | 1 | 4.953 | 16402.6 |
219 | 2025-07-24 07:49:45 | halfpenny | 1 | 81242 | 1 | 6.736 | 12060.9 |
218 | 2025-07-07 10:15:20 | halfpenny | 1 | 81242 | 1 | 4.283 | 18968.5 |
217 | 2025-05-29 07:20:12 | halfpenny | 1 | 81242 | 1 | 6.483 | 12531.5 |
216 | 2025-05-19 09:42:05 | halfpenny | 1 | 81242 | 1 | 1.233 | 65889.7 |
215 | 2025-03-25 08:23:01 | halfpenny | 1 | 81242 | 1 | 3.563 | 22801.6 |
214 | 2025-03-08 04:47:09 | halfpenny | 1 | 81242 | 1 | 6.953 | 11684.5 |
213 | 2025-02-19 06:39:43 | halfpenny | 1 | 81242 | 1 | 9.266 | 8767.8 |
212 | 2025-01-16 03:20:33 | halfpenny | 3 | 148641 | 3 | 42.176 | 3524.3 |
211 | 2025-01-16 03:20:26 | halfpenny | 3 | 148641 | 3 | 32.830 | 4527.6 |
210 | 2025-01-16 03:20:27 | halfpenny | 2 | 121436 | 2 | 15.330 | 7921.5 |
209 | 2025-01-16 03:20:15 | halfpenny | 1 | 81242 | 1 | 2.560 | 31735.2 |
208 | 2025-01-16 03:19:05 | halfpenny | 3 | 148641 | 3 | 41.253 | 3603.2 |
207 | 2025-01-15 22:01:59 | halfpenny | 3 | 148641 | 3 | 33.723 | 4407.7 |
206 | 2025-01-15 22:02:14 | halfpenny | 2 | 121436 | 2 | 18.093 | 6711.8 |
205 | 2025-01-15 22:01:32 | halfpenny | 1 | 81242 | 1 | 6.750 | 12035.9 |
204 | 2025-01-10 22:03:02 | halfpenny | 3 | 148641 | 3 | 29.673 | 5009.3 |
203 | 2024-12-25 18:45:47 | halfpenny | 3 | 148641 | 3 | 51.300 | 2897.5 |
202 | 2024-12-23 16:54:18 | halfpenny | 3 | 148641 | 3 | 31.940 | 4653.8 |
201 | 2024-12-09 12:43:32 | halfpenny | 3 | 148641 | 3 | 34.846 | 4265.7 |
200 | 2024-12-09 12:41:45 | halfpenny | 1 | 81242 | 1 | 1.873 | 43375.3 |
199 | 2024-12-01 14:26:47 | halfpenny | 3 | 148641 | 3 | 36.753 | 4044.3 |
198 | 2024-11-28 18:56:45 | halfpenny | 3 | 148641 | 3 | 36.210 | 4105.0 |
197 | 2024-11-21 03:07:00 | halfpenny | 3 | 148641 | 3 | 39.890 | 3726.3 |
196 | 2024-11-19 20:00:17 | halfpenny | 3 | 148641 | 3 | 42.940 | 3461.6 |
195 | 2024-11-19 20:00:25 | halfpenny | 2 | 121436 | 2 | 16.576 | 7326.0 |
194 | 2024-11-19 19:59:40 | halfpenny | 4 | 165329 | 35 | 60.986 | 2710.9 |
193 | 2024-11-19 19:58:22 | halfpenny | 1 | 81242 | 1 | 5.343 | 15205.3 |
192 | 2024-11-08 09:43:01 | halfpenny | 1 | 81242 | 1 | 3.470 | 23412.7 |
191 | 2024-10-29 00:48:09 | halfpenny | 4 | 165329 | 35 | 69.676 | 2372.8 |
190 | 2024-10-21 02:39:19 | halfpenny | 4 | 165329 | 35 | 72.426 | 2282.7 |
189 | 2024-10-16 16:01:28 | halfpenny | 4 | 165329 | 35 | 59.993 | 2755.8 |
188 | 2024-10-16 16:00:51 | halfpenny | 4 | 165329 | 35 | 60.396 | 2737.4 |
187 | 2024-10-16 16:01:24 | halfpenny | 2 | 121436 | 2 | 15.873 | 7650.5 |
186 | 2024-10-16 16:00:19 | halfpenny | 3 | 148641 | 3 | 22.443 | 6623.0 |
185 | 2024-10-16 16:00:29 | halfpenny | 1 | 81242 | 1 | 6.933 | 11718.2 |
184 | 2024-10-14 11:50:28 | halfpenny | 3 | 148641 | 3 | 37.190 | 3996.8 |
183 | 2024-10-06 01:12:41 | halfpenny | 1 | 81242 | 1 | 11.470 | 7083.0 |
182 | 2024-09-12 01:52:45 | halfpenny | 3 | 148641 | 3 | 71.240 | 2086.5 |
181 | 2024-09-09 17:16:22 | halfpenny | 1 | 81242 | 1 | 9.953 | 8162.6 |
180 | 2024-08-25 22:55:06 | halfpenny | 1 | 81242 | 1 | 12.173 | 6674.0 |
179 | 2024-08-04 00:28:54 | halfpenny | 3 | 148641 | 3 | 37.690 | 3943.8 |
178 | 2024-08-04 00:28:49 | halfpenny | 4 | 165329 | 35 | 31.156 | 5306.5 |
177 | 2024-08-04 00:28:58 | halfpenny | 2 | 121436 | 2 | 13.280 | 9144.3 |
176 | 2024-08-04 00:27:46 | halfpenny | 1 | 81242 | 1 | 5.703 | 14245.5 |
175 | 2024-07-21 15:58:19 | halfpenny | 3 | 148641 | 3 | 27.110 | 5482.9 |
174 | 2024-07-21 15:58:21 | halfpenny | 2 | 121436 | 2 | 19.546 | 6212.8 |
173 | 2024-07-21 15:58:04 | halfpenny | 3 | 148641 | 3 | 27.250 | 5454.7 |
172 | 2024-07-21 15:57:58 | halfpenny | 3 | 148641 | 3 | 19.673 | 7555.6 |
171 | 2024-07-21 15:55:12 | halfpenny | 1 | 81242 | 1 | 2.716 | 29912.4 |
170 | 2024-07-16 18:58:27 | halfpenny | 1 | 81242 | 1 | 15.576 | 5215.8 |
169 | 2024-07-08 17:07:02 | halfpenny | 3 | 148641 | 3 | 32.363 | 4592.9 |
168 | 2024-07-08 06:42:13 | halfpenny | 1 | 81242 | 1 | 5.296 | 15340.3 |
167 | 2024-06-22 23:58:46 | halfpenny | 3 | 148641 | 3 | 20.876 | 7120.2 |
166 | 2024-06-22 23:58:44 | halfpenny | 2 | 121436 | 2 | 14.296 | 8494.4 |
165 | 2024-06-16 11:52:15 | halfpenny | 3 | 148641 | 3 | 26.016 | 5713.4 |
164 | 2024-06-16 11:52:15 | halfpenny | 2 | 121436 | 2 | 13.516 | 8984.6 |
163 | 2024-06-16 11:47:21 | halfpenny | 1 | 81242 | 1 | 6.220 | 13061.4 |
162 | 2024-06-12 16:15:30 | halfpenny | 1 | 81242 | 1 | 6.093 | 13333.7 |
161 | 2024-06-12 05:55:39 | halfpenny | 4 | 165329 | 35 | 37.750 | 4379.6 |
160 | 2024-06-12 02:39:53 | halfpenny | 4 | 165329 | 35 | 68.126 | 2426.8 |
159 | 2024-06-11 17:16:27 | halfpenny | 4 | 165329 | 35 | 66.146 | 2499.5 |
158 | 2024-05-26 01:25:29 | halfpenny | 2 | 121436 | 2 | 8.830 | 13752.7 |
157 | 2024-05-26 01:24:56 | halfpenny | 4 | 165329 | 35 | 31.860 | 5189.2 |
156 | 2024-05-26 01:25:05 | halfpenny | 3 | 148641 | 3 | 14.500 | 10251.1 |
155 | 2024-05-26 01:24:35 | halfpenny | 1 | 81242 | 1 | 3.440 | 23616.9 |
154 | 2024-05-21 16:41:57 | halfpenny | 3 | 148641 | 3 | 14.596 | 10183.7 |
153 | 2024-05-21 16:41:59 | halfpenny | 2 | 121436 | 2 | 9.873 | 12299.8 |
152 | 2024-05-21 16:41:25 | halfpenny | 1 | 81242 | 1 | 1.986 | 40907.4 |
151 | 2024-05-07 10:48:39 | halfpenny | 3 | 148641 | 3 | 16.253 | 9145.5 |
150 | 2024-05-07 10:48:43 | halfpenny | 2 | 121436 | 2 | 6.283 | 19327.7 |
149 | 2024-05-07 10:47:59 | halfpenny | 1 | 81242 | 1 | 1.533 | 52995.4 |
148 | 2024-05-03 11:02:00 | halfpenny | 1 | 81242 | 1 | 2.673 | 30393.6 |
147 | 2024-05-03 10:54:09 | halfpenny | 5 | 174418 | 441 | 29.266 | 5959.7 |
146 | 2024-05-03 10:54:13 | halfpenny | 2 | 121436 | 2 | 4.390 | 27662.0 |
145 | 2024-05-03 10:54:05 | halfpenny | 3 | 148641 | 3 | 8.046 | 18473.9 |
144 | 2024-05-03 10:53:41 | halfpenny | 4 | 165329 | 35 | 13.190 | 12534.4 |
143 | 2024-05-03 10:03:17 | halfpenny | 1 | 81242 | 1 | 3.080 | 26377.3 |
142 | 2024-03-03 22:49:18 | halfpenny | 2 | 121436 | 2 | 9.936 | 12221.8 |
141 | 2024-02-25 11:40:11 | halfpenny | 5 | 174418 | 441 | 53.096 | 3285.0 |
140 | 2024-02-23 08:54:00 | halfpenny | 2 | 121436 | 2 | 4.050 | 29984.2 |
139 | 2024-02-23 03:09:50 | halfpenny | 3 | 148641 | 3 | 7.206 | 20627.4 |
138 | 2024-02-22 14:11:31 | halfpenny | 5 | 174418 | 441 | 59.833 | 2915.1 |
137 | 2024-02-22 08:02:18 | halfpenny | 4 | 165329 | 35 | 28.656 | 5769.4 |
136 | 2024-02-22 03:17:40 | halfpenny | 4 | 165329 | 35 | 24.283 | 6808.4 |
135 | 2024-02-22 03:17:41 | halfpenny | 4 | 165329 | 35 | 14.156 | 11679.1 |
134 | 2024-02-21 11:31:32 | halfpenny | 4 | 165329 | 35 | 41.410 | 3992.5 |
133 | 2024-02-20 03:17:33 | halfpenny | 4 | 165329 | 35 | 36.546 | 4523.9 |
132 | 2024-02-18 22:21:23 | halfpenny | 4 | 165329 | 35 | 32.376 | 5106.5 |
131 | 2024-02-18 22:21:32 | halfpenny | 3 | 148641 | 3 | 19.076 | 7792.0 |
130 | 2024-02-18 22:21:24 | halfpenny | 2 | 121436 | 2 | 6.436 | 18868.2 |
129 | 2024-02-18 14:23:48 | halfpenny | 1 | 81242 | 1 | 1.500 | 54161.3 |
128 | 2024-02-18 00:01:55 | halfpenny | 5 | 174418 | 441 | 64.206 | 2716.5 |
127 | 2024-02-16 23:59:45 | halfpenny | 3 | 148641 | 3 | 25.767 | 5768.7 |
126 | 2024-02-16 23:59:41 | halfpenny | 5 | 174418 | 441 | 27.470 | 6349.4 |
125 | 2024-02-16 23:59:42 | halfpenny | 4 | 165329 | 35 | 15.123 | 10932.3 |