History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stonecrop"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
221 | 2024-04-27 20:40:43 | stonecrop | 4 | 165329 | 59 | 31.113 | 5313.8 |
220 | 2024-04-27 15:25:25 | stonecrop | 4 | 165329 | 59 | 16.280 | 10155.3 |
219 | 2024-04-27 09:48:03 | stonecrop | 3 | 148641 | 8 | 7.563 | 19653.7 |
218 | 2024-04-27 08:28:26 | stonecrop | 4 | 165329 | 59 | 35.406 | 4669.5 |
217 | 2024-03-28 17:56:33 | stonecrop | 1 | 81242 | 2 | 1.546 | 52549.8 |
216 | 2024-03-26 22:52:25 | stonecrop | 1 | 81242 | 2 | 1.236 | 65729.8 |
215 | 2024-03-10 06:58:56 | stonecrop | 3 | 148641 | 8 | 23.736 | 6262.3 |
214 | 2024-03-10 06:58:34 | stonecrop | 2 | 121436 | 2 | 9.656 | 12576.2 |
213 | 2024-03-10 06:57:57 | stonecrop | 1 | 81242 | 2 | 1.703 | 47705.2 |
212 | 2024-03-08 14:33:40 | stonecrop | 3 | 148641 | 8 | 17.533 | 8477.8 |
211 | 2024-03-08 14:32:56 | stonecrop | 2 | 121436 | 2 | 4.483 | 27088.1 |
210 | 2024-03-08 14:32:07 | stonecrop | 3 | 148641 | 8 | 21.673 | 6858.3 |
209 | 2024-03-08 14:32:04 | stonecrop | 2 | 121436 | 2 | 8.920 | 13613.9 |
208 | 2024-03-08 14:31:02 | stonecrop | 1 | 81242 | 2 | 2.830 | 28707.4 |
207 | 2024-03-08 14:28:34 | stonecrop | 4 | 165329 | 59 | 21.080 | 7842.9 |
206 | 2024-03-05 18:56:16 | stonecrop | 4 | 165329 | 59 | 40.376 | 4094.7 |
205 | 2024-03-02 00:45:14 | stonecrop | 5 | 174418 | 647 | 43.300 | 4028.1 |
204 | 2024-02-27 08:21:44 | stonecrop | 3 | 148641 | 8 | 10.923 | 13608.1 |
203 | 2024-02-25 16:43:09 | stonecrop | 3 | 148641 | 8 | 26.863 | 5533.3 |
202 | 2024-02-25 16:43:07 | stonecrop | 4 | 165329 | 59 | 26.063 | 6343.4 |
201 | 2024-02-25 16:43:17 | stonecrop | 2 | 121436 | 2 | 9.343 | 12997.5 |
200 | 2024-02-25 16:40:39 | stonecrop | 1 | 81242 | 2 | 1.486 | 54671.6 |
199 | 2024-02-25 11:37:12 | stonecrop | 5 | 174418 | 647 | 49.190 | 3545.8 |
198 | 2024-02-21 11:52:27 | stonecrop | 5 | 174418 | 647 | 37.720 | 4624.0 |
197 | 2024-02-20 07:04:06 | stonecrop | 3 | 148641 | 8 | 8.890 | 16720.0 |
196 | 2024-02-20 07:04:02 | stonecrop | 2 | 121436 | 2 | 4.173 | 29100.4 |
195 | 2024-02-19 20:34:08 | stonecrop | 1 | 81242 | 2 | 1.313 | 61875.1 |
194 | 2024-02-19 01:58:04 | stonecrop | 5 | 174418 | 647 | 58.676 | 2972.6 |
193 | 2024-02-19 01:58:02 | stonecrop | 4 | 165329 | 59 | 15.016 | 11010.2 |
192 | 2024-02-18 05:03:45 | stonecrop | 5 | 174418 | 647 | 33.503 | 5206.0 |
191 | 2024-02-18 05:03:45 | stonecrop | 4 | 165329 | 59 | 28.706 | 5759.4 |
190 | 2024-02-18 05:03:40 | stonecrop | 3 | 148641 | 8 | 25.766 | 5768.9 |
189 | 2024-02-18 05:03:41 | stonecrop | 2 | 121436 | 2 | 12.846 | 9453.2 |
188 | 2024-02-18 00:14:13 | stonecrop | 1 | 81242 | 2 | 4.813 | 16879.7 |
187 | 2024-01-31 11:02:58 | stonecrop | 1 | 81242 | 2 | 1.330 | 61084.2 |
186 | 2024-01-06 01:15:11 | stonecrop | 1 | 81242 | 2 | 1.376 | 59042.2 |
185 | 2023-12-21 10:46:55 | stonecrop | 1 | 81242 | 2 | 1.283 | 63321.9 |
184 | 2023-11-20 00:22:50 | stonecrop | 3 | 148641 | 8 | 6.373 | 23323.6 |
183 | 2023-10-31 08:58:43 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
182 | 2023-10-08 00:11:22 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
181 | 2023-09-10 00:15:44 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
180 | 2023-08-19 21:51:43 | stonecrop | 3 | 148641 | 8 | 6.360 | 23371.2 |
179 | 2023-08-05 02:33:41 | stonecrop | 1 | 81242 | 2 | 1.280 | 63470.3 |
178 | 2023-05-05 02:28:47 | stonecrop | 3 | 148641 | 8 | 6.093 | 24395.4 |
177 | 2023-04-30 18:57:27 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
176 | 2023-03-30 15:38:08 | stonecrop | 1 | 81242 | 2 | 1.360 | 59736.8 |
175 | 2023-02-26 08:23:39 | stonecrop | 1 | 81242 | 2 | 1.236 | 65729.8 |
174 | 2023-02-25 19:31:47 | stonecrop | 5 | 174418 | 647 | 16.156 | 10795.9 |
173 | 2023-02-10 04:32:37 | stonecrop | 3 | 148641 | 8 | 6.236 | 23836.0 |
172 | 2023-01-11 21:55:06 | stonecrop | 5 | 174418 | 647 | 16.750 | 10413.0 |
171 | 2022-12-24 04:20:51 | stonecrop | 1 | 81242 | 2 | 1.420 | 57212.7 |
170 | 2022-12-14 18:34:47 | stonecrop | 5 | 174418 | 647 | 17.050 | 10229.8 |
169 | 2022-11-22 09:28:08 | stonecrop | 5 | 174418 | 647 | 17.596 | 9912.4 |
168 | 2022-11-21 05:39:34 | stonecrop | 3 | 148641 | 8 | 6.783 | 21913.8 |
167 | 2022-11-09 15:37:06 | stonecrop | 5 | 174418 | 647 | 20.063 | 8693.5 |
166 | 2022-11-02 03:00:19 | stonecrop | 5 | 174418 | 647 | 22.173 | 7866.2 |
165 | 2022-10-28 07:47:43 | stonecrop | 5 | 174418 | 647 | 16.313 | 10692.0 |
164 | 2022-10-09 23:46:50 | stonecrop | 1 | 81242 | 2 | 1.423 | 57092.1 |
163 | 2022-09-14 11:18:33 | stonecrop | 5 | 174418 | 647 | 17.813 | 9791.6 |
162 | 2022-09-10 22:09:55 | stonecrop | 1 | 81242 | 2 | 1.220 | 66591.8 |
161 | 2022-09-06 08:31:40 | stonecrop | 5 | 174418 | 647 | 17.080 | 10211.8 |
160 | 2022-08-23 06:57:10 | stonecrop | 5 | 174418 | 647 | 17.000 | 10259.9 |
159 | 2022-08-22 07:19:04 | stonecrop | 5 | 174418 | 647 | 17.923 | 9731.5 |
158 | 2022-07-22 03:48:26 | stonecrop | 5 | 174418 | 647 | 15.893 | 10974.5 |
157 | 2022-07-19 03:43:59 | stonecrop | 1 | 81242 | 2 | 1.390 | 58447.5 |
156 | 2022-05-07 22:36:20 | stonecrop | 3 | 148641 | 8 | 6.220 | 23897.3 |
155 | 2022-04-22 02:56:10 | stonecrop | 1 | 81242 | 2 | 1.546 | 52549.8 |
154 | 2022-04-19 23:47:36 | stonecrop | 1 | 81242 | 2 | 2.153 | 37734.3 |
153 | 2022-04-14 04:17:30 | stonecrop | 1 | 81242 | 2 | 1.560 | 52078.2 |
152 | 2021-10-08 10:19:47 | stonecrop | 1 | 81242 | 2 | 1.296 | 62686.7 |
151 | 2021-10-05 04:42:49 | stonecrop | 1 | 81242 | 2 | 1.263 | 64324.6 |
150 | 2021-06-25 02:21:52 | stonecrop | 1 | 81242 | 2 | 1.376 | 59042.2 |
149 | 2021-06-02 01:08:15 | stonecrop | 3 | 148641 | 8 | 7.390 | 20113.8 |
148 | 2021-05-26 17:26:12 | stonecrop | 1 | 81242 | 2 | 1.420 | 57212.7 |
147 | 2021-05-07 18:47:50 | stonecrop | 3 | 148641 | 8 | 7.140 | 20818.1 |
146 | 2021-04-19 16:18:34 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
145 | 2021-04-08 15:07:17 | stonecrop | 4 | 165329 | 59 | 11.516 | 14356.5 |
144 | 2021-04-06 03:57:59 | stonecrop | 3 | 148641 | 8 | 6.500 | 22867.8 |
143 | 2021-02-16 05:36:27 | stonecrop | 4 | 165329 | 59 | 10.690 | 15465.8 |
142 | 2021-02-14 04:30:14 | stonecrop | 3 | 148641 | 8 | 6.296 | 23608.8 |
141 | 2021-02-01 01:39:46 | stonecrop | 1 | 81242 | 2 | 1.376 | 59042.2 |
140 | 2021-01-21 07:56:57 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
139 | 2020-12-22 04:40:39 | stonecrop | 3 | 148641 | 8 | 7.063 | 21045.0 |
138 | 2020-11-08 12:38:58 | stonecrop | 3 | 148641 | 8 | 7.220 | 20587.4 |
137 | 2020-10-28 03:44:06 | stonecrop | 2 | 121436 | 2 | 3.140 | 38673.9 |
136 | 2020-10-05 00:50:17 | stonecrop | 1 | 81242 | 2 | 1.423 | 57092.1 |
135 | 2020-09-21 00:31:21 | stonecrop | 1 | 81242 | 2 | 1.423 | 57092.1 |
134 | 2020-09-04 01:04:16 | stonecrop | 1 | 81242 | 2 | 1.283 | 63321.9 |
133 | 2020-07-29 13:51:06 | stonecrop | 1 | 81242 | 2 | 1.356 | 59913.0 |
132 | 2020-06-21 06:16:11 | stonecrop | 1 | 81242 | 2 | 1.296 | 62686.7 |
131 | 2020-06-20 06:57:46 | stonecrop | 1 | 81242 | 2 | 1.250 | 64993.6 |
130 | 2020-06-14 03:59:00 | stonecrop | 1 | 81242 | 2 | 1.640 | 49537.8 |
129 | 2020-06-13 06:38:54 | stonecrop | 1 | 81242 | 2 | 1.356 | 59913.0 |
128 | 2020-04-28 10:36:30 | stonecrop | 1 | 81242 | 2 | 1.266 | 64172.2 |
127 | 2020-03-27 15:34:59 | stonecrop | 5 | 174418 | 647 | 20.030 | 8707.8 |
126 | 2020-03-27 00:41:44 | stonecrop | 4 | 165329 | 59 | 11.563 | 14298.1 |
125 | 2020-03-26 23:01:32 | stonecrop | 1 | 81242 | 2 | 1.436 | 56575.2 |
124 | 2020-03-26 21:50:31 | stonecrop | 5 | 174418 | 647 | 27.813 | 6271.1 |
123 | 2020-03-26 17:00:13 | stonecrop | 5 | 174418 | 647 | 28.516 | 6116.5 |
122 | 2020-03-26 03:14:24 | stonecrop | 5 | 174418 | 647 | 20.923 | 8336.2 |