History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiffiest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
206 | 2024-04-27 20:38:56 | spiffiest | 1 | 81242 | 3 | 6.250 | 12998.7 |
205 | 2024-04-05 11:45:35 | spiffiest | 1 | 81242 | 3 | 3.406 | 23852.6 |
204 | 2024-03-29 21:55:46 | spiffiest | 1 | 81242 | 3 | 4.970 | 16346.5 |
203 | 2024-03-29 21:04:25 | spiffiest | 1 | 81242 | 3 | 1.500 | 54161.3 |
202 | 2024-03-28 12:28:00 | spiffiest | 1 | 81242 | 3 | 1.356 | 59913.0 |
201 | 2024-03-07 04:13:19 | spiffiest | 1 | 81242 | 3 | 1.623 | 50056.7 |
200 | 2024-03-06 03:26:09 | spiffiest | 1 | 81242 | 3 | 1.483 | 54782.2 |
199 | 2024-02-28 17:44:08 | spiffiest | 3 | 148641 | 104 | 6.750 | 22020.9 |
198 | 2024-02-28 11:43:07 | spiffiest | 1 | 81242 | 3 | 1.703 | 47705.2 |
197 | 2024-02-27 11:07:13 | spiffiest | 1 | 81242 | 3 | 1.533 | 52995.4 |
196 | 2024-02-26 16:47:23 | spiffiest | 3 | 148641 | 104 | 16.406 | 9060.2 |
195 | 2024-02-26 16:47:23 | spiffiest | 2 | 121436 | 20 | 8.516 | 14259.7 |
194 | 2024-02-26 16:12:49 | spiffiest | 1 | 81242 | 3 | 6.326 | 12842.6 |
193 | 2024-01-29 11:40:42 | spiffiest | 1 | 81242 | 3 | 2.626 | 30937.5 |
192 | 2024-01-23 14:35:26 | spiffiest | 3 | 148641 | 104 | 21.813 | 6814.3 |
191 | 2024-01-23 11:13:39 | spiffiest | 3 | 148641 | 104 | 10.593 | 14032.0 |
190 | 2024-01-15 07:00:06 | spiffiest | 3 | 148641 | 104 | 6.000 | 24773.5 |
189 | 2024-01-14 11:46:14 | spiffiest | 1 | 81242 | 3 | 1.453 | 55913.3 |
188 | 2024-01-11 08:53:35 | spiffiest | 1 | 81242 | 3 | 1.233 | 65889.7 |
187 | 2023-12-13 04:06:30 | spiffiest | 1 | 81242 | 3 | 1.296 | 62686.7 |
186 | 2023-11-23 19:50:41 | spiffiest | 1 | 81242 | 3 | 1.453 | 55913.3 |
185 | 2023-11-09 10:20:44 | spiffiest | 1 | 81242 | 3 | 1.266 | 64172.2 |
184 | 2023-11-06 15:21:08 | spiffiest | 1 | 81242 | 3 | 1.440 | 56418.1 |
183 | 2023-10-24 09:52:02 | spiffiest | 3 | 148641 | 104 | 6.450 | 23045.1 |
182 | 2023-09-25 09:17:42 | spiffiest | 1 | 81242 | 3 | 1.470 | 55266.7 |
181 | 2023-08-19 02:17:23 | spiffiest | 1 | 81242 | 3 | 1.423 | 57092.1 |
180 | 2023-08-02 13:13:13 | spiffiest | 3 | 148641 | 104 | 6.033 | 24638.0 |
179 | 2023-04-12 06:09:54 | spiffiest | 3 | 148641 | 104 | 5.860 | 25365.4 |
178 | 2023-04-09 05:15:30 | spiffiest | 1 | 81242 | 3 | 1.403 | 57905.9 |
177 | 2023-01-16 22:09:24 | spiffiest | 3 | 148641 | 104 | 5.843 | 25439.2 |
176 | 2022-11-30 14:18:15 | spiffiest | 1 | 81242 | 3 | 1.250 | 64993.6 |
175 | 2022-11-27 07:26:26 | spiffiest | 1 | 81242 | 3 | 1.266 | 64172.2 |
174 | 2022-10-27 11:21:23 | spiffiest | 3 | 148641 | 104 | 5.873 | 25309.2 |
173 | 2022-07-09 03:26:35 | spiffiest | 1 | 81242 | 3 | 1.546 | 52549.8 |
172 | 2022-07-03 04:05:56 | spiffiest | 1 | 81242 | 3 | 1.280 | 63470.3 |
171 | 2022-06-14 12:06:09 | spiffiest | 1 | 81242 | 3 | 1.360 | 59736.8 |
170 | 2022-05-28 11:19:11 | spiffiest | 3 | 148641 | 104 | 5.953 | 24969.1 |
169 | 2022-03-11 17:52:55 | spiffiest | 1 | 81242 | 3 | 1.436 | 56575.2 |
168 | 2022-03-09 13:35:40 | spiffiest | 1 | 81242 | 3 | 1.766 | 46003.4 |
167 | 2022-02-13 06:54:33 | spiffiest | 1 | 81242 | 3 | 1.220 | 66591.8 |
166 | 2022-01-03 19:51:44 | spiffiest | 1 | 81242 | 3 | 1.610 | 50460.9 |
165 | 2022-01-01 17:12:38 | spiffiest | 1 | 81242 | 3 | 1.610 | 50460.9 |
164 | 2021-11-10 17:48:30 | spiffiest | 1 | 81242 | 3 | 1.456 | 55798.1 |
163 | 2021-10-06 23:27:45 | spiffiest | 1 | 81242 | 3 | 1.376 | 59042.2 |
162 | 2021-07-01 04:58:49 | spiffiest | 1 | 81242 | 3 | 1.250 | 64993.6 |
161 | 2021-06-01 04:05:43 | spiffiest | 2 | 121436 | 20 | 3.513 | 34567.6 |
160 | 2021-05-05 04:28:50 | spiffiest | 1 | 81242 | 3 | 1.530 | 53099.3 |
159 | 2021-04-21 06:18:04 | spiffiest | 1 | 81242 | 3 | 1.330 | 61084.2 |
158 | 2021-04-05 06:34:18 | spiffiest | 2 | 121436 | 20 | 3.080 | 39427.3 |
157 | 2021-03-31 05:30:44 | spiffiest | 1 | 81242 | 3 | 1.373 | 59171.2 |
156 | 2021-03-09 15:10:54 | spiffiest | 2 | 121436 | 20 | 3.106 | 39097.2 |
155 | 2021-03-07 18:13:26 | spiffiest | 1 | 81242 | 3 | 1.250 | 64993.6 |
154 | 2021-02-13 09:11:31 | spiffiest | 2 | 121436 | 20 | 3.500 | 34696.0 |
153 | 2021-02-11 16:37:20 | spiffiest | 1 | 81242 | 3 | 1.466 | 55417.5 |
152 | 2021-01-18 04:47:32 | spiffiest | 1 | 81242 | 3 | 1.360 | 59736.8 |
151 | 2020-12-19 15:03:17 | spiffiest | 1 | 81242 | 3 | 1.436 | 56575.2 |
150 | 2020-11-16 20:42:21 | spiffiest | 2 | 121436 | 20 | 7.200 | 16866.1 |
149 | 2020-10-29 13:36:26 | spiffiest | 1 | 81242 | 3 | 1.453 | 55913.3 |
148 | 2020-09-19 04:42:42 | spiffiest | 1 | 81242 | 3 | 1.436 | 56575.2 |
147 | 2020-07-31 14:05:14 | spiffiest | 1 | 81242 | 3 | 1.310 | 62016.8 |
146 | 2020-05-28 01:08:12 | spiffiest | 1 | 81242 | 3 | 1.250 | 64993.6 |
145 | 2020-05-25 01:58:32 | spiffiest | 1 | 81242 | 3 | 1.376 | 59042.2 |
144 | 2020-03-27 06:11:44 | spiffiest | 1 | 81242 | 3 | 2.483 | 32719.3 |
143 | 2020-02-14 19:23:49 | spiffiest | 1 | 81242 | 3 | 1.626 | 49964.3 |
142 | 2020-02-07 21:46:58 | spiffiest | 1 | 81242 | 3 | 1.453 | 55913.3 |
141 | 2020-02-07 03:36:18 | spiffiest | 1 | 81242 | 3 | 3.110 | 26122.8 |
140 | 2020-02-03 23:20:02 | spiffiest | 1 | 81242 | 3 | 3.046 | 26671.7 |
139 | 2020-02-02 06:36:59 | spiffiest | 1 | 81242 | 3 | 1.656 | 49059.2 |
138 | 2020-02-01 09:02:05 | spiffiest | 1 | 81242 | 3 | 1.530 | 53099.3 |
137 | 2020-01-22 06:14:24 | spiffiest | 1 | 81242 | 3 | 1.546 | 52549.8 |
136 | 2020-01-17 21:04:47 | spiffiest | 1 | 81242 | 3 | 1.440 | 56418.1 |
135 | 2020-01-07 22:16:03 | spiffiest | 1 | 81242 | 3 | 3.063 | 26523.7 |
134 | 2020-01-02 05:03:29 | spiffiest | 1 | 81242 | 3 | 3.093 | 26266.4 |
133 | 2019-11-06 14:41:45 | spiffiest | 1 | 81242 | 3 | 1.330 | 61084.2 |
132 | 2019-08-08 12:24:43 | spiffiest | 1 | 81242 | 3 | 1.363 | 59605.3 |
131 | 2019-07-24 16:30:05 | spiffiest | 1 | 81242 | 3 | 1.380 | 58871.0 |
130 | 2019-04-29 04:20:39 | spiffiest | 1 | 81242 | 3 | 1.470 | 55266.7 |
129 | 2019-01-25 15:50:41 | spiffiest | 1 | 81242 | 3 | 1.233 | 65889.7 |
128 | 2019-01-06 08:06:09 | spiffiest | 1 | 81242 | 3 | 1.433 | 56693.6 |
127 | 2019-01-03 00:50:19 | spiffiest | 1 | 81242 | 3 | 1.460 | 55645.2 |
126 | 2018-10-15 06:59:07 | spiffiest | 1 | 81242 | 3 | 1.260 | 64477.8 |
125 | 2018-09-06 04:56:53 | spiffiest | 1 | 81242 | 3 | 1.510 | 53802.6 |
124 | 2018-07-16 08:45:12 | spiffiest | 1 | 81242 | 3 | 1.246 | 65202.2 |
123 | 2018-07-11 17:29:57 | spiffiest | 1 | 81242 | 3 | 1.250 | 64993.6 |
122 | 2018-06-06 22:47:16 | spiffiest | 1 | 81242 | 3 | 1.410 | 57618.4 |
121 | 2017-12-31 21:34:22 | spiffiest | 1 | 81242 | 3 | 1.860 | 43678.5 |
120 | 2017-07-02 14:35:37 | spiffiest | 1 | 81242 | 3 | 1.606 | 50586.6 |
119 | 2017-04-09 23:28:33 | spiffiest | 1 | 81242 | 3 | 1.883 | 43145.0 |
118 | 2017-02-17 08:42:12 | spiffiest | 1 | 81242 | 3 | 1.923 | 42247.5 |
117 | 2017-02-08 04:26:24 | spiffiest | 1 | 81242 | 3 | 1.583 | 51321.5 |
116 | 2017-01-27 02:12:51 | spiffiest | 1 | 81242 | 3 | 1.693 | 47987.0 |
115 | 2017-01-08 07:36:40 | spiffiest | 1 | 81242 | 3 | 1.746 | 46530.4 |
114 | 2016-12-03 05:56:51 | spiffiest | 1 | 81242 | 3 | 2.070 | 39247.3 |
113 | 2016-12-01 08:21:16 | spiffiest | 1 | 81242 | 3 | 2.016 | 40298.6 |
112 | 2016-11-06 01:21:18 | spiffiest | 1 | 81242 | 3 | 1.733 | 46879.4 |
111 | 2016-11-04 10:51:01 | spiffiest | 1 | 81242 | 3 | 2.123 | 38267.5 |
110 | 2016-10-30 08:30:35 | spiffiest | 1 | 81242 | 3 | 2.073 | 39190.5 |
109 | 2016-10-28 10:24:02 | spiffiest | 1 | 81242 | 3 | 1.746 | 46530.4 |
108 | 2016-10-22 08:49:13 | spiffiest | 1 | 81242 | 3 | 1.976 | 41114.4 |
107 | 2016-08-22 14:59:56 | spiffiest | 1 | 81242 | 3 | 1.726 | 47069.5 |