History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"royalties"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
217 | 2024-05-01 05:46:40 | royalties | 1 | 81242 | 2 | 2.703 | 30056.2 |
216 | 2024-04-26 07:15:04 | royalties | 4 | 165329 | 496 | 37.906 | 4361.6 |
215 | 2024-04-26 07:14:59 | royalties | 2 | 121436 | 3 | 7.643 | 15888.5 |
214 | 2024-04-26 07:14:53 | royalties | 3 | 148641 | 50 | 10.690 | 13904.7 |
213 | 2024-04-26 04:33:52 | royalties | 1 | 81242 | 2 | 1.343 | 60492.9 |
212 | 2024-04-18 22:37:23 | royalties | 1 | 81242 | 2 | 2.810 | 28911.7 |
211 | 2024-04-17 15:27:33 | royalties | 1 | 81242 | 2 | 7.000 | 11606.0 |
210 | 2024-04-17 14:43:31 | royalties | 1 | 81242 | 2 | 3.296 | 24648.7 |
209 | 2024-04-13 10:37:13 | royalties | 1 | 81242 | 2 | 1.420 | 57212.7 |
208 | 2024-04-10 19:32:26 | royalties | 1 | 81242 | 2 | 4.970 | 16346.5 |
207 | 2024-04-10 07:16:22 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
206 | 2024-03-10 23:11:00 | royalties | 1 | 81242 | 2 | 4.860 | 16716.5 |
205 | 2024-03-08 16:45:38 | royalties | 4 | 165329 | 496 | 41.423 | 3991.2 |
204 | 2024-03-08 00:43:57 | royalties | 1 | 81242 | 2 | 1.843 | 44081.4 |
203 | 2024-03-05 16:20:48 | royalties | 1 | 81242 | 2 | 1.483 | 54782.2 |
202 | 2024-03-01 21:44:48 | royalties | 2 | 121436 | 3 | 8.280 | 14666.2 |
201 | 2024-03-01 21:44:46 | royalties | 1 | 81242 | 2 | 3.203 | 25364.3 |
200 | 2024-02-28 02:40:35 | royalties | 3 | 148641 | 50 | 19.750 | 7526.1 |
199 | 2024-02-28 02:40:37 | royalties | 2 | 121436 | 3 | 8.216 | 14780.4 |
198 | 2024-02-28 02:39:51 | royalties | 1 | 81242 | 2 | 2.093 | 38816.1 |
197 | 2024-02-28 02:39:04 | royalties | 4 | 165329 | 496 | 20.533 | 8051.9 |
196 | 2024-02-27 23:13:44 | royalties | 3 | 148641 | 50 | 17.530 | 8479.2 |
195 | 2024-02-27 23:13:40 | royalties | 4 | 165329 | 496 | 15.440 | 10707.8 |
194 | 2024-02-27 23:13:40 | royalties | 2 | 121436 | 3 | 8.406 | 14446.3 |
193 | 2024-02-09 20:00:17 | royalties | 1 | 81242 | 2 | 2.640 | 30773.5 |
192 | 2024-02-05 19:34:06 | royalties | 1 | 81242 | 2 | 2.123 | 38267.5 |
191 | 2024-01-30 00:27:55 | royalties | 1 | 81242 | 2 | 1.360 | 59736.8 |
190 | 2023-12-30 18:20:09 | royalties | 1 | 81242 | 2 | 1.326 | 61268.5 |
189 | 2023-12-19 20:57:41 | royalties | 1 | 81242 | 2 | 1.236 | 65729.8 |
188 | 2023-12-05 02:35:20 | royalties | 1 | 81242 | 2 | 1.423 | 57092.1 |
187 | 2023-11-29 11:15:10 | royalties | 1 | 81242 | 2 | 1.296 | 62686.7 |
186 | 2023-10-22 07:14:37 | royalties | 1 | 81242 | 2 | 1.266 | 64172.2 |
185 | 2023-10-06 02:51:34 | royalties | 1 | 81242 | 2 | 1.296 | 62686.7 |
184 | 2023-08-18 08:42:04 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
183 | 2023-05-21 10:44:24 | royalties | 1 | 81242 | 2 | 1.283 | 63321.9 |
182 | 2023-03-14 12:24:02 | royalties | 1 | 81242 | 2 | 1.250 | 64993.6 |
181 | 2023-01-03 07:14:34 | royalties | 1 | 81242 | 2 | 1.216 | 66810.9 |
180 | 2022-09-24 05:29:04 | royalties | 1 | 81242 | 2 | 1.360 | 59736.8 |
179 | 2021-11-18 18:40:24 | royalties | 1 | 81242 | 2 | 2.940 | 27633.3 |
178 | 2021-11-17 22:46:24 | royalties | 1 | 81242 | 2 | 1.470 | 55266.7 |
177 | 2021-09-27 09:48:45 | royalties | 4 | 165329 | 496 | 12.126 | 13634.3 |
176 | 2021-09-27 09:26:32 | royalties | 1 | 81242 | 2 | 1.500 | 54161.3 |
175 | 2021-09-22 10:49:03 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
174 | 2021-09-21 05:54:35 | royalties | 1 | 81242 | 2 | 1.250 | 64993.6 |
173 | 2021-09-15 03:30:42 | royalties | 1 | 81242 | 2 | 1.423 | 57092.1 |
172 | 2021-02-16 22:07:44 | royalties | 1 | 81242 | 2 | 1.280 | 63470.3 |
171 | 2020-09-24 00:26:12 | royalties | 1 | 81242 | 2 | 1.360 | 59736.8 |
170 | 2020-09-05 07:48:11 | royalties | 1 | 81242 | 2 | 1.233 | 65889.7 |
169 | 2020-08-20 08:24:22 | royalties | 1 | 81242 | 2 | 1.233 | 65889.7 |
168 | 2020-08-02 13:20:41 | royalties | 1 | 81242 | 2 | 1.483 | 54782.2 |
167 | 2020-07-18 00:25:59 | royalties | 1 | 81242 | 2 | 1.360 | 59736.8 |
166 | 2020-03-30 08:28:30 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
165 | 2020-03-23 23:29:07 | royalties | 1 | 81242 | 2 | 1.563 | 51978.2 |
164 | 2020-03-05 17:52:50 | royalties | 1 | 81242 | 2 | 1.780 | 45641.6 |
163 | 2020-03-02 05:33:38 | royalties | 4 | 165329 | 496 | 12.363 | 13372.9 |
162 | 2020-02-28 10:24:17 | royalties | 4 | 165329 | 496 | 15.110 | 10941.7 |
161 | 2020-02-28 07:16:32 | royalties | 4 | 165329 | 496 | 20.846 | 7931.0 |
160 | 2020-02-27 18:09:06 | royalties | 4 | 165329 | 496 | 14.563 | 11352.7 |
159 | 2020-02-26 18:24:44 | royalties | 4 | 165329 | 496 | 22.830 | 7241.7 |
158 | 2020-02-25 18:40:16 | royalties | 4 | 165329 | 496 | 13.126 | 12595.5 |
157 | 2020-02-25 17:23:08 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
156 | 2020-02-25 14:01:43 | royalties | 4 | 165329 | 496 | 27.816 | 5943.7 |
155 | 2020-02-25 08:24:14 | royalties | 4 | 165329 | 496 | 13.016 | 12702.0 |
154 | 2020-02-19 20:41:00 | royalties | 1 | 81242 | 2 | 1.610 | 50460.9 |
153 | 2020-02-19 18:24:30 | royalties | 1 | 81242 | 2 | 1.750 | 46424.0 |
152 | 2020-02-04 01:43:42 | royalties | 1 | 81242 | 2 | 4.186 | 19408.0 |
151 | 2020-01-30 02:22:54 | royalties | 1 | 81242 | 2 | 1.610 | 50460.9 |
150 | 2020-01-27 19:36:54 | royalties | 1 | 81242 | 2 | 3.060 | 26549.7 |
149 | 2020-01-27 17:49:51 | royalties | 1 | 81242 | 2 | 1.423 | 57092.1 |
148 | 2020-01-18 06:25:28 | royalties | 4 | 165329 | 496 | 18.113 | 9127.6 |
147 | 2020-01-18 01:00:48 | royalties | 4 | 165329 | 496 | 25.393 | 6510.8 |
146 | 2020-01-17 20:52:13 | royalties | 2 | 121436 | 3 | 3.750 | 32382.9 |
145 | 2020-01-17 20:51:18 | royalties | 4 | 165329 | 496 | 26.890 | 6148.3 |
144 | 2020-01-17 20:49:59 | royalties | 3 | 148641 | 50 | 18.033 | 8242.7 |
143 | 2020-01-17 16:32:43 | royalties | 1 | 81242 | 2 | 1.440 | 56418.1 |
142 | 2020-01-16 15:43:03 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
141 | 2020-01-03 17:30:39 | royalties | 1 | 81242 | 2 | 1.406 | 57782.4 |
140 | 2019-12-31 04:05:10 | royalties | 1 | 81242 | 2 | 1.513 | 53696.0 |
139 | 2019-12-16 10:07:27 | royalties | 1 | 81242 | 2 | 1.533 | 52995.4 |
138 | 2019-09-14 23:09:37 | royalties | 1 | 81242 | 2 | 1.140 | 71264.9 |
137 | 2019-06-23 02:58:06 | royalties | 1 | 81242 | 2 | 1.263 | 64324.6 |
136 | 2019-06-06 00:50:56 | royalties | 1 | 81242 | 2 | 1.343 | 60492.9 |
135 | 2019-02-21 05:02:13 | royalties | 1 | 81242 | 2 | 1.366 | 59474.4 |
134 | 2019-02-15 08:33:16 | royalties | 1 | 81242 | 2 | 1.386 | 58616.2 |
133 | 2019-01-28 10:51:10 | royalties | 4 | 165329 | 496 | 11.363 | 14549.8 |
132 | 2018-12-24 01:07:08 | royalties | 1 | 81242 | 2 | 1.196 | 67928.1 |
131 | 2018-12-22 01:04:55 | royalties | 1 | 81242 | 2 | 1.186 | 68500.8 |
130 | 2018-11-20 01:07:54 | royalties | 1 | 81242 | 2 | 2.406 | 33766.4 |
129 | 2018-11-04 12:01:43 | royalties | 1 | 81242 | 2 | 1.173 | 69260.0 |
128 | 2018-10-22 06:04:29 | royalties | 1 | 81242 | 2 | 1.253 | 64838.0 |
127 | 2018-10-20 08:25:17 | royalties | 1 | 81242 | 2 | 1.460 | 55645.2 |
126 | 2018-10-17 23:04:49 | royalties | 1 | 81242 | 2 | 1.350 | 60179.3 |
125 | 2018-09-15 17:10:09 | royalties | 1 | 81242 | 2 | 1.236 | 65729.8 |
124 | 2018-07-13 12:15:40 | royalties | 1 | 81242 | 2 | 1.233 | 65889.7 |
123 | 2018-07-13 10:56:14 | royalties | 1 | 81242 | 2 | 1.230 | 66050.4 |
122 | 2018-06-01 04:43:14 | royalties | 1 | 81242 | 2 | 1.223 | 66428.5 |
121 | 2018-05-15 01:49:56 | royalties | 1 | 81242 | 2 | 1.376 | 59042.2 |
120 | 2018-04-29 18:21:05 | royalties | 1 | 81242 | 2 | 1.403 | 57905.9 |
119 | 2018-04-05 18:05:24 | royalties | 4 | 165329 | 496 | 16.503 | 10018.1 |
118 | 2018-04-05 18:00:54 | royalties | 4 | 165329 | 496 | 17.890 | 9241.4 |