History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"forename"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
230 | 2024-04-24 09:02:19 | forename | 4 | 161609 | 728 | 16.326 | 9898.9 |
229 | 2024-04-21 01:13:32 | forename | 1 | 82945 | 3 | 4.376 | 18954.5 |
228 | 2024-04-19 00:18:15 | forename | 3 | 146162 | 91 | 18.923 | 7724.0 |
227 | 2024-04-19 00:18:17 | forename | 2 | 121059 | 9 | 8.780 | 13788.0 |
226 | 2024-04-18 20:32:21 | forename | 1 | 82945 | 3 | 1.373 | 60411.5 |
225 | 2024-04-09 06:57:18 | forename | 4 | 161609 | 728 | 12.376 | 13058.3 |
224 | 2024-04-09 03:13:59 | forename | 1 | 82945 | 3 | 3.470 | 23903.5 |
223 | 2024-04-06 00:41:26 | forename | 4 | 161609 | 728 | 16.420 | 9842.2 |
222 | 2024-04-05 11:39:29 | forename | 1 | 82945 | 3 | 4.470 | 18555.9 |
221 | 2024-04-03 21:37:18 | forename | 4 | 161609 | 728 | 23.876 | 6768.7 |
220 | 2024-04-03 12:57:46 | forename | 4 | 161609 | 728 | 30.610 | 5279.6 |
219 | 2024-04-01 06:17:20 | forename | 1 | 82945 | 3 | 1.610 | 51518.6 |
218 | 2024-04-01 05:53:36 | forename | 4 | 161609 | 728 | 32.940 | 4906.2 |
217 | 2024-03-31 23:40:36 | forename | 4 | 161609 | 728 | 18.830 | 8582.5 |
216 | 2024-03-31 23:40:51 | forename | 1 | 82945 | 3 | 3.296 | 25165.4 |
215 | 2024-03-12 01:47:23 | forename | 2 | 121059 | 9 | 4.330 | 27958.2 |
214 | 2024-03-12 01:47:18 | forename | 3 | 146162 | 91 | 7.593 | 19249.6 |
213 | 2024-03-12 01:47:20 | forename | 2 | 121059 | 9 | 4.250 | 28484.5 |
212 | 2024-03-12 01:47:13 | forename | 1 | 82945 | 3 | 1.500 | 55296.7 |
211 | 2024-03-12 01:47:01 | forename | 3 | 146162 | 91 | 8.576 | 17043.1 |
210 | 2024-03-10 20:06:42 | forename | 3 | 146162 | 91 | 18.080 | 8084.2 |
209 | 2024-03-09 17:36:20 | forename | 3 | 146162 | 91 | 16.313 | 8959.8 |
208 | 2024-03-09 17:36:24 | forename | 2 | 121059 | 9 | 8.890 | 13617.4 |
207 | 2024-03-09 17:19:52 | forename | 1 | 82945 | 3 | 1.283 | 64649.3 |
206 | 2024-03-07 14:51:50 | forename | 1 | 82945 | 3 | 1.376 | 60279.8 |
205 | 2024-03-06 23:12:54 | forename | 4 | 161609 | 728 | 39.046 | 4138.9 |
204 | 2024-03-06 03:41:14 | forename | 1 | 82945 | 3 | 1.640 | 50576.2 |
203 | 2024-03-06 01:47:23 | forename | 4 | 161609 | 728 | 59.456 | 2718.1 |
202 | 2024-03-05 13:23:54 | forename | 1 | 82945 | 3 | 3.046 | 27230.8 |
201 | 2024-03-03 21:14:38 | forename | 4 | 161609 | 728 | 13.503 | 11968.4 |
200 | 2024-02-25 20:35:20 | forename | 4 | 161609 | 728 | 16.063 | 10060.9 |
199 | 2024-02-22 05:08:29 | forename | 4 | 161609 | 728 | 11.923 | 13554.4 |
198 | 2024-02-17 21:08:03 | forename | 4 | 161609 | 728 | 31.003 | 5212.7 |
197 | 2024-01-30 22:44:51 | forename | 2 | 121059 | 9 | 7.653 | 15818.5 |
196 | 2024-01-30 22:44:26 | forename | 3 | 146162 | 91 | 8.060 | 18134.2 |
195 | 2024-01-29 21:03:06 | forename | 4 | 161609 | 728 | 13.003 | 12428.6 |
194 | 2024-01-26 16:00:37 | forename | 4 | 161609 | 728 | 14.673 | 11014.0 |
193 | 2024-01-22 21:21:44 | forename | 1 | 82945 | 3 | 1.610 | 51518.6 |
192 | 2024-01-22 21:19:45 | forename | 4 | 161609 | 728 | 38.690 | 4177.0 |
191 | 2024-01-22 21:19:43 | forename | 3 | 146162 | 91 | 25.063 | 5831.8 |
190 | 2024-01-22 21:19:39 | forename | 2 | 121059 | 9 | 12.140 | 9971.9 |
189 | 2024-01-22 21:17:55 | forename | 4 | 161609 | 728 | 19.096 | 8463.0 |
188 | 2024-01-22 21:17:50 | forename | 2 | 121059 | 9 | 6.986 | 17328.8 |
187 | 2024-01-22 21:17:46 | forename | 3 | 146162 | 91 | 10.080 | 14500.2 |
186 | 2024-01-09 06:52:23 | forename | 2 | 121059 | 9 | 3.313 | 36540.6 |
185 | 2023-12-28 05:29:30 | forename | 1 | 82945 | 3 | 1.296 | 64000.8 |
184 | 2023-12-04 16:14:13 | forename | 1 | 82945 | 3 | 1.356 | 61168.9 |
183 | 2023-11-16 03:24:38 | forename | 1 | 82945 | 3 | 1.280 | 64800.8 |
182 | 2023-11-06 01:47:53 | forename | 1 | 82945 | 3 | 1.356 | 61168.9 |
181 | 2023-11-05 13:44:20 | forename | 1 | 82945 | 3 | 2.766 | 29987.3 |
180 | 2023-10-17 01:03:24 | forename | 2 | 121059 | 9 | 3.813 | 31749.0 |
179 | 2023-10-17 00:45:08 | forename | 1 | 82945 | 3 | 1.280 | 64800.8 |
178 | 2023-10-15 17:35:11 | forename | 1 | 82945 | 3 | 1.423 | 58288.8 |
177 | 2023-08-09 06:56:37 | forename | 1 | 82945 | 3 | 1.266 | 65517.4 |
176 | 2023-07-27 09:32:41 | forename | 2 | 121059 | 9 | 3.216 | 37642.7 |
175 | 2023-07-22 06:40:17 | forename | 1 | 82945 | 3 | 1.423 | 58288.8 |
174 | 2023-05-12 01:53:30 | forename | 1 | 82945 | 3 | 1.420 | 58412.0 |
173 | 2023-05-04 04:27:01 | forename | 1 | 82945 | 3 | 1.390 | 59672.7 |
172 | 2023-04-10 15:07:00 | forename | 1 | 82945 | 3 | 1.280 | 64800.8 |
171 | 2023-04-06 14:11:20 | forename | 2 | 121059 | 9 | 3.250 | 37248.9 |
170 | 2023-03-22 21:58:05 | forename | 1 | 82945 | 3 | 1.436 | 57761.1 |
169 | 2023-03-06 07:42:43 | forename | 1 | 82945 | 3 | 1.390 | 59672.7 |
168 | 2023-01-03 02:04:59 | forename | 2 | 121059 | 9 | 3.110 | 38925.7 |
167 | 2022-12-29 21:12:01 | forename | 1 | 82945 | 3 | 1.250 | 66356.0 |
166 | 2022-12-28 23:47:52 | forename | 1 | 82945 | 3 | 1.250 | 66356.0 |
165 | 2022-09-18 10:20:01 | forename | 1 | 82945 | 3 | 1.266 | 65517.4 |
164 | 2022-09-05 03:31:19 | forename | 2 | 121059 | 9 | 3.140 | 38553.8 |
163 | 2022-09-03 23:41:59 | forename | 1 | 82945 | 3 | 1.250 | 66356.0 |
162 | 2022-07-23 23:23:36 | forename | 4 | 161609 | 728 | 12.003 | 13464.1 |
161 | 2022-07-15 11:47:08 | forename | 4 | 161609 | 728 | 11.190 | 14442.3 |
160 | 2022-06-14 12:04:28 | forename | 1 | 82945 | 3 | 1.266 | 65517.4 |
159 | 2022-05-09 01:54:31 | forename | 1 | 82945 | 3 | 1.420 | 58412.0 |
158 | 2022-04-28 06:35:02 | forename | 1 | 82945 | 3 | 1.250 | 66356.0 |
157 | 2022-04-23 17:46:40 | forename | 1 | 82945 | 3 | 1.453 | 57085.3 |
156 | 2022-01-24 16:29:48 | forename | 1 | 82945 | 3 | 1.470 | 56425.2 |
155 | 2022-01-17 07:06:49 | forename | 1 | 82945 | 3 | 1.406 | 58993.6 |
154 | 2021-12-16 06:06:52 | forename | 1 | 82945 | 3 | 1.440 | 57600.7 |
153 | 2021-11-15 03:09:59 | forename | 1 | 82945 | 3 | 1.280 | 64800.8 |
152 | 2021-10-21 12:43:00 | forename | 1 | 82945 | 3 | 1.406 | 58993.6 |
151 | 2021-10-11 10:08:45 | forename | 1 | 82945 | 3 | 1.390 | 59672.7 |
150 | 2021-07-09 21:50:19 | forename | 1 | 82945 | 3 | 1.516 | 54713.1 |
149 | 2021-06-14 07:43:13 | forename | 4 | 161609 | 728 | 11.706 | 13805.7 |
148 | 2021-05-13 11:36:29 | forename | 1 | 82945 | 3 | 1.403 | 59119.7 |
147 | 2021-04-12 09:50:51 | forename | 1 | 82945 | 3 | 1.390 | 59672.7 |
146 | 2021-04-06 01:18:06 | forename | 1 | 82945 | 3 | 1.266 | 65517.4 |
145 | 2021-04-01 21:11:43 | forename | 1 | 82945 | 3 | 1.500 | 55296.7 |
144 | 2021-03-11 12:06:14 | forename | 4 | 161609 | 728 | 10.750 | 15033.4 |
143 | 2021-02-19 06:57:49 | forename | 1 | 82945 | 3 | 1.376 | 60279.8 |
142 | 2021-02-14 08:00:27 | forename | 4 | 161609 | 728 | 12.453 | 12977.5 |
141 | 2021-01-28 19:27:34 | forename | 1 | 82945 | 3 | 1.453 | 57085.3 |
140 | 2020-12-24 15:18:16 | forename | 1 | 82945 | 3 | 1.296 | 64000.8 |
139 | 2020-11-29 21:45:03 | forename | 4 | 161609 | 728 | 11.453 | 14110.6 |
138 | 2020-10-30 03:38:38 | forename | 1 | 82945 | 3 | 1.373 | 60411.5 |
137 | 2020-10-20 03:24:22 | forename | 1 | 82945 | 3 | 1.313 | 63172.1 |
136 | 2020-09-20 19:06:03 | forename | 1 | 82945 | 3 | 1.420 | 58412.0 |
135 | 2020-06-07 07:12:30 | forename | 1 | 82945 | 3 | 1.326 | 62552.8 |
134 | 2020-03-28 01:00:43 | forename | 1 | 82945 | 3 | 3.110 | 26670.4 |
133 | 2020-03-23 13:10:34 | forename | 1 | 82945 | 3 | 1.406 | 58993.6 |
132 | 2020-03-05 19:05:03 | forename | 1 | 82945 | 3 | 1.533 | 54106.3 |
131 | 2020-02-28 21:42:38 | forename | 1 | 82945 | 3 | 1.626 | 51011.7 |