History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reservoir"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
214 | 2024-05-03 18:30:37 | reservoir | 4 | 165329 | 92 | 21.846 | 7567.9 |
213 | 2024-05-02 13:28:00 | reservoir | 3 | 148641 | 13 | 8.250 | 18017.1 |
212 | 2024-05-02 13:27:51 | reservoir | 4 | 165329 | 92 | 13.906 | 11889.0 |
211 | 2024-05-02 13:27:47 | reservoir | 4 | 165329 | 92 | 14.483 | 11415.4 |
210 | 2024-05-02 13:27:55 | reservoir | 2 | 121436 | 3 | 5.733 | 21181.9 |
209 | 2024-05-02 13:27:51 | reservoir | 1 | 81242 | 2 | 1.610 | 50460.9 |
208 | 2024-05-02 13:27:19 | reservoir | 1 | 81242 | 2 | 1.436 | 56575.2 |
207 | 2024-04-09 11:46:39 | reservoir | 3 | 148641 | 13 | 21.970 | 6765.6 |
206 | 2024-04-08 12:38:38 | reservoir | 3 | 148641 | 13 | 19.143 | 7764.8 |
205 | 2024-04-08 12:38:36 | reservoir | 2 | 121436 | 3 | 6.826 | 17790.2 |
204 | 2024-04-08 12:36:38 | reservoir | 1 | 81242 | 2 | 1.403 | 57905.9 |
203 | 2024-03-30 10:49:25 | reservoir | 1 | 81242 | 2 | 1.530 | 53099.3 |
202 | 2024-03-28 17:18:36 | reservoir | 3 | 148641 | 13 | 22.813 | 6515.6 |
201 | 2024-03-28 17:18:34 | reservoir | 2 | 121436 | 3 | 10.860 | 11182.0 |
200 | 2024-03-28 17:11:58 | reservoir | 1 | 81242 | 2 | 1.596 | 50903.5 |
199 | 2024-03-20 11:39:47 | reservoir | 4 | 165329 | 92 | 40.923 | 4040.0 |
198 | 2024-03-16 19:47:14 | reservoir | 3 | 148641 | 13 | 14.610 | 10173.9 |
197 | 2024-03-16 19:47:13 | reservoir | 2 | 121436 | 3 | 4.390 | 27662.0 |
196 | 2024-03-16 19:45:31 | reservoir | 1 | 81242 | 2 | 3.126 | 25989.1 |
195 | 2024-03-15 17:26:52 | reservoir | 4 | 165329 | 92 | 38.813 | 4259.6 |
194 | 2024-03-15 12:44:52 | reservoir | 4 | 165329 | 92 | 26.970 | 6130.1 |
193 | 2024-03-15 12:44:49 | reservoir | 3 | 148641 | 13 | 19.516 | 7616.4 |
192 | 2024-03-15 12:44:47 | reservoir | 2 | 121436 | 3 | 13.296 | 9133.3 |
191 | 2024-03-15 12:16:18 | reservoir | 1 | 81242 | 2 | 1.343 | 60492.9 |
190 | 2024-03-15 00:20:33 | reservoir | 5 | 174418 | 942 | 38.360 | 4546.9 |
189 | 2024-03-14 20:06:10 | reservoir | 5 | 174418 | 942 | 71.770 | 2430.2 |
188 | 2024-03-14 17:48:19 | reservoir | 5 | 174418 | 942 | 69.250 | 2518.7 |
187 | 2024-03-14 05:01:00 | reservoir | 4 | 165329 | 92 | 14.813 | 11161.1 |
186 | 2024-03-14 05:00:59 | reservoir | 4 | 165329 | 92 | 15.003 | 11019.7 |
185 | 2024-03-14 00:59:16 | reservoir | 5 | 174418 | 942 | 57.876 | 3013.6 |
184 | 2024-03-14 00:59:01 | reservoir | 4 | 165329 | 92 | 38.846 | 4256.0 |
183 | 2024-03-13 17:01:01 | reservoir | 5 | 174418 | 942 | 31.766 | 5490.7 |
182 | 2024-03-13 17:00:59 | reservoir | 4 | 165329 | 92 | 16.486 | 10028.4 |
181 | 2024-03-13 17:00:59 | reservoir | 3 | 148641 | 13 | 15.233 | 9757.8 |
180 | 2024-03-13 17:00:59 | reservoir | 2 | 121436 | 3 | 5.250 | 23130.7 |
179 | 2024-03-13 17:00:41 | reservoir | 1 | 81242 | 2 | 1.673 | 48560.7 |
178 | 2024-02-20 05:30:01 | reservoir | 1 | 81242 | 2 | 3.656 | 22221.6 |
177 | 2024-02-12 14:19:31 | reservoir | 5 | 174418 | 942 | 36.376 | 4794.9 |
176 | 2024-02-10 18:02:22 | reservoir | 5 | 174418 | 942 | 64.020 | 2724.4 |
175 | 2024-02-08 07:26:22 | reservoir | 1 | 81242 | 2 | 3.203 | 25364.3 |
174 | 2024-02-07 23:34:49 | reservoir | 5 | 174418 | 942 | 78.800 | 2213.4 |
173 | 2024-02-07 07:28:38 | reservoir | 1 | 81242 | 2 | 1.450 | 56029.0 |
172 | 2024-02-07 04:20:03 | reservoir | 1 | 81242 | 2 | 2.966 | 27391.1 |
171 | 2024-02-06 09:52:46 | reservoir | 4 | 165329 | 92 | 24.080 | 6865.8 |
170 | 2024-02-06 09:52:41 | reservoir | 3 | 148641 | 13 | 10.440 | 14237.6 |
169 | 2024-02-06 09:52:37 | reservoir | 2 | 121436 | 3 | 3.720 | 32644.1 |
168 | 2024-02-06 07:20:30 | reservoir | 5 | 174418 | 942 | 27.316 | 6385.2 |
167 | 2024-02-06 06:32:50 | reservoir | 4 | 165329 | 92 | 16.656 | 9926.1 |
166 | 2024-02-06 06:32:38 | reservoir | 5 | 174418 | 942 | 24.596 | 7091.3 |
165 | 2024-02-06 06:32:46 | reservoir | 3 | 148641 | 13 | 9.656 | 15393.6 |
164 | 2024-02-06 06:32:42 | reservoir | 2 | 121436 | 3 | 4.186 | 29010.0 |
163 | 2024-02-06 04:22:10 | reservoir | 1 | 81242 | 2 | 1.456 | 55798.1 |
162 | 2024-01-07 22:56:48 | reservoir | 1 | 81242 | 2 | 1.703 | 47705.2 |
161 | 2023-12-27 05:14:14 | reservoir | 1 | 81242 | 2 | 1.296 | 62686.7 |
160 | 2023-12-22 03:21:44 | reservoir | 1 | 81242 | 2 | 1.330 | 61084.2 |
159 | 2023-12-10 05:03:06 | reservoir | 1 | 81242 | 2 | 1.313 | 61875.1 |
158 | 2023-10-08 18:22:47 | reservoir | 1 | 81242 | 2 | 1.406 | 57782.4 |
157 | 2023-08-06 12:51:57 | reservoir | 1 | 81242 | 2 | 1.296 | 62686.7 |
156 | 2023-06-26 07:55:48 | reservoir | 1 | 81242 | 2 | 1.436 | 56575.2 |
155 | 2023-05-05 00:55:59 | reservoir | 1 | 81242 | 2 | 1.280 | 63470.3 |
154 | 2023-02-25 18:31:11 | reservoir | 1 | 81242 | 2 | 1.233 | 65889.7 |
153 | 2023-01-20 23:58:38 | reservoir | 1 | 81242 | 2 | 1.250 | 64993.6 |
152 | 2022-12-23 16:31:05 | reservoir | 1 | 81242 | 2 | 1.250 | 64993.6 |
151 | 2022-09-11 01:52:29 | reservoir | 1 | 81242 | 2 | 1.360 | 59736.8 |
150 | 2022-08-12 00:49:06 | reservoir | 1 | 81242 | 2 | 1.280 | 63470.3 |
149 | 2022-02-22 01:38:17 | reservoir | 1 | 81242 | 2 | 1.826 | 44491.8 |
148 | 2021-09-16 08:46:21 | reservoir | 1 | 81242 | 2 | 1.360 | 59736.8 |
147 | 2021-07-28 06:27:41 | reservoir | 1 | 81242 | 2 | 1.423 | 57092.1 |
146 | 2021-05-23 17:13:48 | reservoir | 1 | 81242 | 2 | 1.440 | 56418.1 |
145 | 2021-05-19 14:19:23 | reservoir | 1 | 81242 | 2 | 1.500 | 54161.3 |
144 | 2021-04-19 12:56:48 | reservoir | 1 | 81242 | 2 | 1.266 | 64172.2 |
143 | 2021-03-22 10:40:56 | reservoir | 1 | 81242 | 2 | 1.470 | 55266.7 |
142 | 2021-02-13 03:28:11 | reservoir | 1 | 81242 | 2 | 1.470 | 55266.7 |
141 | 2021-02-03 17:21:48 | reservoir | 3 | 148641 | 13 | 6.546 | 22707.1 |
140 | 2021-01-17 21:41:22 | reservoir | 1 | 81242 | 2 | 1.266 | 64172.2 |
139 | 2020-12-07 05:52:56 | reservoir | 1 | 81242 | 2 | 1.530 | 53099.3 |
138 | 2020-11-13 23:42:12 | reservoir | 1 | 81242 | 2 | 1.263 | 64324.6 |
137 | 2020-11-11 20:38:36 | reservoir | 1 | 81242 | 2 | 1.643 | 49447.4 |
136 | 2020-11-10 08:17:53 | reservoir | 1 | 81242 | 2 | 1.266 | 64172.2 |
135 | 2020-10-31 23:41:35 | reservoir | 1 | 81242 | 2 | 1.450 | 56029.0 |
134 | 2020-10-31 15:04:00 | reservoir | 1 | 81242 | 2 | 1.500 | 54161.3 |
133 | 2020-10-26 11:51:14 | reservoir | 1 | 81242 | 2 | 1.280 | 63470.3 |
132 | 2020-09-21 09:52:30 | reservoir | 1 | 81242 | 2 | 1.283 | 63321.9 |
131 | 2020-05-14 07:20:22 | reservoir | 1 | 81242 | 2 | 1.310 | 62016.8 |
130 | 2020-03-27 15:06:47 | reservoir | 1 | 81242 | 2 | 1.546 | 52549.8 |
129 | 2020-03-04 10:22:17 | reservoir | 1 | 81242 | 2 | 1.423 | 57092.1 |
128 | 2020-02-28 19:57:47 | reservoir | 1 | 81242 | 2 | 3.046 | 26671.7 |
127 | 2020-02-19 22:36:23 | reservoir | 1 | 81242 | 2 | 1.296 | 62686.7 |
126 | 2020-02-13 08:10:41 | reservoir | 1 | 81242 | 2 | 5.076 | 16005.1 |
125 | 2020-02-11 18:28:15 | reservoir | 1 | 81242 | 2 | 4.076 | 19931.8 |
124 | 2020-02-09 21:52:47 | reservoir | 1 | 81242 | 2 | 2.593 | 31331.3 |
123 | 2020-01-19 06:11:17 | reservoir | 1 | 81242 | 2 | 3.216 | 25261.8 |
122 | 2020-01-15 22:34:34 | reservoir | 1 | 81242 | 2 | 1.873 | 43375.3 |
121 | 2020-01-08 04:58:44 | reservoir | 1 | 81242 | 2 | 3.470 | 23412.7 |
120 | 2020-01-07 05:00:07 | reservoir | 1 | 81242 | 2 | 1.466 | 55417.5 |
119 | 2019-10-15 14:49:01 | reservoir | 1 | 81242 | 2 | 1.296 | 62686.7 |
118 | 2019-07-23 14:28:52 | reservoir | 1 | 81242 | 2 | 1.236 | 65729.8 |
117 | 2019-06-16 17:50:38 | reservoir | 1 | 81242 | 2 | 1.253 | 64838.0 |
116 | 2019-02-13 16:49:24 | reservoir | 1 | 81242 | 2 | 1.456 | 55798.1 |
115 | 2018-10-01 14:03:32 | reservoir | 1 | 81242 | 2 | 1.690 | 48072.2 |