History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affordable"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
201 | 2024-05-14 14:39:22 | affordable | 1 | 67641 | 2 | 1.090 | 62056.0 |
200 | 2024-05-13 12:28:00 | affordable | 4 | 161450 | 111 | 34.410 | 4692.0 |
199 | 2024-05-12 16:21:14 | affordable | 4 | 161450 | 111 | 34.190 | 4722.1 |
198 | 2024-05-12 16:21:17 | affordable | 3 | 140603 | 20 | 11.373 | 12362.9 |
197 | 2024-05-12 16:21:17 | affordable | 2 | 108824 | 5 | 10.406 | 10457.8 |
196 | 2024-05-12 16:20:00 | affordable | 1 | 67641 | 2 | 2.483 | 27241.6 |
195 | 2024-05-12 16:19:35 | affordable | 4 | 161450 | 111 | 18.330 | 8808.0 |
194 | 2024-05-12 16:19:35 | affordable | 2 | 108824 | 5 | 6.920 | 15726.0 |
193 | 2024-05-12 16:19:33 | affordable | 3 | 140603 | 20 | 8.796 | 15984.9 |
192 | 2024-05-12 16:19:17 | affordable | 1 | 67641 | 2 | 1.296 | 52192.1 |
191 | 2024-05-12 16:19:09 | affordable | 1 | 67641 | 2 | 2.330 | 29030.5 |
190 | 2024-04-29 18:36:12 | affordable | 2 | 108824 | 5 | 2.923 | 37230.2 |
189 | 2024-04-26 04:15:31 | affordable | 1 | 67641 | 2 | 1.080 | 62630.6 |
188 | 2024-04-16 07:40:47 | affordable | 1 | 67641 | 2 | 1.186 | 57032.9 |
187 | 2024-04-03 19:52:56 | affordable | 1 | 67641 | 2 | 1.483 | 45610.9 |
186 | 2024-04-02 13:52:35 | affordable | 4 | 161450 | 111 | 28.126 | 5740.2 |
185 | 2024-04-02 13:52:34 | affordable | 3 | 140603 | 20 | 17.783 | 7906.6 |
184 | 2024-04-02 13:52:33 | affordable | 2 | 108824 | 5 | 6.686 | 16276.4 |
183 | 2024-04-02 13:51:49 | affordable | 1 | 67641 | 2 | 3.970 | 17038.0 |
182 | 2024-03-30 03:32:54 | affordable | 1 | 67641 | 2 | 2.516 | 26884.3 |
181 | 2024-03-27 09:34:05 | affordable | 1 | 67641 | 2 | 1.076 | 62863.4 |
180 | 2024-03-13 18:54:13 | affordable | 4 | 161450 | 111 | 15.656 | 10312.3 |
179 | 2024-03-13 09:14:01 | affordable | 1 | 67641 | 2 | 1.046 | 64666.3 |
178 | 2024-03-10 11:56:42 | affordable | 4 | 161450 | 111 | 29.830 | 5412.3 |
177 | 2024-03-10 11:56:36 | affordable | 3 | 140603 | 20 | 19.376 | 7256.6 |
176 | 2024-03-10 11:30:42 | affordable | 4 | 161450 | 111 | 24.016 | 6722.6 |
175 | 2024-03-10 09:25:02 | affordable | 4 | 161450 | 111 | 19.046 | 8476.8 |
174 | 2024-03-10 08:49:52 | affordable | 4 | 161450 | 111 | 29.030 | 5561.5 |
173 | 2024-03-10 08:49:55 | affordable | 3 | 140603 | 20 | 16.220 | 8668.5 |
172 | 2024-03-10 08:49:55 | affordable | 2 | 108824 | 5 | 6.986 | 15577.4 |
171 | 2024-03-10 08:47:55 | affordable | 1 | 67641 | 2 | 3.860 | 17523.6 |
170 | 2024-03-02 02:12:10 | affordable | 1 | 67641 | 2 | 1.216 | 55625.8 |
169 | 2024-03-01 19:35:57 | affordable | 3 | 140603 | 20 | 7.123 | 19739.3 |
168 | 2024-02-29 19:46:51 | affordable | 3 | 140603 | 20 | 5.890 | 23871.5 |
167 | 2024-02-27 21:54:51 | affordable | 1 | 67641 | 2 | 2.576 | 26258.2 |
166 | 2024-02-10 17:12:21 | affordable | 2 | 108824 | 5 | 10.296 | 10569.5 |
165 | 2024-01-28 04:28:40 | affordable | 1 | 67641 | 2 | 0.983 | 68810.8 |
164 | 2023-12-20 19:02:51 | affordable | 2 | 108824 | 5 | 2.466 | 44129.8 |
163 | 2023-12-15 13:26:23 | affordable | 1 | 67641 | 2 | 1.030 | 65670.9 |
162 | 2023-12-14 13:55:40 | affordable | 1 | 67641 | 2 | 1.000 | 67641.0 |
161 | 2023-12-05 15:12:14 | affordable | 1 | 67641 | 2 | 1.046 | 64666.3 |
160 | 2023-11-24 16:16:57 | affordable | 1 | 67641 | 2 | 0.986 | 68601.4 |
159 | 2023-11-20 03:58:02 | affordable | 3 | 140603 | 20 | 5.406 | 26008.7 |
158 | 2023-11-17 01:10:41 | affordable | 1 | 67641 | 2 | 1.110 | 60937.8 |
157 | 2023-10-14 21:22:27 | affordable | 1 | 67641 | 2 | 1.106 | 61158.2 |
156 | 2023-10-13 22:59:40 | affordable | 1 | 67641 | 2 | 1.156 | 58513.0 |
155 | 2023-09-20 21:04:32 | affordable | 2 | 108824 | 5 | 2.860 | 38050.3 |
154 | 2023-09-12 23:13:03 | affordable | 1 | 67641 | 2 | 0.986 | 68601.4 |
153 | 2023-08-20 10:04:23 | affordable | 3 | 140603 | 20 | 5.140 | 27354.7 |
152 | 2023-06-26 23:35:59 | affordable | 2 | 108824 | 5 | 2.470 | 44058.3 |
151 | 2023-06-23 03:45:46 | affordable | 1 | 67641 | 2 | 1.060 | 63812.3 |
150 | 2023-05-25 19:10:56 | affordable | 1 | 67641 | 2 | 0.970 | 69733.0 |
149 | 2023-05-03 06:41:13 | affordable | 3 | 140603 | 20 | 6.123 | 22963.1 |
148 | 2023-04-03 16:22:06 | affordable | 1 | 67641 | 2 | 0.970 | 69733.0 |
147 | 2023-03-20 14:25:14 | affordable | 2 | 108824 | 5 | 2.453 | 44363.6 |
146 | 2023-02-07 23:41:55 | affordable | 3 | 140603 | 20 | 5.046 | 27864.2 |
145 | 2023-01-11 09:20:36 | affordable | 1 | 67641 | 2 | 0.966 | 70021.7 |
144 | 2022-12-20 16:55:39 | affordable | 2 | 108824 | 5 | 2.580 | 42179.8 |
143 | 2022-11-19 17:02:09 | affordable | 3 | 140603 | 20 | 10.190 | 13798.1 |
142 | 2022-11-18 13:09:13 | affordable | 1 | 67641 | 2 | 1.093 | 61885.6 |
141 | 2022-08-19 23:57:13 | affordable | 1 | 67641 | 2 | 1.106 | 61158.2 |
140 | 2022-08-16 05:11:19 | affordable | 2 | 108824 | 5 | 2.640 | 41221.2 |
139 | 2022-07-14 19:37:55 | affordable | 4 | 161450 | 111 | 9.780 | 16508.2 |
138 | 2022-07-10 06:16:46 | affordable | 1 | 67641 | 2 | 0.986 | 68601.4 |
137 | 2022-06-22 20:26:06 | affordable | 3 | 140603 | 20 | 5.110 | 27515.3 |
136 | 2022-03-27 20:47:05 | affordable | 1 | 67641 | 2 | 1.140 | 59334.2 |
135 | 2022-03-19 09:46:05 | affordable | 1 | 67641 | 2 | 0.983 | 68810.8 |
134 | 2022-03-15 23:02:48 | affordable | 1 | 67641 | 2 | 1.203 | 56226.9 |
133 | 2021-11-05 09:46:13 | affordable | 1 | 67641 | 2 | 1.173 | 57665.0 |
132 | 2021-07-08 06:38:51 | affordable | 1 | 67641 | 2 | 0.983 | 68810.8 |
131 | 2021-04-08 11:17:39 | affordable | 1 | 67641 | 2 | 1.156 | 58513.0 |
130 | 2021-04-04 07:30:13 | affordable | 1 | 67641 | 2 | 1.140 | 59334.2 |
129 | 2021-02-22 08:26:17 | affordable | 1 | 67641 | 2 | 2.203 | 30704.0 |
128 | 2020-12-30 07:12:35 | affordable | 1 | 67641 | 2 | 1.000 | 67641.0 |
127 | 2020-12-26 17:15:03 | affordable | 1 | 67641 | 2 | 1.110 | 60937.8 |
126 | 2020-10-28 19:20:13 | affordable | 1 | 67641 | 2 | 1.000 | 67641.0 |
125 | 2020-09-23 00:34:05 | affordable | 1 | 67641 | 2 | 1.013 | 66773.0 |
124 | 2020-05-27 23:40:06 | affordable | 1 | 67641 | 2 | 1.080 | 62630.6 |
123 | 2020-05-25 00:24:18 | affordable | 1 | 67641 | 2 | 1.013 | 66773.0 |
122 | 2020-03-23 08:57:21 | affordable | 1 | 67641 | 2 | 1.236 | 54725.7 |
121 | 2020-02-12 23:03:28 | affordable | 1 | 67641 | 2 | 1.186 | 57032.9 |
120 | 2020-02-09 22:09:52 | affordable | 1 | 67641 | 2 | 1.203 | 56226.9 |
119 | 2020-02-03 10:42:00 | affordable | 1 | 67641 | 2 | 1.186 | 57032.9 |
118 | 2020-01-30 08:44:18 | affordable | 1 | 67641 | 2 | 2.393 | 28266.2 |
117 | 2020-01-27 19:13:47 | affordable | 1 | 67641 | 2 | 1.016 | 66575.8 |
116 | 2020-01-20 22:17:30 | affordable | 1 | 67641 | 2 | 2.593 | 26086.0 |
115 | 2020-01-19 21:13:31 | affordable | 1 | 67641 | 2 | 1.080 | 62630.6 |
114 | 2020-01-01 22:33:59 | affordable | 1 | 67641 | 2 | 1.250 | 54112.8 |
113 | 2020-01-01 08:08:23 | affordable | 1 | 67641 | 2 | 1.186 | 57032.9 |
112 | 2019-11-12 21:23:37 | affordable | 1 | 67641 | 2 | 1.093 | 61885.6 |
111 | 2019-08-11 13:28:46 | affordable | 1 | 67641 | 2 | 1.033 | 65480.2 |
110 | 2019-07-23 15:41:23 | affordable | 1 | 67641 | 2 | 0.980 | 69021.4 |
109 | 2019-05-02 06:48:53 | affordable | 1 | 67641 | 2 | 1.123 | 60232.4 |
108 | 2019-01-14 03:56:55 | affordable | 1 | 67641 | 2 | 1.060 | 63812.3 |
107 | 2018-11-05 11:17:21 | affordable | 1 | 67641 | 2 | 1.006 | 67237.6 |
106 | 2018-09-18 03:01:26 | affordable | 1 | 67641 | 2 | 1.156 | 58513.0 |
105 | 2018-06-28 11:21:08 | affordable | 1 | 67641 | 2 | 0.956 | 70754.2 |
104 | 2018-06-27 00:13:36 | affordable | 1 | 67641 | 2 | 1.106 | 61158.2 |
103 | 2018-06-26 15:00:22 | affordable | 1 | 67641 | 2 | 0.966 | 70021.7 |
102 | 2018-06-24 01:27:53 | affordable | 1 | 67641 | 2 | 1.000 | 67641.0 |