History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"suburbs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-04-29 15:17:30 | suburbs | 2 | 107671 | 15 | 3.423 | 31455.2 |
199 | 2024-04-08 11:18:09 | suburbs | 1 | 69583 | 2 | 2.766 | 25156.5 |
198 | 2024-03-29 03:54:11 | suburbs | 1 | 69583 | 2 | 2.750 | 25302.9 |
197 | 2024-03-19 13:16:57 | suburbs | 3 | 134027 | 151 | 18.326 | 7313.5 |
196 | 2024-03-18 21:53:48 | suburbs | 3 | 134027 | 151 | 15.626 | 8577.2 |
195 | 2024-03-18 09:32:19 | suburbs | 3 | 134027 | 151 | 7.296 | 18369.9 |
194 | 2024-03-18 09:32:21 | suburbs | 2 | 107671 | 15 | 3.593 | 29966.9 |
193 | 2024-03-18 09:32:17 | suburbs | 1 | 69583 | 2 | 1.326 | 52475.9 |
192 | 2024-02-28 19:10:54 | suburbs | 1 | 69583 | 2 | 1.140 | 61037.7 |
191 | 2024-02-27 22:00:07 | suburbs | 1 | 69583 | 2 | 3.593 | 19366.3 |
190 | 2024-02-18 03:57:27 | suburbs | 1 | 69583 | 2 | 1.173 | 59320.5 |
189 | 2024-02-14 22:46:17 | suburbs | 1 | 69583 | 2 | 6.016 | 11566.3 |
188 | 2024-02-06 17:41:33 | suburbs | 1 | 69583 | 2 | 1.326 | 52475.9 |
187 | 2024-02-05 21:09:54 | suburbs | 2 | 107671 | 15 | 4.953 | 21738.5 |
186 | 2024-02-04 07:08:38 | suburbs | 2 | 107671 | 15 | 3.516 | 30623.2 |
185 | 2024-02-04 07:08:10 | suburbs | 3 | 134027 | 151 | 7.720 | 17361.0 |
184 | 2024-02-03 00:20:45 | suburbs | 3 | 134027 | 151 | 7.953 | 16852.4 |
183 | 2024-02-03 00:20:49 | suburbs | 2 | 107671 | 15 | 3.440 | 31299.7 |
182 | 2024-02-03 00:20:41 | suburbs | 1 | 69583 | 2 | 1.126 | 61796.6 |
181 | 2024-01-08 21:54:14 | suburbs | 1 | 69583 | 2 | 1.250 | 55666.4 |
180 | 2024-01-03 02:54:51 | suburbs | 1 | 69583 | 2 | 1.203 | 57841.2 |
179 | 2023-12-21 12:40:36 | suburbs | 2 | 107671 | 15 | 2.983 | 36094.9 |
178 | 2023-11-18 20:41:40 | suburbs | 1 | 69583 | 2 | 1.203 | 57841.2 |
177 | 2023-11-05 16:36:34 | suburbs | 1 | 69583 | 2 | 1.186 | 58670.3 |
176 | 2023-09-29 09:09:03 | suburbs | 1 | 69583 | 2 | 1.203 | 57841.2 |
175 | 2023-09-27 02:49:17 | suburbs | 1 | 69583 | 2 | 1.233 | 56433.9 |
174 | 2023-09-20 21:27:27 | suburbs | 2 | 107671 | 15 | 2.826 | 38100.1 |
173 | 2023-07-01 10:23:38 | suburbs | 2 | 107671 | 15 | 2.953 | 36461.6 |
172 | 2023-05-14 14:22:56 | suburbs | 1 | 69583 | 2 | 1.220 | 57035.2 |
171 | 2023-03-24 12:28:30 | suburbs | 2 | 107671 | 15 | 3.110 | 34620.9 |
170 | 2023-01-13 22:20:53 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
169 | 2022-12-23 07:52:51 | suburbs | 2 | 107671 | 15 | 2.796 | 38508.9 |
168 | 2022-09-03 21:58:47 | suburbs | 1 | 69583 | 2 | 1.126 | 61796.6 |
167 | 2022-09-02 01:44:08 | suburbs | 1 | 69583 | 2 | 1.126 | 61796.6 |
166 | 2022-09-01 15:40:21 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
165 | 2022-08-21 03:52:14 | suburbs | 2 | 107671 | 15 | 2.860 | 37647.2 |
164 | 2022-08-16 04:29:25 | suburbs | 1 | 69583 | 2 | 1.220 | 57035.2 |
163 | 2022-08-13 20:02:35 | suburbs | 1 | 69583 | 2 | 1.110 | 62687.4 |
162 | 2022-05-04 12:04:33 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
161 | 2022-04-19 08:59:46 | suburbs | 1 | 69583 | 2 | 1.470 | 47335.4 |
160 | 2022-04-11 09:06:39 | suburbs | 1 | 69583 | 2 | 1.123 | 61961.7 |
159 | 2022-04-07 22:28:19 | suburbs | 1 | 69583 | 2 | 1.376 | 50569.0 |
158 | 2021-12-11 02:15:53 | suburbs | 1 | 69583 | 2 | 2.546 | 27330.3 |
157 | 2021-10-23 14:17:09 | suburbs | 1 | 69583 | 2 | 1.283 | 54234.6 |
156 | 2021-08-22 15:11:04 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
155 | 2021-08-11 10:44:57 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
154 | 2021-05-28 19:31:54 | suburbs | 1 | 69583 | 2 | 1.343 | 51811.6 |
153 | 2021-05-03 03:01:41 | suburbs | 1 | 69583 | 2 | 1.266 | 54962.9 |
152 | 2021-04-22 21:33:23 | suburbs | 1 | 69583 | 2 | 1.920 | 36241.1 |
151 | 2021-04-22 03:55:49 | suburbs | 1 | 69583 | 2 | 1.533 | 45390.1 |
150 | 2021-04-01 08:57:42 | suburbs | 1 | 69583 | 2 | 1.110 | 62687.4 |
149 | 2021-02-10 00:56:39 | suburbs | 1 | 69583 | 2 | 1.110 | 62687.4 |
148 | 2021-01-14 09:25:44 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
147 | 2020-11-17 03:57:23 | suburbs | 1 | 69583 | 2 | 1.156 | 60192.9 |
146 | 2020-11-01 06:17:16 | suburbs | 1 | 69583 | 2 | 1.326 | 52475.9 |
145 | 2020-10-20 12:00:33 | suburbs | 1 | 69583 | 2 | 1.220 | 57035.2 |
144 | 2020-10-09 06:02:47 | suburbs | 1 | 69583 | 2 | 1.220 | 57035.2 |
143 | 2020-06-20 05:11:29 | suburbs | 1 | 69583 | 2 | 1.156 | 60192.9 |
142 | 2020-03-29 11:55:22 | suburbs | 1 | 69583 | 2 | 1.233 | 56433.9 |
141 | 2020-03-28 04:49:19 | suburbs | 1 | 69583 | 2 | 2.170 | 32065.9 |
140 | 2020-03-21 11:36:15 | suburbs | 1 | 69583 | 2 | 2.140 | 32515.4 |
139 | 2020-03-09 11:46:55 | suburbs | 1 | 69583 | 2 | 1.093 | 63662.4 |
138 | 2020-02-22 16:49:08 | suburbs | 1 | 69583 | 2 | 1.283 | 54234.6 |
137 | 2020-02-22 12:30:54 | suburbs | 1 | 69583 | 2 | 1.266 | 54962.9 |
136 | 2020-02-12 23:19:58 | suburbs | 1 | 69583 | 2 | 2.733 | 25460.3 |
135 | 2020-02-06 09:57:40 | suburbs | 1 | 69583 | 2 | 1.626 | 42794.0 |
134 | 2020-02-06 01:36:44 | suburbs | 1 | 69583 | 2 | 1.326 | 52475.9 |
133 | 2020-02-05 23:38:46 | suburbs | 1 | 69583 | 2 | 1.546 | 45008.4 |
132 | 2020-01-25 14:04:44 | suburbs | 1 | 69583 | 2 | 1.373 | 50679.5 |
131 | 2020-01-18 11:52:14 | suburbs | 1 | 69583 | 2 | 2.910 | 23911.7 |
130 | 2020-01-18 07:49:14 | suburbs | 1 | 69583 | 2 | 1.483 | 46920.4 |
129 | 2020-01-14 12:32:00 | suburbs | 2 | 107671 | 15 | 4.220 | 25514.5 |
128 | 2020-01-14 08:21:52 | suburbs | 1 | 69583 | 2 | 3.253 | 21390.4 |
127 | 2020-01-08 09:20:54 | suburbs | 1 | 69583 | 2 | 2.736 | 25432.4 |
126 | 2020-01-08 00:30:06 | suburbs | 1 | 69583 | 2 | 2.640 | 26357.2 |
125 | 2019-12-29 01:36:33 | suburbs | 1 | 69583 | 2 | 1.313 | 52995.4 |
124 | 2019-12-28 16:42:14 | suburbs | 1 | 69583 | 2 | 1.296 | 53690.6 |
123 | 2019-12-28 07:04:09 | suburbs | 1 | 69583 | 2 | 1.203 | 57841.2 |
122 | 2019-11-30 17:31:17 | suburbs | 1 | 69583 | 2 | 1.186 | 58670.3 |
121 | 2019-08-29 05:37:48 | suburbs | 1 | 69583 | 2 | 1.160 | 59985.3 |
120 | 2019-07-23 23:13:48 | suburbs | 1 | 69583 | 2 | 1.060 | 65644.3 |
119 | 2019-05-20 05:13:37 | suburbs | 1 | 69583 | 2 | 1.136 | 61252.6 |
118 | 2019-02-20 22:52:30 | suburbs | 1 | 69583 | 2 | 1.080 | 64428.7 |
117 | 2019-02-05 12:22:14 | suburbs | 1 | 69583 | 2 | 1.180 | 58968.6 |
116 | 2019-02-03 19:32:23 | suburbs | 1 | 69583 | 2 | 1.096 | 63488.1 |
115 | 2019-01-29 05:05:56 | suburbs | 1 | 69583 | 2 | 1.246 | 55845.1 |
114 | 2019-01-19 07:10:46 | suburbs | 1 | 69583 | 2 | 1.166 | 59676.7 |
113 | 2019-01-10 05:29:29 | suburbs | 1 | 69583 | 2 | 1.283 | 54234.6 |
112 | 2018-12-31 10:56:36 | suburbs | 1 | 69583 | 2 | 1.060 | 65644.3 |
111 | 2018-12-27 14:43:46 | suburbs | 1 | 69583 | 2 | 1.043 | 66714.3 |
110 | 2018-12-06 22:52:32 | suburbs | 1 | 69583 | 2 | 1.060 | 65644.3 |
109 | 2018-12-03 02:28:10 | suburbs | 1 | 69583 | 2 | 1.046 | 66522.9 |
108 | 2018-11-08 06:03:31 | suburbs | 1 | 69583 | 2 | 1.073 | 64849.0 |
107 | 2018-10-13 04:40:40 | suburbs | 1 | 69583 | 2 | 1.030 | 67556.3 |
106 | 2018-10-05 18:47:03 | suburbs | 1 | 69583 | 2 | 1.080 | 64428.7 |
105 | 2018-10-01 21:46:11 | suburbs | 1 | 69583 | 2 | 1.253 | 55533.1 |
104 | 2018-09-23 06:33:03 | suburbs | 1 | 69583 | 2 | 1.283 | 54234.6 |
103 | 2018-09-16 07:39:31 | suburbs | 1 | 69583 | 2 | 1.083 | 64250.2 |
102 | 2018-09-10 23:22:28 | suburbs | 1 | 69583 | 2 | 1.130 | 61577.9 |
101 | 2018-08-06 12:47:29 | suburbs | 1 | 69583 | 2 | 1.203 | 57841.2 |