History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gavelocks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
205 | 2024-05-28 16:03:07 | gavelocks | 1 | 81242 | 3 | 4.296 | 18911.1 |
204 | 2024-05-23 02:44:13 | gavelocks | 4 | 165329 | 183 | 22.503 | 7347.0 |
203 | 2024-05-10 12:12:33 | gavelocks | 4 | 165329 | 183 | 27.016 | 6119.7 |
202 | 2024-05-09 11:33:28 | gavelocks | 4 | 165329 | 183 | 21.033 | 7860.5 |
201 | 2024-05-09 08:04:59 | gavelocks | 4 | 165329 | 183 | 39.393 | 4196.9 |
200 | 2024-05-09 08:05:10 | gavelocks | 2 | 121436 | 7 | 8.690 | 13974.2 |
199 | 2024-05-09 08:05:00 | gavelocks | 3 | 148641 | 27 | 12.626 | 11772.6 |
198 | 2024-05-09 08:03:11 | gavelocks | 1 | 81242 | 3 | 1.423 | 57092.1 |
197 | 2024-05-07 11:59:07 | gavelocks | 1 | 81242 | 3 | 4.483 | 18122.2 |
196 | 2024-05-05 13:11:29 | gavelocks | 1 | 81242 | 3 | 2.780 | 29223.7 |
195 | 2024-04-08 06:40:40 | gavelocks | 1 | 81242 | 3 | 1.343 | 60492.9 |
194 | 2024-04-07 08:15:24 | gavelocks | 1 | 81242 | 3 | 2.690 | 30201.5 |
193 | 2024-04-01 13:57:05 | gavelocks | 1 | 81242 | 3 | 4.546 | 17871.1 |
192 | 2024-04-01 09:09:05 | gavelocks | 1 | 81242 | 3 | 1.640 | 49537.8 |
191 | 2024-03-29 10:28:42 | gavelocks | 1 | 81242 | 3 | 2.470 | 32891.5 |
190 | 2024-03-09 17:41:33 | gavelocks | 2 | 121436 | 7 | 7.986 | 15206.1 |
189 | 2024-03-09 01:02:12 | gavelocks | 4 | 165329 | 183 | 40.126 | 4120.2 |
188 | 2024-03-08 00:49:16 | gavelocks | 1 | 81242 | 3 | 3.796 | 21402.0 |
187 | 2024-03-05 20:06:59 | gavelocks | 4 | 165329 | 183 | 40.330 | 4099.4 |
186 | 2024-03-05 09:35:37 | gavelocks | 4 | 165329 | 183 | 26.643 | 6205.3 |
185 | 2024-03-05 09:35:03 | gavelocks | 3 | 148641 | 27 | 20.580 | 7222.6 |
184 | 2024-03-05 09:35:02 | gavelocks | 2 | 121436 | 7 | 8.546 | 14209.7 |
183 | 2024-03-05 09:34:09 | gavelocks | 1 | 81242 | 3 | 2.923 | 27794.0 |
182 | 2024-03-02 04:59:08 | gavelocks | 1 | 81242 | 3 | 3.186 | 25499.7 |
181 | 2024-03-01 22:45:54 | gavelocks | 1 | 81242 | 3 | 1.550 | 52414.2 |
180 | 2024-02-05 14:14:43 | gavelocks | 1 | 81242 | 3 | 1.453 | 55913.3 |
179 | 2024-02-02 00:21:53 | gavelocks | 1 | 81242 | 3 | 1.360 | 59736.8 |
178 | 2024-01-31 05:56:47 | gavelocks | 1 | 81242 | 3 | 1.440 | 56418.1 |
177 | 2024-01-28 21:54:51 | gavelocks | 1 | 81242 | 3 | 1.296 | 62686.7 |
176 | 2024-01-26 11:54:33 | gavelocks | 1 | 81242 | 3 | 1.436 | 56575.2 |
175 | 2023-12-27 04:32:26 | gavelocks | 1 | 81242 | 3 | 2.766 | 29371.7 |
174 | 2023-11-23 14:29:02 | gavelocks | 1 | 81242 | 3 | 1.453 | 55913.3 |
173 | 2023-09-09 15:19:09 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
172 | 2023-06-18 05:07:49 | gavelocks | 1 | 81242 | 3 | 1.393 | 58321.6 |
171 | 2023-05-09 03:30:23 | gavelocks | 1 | 81242 | 3 | 1.186 | 68500.8 |
170 | 2023-04-04 03:31:10 | gavelocks | 1 | 81242 | 3 | 1.326 | 61268.5 |
169 | 2023-03-20 22:48:36 | gavelocks | 1 | 81242 | 3 | 1.420 | 57212.7 |
168 | 2023-01-16 12:14:44 | gavelocks | 1 | 81242 | 3 | 1.186 | 68500.8 |
167 | 2022-11-13 07:59:11 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
166 | 2022-07-04 16:04:53 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
165 | 2020-12-05 17:34:39 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
164 | 2020-10-31 20:26:40 | gavelocks | 1 | 81242 | 3 | 1.373 | 59171.2 |
163 | 2020-03-23 23:40:01 | gavelocks | 1 | 81242 | 3 | 1.326 | 61268.5 |
162 | 2020-03-07 23:08:25 | gavelocks | 1 | 81242 | 3 | 1.326 | 61268.5 |
161 | 2020-03-01 01:04:26 | gavelocks | 1 | 81242 | 3 | 1.423 | 57092.1 |
160 | 2020-02-11 10:19:00 | gavelocks | 1 | 81242 | 3 | 3.313 | 24522.2 |
159 | 2020-02-05 02:57:20 | gavelocks | 1 | 81242 | 3 | 1.563 | 51978.2 |
158 | 2020-02-02 03:01:36 | gavelocks | 1 | 81242 | 3 | 3.000 | 27080.7 |
157 | 2020-01-30 01:47:42 | gavelocks | 1 | 81242 | 3 | 1.406 | 57782.4 |
156 | 2020-01-29 08:29:39 | gavelocks | 1 | 81242 | 3 | 2.703 | 30056.2 |
155 | 2020-01-17 07:17:53 | gavelocks | 1 | 81242 | 3 | 3.000 | 27080.7 |
154 | 2020-01-15 15:10:16 | gavelocks | 1 | 81242 | 3 | 1.453 | 55913.3 |
153 | 2020-01-05 01:33:45 | gavelocks | 1 | 81242 | 3 | 1.406 | 57782.4 |
152 | 2019-12-29 06:16:53 | gavelocks | 1 | 81242 | 3 | 1.560 | 52078.2 |
151 | 2019-12-05 00:18:43 | gavelocks | 1 | 81242 | 3 | 1.406 | 57782.4 |
150 | 2019-09-02 19:48:52 | gavelocks | 1 | 81242 | 3 | 1.406 | 57782.4 |
149 | 2019-05-24 20:15:39 | gavelocks | 1 | 81242 | 3 | 1.476 | 55042.0 |
148 | 2019-03-27 21:34:36 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
147 | 2019-01-27 13:18:55 | gavelocks | 1 | 81242 | 3 | 1.333 | 60946.7 |
146 | 2019-01-14 21:02:58 | gavelocks | 1 | 81242 | 3 | 1.556 | 52212.1 |
145 | 2019-01-11 06:48:30 | gavelocks | 1 | 81242 | 3 | 1.173 | 69260.0 |
144 | 2018-12-04 02:50:54 | gavelocks | 1 | 81242 | 3 | 1.260 | 64477.8 |
143 | 2018-11-11 08:42:50 | gavelocks | 1 | 81242 | 3 | 1.183 | 68674.6 |
142 | 2018-10-21 05:47:14 | gavelocks | 1 | 81242 | 3 | 1.373 | 59171.2 |
141 | 2018-10-12 10:26:00 | gavelocks | 1 | 81242 | 3 | 1.380 | 58871.0 |
140 | 2018-10-03 03:33:51 | gavelocks | 1 | 81242 | 3 | 1.203 | 67532.8 |
139 | 2018-09-27 10:13:55 | gavelocks | 1 | 81242 | 3 | 1.570 | 51746.5 |
138 | 2018-06-27 17:17:11 | gavelocks | 1 | 81242 | 3 | 1.220 | 66591.8 |
137 | 2018-04-13 14:53:03 | gavelocks | 1 | 81242 | 3 | 1.213 | 66976.1 |
136 | 2018-04-13 14:36:59 | gavelocks | 1 | 81242 | 3 | 1.346 | 60358.1 |
135 | 2018-03-04 18:35:52 | gavelocks | 1 | 81242 | 3 | 2.260 | 35947.8 |
134 | 2017-11-12 21:31:22 | gavelocks | 1 | 81242 | 3 | 3.470 | 23412.7 |
133 | 2017-10-20 18:25:11 | gavelocks | 1 | 81242 | 3 | 1.990 | 40825.1 |
132 | 2017-04-15 20:16:18 | gavelocks | 1 | 81242 | 3 | 1.650 | 49237.6 |
131 | 2017-04-06 14:30:02 | gavelocks | 1 | 81242 | 3 | 1.676 | 48473.7 |
130 | 2016-12-20 20:57:51 | gavelocks | 4 | 165329 | 183 | 21.206 | 7796.3 |
129 | 2016-12-13 03:47:46 | gavelocks | 4 | 165329 | 183 | 21.516 | 7684.0 |
128 | 2016-10-26 09:49:21 | gavelocks | 1 | 81242 | 3 | 1.700 | 47789.4 |
127 | 2016-08-15 05:22:41 | gavelocks | 4 | 165329 | 183 | 16.363 | 10103.8 |
126 | 2016-08-03 16:39:58 | gavelocks | 4 | 165329 | 183 | 48.573 | 3403.7 |
125 | 2016-07-28 13:01:21 | gavelocks | 4 | 165329 | 183 | 19.166 | 8626.2 |
124 | 2016-07-20 10:27:14 | gavelocks | 1 | 81242 | 3 | 1.950 | 41662.6 |
123 | 2016-07-13 13:23:13 | gavelocks | 4 | 165329 | 183 | 31.123 | 5312.1 |
122 | 2016-06-15 13:44:14 | gavelocks | 4 | 165329 | 183 | 41.553 | 3978.8 |
121 | 2016-06-15 10:37:20 | gavelocks | 4 | 165329 | 183 | 18.126 | 9121.1 |
120 | 2016-06-11 09:50:48 | gavelocks | 4 | 165329 | 183 | 21.206 | 7796.3 |
119 | 2016-06-07 09:03:13 | gavelocks | 4 | 165329 | 183 | 29.316 | 5639.5 |
118 | 2016-06-03 09:10:57 | gavelocks | 4 | 165329 | 183 | 11.703 | 14127.1 |
117 | 2016-06-01 05:26:14 | gavelocks | 4 | 165329 | 183 | 16.470 | 10038.2 |
116 | 2016-05-30 09:15:47 | gavelocks | 4 | 165329 | 183 | 47.413 | 3487.0 |
115 | 2016-05-26 09:14:06 | gavelocks | 4 | 165329 | 183 | 15.490 | 10673.3 |
114 | 2016-05-26 08:41:05 | gavelocks | 1 | 81242 | 3 | 1.420 | 57212.7 |
113 | 2016-05-22 09:03:13 | gavelocks | 4 | 165329 | 183 | 34.776 | 4754.1 |
112 | 2016-05-21 13:14:26 | gavelocks | 4 | 165329 | 183 | 28.590 | 5782.8 |
111 | 2016-05-20 23:16:02 | gavelocks | 4 | 165329 | 183 | 12.886 | 12830.1 |
110 | 2016-05-19 09:33:43 | gavelocks | 4 | 165329 | 183 | 28.536 | 5793.7 |
109 | 2016-05-19 06:25:23 | gavelocks | 1 | 81242 | 3 | 3.640 | 22319.2 |
108 | 2016-05-18 09:13:14 | gavelocks | 4 | 165329 | 183 | 27.433 | 6026.6 |
107 | 2016-05-14 10:25:44 | gavelocks | 4 | 165329 | 183 | 15.600 | 10598.0 |
106 | 2016-05-10 09:42:34 | gavelocks | 4 | 165329 | 183 | 12.386 | 13348.1 |