History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whoever"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
198 | 2024-05-03 15:00:01 | whoever | 1 | 69583 | 3 | 1.140 | 61037.7 |
197 | 2024-05-03 05:07:36 | whoever | 3 | 134027 | 229 | 10.750 | 12467.6 |
196 | 2024-04-30 11:30:46 | whoever | 1 | 69583 | 3 | 2.826 | 24622.4 |
195 | 2024-04-27 00:37:48 | whoever | 1 | 69583 | 3 | 1.356 | 51314.9 |
194 | 2024-04-25 06:13:07 | whoever | 2 | 107671 | 18 | 6.546 | 16448.4 |
193 | 2024-04-25 06:13:06 | whoever | 3 | 134027 | 229 | 7.376 | 18170.7 |
192 | 2024-04-20 22:12:35 | whoever | 2 | 107671 | 18 | 9.110 | 11819.0 |
191 | 2024-04-20 21:24:19 | whoever | 3 | 134027 | 229 | 24.796 | 5405.2 |
190 | 2024-04-20 16:02:50 | whoever | 2 | 107671 | 18 | 3.563 | 30219.2 |
189 | 2024-04-20 16:02:30 | whoever | 3 | 134027 | 229 | 7.906 | 16952.6 |
188 | 2024-04-20 00:39:39 | whoever | 3 | 134027 | 229 | 9.220 | 14536.6 |
187 | 2024-04-19 22:38:48 | whoever | 3 | 134027 | 229 | 17.470 | 7671.8 |
186 | 2024-03-30 23:34:05 | whoever | 1 | 69583 | 3 | 3.143 | 22139.0 |
185 | 2024-03-16 00:16:27 | whoever | 1 | 69583 | 3 | 1.013 | 68690.0 |
184 | 2024-03-11 12:21:54 | whoever | 3 | 134027 | 229 | 23.546 | 5692.1 |
183 | 2024-03-04 12:43:41 | whoever | 3 | 134027 | 229 | 22.390 | 5986.0 |
182 | 2024-03-02 04:29:07 | whoever | 3 | 134027 | 229 | 7.140 | 18771.3 |
181 | 2024-03-02 04:29:06 | whoever | 2 | 107671 | 18 | 3.126 | 34443.7 |
180 | 2024-02-29 05:49:22 | whoever | 1 | 69583 | 3 | 1.170 | 59472.6 |
179 | 2024-02-22 10:19:34 | whoever | 3 | 134027 | 229 | 11.063 | 12114.9 |
178 | 2024-02-21 00:22:52 | whoever | 3 | 134027 | 229 | 8.220 | 16305.0 |
177 | 2024-02-20 14:02:22 | whoever | 2 | 107671 | 18 | 3.736 | 28819.9 |
176 | 2024-02-05 14:09:59 | whoever | 2 | 107671 | 18 | 3.343 | 32207.9 |
175 | 2024-02-05 14:09:35 | whoever | 3 | 134027 | 229 | 8.000 | 16753.4 |
174 | 2024-02-01 02:36:11 | whoever | 1 | 69583 | 3 | 1.563 | 44518.9 |
173 | 2024-01-27 06:34:29 | whoever | 3 | 134027 | 229 | 6.500 | 20619.5 |
172 | 2024-01-27 02:28:51 | whoever | 2 | 107671 | 18 | 3.063 | 35152.1 |
171 | 2024-01-27 02:28:39 | whoever | 3 | 134027 | 229 | 6.860 | 19537.5 |
170 | 2024-01-13 07:55:42 | whoever | 3 | 134027 | 229 | 6.123 | 21889.1 |
169 | 2024-01-01 14:49:11 | whoever | 1 | 69583 | 3 | 1.156 | 60192.9 |
168 | 2023-12-25 13:53:31 | whoever | 1 | 69583 | 3 | 1.250 | 55666.4 |
167 | 2023-12-15 23:39:11 | whoever | 1 | 69583 | 3 | 1.160 | 59985.3 |
166 | 2023-11-24 04:21:09 | whoever | 1 | 69583 | 3 | 1.140 | 61037.7 |
165 | 2023-11-21 15:17:58 | whoever | 1 | 69583 | 3 | 1.046 | 66522.9 |
164 | 2023-11-19 18:59:59 | whoever | 1 | 69583 | 3 | 1.153 | 60349.5 |
163 | 2023-11-18 14:24:10 | whoever | 2 | 107671 | 18 | 2.656 | 40538.8 |
162 | 2023-11-17 21:26:49 | whoever | 3 | 134027 | 229 | 6.470 | 20715.1 |
161 | 2023-10-01 17:49:14 | whoever | 1 | 69583 | 3 | 1.013 | 68690.0 |
160 | 2023-09-27 04:22:27 | whoever | 1 | 69583 | 3 | 0.983 | 70786.4 |
159 | 2023-09-24 21:30:56 | whoever | 1 | 69583 | 3 | 1.046 | 66522.9 |
158 | 2023-08-19 23:36:44 | whoever | 3 | 134027 | 229 | 7.080 | 18930.4 |
157 | 2023-08-19 12:33:59 | whoever | 2 | 107671 | 18 | 2.906 | 37051.3 |
156 | 2023-07-29 10:39:47 | whoever | 1 | 69583 | 3 | 1.016 | 68487.2 |
155 | 2023-05-02 22:49:19 | whoever | 3 | 134027 | 229 | 5.390 | 24865.9 |
154 | 2023-05-02 21:30:09 | whoever | 2 | 107671 | 18 | 2.656 | 40538.8 |
153 | 2023-04-26 07:15:36 | whoever | 1 | 69583 | 3 | 1.033 | 67360.1 |
152 | 2023-02-09 16:07:57 | whoever | 2 | 107671 | 18 | 3.093 | 34811.2 |
151 | 2023-02-08 03:15:34 | whoever | 3 | 134027 | 229 | 5.560 | 24105.6 |
150 | 2022-11-21 02:52:56 | whoever | 3 | 134027 | 229 | 5.486 | 24430.7 |
149 | 2022-11-20 19:49:39 | whoever | 2 | 107671 | 18 | 2.656 | 40538.8 |
148 | 2022-08-07 12:29:14 | whoever | 1 | 69583 | 3 | 1.016 | 68487.2 |
147 | 2022-06-26 11:19:09 | whoever | 3 | 134027 | 229 | 5.610 | 23890.7 |
146 | 2022-06-24 18:22:03 | whoever | 2 | 107671 | 18 | 2.983 | 36094.9 |
145 | 2022-06-15 12:01:15 | whoever | 1 | 69583 | 3 | 1.203 | 57841.2 |
144 | 2022-03-12 05:48:25 | whoever | 1 | 69583 | 3 | 1.156 | 60192.9 |
143 | 2022-02-16 09:26:45 | whoever | 1 | 69583 | 3 | 1.060 | 65644.3 |
142 | 2020-11-02 18:45:43 | whoever | 1 | 69583 | 3 | 1.186 | 58670.3 |
141 | 2020-10-26 07:58:38 | whoever | 1 | 69583 | 3 | 1.123 | 61961.7 |
140 | 2020-07-31 19:06:49 | whoever | 1 | 69583 | 3 | 1.220 | 57035.2 |
139 | 2020-07-29 07:00:35 | whoever | 1 | 69583 | 3 | 1.126 | 61796.6 |
138 | 2020-03-23 14:21:37 | whoever | 1 | 69583 | 3 | 2.546 | 27330.3 |
137 | 2020-03-23 10:35:46 | whoever | 1 | 69583 | 3 | 1.736 | 40082.4 |
136 | 2020-03-20 15:31:55 | whoever | 1 | 69583 | 3 | 1.030 | 67556.3 |
135 | 2020-03-02 05:49:07 | whoever | 3 | 134027 | 229 | 7.280 | 18410.3 |
134 | 2020-03-01 09:00:10 | whoever | 3 | 134027 | 229 | 9.690 | 13831.5 |
133 | 2020-02-29 09:26:14 | whoever | 3 | 134027 | 229 | 9.953 | 13466.0 |
132 | 2020-02-25 14:21:49 | whoever | 1 | 69583 | 3 | 1.280 | 54361.7 |
131 | 2020-02-25 11:35:43 | whoever | 1 | 69583 | 3 | 1.190 | 58473.1 |
130 | 2020-02-25 02:25:06 | whoever | 3 | 134027 | 229 | 7.173 | 18684.9 |
129 | 2020-02-19 10:46:30 | whoever | 1 | 69583 | 3 | 1.296 | 53690.6 |
128 | 2020-02-18 13:07:51 | whoever | 3 | 134027 | 229 | 9.470 | 14152.8 |
127 | 2020-02-15 01:39:03 | whoever | 1 | 69583 | 3 | 1.343 | 51811.6 |
126 | 2020-02-13 07:09:08 | whoever | 1 | 69583 | 3 | 2.110 | 32977.7 |
125 | 2020-02-09 17:16:08 | whoever | 3 | 134027 | 229 | 9.140 | 14663.8 |
124 | 2020-02-04 05:58:45 | whoever | 1 | 69583 | 3 | 1.533 | 45390.1 |
123 | 2020-02-02 05:19:07 | whoever | 1 | 69583 | 3 | 2.563 | 27149.0 |
122 | 2020-01-24 13:43:59 | whoever | 3 | 134027 | 229 | 16.233 | 8256.5 |
121 | 2020-01-24 05:03:26 | whoever | 3 | 134027 | 229 | 15.876 | 8442.1 |
120 | 2020-01-23 11:59:30 | whoever | 1 | 69583 | 3 | 2.716 | 25619.7 |
119 | 2020-01-22 20:41:44 | whoever | 1 | 69583 | 3 | 2.750 | 25302.9 |
118 | 2020-01-22 10:02:21 | whoever | 3 | 134027 | 229 | 8.406 | 15944.2 |
117 | 2020-01-22 05:29:47 | whoever | 3 | 134027 | 229 | 17.453 | 7679.3 |
116 | 2020-01-21 03:55:17 | whoever | 1 | 69583 | 3 | 2.516 | 27656.2 |
115 | 2020-01-17 04:16:56 | whoever | 3 | 134027 | 229 | 6.483 | 20673.6 |
114 | 2020-01-16 23:53:33 | whoever | 3 | 134027 | 229 | 10.750 | 12467.6 |
113 | 2020-01-15 15:21:52 | whoever | 1 | 69583 | 3 | 1.283 | 54234.6 |
112 | 2020-01-12 23:31:44 | whoever | 1 | 69583 | 3 | 1.266 | 54962.9 |
111 | 2020-01-09 21:25:15 | whoever | 1 | 69583 | 3 | 1.030 | 67556.3 |
110 | 2019-12-31 19:59:36 | whoever | 1 | 69583 | 3 | 1.173 | 59320.5 |
109 | 2019-12-29 01:15:19 | whoever | 3 | 134027 | 229 | 7.983 | 16789.1 |
108 | 2019-12-29 00:47:28 | whoever | 3 | 134027 | 229 | 5.750 | 23309.0 |
107 | 2019-12-28 22:58:19 | whoever | 3 | 134027 | 229 | 13.296 | 10080.2 |
106 | 2019-12-28 20:57:39 | whoever | 1 | 69583 | 3 | 1.046 | 66522.9 |
105 | 2019-12-09 07:32:02 | whoever | 1 | 69583 | 3 | 1.186 | 58670.3 |
104 | 2019-09-07 09:21:16 | whoever | 1 | 69583 | 3 | 1.080 | 64428.7 |
103 | 2019-06-18 20:09:14 | whoever | 1 | 69583 | 3 | 1.016 | 68487.2 |
102 | 2019-06-02 17:53:37 | whoever | 1 | 69583 | 3 | 1.036 | 67165.1 |
101 | 2019-05-30 16:55:15 | whoever | 1 | 69583 | 3 | 1.006 | 69168.0 |
100 | 2019-05-26 08:19:24 | whoever | 1 | 69583 | 3 | 1.130 | 61577.9 |
99 | 2019-01-29 01:52:59 | whoever | 1 | 69583 | 3 | 1.000 | 69583.0 |