History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tzitzit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
208 | 2024-04-29 01:26:11 | tzitzit | 1 | 69583 | 3 | 1.236 | 56296.9 |
207 | 2024-04-29 01:25:20 | tzitzit | 3 | 134027 | 22 | 9.533 | 14059.3 |
206 | 2024-04-29 01:25:17 | tzitzit | 2 | 107671 | 5 | 3.923 | 27446.1 |
205 | 2024-04-09 10:50:47 | tzitzit | 4 | 151207 | 286 | 25.093 | 6025.9 |
204 | 2024-04-08 08:04:23 | tzitzit | 3 | 134027 | 22 | 17.876 | 7497.6 |
203 | 2024-04-08 08:04:15 | tzitzit | 2 | 107671 | 5 | 3.656 | 29450.5 |
202 | 2024-04-08 08:04:06 | tzitzit | 1 | 69583 | 3 | 3.080 | 22591.9 |
201 | 2024-04-08 05:17:38 | tzitzit | 4 | 151207 | 286 | 16.983 | 8903.4 |
200 | 2024-04-07 14:37:59 | tzitzit | 1 | 69583 | 3 | 4.173 | 16674.6 |
199 | 2024-04-04 23:03:44 | tzitzit | 4 | 151207 | 286 | 37.470 | 4035.4 |
198 | 2024-04-04 07:07:44 | tzitzit | 4 | 151207 | 286 | 15.393 | 9823.1 |
197 | 2024-04-04 06:51:08 | tzitzit | 4 | 151207 | 286 | 31.893 | 4741.1 |
196 | 2024-04-04 06:51:08 | tzitzit | 3 | 134027 | 22 | 16.313 | 8216.0 |
195 | 2024-04-04 06:51:04 | tzitzit | 1 | 69583 | 3 | 3.763 | 18491.4 |
194 | 2024-04-04 06:50:44 | tzitzit | 2 | 107671 | 5 | 8.813 | 12217.3 |
193 | 2024-04-04 06:50:39 | tzitzit | 1 | 69583 | 3 | 1.906 | 36507.3 |
192 | 2024-03-25 14:20:39 | tzitzit | 1 | 69583 | 3 | 1.203 | 57841.2 |
191 | 2024-03-05 17:22:56 | tzitzit | 4 | 151207 | 286 | 12.673 | 11931.4 |
190 | 2024-03-05 02:27:31 | tzitzit | 1 | 69583 | 3 | 1.560 | 44604.5 |
189 | 2024-03-05 01:15:49 | tzitzit | 3 | 134027 | 22 | 14.703 | 9115.6 |
188 | 2024-03-05 01:15:46 | tzitzit | 2 | 107671 | 5 | 3.670 | 29338.1 |
187 | 2024-03-04 21:15:48 | tzitzit | 3 | 134027 | 22 | 18.300 | 7323.9 |
186 | 2024-03-04 21:15:47 | tzitzit | 2 | 107671 | 5 | 10.780 | 9988.0 |
185 | 2024-03-04 20:32:33 | tzitzit | 1 | 69583 | 3 | 2.643 | 26327.3 |
184 | 2024-03-04 16:30:34 | tzitzit | 3 | 134027 | 22 | 21.156 | 6335.2 |
183 | 2024-03-03 11:00:44 | tzitzit | 3 | 134027 | 22 | 30.940 | 4331.8 |
182 | 2024-03-03 11:00:44 | tzitzit | 2 | 107671 | 5 | 8.203 | 13125.8 |
181 | 2024-03-03 11:00:40 | tzitzit | 1 | 69583 | 3 | 2.690 | 25867.3 |
180 | 2024-03-03 08:19:04 | tzitzit | 4 | 151207 | 286 | 12.253 | 12340.4 |
179 | 2024-03-02 18:34:57 | tzitzit | 4 | 151207 | 286 | 37.063 | 4079.7 |
178 | 2024-03-02 16:06:47 | tzitzit | 4 | 151207 | 286 | 26.126 | 5787.6 |
177 | 2024-02-28 21:55:27 | tzitzit | 4 | 151207 | 286 | 19.123 | 7907.1 |
176 | 2024-02-21 12:15:12 | tzitzit | 1 | 69583 | 3 | 1.236 | 56296.9 |
175 | 2024-02-14 23:15:05 | tzitzit | 1 | 69583 | 3 | 4.860 | 14317.5 |
174 | 2024-02-03 00:12:28 | tzitzit | 1 | 69583 | 3 | 1.233 | 56433.9 |
173 | 2024-02-02 06:05:23 | tzitzit | 4 | 151207 | 286 | 10.156 | 14888.4 |
172 | 2024-02-01 04:35:52 | tzitzit | 4 | 151207 | 286 | 10.720 | 14105.1 |
171 | 2024-02-01 04:35:55 | tzitzit | 2 | 107671 | 5 | 3.013 | 35735.5 |
170 | 2024-02-01 04:35:48 | tzitzit | 3 | 134027 | 22 | 6.016 | 22278.4 |
169 | 2024-02-01 04:26:16 | tzitzit | 4 | 151207 | 286 | 12.576 | 12023.5 |
168 | 2024-02-01 01:36:28 | tzitzit | 4 | 151207 | 286 | 12.126 | 12469.7 |
167 | 2024-02-01 01:36:24 | tzitzit | 3 | 134027 | 22 | 7.080 | 18930.4 |
166 | 2024-02-01 01:36:08 | tzitzit | 2 | 107671 | 5 | 3.343 | 32207.9 |
165 | 2024-02-01 01:35:56 | tzitzit | 1 | 69583 | 3 | 1.093 | 63662.4 |
164 | 2024-01-03 15:48:18 | tzitzit | 1 | 69583 | 3 | 1.063 | 65459.1 |
163 | 2023-12-17 20:54:38 | tzitzit | 1 | 69583 | 3 | 1.123 | 61961.7 |
162 | 2023-11-23 17:20:31 | tzitzit | 4 | 151207 | 286 | 11.513 | 13133.6 |
161 | 2023-11-19 16:23:46 | tzitzit | 1 | 69583 | 3 | 1.140 | 61037.7 |
160 | 2023-10-06 09:24:39 | tzitzit | 1 | 69583 | 3 | 1.220 | 57035.2 |
159 | 2023-08-23 20:49:07 | tzitzit | 4 | 151207 | 286 | 9.770 | 15476.7 |
158 | 2023-08-03 07:31:44 | tzitzit | 1 | 69583 | 3 | 1.030 | 67556.3 |
157 | 2023-07-05 01:33:31 | tzitzit | 1 | 69583 | 3 | 1.170 | 59472.6 |
156 | 2023-05-27 00:58:05 | tzitzit | 4 | 151207 | 286 | 9.170 | 16489.3 |
155 | 2023-05-09 10:30:01 | tzitzit | 4 | 151207 | 286 | 10.563 | 14314.8 |
154 | 2023-05-04 05:02:49 | tzitzit | 1 | 69583 | 3 | 1.140 | 61037.7 |
153 | 2023-04-02 17:08:44 | tzitzit | 4 | 151207 | 286 | 9.283 | 16288.6 |
152 | 2023-03-18 19:33:03 | tzitzit | 4 | 151207 | 286 | 9.700 | 15588.4 |
151 | 2023-02-26 08:44:00 | tzitzit | 1 | 69583 | 3 | 1.016 | 68487.2 |
150 | 2023-02-15 00:41:12 | tzitzit | 4 | 151207 | 286 | 9.326 | 16213.5 |
149 | 2023-02-13 11:57:52 | tzitzit | 4 | 151207 | 286 | 10.173 | 14863.6 |
148 | 2023-01-30 04:00:18 | tzitzit | 4 | 151207 | 286 | 10.456 | 14461.3 |
147 | 2023-01-06 05:14:37 | tzitzit | 4 | 151207 | 286 | 9.390 | 16103.0 |
146 | 2022-12-29 11:23:51 | tzitzit | 4 | 151207 | 286 | 10.033 | 15071.0 |
145 | 2022-12-25 00:58:54 | tzitzit | 1 | 69583 | 3 | 1.000 | 69583.0 |
144 | 2022-11-26 11:21:12 | tzitzit | 4 | 151207 | 286 | 10.483 | 14424.0 |
143 | 2022-09-13 12:02:02 | tzitzit | 1 | 69583 | 3 | 1.016 | 68487.2 |
142 | 2022-09-04 04:16:07 | tzitzit | 4 | 151207 | 286 | 10.076 | 15006.6 |
141 | 2022-07-16 15:56:28 | tzitzit | 1 | 69583 | 3 | 1.060 | 65644.3 |
140 | 2022-06-24 21:04:16 | tzitzit | 4 | 151207 | 286 | 10.876 | 13902.8 |
139 | 2022-06-19 08:14:54 | tzitzit | 4 | 151207 | 286 | 10.050 | 15045.5 |
138 | 2022-05-23 12:54:28 | tzitzit | 4 | 151207 | 286 | 9.733 | 15535.5 |
137 | 2022-04-21 16:24:51 | tzitzit | 4 | 151207 | 286 | 11.486 | 13164.5 |
136 | 2022-03-14 07:03:14 | tzitzit | 1 | 69583 | 3 | 1.076 | 64668.2 |
135 | 2022-03-12 03:00:40 | tzitzit | 1 | 69583 | 3 | 1.096 | 63488.1 |
134 | 2021-12-24 22:20:38 | tzitzit | 4 | 151207 | 286 | 10.203 | 14819.9 |
133 | 2021-10-30 00:00:20 | tzitzit | 1 | 69583 | 3 | 1.216 | 57222.9 |
132 | 2021-10-09 06:27:36 | tzitzit | 4 | 151207 | 286 | 9.236 | 16371.5 |
131 | 2021-09-21 17:37:07 | tzitzit | 1 | 69583 | 3 | 2.846 | 24449.4 |
130 | 2021-09-20 12:37:16 | tzitzit | 1 | 69583 | 3 | 1.190 | 58473.1 |
129 | 2021-09-13 18:11:04 | tzitzit | 1 | 69583 | 3 | 1.060 | 65644.3 |
128 | 2021-09-04 19:43:45 | tzitzit | 4 | 151207 | 286 | 9.970 | 15166.2 |
127 | 2021-08-12 18:27:32 | tzitzit | 1 | 69583 | 3 | 1.156 | 60192.9 |
126 | 2021-07-30 13:00:48 | tzitzit | 2 | 107671 | 5 | 2.690 | 40026.4 |
125 | 2021-07-20 23:36:59 | tzitzit | 4 | 151207 | 286 | 9.266 | 16318.5 |
124 | 2021-07-17 21:48:04 | tzitzit | 4 | 151207 | 286 | 9.126 | 16568.8 |
123 | 2021-07-05 07:22:35 | tzitzit | 1 | 69583 | 3 | 1.156 | 60192.9 |
122 | 2021-06-28 02:16:56 | tzitzit | 1 | 69583 | 3 | 1.186 | 58670.3 |
121 | 2021-06-17 15:37:21 | tzitzit | 4 | 151207 | 286 | 9.783 | 15456.1 |
120 | 2021-05-24 20:27:44 | tzitzit | 1 | 69583 | 3 | 1.173 | 59320.5 |
119 | 2021-05-07 02:10:18 | tzitzit | 1 | 69583 | 3 | 1.313 | 52995.4 |
118 | 2021-02-06 07:21:27 | tzitzit | 1 | 69583 | 3 | 1.106 | 62914.1 |
117 | 2020-10-31 20:09:30 | tzitzit | 1 | 69583 | 3 | 1.186 | 58670.3 |
116 | 2020-06-03 18:20:55 | tzitzit | 1 | 69583 | 3 | 1.060 | 65644.3 |
115 | 2020-04-20 13:52:36 | tzitzit | 1 | 69583 | 3 | 1.063 | 65459.1 |
114 | 2020-03-29 00:05:03 | tzitzit | 1 | 69583 | 3 | 1.030 | 67556.3 |
113 | 2020-03-27 16:46:05 | tzitzit | 1 | 69583 | 3 | 1.110 | 62687.4 |
112 | 2020-03-23 00:01:47 | tzitzit | 1 | 69583 | 3 | 1.186 | 58670.3 |
111 | 2020-03-14 07:38:28 | tzitzit | 1 | 69583 | 3 | 1.156 | 60192.9 |
110 | 2020-02-17 21:53:29 | tzitzit | 1 | 69583 | 3 | 1.360 | 51164.0 |
109 | 2020-02-15 21:23:15 | tzitzit | 1 | 69583 | 3 | 1.063 | 65459.1 |