History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sergeancy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
219 | 2024-05-12 14:02:01 | sergeancy | 2 | 121436 | 5 | 7.140 | 17007.8 |
218 | 2024-05-12 13:59:50 | sergeancy | 1 | 81242 | 2 | 2.420 | 33571.1 |
217 | 2024-05-12 05:40:54 | sergeancy | 3 | 148641 | 25 | 19.000 | 7823.2 |
216 | 2024-05-11 23:35:18 | sergeancy | 3 | 148641 | 25 | 13.330 | 11150.9 |
215 | 2024-05-11 23:35:20 | sergeancy | 2 | 121436 | 5 | 9.360 | 12973.9 |
214 | 2024-05-11 23:34:26 | sergeancy | 1 | 81242 | 2 | 1.656 | 49059.2 |
213 | 2024-05-11 17:06:55 | sergeancy | 1 | 81242 | 2 | 3.143 | 25848.6 |
212 | 2024-05-10 21:09:04 | sergeancy | 4 | 165329 | 144 | 37.846 | 4368.5 |
211 | 2024-05-07 13:12:53 | sergeancy | 4 | 165329 | 144 | 20.330 | 8132.3 |
210 | 2024-05-07 01:46:49 | sergeancy | 4 | 165329 | 144 | 37.266 | 4436.5 |
209 | 2024-05-07 01:46:53 | sergeancy | 2 | 121436 | 5 | 11.876 | 10225.3 |
208 | 2024-05-06 19:18:52 | sergeancy | 1 | 81242 | 2 | 1.486 | 54671.6 |
207 | 2024-05-05 04:42:44 | sergeancy | 1 | 81242 | 2 | 1.453 | 55913.3 |
206 | 2024-05-02 11:59:50 | sergeancy | 1 | 81242 | 2 | 3.466 | 23439.7 |
205 | 2024-05-01 23:18:25 | sergeancy | 2 | 121436 | 5 | 4.750 | 25565.5 |
204 | 2024-04-30 08:34:04 | sergeancy | 3 | 148641 | 25 | 14.250 | 10430.9 |
203 | 2024-04-09 22:37:07 | sergeancy | 1 | 81242 | 2 | 1.453 | 55913.3 |
202 | 2024-04-08 08:09:32 | sergeancy | 1 | 81242 | 2 | 2.220 | 36595.5 |
201 | 2024-04-01 04:18:52 | sergeancy | 1 | 81242 | 2 | 3.173 | 25604.2 |
200 | 2024-03-31 22:52:08 | sergeancy | 3 | 148641 | 25 | 29.690 | 5006.4 |
199 | 2024-03-31 22:52:11 | sergeancy | 2 | 121436 | 5 | 4.483 | 27088.1 |
198 | 2024-03-31 22:48:28 | sergeancy | 1 | 81242 | 2 | 1.656 | 49059.2 |
197 | 2024-03-29 07:54:00 | sergeancy | 4 | 165329 | 144 | 24.766 | 6675.6 |
196 | 2024-03-24 17:53:48 | sergeancy | 4 | 165329 | 144 | 16.423 | 10066.9 |
195 | 2024-03-24 17:53:43 | sergeancy | 3 | 148641 | 25 | 14.046 | 10582.4 |
194 | 2024-03-24 17:53:46 | sergeancy | 2 | 121436 | 5 | 4.860 | 24986.8 |
193 | 2024-03-24 17:45:17 | sergeancy | 1 | 81242 | 2 | 1.640 | 49537.8 |
192 | 2024-03-10 17:50:02 | sergeancy | 1 | 81242 | 2 | 1.626 | 49964.3 |
191 | 2024-03-05 16:20:13 | sergeancy | 1 | 81242 | 2 | 1.483 | 54782.2 |
190 | 2024-03-01 16:56:46 | sergeancy | 1 | 81242 | 2 | 3.253 | 24974.5 |
189 | 2024-02-28 01:32:09 | sergeancy | 1 | 81242 | 2 | 1.610 | 50460.9 |
188 | 2024-02-08 11:45:27 | sergeancy | 3 | 148641 | 25 | 27.890 | 5329.5 |
187 | 2024-02-07 23:28:35 | sergeancy | 4 | 165329 | 144 | 30.736 | 5379.0 |
186 | 2024-02-06 16:15:58 | sergeancy | 4 | 165329 | 144 | 29.110 | 5679.5 |
185 | 2024-02-06 16:15:51 | sergeancy | 3 | 148641 | 25 | 22.826 | 6511.9 |
184 | 2024-02-06 16:15:48 | sergeancy | 2 | 121436 | 5 | 9.873 | 12299.8 |
183 | 2024-02-06 03:39:29 | sergeancy | 1 | 81242 | 2 | 1.453 | 55913.3 |
182 | 2024-02-03 21:46:46 | sergeancy | 1 | 81242 | 2 | 1.280 | 63470.3 |
181 | 2024-02-02 11:50:58 | sergeancy | 1 | 81242 | 2 | 1.393 | 58321.6 |
180 | 2024-01-29 01:27:47 | sergeancy | 1 | 81242 | 2 | 1.263 | 64324.6 |
179 | 2024-01-01 22:07:43 | sergeancy | 1 | 81242 | 2 | 1.436 | 56575.2 |
178 | 2023-12-22 11:16:52 | sergeancy | 2 | 121436 | 5 | 3.343 | 36325.5 |
177 | 2023-12-22 10:44:43 | sergeancy | 3 | 148641 | 25 | 6.623 | 22443.2 |
176 | 2023-11-26 03:22:34 | sergeancy | 1 | 81242 | 2 | 1.436 | 56575.2 |
175 | 2023-11-19 03:33:00 | sergeancy | 1 | 81242 | 2 | 1.436 | 56575.2 |
174 | 2023-10-07 21:28:52 | sergeancy | 1 | 81242 | 2 | 1.250 | 64993.6 |
173 | 2023-09-23 19:45:30 | sergeancy | 2 | 121436 | 5 | 3.656 | 33215.5 |
172 | 2023-09-23 07:40:26 | sergeancy | 3 | 148641 | 25 | 6.670 | 22285.0 |
171 | 2023-09-11 02:20:01 | sergeancy | 1 | 81242 | 2 | 1.530 | 53099.3 |
170 | 2023-07-03 04:27:10 | sergeancy | 2 | 121436 | 5 | 3.266 | 37181.9 |
169 | 2023-07-02 21:05:06 | sergeancy | 3 | 148641 | 25 | 7.080 | 20994.5 |
168 | 2023-06-16 04:40:16 | sergeancy | 1 | 81242 | 2 | 1.470 | 55266.7 |
167 | 2023-05-11 23:12:09 | sergeancy | 1 | 81242 | 2 | 1.263 | 64324.6 |
166 | 2023-03-30 14:49:01 | sergeancy | 1 | 81242 | 2 | 1.263 | 64324.6 |
165 | 2023-03-29 03:06:47 | sergeancy | 2 | 121436 | 5 | 3.220 | 37713.0 |
164 | 2023-03-23 21:05:24 | sergeancy | 3 | 148641 | 25 | 6.296 | 23608.8 |
163 | 2023-01-12 22:33:00 | sergeancy | 1 | 81242 | 2 | 1.470 | 55266.7 |
162 | 2022-12-31 02:34:11 | sergeancy | 1 | 81242 | 2 | 1.250 | 64993.6 |
161 | 2022-12-26 11:49:48 | sergeancy | 2 | 121436 | 5 | 3.343 | 36325.5 |
160 | 2022-12-24 10:00:00 | sergeancy | 3 | 148641 | 25 | 6.456 | 23023.7 |
159 | 2022-10-25 12:45:02 | sergeancy | 1 | 81242 | 2 | 1.300 | 62493.8 |
158 | 2022-08-26 12:58:45 | sergeancy | 2 | 121436 | 5 | 3.186 | 38115.5 |
157 | 2022-08-23 13:42:30 | sergeancy | 3 | 148641 | 25 | 6.830 | 21763.0 |
156 | 2022-07-31 01:33:17 | sergeancy | 1 | 81242 | 2 | 1.326 | 61268.5 |
155 | 2022-06-12 12:21:14 | sergeancy | 1 | 81242 | 2 | 1.280 | 63470.3 |
154 | 2022-03-02 07:08:01 | sergeancy | 1 | 81242 | 2 | 1.296 | 62686.7 |
153 | 2022-02-20 02:48:43 | sergeancy | 1 | 81242 | 2 | 1.470 | 55266.7 |
152 | 2021-12-11 09:34:06 | sergeancy | 1 | 81242 | 2 | 1.516 | 53589.7 |
151 | 2021-11-06 03:10:54 | sergeancy | 1 | 81242 | 2 | 1.563 | 51978.2 |
150 | 2021-10-06 20:51:02 | sergeancy | 1 | 81242 | 2 | 1.533 | 52995.4 |
149 | 2021-09-28 22:02:55 | sergeancy | 1 | 81242 | 2 | 1.420 | 57212.7 |
148 | 2021-09-28 03:31:14 | sergeancy | 1 | 81242 | 2 | 1.453 | 55913.3 |
147 | 2021-09-24 14:01:11 | sergeancy | 1 | 81242 | 2 | 1.280 | 63470.3 |
146 | 2021-07-01 02:01:03 | sergeancy | 1 | 81242 | 2 | 1.313 | 61875.1 |
145 | 2021-05-09 08:32:41 | sergeancy | 1 | 81242 | 2 | 1.453 | 55913.3 |
144 | 2021-04-07 21:43:19 | sergeancy | 1 | 81242 | 2 | 1.436 | 56575.2 |
143 | 2021-03-31 02:01:41 | sergeancy | 1 | 81242 | 2 | 1.533 | 52995.4 |
142 | 2021-03-12 04:21:46 | sergeancy | 1 | 81242 | 2 | 1.406 | 57782.4 |
141 | 2021-02-15 16:25:42 | sergeancy | 1 | 81242 | 2 | 1.313 | 61875.1 |
140 | 2021-02-13 08:02:15 | sergeancy | 1 | 81242 | 2 | 1.296 | 62686.7 |
139 | 2020-12-08 07:28:53 | sergeancy | 1 | 81242 | 2 | 1.330 | 61084.2 |
138 | 2020-11-01 17:46:44 | sergeancy | 1 | 81242 | 2 | 2.623 | 30972.9 |
137 | 2020-10-31 13:49:48 | sergeancy | 1 | 81242 | 2 | 1.563 | 51978.2 |
136 | 2020-09-05 06:20:44 | sergeancy | 1 | 81242 | 2 | 1.420 | 57212.7 |
135 | 2020-05-06 12:25:30 | sergeancy | 1 | 81242 | 2 | 1.470 | 55266.7 |
134 | 2020-03-24 18:33:13 | sergeancy | 1 | 81242 | 2 | 1.360 | 59736.8 |
133 | 2020-03-17 11:07:10 | sergeancy | 1 | 81242 | 2 | 1.310 | 62016.8 |
132 | 2020-02-15 12:31:08 | sergeancy | 1 | 81242 | 2 | 2.330 | 34867.8 |
131 | 2020-02-10 00:39:47 | sergeancy | 1 | 81242 | 2 | 1.656 | 49059.2 |
130 | 2020-02-07 01:06:53 | sergeancy | 1 | 81242 | 2 | 1.423 | 57092.1 |
129 | 2020-02-05 12:11:16 | sergeancy | 1 | 81242 | 2 | 2.796 | 29056.5 |
128 | 2020-02-04 10:26:09 | sergeancy | 1 | 81242 | 2 | 1.780 | 45641.6 |
127 | 2020-02-02 06:29:07 | sergeancy | 1 | 81242 | 2 | 1.643 | 49447.4 |
126 | 2020-02-02 03:50:07 | sergeancy | 1 | 81242 | 2 | 3.140 | 25873.2 |
125 | 2020-01-20 07:08:29 | sergeancy | 1 | 81242 | 2 | 1.593 | 50999.4 |
124 | 2020-01-17 08:44:54 | sergeancy | 1 | 81242 | 2 | 1.440 | 56418.1 |
123 | 2020-01-11 11:27:59 | sergeancy | 1 | 81242 | 2 | 1.436 | 56575.2 |
122 | 2020-01-05 04:37:16 | sergeancy | 1 | 81242 | 2 | 1.580 | 51419.0 |
121 | 2019-10-21 05:33:59 | sergeancy | 1 | 81242 | 2 | 1.500 | 54161.3 |
120 | 2019-07-04 09:03:39 | sergeancy | 1 | 81242 | 2 | 1.483 | 54782.2 |