History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crimson"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
203 | 2024-05-03 13:00:11 | crimson | 2 | 107671 | 12 | 3.596 | 29941.9 |
202 | 2024-05-03 06:13:35 | crimson | 3 | 134027 | 115 | 7.390 | 18136.3 |
201 | 2024-05-02 22:01:28 | crimson | 1 | 69583 | 2 | 1.296 | 53690.6 |
200 | 2024-04-24 23:16:16 | crimson | 2 | 107671 | 12 | 7.800 | 13804.0 |
199 | 2024-04-24 23:16:08 | crimson | 3 | 134027 | 115 | 8.283 | 16181.0 |
198 | 2024-04-18 17:33:26 | crimson | 2 | 107671 | 12 | 12.330 | 8732.4 |
197 | 2024-04-13 13:00:39 | crimson | 1 | 69583 | 2 | 1.296 | 53690.6 |
196 | 2024-04-12 23:40:33 | crimson | 2 | 107671 | 12 | 3.186 | 33795.0 |
195 | 2024-04-12 23:39:49 | crimson | 3 | 134027 | 115 | 7.373 | 18178.1 |
194 | 2024-04-12 03:58:37 | crimson | 3 | 134027 | 115 | 26.580 | 5042.4 |
193 | 2024-04-10 23:16:50 | crimson | 3 | 134027 | 115 | 8.126 | 16493.6 |
192 | 2024-04-10 13:26:53 | crimson | 3 | 134027 | 115 | 8.220 | 16305.0 |
191 | 2024-04-10 13:26:54 | crimson | 2 | 107671 | 12 | 5.733 | 18780.9 |
190 | 2024-04-10 13:26:28 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
189 | 2024-04-09 18:59:30 | crimson | 1 | 69583 | 2 | 1.266 | 54962.9 |
188 | 2024-03-28 18:45:43 | crimson | 1 | 69583 | 2 | 2.826 | 24622.4 |
187 | 2024-02-27 09:17:32 | crimson | 1 | 69583 | 2 | 1.420 | 49002.1 |
186 | 2024-01-09 14:16:53 | crimson | 1 | 69583 | 2 | 1.123 | 61961.7 |
185 | 2023-12-31 13:18:21 | crimson | 1 | 69583 | 2 | 2.203 | 31585.6 |
184 | 2023-12-18 09:35:50 | crimson | 1 | 69583 | 2 | 1.076 | 64668.2 |
183 | 2023-12-09 21:54:05 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
182 | 2023-11-25 02:17:32 | crimson | 1 | 69583 | 2 | 1.110 | 62687.4 |
181 | 2023-11-19 22:39:10 | crimson | 1 | 69583 | 2 | 1.126 | 61796.6 |
180 | 2023-11-09 00:26:18 | crimson | 1 | 69583 | 2 | 1.080 | 64428.7 |
179 | 2023-11-02 02:00:19 | crimson | 1 | 69583 | 2 | 1.250 | 55666.4 |
178 | 2023-10-13 10:07:53 | crimson | 1 | 69583 | 2 | 1.076 | 64668.2 |
177 | 2023-09-24 08:37:26 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
176 | 2023-09-15 06:20:37 | crimson | 1 | 69583 | 2 | 2.406 | 28920.6 |
175 | 2023-08-26 04:40:16 | crimson | 1 | 69583 | 2 | 2.500 | 27833.2 |
174 | 2023-08-22 11:13:39 | crimson | 1 | 69583 | 2 | 1.186 | 58670.3 |
173 | 2023-05-27 17:48:16 | crimson | 1 | 69583 | 2 | 1.063 | 65459.1 |
172 | 2023-04-23 22:43:02 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
171 | 2023-03-24 13:09:58 | crimson | 1 | 69583 | 2 | 1.076 | 64668.2 |
170 | 2023-01-08 16:13:25 | crimson | 1 | 69583 | 2 | 1.063 | 65459.1 |
169 | 2022-12-31 08:40:16 | crimson | 1 | 69583 | 2 | 1.063 | 65459.1 |
168 | 2022-10-05 06:58:57 | crimson | 1 | 69583 | 2 | 1.063 | 65459.1 |
167 | 2022-09-13 06:42:32 | crimson | 1 | 69583 | 2 | 1.076 | 64668.2 |
166 | 2022-05-24 08:39:28 | crimson | 1 | 69583 | 2 | 1.283 | 54234.6 |
165 | 2022-04-26 17:05:37 | crimson | 1 | 69583 | 2 | 1.233 | 56433.9 |
164 | 2022-02-07 19:02:02 | crimson | 1 | 69583 | 2 | 1.186 | 58670.3 |
163 | 2021-12-31 09:49:08 | crimson | 1 | 69583 | 2 | 1.170 | 59472.6 |
162 | 2021-12-01 14:28:34 | crimson | 1 | 69583 | 2 | 1.310 | 53116.8 |
161 | 2021-10-13 04:02:41 | crimson | 1 | 69583 | 2 | 1.266 | 54962.9 |
160 | 2021-10-11 01:19:52 | crimson | 1 | 69583 | 2 | 1.080 | 64428.7 |
159 | 2021-09-14 16:41:39 | crimson | 1 | 69583 | 2 | 2.626 | 26497.7 |
158 | 2021-09-06 23:22:25 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
157 | 2021-08-18 04:53:41 | crimson | 1 | 69583 | 2 | 1.080 | 64428.7 |
156 | 2021-04-29 03:42:02 | crimson | 1 | 69583 | 2 | 1.343 | 51811.6 |
155 | 2021-03-28 18:49:52 | crimson | 1 | 69583 | 2 | 1.093 | 63662.4 |
154 | 2021-01-12 13:57:08 | crimson | 1 | 69583 | 2 | 1.186 | 58670.3 |
153 | 2020-11-08 11:46:25 | crimson | 1 | 69583 | 2 | 1.093 | 63662.4 |
152 | 2020-11-02 02:52:56 | crimson | 1 | 69583 | 2 | 1.516 | 45899.1 |
151 | 2020-10-24 20:56:27 | crimson | 1 | 69583 | 2 | 2.076 | 33517.8 |
150 | 2020-10-22 04:26:26 | crimson | 1 | 69583 | 2 | 1.173 | 59320.5 |
149 | 2020-03-28 21:28:50 | crimson | 1 | 69583 | 2 | 1.283 | 54234.6 |
148 | 2020-03-28 02:47:06 | crimson | 1 | 69583 | 2 | 1.263 | 55093.4 |
147 | 2020-03-22 03:42:40 | crimson | 1 | 69583 | 2 | 1.233 | 56433.9 |
146 | 2020-03-13 09:07:19 | crimson | 1 | 69583 | 2 | 1.236 | 56296.9 |
145 | 2020-02-24 22:11:30 | crimson | 1 | 69583 | 2 | 1.283 | 54234.6 |
144 | 2020-02-24 00:53:38 | crimson | 1 | 69583 | 2 | 1.343 | 51811.6 |
143 | 2020-02-21 10:46:28 | crimson | 1 | 69583 | 2 | 1.063 | 65459.1 |
142 | 2020-02-18 01:07:14 | crimson | 1 | 69583 | 2 | 4.703 | 14795.4 |
141 | 2020-02-17 18:47:16 | crimson | 1 | 69583 | 2 | 1.296 | 53690.6 |
140 | 2020-02-02 06:00:25 | crimson | 1 | 69583 | 2 | 1.750 | 39761.7 |
139 | 2020-01-26 17:51:21 | crimson | 1 | 69583 | 2 | 1.343 | 51811.6 |
138 | 2020-01-23 21:19:14 | crimson | 1 | 69583 | 2 | 1.220 | 57035.2 |
137 | 2020-01-23 19:24:11 | crimson | 1 | 69583 | 2 | 2.843 | 24475.2 |
136 | 2020-01-23 19:06:26 | crimson | 1 | 69583 | 2 | 1.780 | 39091.6 |
135 | 2020-01-16 16:22:29 | crimson | 1 | 69583 | 2 | 1.266 | 54962.9 |
134 | 2020-01-11 20:21:27 | crimson | 1 | 69583 | 2 | 1.250 | 55666.4 |
133 | 2020-01-01 16:50:46 | crimson | 1 | 69583 | 2 | 1.266 | 54962.9 |
132 | 2019-12-30 08:05:49 | crimson | 1 | 69583 | 2 | 1.436 | 48456.1 |
131 | 2019-12-10 11:46:37 | crimson | 1 | 69583 | 2 | 1.216 | 57222.9 |
130 | 2019-09-08 15:44:06 | crimson | 1 | 69583 | 2 | 0.993 | 70073.5 |
129 | 2019-06-08 23:32:12 | crimson | 1 | 69583 | 2 | 1.186 | 58670.3 |
128 | 2019-02-27 16:48:19 | crimson | 1 | 69583 | 2 | 1.146 | 60718.2 |
127 | 2019-02-24 06:06:01 | crimson | 1 | 69583 | 2 | 2.286 | 30438.8 |
126 | 2019-02-12 11:49:53 | crimson | 1 | 69583 | 2 | 1.116 | 62350.4 |
125 | 2018-11-16 21:07:50 | crimson | 1 | 69583 | 2 | 1.243 | 55979.9 |
124 | 2018-11-13 20:56:09 | crimson | 1 | 69583 | 2 | 1.070 | 65030.8 |
123 | 2018-11-03 20:14:20 | crimson | 1 | 69583 | 2 | 1.146 | 60718.2 |
122 | 2018-11-01 20:14:13 | crimson | 1 | 69583 | 2 | 1.306 | 53279.5 |
121 | 2018-10-28 19:56:12 | crimson | 1 | 69583 | 2 | 1.146 | 60718.2 |
120 | 2018-09-24 03:54:37 | crimson | 1 | 69583 | 2 | 1.420 | 49002.1 |
119 | 2018-08-18 18:27:49 | crimson | 1 | 69583 | 2 | 1.220 | 57035.2 |
118 | 2018-08-13 00:09:16 | crimson | 1 | 69583 | 2 | 1.126 | 61796.6 |
117 | 2018-08-06 02:46:51 | crimson | 1 | 69583 | 2 | 1.096 | 63488.1 |
116 | 2018-08-04 08:29:06 | crimson | 1 | 69583 | 2 | 1.233 | 56433.9 |
115 | 2018-06-29 23:28:34 | crimson | 1 | 69583 | 2 | 1.346 | 51696.1 |
114 | 2018-06-23 14:19:25 | crimson | 1 | 69583 | 2 | 1.083 | 64250.2 |
113 | 2018-06-04 04:02:49 | crimson | 1 | 69583 | 2 | 1.073 | 64849.0 |
112 | 2018-06-02 18:54:33 | crimson | 1 | 69583 | 2 | 1.306 | 53279.5 |
111 | 2018-05-31 07:22:50 | crimson | 1 | 69583 | 2 | 1.193 | 58326.1 |
110 | 2018-05-28 00:07:56 | crimson | 1 | 69583 | 2 | 1.210 | 57506.6 |
109 | 2018-05-23 05:28:01 | crimson | 1 | 69583 | 2 | 1.100 | 63257.3 |
108 | 2018-05-21 09:01:05 | crimson | 1 | 69583 | 2 | 1.203 | 57841.2 |
107 | 2018-05-19 21:59:34 | crimson | 1 | 69583 | 2 | 1.193 | 58326.1 |
106 | 2018-05-12 10:42:28 | crimson | 1 | 69583 | 2 | 1.340 | 51927.6 |
105 | 2018-04-23 21:27:13 | crimson | 1 | 69583 | 2 | 1.126 | 61796.6 |
104 | 2018-04-18 12:25:59 | crimson | 1 | 69583 | 2 | 1.086 | 64072.7 |