History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"washroom"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-05-05 14:19:13 | washroom | 4 | 161609 | 226 | 14.656 | 11026.8 |
199 | 2024-05-05 02:33:23 | washroom | 3 | 146162 | 33 | 7.356 | 19869.8 |
198 | 2024-05-01 10:51:48 | washroom | 4 | 161609 | 226 | 21.376 | 7560.3 |
197 | 2024-04-28 04:59:40 | washroom | 4 | 161609 | 226 | 38.206 | 4229.9 |
196 | 2024-04-28 03:57:28 | washroom | 3 | 146162 | 33 | 9.920 | 14734.1 |
195 | 2024-04-28 03:57:24 | washroom | 1 | 82945 | 2 | 1.546 | 53651.4 |
194 | 2024-04-28 03:57:04 | washroom | 2 | 121059 | 6 | 8.796 | 13763.0 |
193 | 2024-04-27 21:16:41 | washroom | 4 | 161609 | 226 | 33.206 | 4866.9 |
192 | 2024-04-27 16:57:58 | washroom | 2 | 121059 | 6 | 3.643 | 33230.6 |
191 | 2024-04-19 04:00:02 | washroom | 2 | 121059 | 6 | 16.863 | 7179.0 |
190 | 2024-04-19 04:00:00 | washroom | 3 | 146162 | 33 | 16.516 | 8849.7 |
189 | 2024-04-19 03:22:35 | washroom | 1 | 82945 | 2 | 1.546 | 53651.4 |
188 | 2024-04-11 09:21:27 | washroom | 2 | 121059 | 6 | 3.983 | 30393.9 |
187 | 2024-04-11 08:59:30 | washroom | 3 | 146162 | 33 | 7.906 | 18487.5 |
186 | 2024-04-10 08:37:04 | washroom | 1 | 82945 | 2 | 1.516 | 54713.1 |
185 | 2024-04-07 23:22:45 | washroom | 1 | 82945 | 2 | 2.263 | 36652.7 |
184 | 2024-04-07 18:22:47 | washroom | 3 | 146162 | 33 | 19.610 | 7453.4 |
183 | 2024-04-06 14:28:10 | washroom | 4 | 161609 | 226 | 13.813 | 11699.8 |
182 | 2024-04-06 13:29:11 | washroom | 3 | 146162 | 33 | 17.766 | 8227.1 |
181 | 2024-04-06 05:35:57 | washroom | 3 | 146162 | 33 | 8.266 | 17682.3 |
180 | 2024-04-06 05:35:59 | washroom | 2 | 121059 | 6 | 4.110 | 29454.7 |
179 | 2024-04-06 05:35:56 | washroom | 1 | 82945 | 2 | 1.326 | 62552.8 |
178 | 2024-04-05 12:17:36 | washroom | 4 | 161609 | 226 | 25.453 | 6349.3 |
177 | 2024-04-01 08:45:44 | washroom | 4 | 161609 | 226 | 26.486 | 6101.7 |
176 | 2024-03-28 19:10:31 | washroom | 4 | 161609 | 226 | 25.703 | 6287.6 |
175 | 2024-03-28 09:08:30 | washroom | 4 | 161609 | 226 | 12.643 | 12782.5 |
174 | 2024-03-28 09:08:34 | washroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
173 | 2024-03-28 09:08:26 | washroom | 2 | 121059 | 6 | 3.623 | 33414.0 |
172 | 2024-03-28 09:08:15 | washroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
171 | 2024-03-21 06:46:00 | washroom | 1 | 82945 | 2 | 1.826 | 45424.4 |
170 | 2024-03-11 02:54:15 | washroom | 1 | 82945 | 2 | 1.436 | 57761.1 |
169 | 2024-03-07 18:42:45 | washroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
168 | 2024-03-07 08:03:50 | washroom | 4 | 161609 | 226 | 19.970 | 8092.6 |
167 | 2024-03-06 08:56:31 | washroom | 4 | 161609 | 226 | 33.943 | 4761.2 |
166 | 2024-03-02 06:25:16 | washroom | 3 | 146162 | 33 | 8.890 | 16441.2 |
165 | 2024-03-01 15:25:46 | washroom | 4 | 161609 | 226 | 17.016 | 9497.5 |
164 | 2024-02-28 20:29:45 | washroom | 2 | 121059 | 6 | 6.846 | 17683.2 |
163 | 2024-02-28 16:10:22 | washroom | 4 | 161609 | 226 | 32.923 | 4908.7 |
162 | 2024-02-28 16:05:50 | washroom | 2 | 121059 | 6 | 8.313 | 14562.6 |
161 | 2024-02-28 14:20:30 | washroom | 1 | 82945 | 2 | 1.390 | 59672.7 |
160 | 2024-02-27 08:25:41 | washroom | 3 | 146162 | 33 | 16.486 | 8865.8 |
159 | 2024-02-27 06:22:43 | washroom | 4 | 161609 | 226 | 16.766 | 9639.1 |
158 | 2024-02-26 09:11:50 | washroom | 4 | 161609 | 226 | 20.140 | 8024.3 |
157 | 2024-02-26 09:11:51 | washroom | 3 | 146162 | 33 | 14.000 | 10440.1 |
156 | 2024-02-26 09:11:49 | washroom | 2 | 121059 | 6 | 4.046 | 29920.7 |
155 | 2024-02-26 09:11:46 | washroom | 1 | 82945 | 2 | 3.016 | 27501.7 |
154 | 2024-02-10 07:01:11 | washroom | 3 | 146162 | 33 | 17.563 | 8322.2 |
153 | 2024-02-05 08:32:55 | washroom | 4 | 161609 | 226 | 25.546 | 6326.2 |
152 | 2024-02-05 03:15:15 | washroom | 4 | 161609 | 226 | 27.003 | 5984.9 |
151 | 2024-02-04 08:12:32 | washroom | 3 | 146162 | 33 | 11.830 | 12355.2 |
150 | 2024-01-27 11:07:31 | washroom | 2 | 121059 | 6 | 7.280 | 16629.0 |
149 | 2024-01-27 11:07:11 | washroom | 3 | 146162 | 33 | 7.046 | 20744.0 |
148 | 2024-01-27 03:26:35 | washroom | 4 | 161609 | 226 | 12.686 | 12739.2 |
147 | 2024-01-27 00:46:17 | washroom | 2 | 121059 | 6 | 3.706 | 32665.7 |
146 | 2024-01-26 23:04:35 | washroom | 4 | 161609 | 226 | 25.080 | 6443.7 |
145 | 2024-01-26 23:04:49 | washroom | 1 | 82945 | 2 | 1.626 | 51011.7 |
144 | 2024-01-26 23:04:31 | washroom | 3 | 146162 | 33 | 15.626 | 9353.8 |
143 | 2024-01-26 23:04:27 | washroom | 2 | 121059 | 6 | 3.966 | 30524.2 |
142 | 2024-01-22 05:01:24 | washroom | 1 | 82945 | 2 | 1.406 | 58993.6 |
141 | 2023-12-29 06:26:17 | washroom | 3 | 146162 | 33 | 7.063 | 20694.0 |
140 | 2023-11-19 07:16:28 | washroom | 1 | 82945 | 2 | 1.376 | 60279.8 |
139 | 2023-10-02 16:19:17 | washroom | 3 | 146162 | 33 | 8.063 | 18127.5 |
138 | 2023-09-06 14:37:11 | washroom | 1 | 82945 | 2 | 1.326 | 62552.8 |
137 | 2023-07-14 05:06:23 | washroom | 3 | 146162 | 33 | 6.156 | 23743.0 |
136 | 2023-06-10 16:42:03 | washroom | 1 | 82945 | 2 | 1.233 | 67270.9 |
135 | 2023-04-23 05:03:52 | washroom | 1 | 82945 | 2 | 1.266 | 65517.4 |
134 | 2023-04-02 10:52:14 | washroom | 3 | 146162 | 33 | 6.606 | 22125.6 |
133 | 2023-03-30 02:16:59 | washroom | 1 | 82945 | 2 | 1.406 | 58993.6 |
132 | 2023-03-20 17:04:56 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
131 | 2023-01-12 15:01:35 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
130 | 2023-01-01 19:36:16 | washroom | 3 | 146162 | 33 | 7.190 | 20328.5 |
129 | 2022-11-02 11:22:04 | washroom | 1 | 82945 | 2 | 1.420 | 58412.0 |
128 | 2022-09-07 21:42:22 | washroom | 3 | 146162 | 33 | 6.280 | 23274.2 |
127 | 2022-06-21 15:19:19 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
126 | 2022-03-11 19:36:36 | washroom | 1 | 82945 | 2 | 1.326 | 62552.8 |
125 | 2021-11-24 00:00:56 | washroom | 1 | 82945 | 2 | 1.436 | 57761.1 |
124 | 2021-09-27 16:32:28 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
123 | 2021-09-26 22:15:12 | washroom | 1 | 82945 | 2 | 1.420 | 58412.0 |
122 | 2021-09-22 12:48:01 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
121 | 2021-05-01 08:02:46 | washroom | 1 | 82945 | 2 | 1.483 | 55930.5 |
120 | 2021-03-30 15:18:56 | washroom | 1 | 82945 | 2 | 1.530 | 54212.4 |
119 | 2021-02-08 10:25:12 | washroom | 1 | 82945 | 2 | 1.280 | 64800.8 |
118 | 2021-01-27 08:03:02 | washroom | 4 | 161609 | 226 | 11.313 | 14285.2 |
117 | 2020-12-15 10:38:38 | washroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
116 | 2020-11-10 15:19:47 | washroom | 1 | 82945 | 2 | 1.233 | 67270.9 |
115 | 2020-10-25 14:40:20 | washroom | 1 | 82945 | 2 | 1.313 | 63172.1 |
114 | 2020-06-09 15:27:27 | washroom | 1 | 82945 | 2 | 1.296 | 64000.8 |
113 | 2020-03-28 00:49:34 | washroom | 1 | 82945 | 2 | 1.500 | 55296.7 |
112 | 2020-03-27 22:09:00 | washroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
111 | 2020-03-26 10:09:45 | washroom | 1 | 82945 | 2 | 1.470 | 56425.2 |
110 | 2020-03-24 07:00:05 | washroom | 1 | 82945 | 2 | 1.423 | 58288.8 |
109 | 2020-02-28 15:30:05 | washroom | 1 | 82945 | 2 | 1.546 | 53651.4 |
108 | 2020-02-27 23:36:20 | washroom | 1 | 82945 | 2 | 3.033 | 27347.5 |
107 | 2020-02-06 08:29:17 | washroom | 1 | 82945 | 2 | 2.423 | 34232.4 |
106 | 2020-01-30 06:41:55 | washroom | 1 | 82945 | 2 | 1.563 | 53067.8 |
105 | 2020-01-29 04:22:23 | washroom | 1 | 82945 | 2 | 2.093 | 39629.7 |
104 | 2020-01-27 15:51:23 | washroom | 1 | 82945 | 2 | 1.640 | 50576.2 |
103 | 2020-01-26 20:35:19 | washroom | 1 | 82945 | 2 | 1.686 | 49196.3 |
102 | 2020-01-19 06:39:02 | washroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
101 | 2020-01-13 21:33:33 | washroom | 1 | 82945 | 2 | 1.716 | 48336.2 |