History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiritual"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
204 | 2024-05-30 18:47:52 | spiritual | 1 | 81242 | 3 | 1.500 | 54161.3 |
203 | 2024-05-14 23:15:52 | spiritual | 4 | 165329 | 145 | 11.406 | 14494.9 |
202 | 2024-05-14 19:24:02 | spiritual | 3 | 148641 | 29 | 26.530 | 5602.8 |
201 | 2024-05-12 22:14:17 | spiritual | 1 | 81242 | 3 | 1.593 | 50999.4 |
200 | 2024-05-12 09:31:15 | spiritual | 4 | 165329 | 145 | 46.533 | 3552.9 |
199 | 2024-05-12 00:13:56 | spiritual | 4 | 165329 | 145 | 29.266 | 5649.2 |
198 | 2024-05-12 00:14:01 | spiritual | 3 | 148641 | 29 | 13.686 | 10860.8 |
197 | 2024-05-12 00:13:57 | spiritual | 2 | 121436 | 6 | 5.830 | 20829.5 |
196 | 2024-05-12 00:13:40 | spiritual | 1 | 81242 | 3 | 4.376 | 18565.4 |
195 | 2024-05-08 00:08:36 | spiritual | 1 | 81242 | 3 | 2.936 | 27671.0 |
194 | 2024-05-03 21:29:08 | spiritual | 1 | 81242 | 3 | 1.470 | 55266.7 |
193 | 2024-05-01 01:49:21 | spiritual | 1 | 81242 | 3 | 1.406 | 57782.4 |
192 | 2024-04-30 15:44:47 | spiritual | 1 | 81242 | 3 | 2.170 | 37438.7 |
191 | 2024-04-26 00:50:59 | spiritual | 2 | 121436 | 6 | 9.096 | 13350.5 |
190 | 2024-04-25 21:28:52 | spiritual | 1 | 81242 | 3 | 1.640 | 49537.8 |
189 | 2024-04-10 03:30:10 | spiritual | 1 | 81242 | 3 | 1.623 | 50056.7 |
188 | 2024-04-07 15:14:29 | spiritual | 1 | 81242 | 3 | 1.986 | 40907.4 |
187 | 2024-04-07 14:56:32 | spiritual | 4 | 165329 | 145 | 46.016 | 3592.9 |
186 | 2024-04-06 20:42:04 | spiritual | 4 | 165329 | 145 | 20.220 | 8176.5 |
185 | 2024-04-06 20:41:34 | spiritual | 3 | 148641 | 29 | 22.110 | 6722.8 |
184 | 2024-04-06 08:11:43 | spiritual | 4 | 165329 | 145 | 37.063 | 4460.8 |
183 | 2024-04-06 08:11:43 | spiritual | 3 | 148641 | 29 | 27.016 | 5502.0 |
182 | 2024-04-06 08:11:46 | spiritual | 2 | 121436 | 6 | 9.126 | 13306.6 |
181 | 2024-04-06 07:55:04 | spiritual | 1 | 81242 | 3 | 4.440 | 18297.7 |
180 | 2024-03-30 02:40:09 | spiritual | 1 | 81242 | 3 | 1.470 | 55266.7 |
179 | 2024-03-25 10:05:58 | spiritual | 1 | 81242 | 3 | 1.233 | 65889.7 |
178 | 2024-03-11 06:08:26 | spiritual | 2 | 121436 | 6 | 13.110 | 9262.9 |
177 | 2024-03-11 02:38:45 | spiritual | 1 | 81242 | 3 | 1.533 | 52995.4 |
176 | 2024-03-05 10:09:13 | spiritual | 1 | 81242 | 3 | 1.513 | 53696.0 |
175 | 2024-03-03 14:23:45 | spiritual | 4 | 165329 | 145 | 27.533 | 6004.8 |
174 | 2024-03-03 14:23:45 | spiritual | 3 | 148641 | 29 | 12.250 | 12134.0 |
173 | 2024-03-03 14:23:45 | spiritual | 2 | 121436 | 6 | 8.826 | 13758.9 |
172 | 2024-03-03 14:21:27 | spiritual | 1 | 81242 | 3 | 1.483 | 54782.2 |
171 | 2024-02-28 19:20:04 | spiritual | 1 | 81242 | 3 | 1.470 | 55266.7 |
170 | 2024-02-27 17:51:55 | spiritual | 1 | 81242 | 3 | 1.280 | 63470.3 |
169 | 2024-02-08 10:20:29 | spiritual | 1 | 81242 | 3 | 4.800 | 16925.4 |
168 | 2024-01-29 16:06:38 | spiritual | 1 | 81242 | 3 | 1.423 | 57092.1 |
167 | 2024-01-26 01:02:13 | spiritual | 1 | 81242 | 3 | 1.453 | 55913.3 |
166 | 2024-01-18 04:37:02 | spiritual | 4 | 165329 | 145 | 13.623 | 12136.0 |
165 | 2024-01-12 08:59:37 | spiritual | 1 | 81242 | 3 | 1.516 | 53589.7 |
164 | 2024-01-10 12:48:16 | spiritual | 4 | 165329 | 145 | 10.670 | 15494.8 |
163 | 2023-11-19 22:27:36 | spiritual | 1 | 81242 | 3 | 1.346 | 60358.1 |
162 | 2023-11-18 06:47:58 | spiritual | 4 | 165329 | 145 | 15.670 | 10550.7 |
161 | 2023-11-05 21:48:23 | spiritual | 4 | 165329 | 145 | 10.953 | 15094.4 |
160 | 2023-11-05 21:13:20 | spiritual | 1 | 81242 | 3 | 1.360 | 59736.8 |
159 | 2023-10-24 07:12:45 | spiritual | 4 | 165329 | 145 | 13.843 | 11943.1 |
158 | 2023-10-24 07:12:35 | spiritual | 4 | 165329 | 145 | 12.860 | 12856.1 |
157 | 2023-10-24 02:27:40 | spiritual | 4 | 165329 | 145 | 21.986 | 7519.7 |
156 | 2023-10-20 10:34:46 | spiritual | 4 | 165329 | 145 | 11.420 | 14477.1 |
155 | 2023-10-09 12:13:00 | spiritual | 1 | 81242 | 3 | 1.440 | 56418.1 |
154 | 2023-09-13 21:05:43 | spiritual | 1 | 81242 | 3 | 1.403 | 57905.9 |
153 | 2023-09-01 09:43:50 | spiritual | 1 | 81242 | 3 | 1.280 | 63470.3 |
152 | 2023-08-29 01:51:53 | spiritual | 1 | 81242 | 3 | 1.220 | 66591.8 |
151 | 2023-08-26 17:55:43 | spiritual | 1 | 81242 | 3 | 1.250 | 64993.6 |
150 | 2023-07-30 14:34:05 | spiritual | 4 | 165329 | 145 | 10.563 | 15651.7 |
149 | 2023-05-29 23:27:11 | spiritual | 1 | 81242 | 3 | 1.360 | 59736.8 |
148 | 2023-04-10 05:10:42 | spiritual | 4 | 165329 | 145 | 11.766 | 14051.4 |
147 | 2023-04-08 23:05:40 | spiritual | 1 | 81242 | 3 | 1.770 | 45899.4 |
146 | 2023-03-23 05:56:41 | spiritual | 1 | 81242 | 3 | 1.233 | 65889.7 |
145 | 2023-01-15 12:08:13 | spiritual | 4 | 165329 | 145 | 10.376 | 15933.8 |
144 | 2023-01-07 22:53:26 | spiritual | 1 | 81242 | 3 | 1.220 | 66591.8 |
143 | 2022-11-25 18:16:24 | spiritual | 4 | 165329 | 145 | 11.203 | 14757.6 |
142 | 2022-11-25 18:16:02 | spiritual | 4 | 165329 | 145 | 11.580 | 14277.1 |
141 | 2022-11-25 18:15:40 | spiritual | 4 | 165329 | 145 | 11.500 | 14376.4 |
140 | 2022-11-25 18:15:30 | spiritual | 3 | 148641 | 29 | 6.186 | 24028.6 |
139 | 2022-11-25 18:15:20 | spiritual | 2 | 121436 | 6 | 3.436 | 35342.3 |
138 | 2022-11-23 23:14:57 | spiritual | 1 | 81242 | 3 | 1.236 | 65729.8 |
137 | 2022-11-23 19:09:47 | spiritual | 1 | 81242 | 3 | 1.263 | 64324.6 |
136 | 2022-10-19 10:09:02 | spiritual | 4 | 165329 | 145 | 10.623 | 15563.3 |
135 | 2022-10-04 15:33:55 | spiritual | 1 | 81242 | 3 | 1.376 | 59042.2 |
134 | 2022-06-25 04:18:20 | spiritual | 1 | 81242 | 3 | 1.233 | 65889.7 |
133 | 2022-06-10 05:53:34 | spiritual | 4 | 165329 | 145 | 10.920 | 15140.0 |
132 | 2022-05-20 22:57:11 | spiritual | 4 | 165329 | 145 | 10.656 | 15515.1 |
131 | 2022-05-18 17:59:50 | spiritual | 1 | 81242 | 3 | 1.420 | 57212.7 |
130 | 2022-02-15 07:15:38 | spiritual | 1 | 81242 | 3 | 1.470 | 55266.7 |
129 | 2022-01-29 23:39:08 | spiritual | 1 | 81242 | 3 | 1.280 | 63470.3 |
128 | 2021-09-20 19:40:45 | spiritual | 1 | 81242 | 3 | 1.423 | 57092.1 |
127 | 2021-06-10 06:38:15 | spiritual | 1 | 81242 | 3 | 1.313 | 61875.1 |
126 | 2021-03-07 20:27:49 | spiritual | 1 | 81242 | 3 | 1.406 | 57782.4 |
125 | 2021-01-31 07:30:11 | spiritual | 1 | 81242 | 3 | 1.266 | 64172.2 |
124 | 2021-01-28 10:43:19 | spiritual | 1 | 81242 | 3 | 2.500 | 32496.8 |
123 | 2021-01-03 10:55:11 | spiritual | 1 | 81242 | 3 | 1.266 | 64172.2 |
122 | 2020-12-04 02:51:44 | spiritual | 1 | 81242 | 3 | 1.266 | 64172.2 |
121 | 2020-11-11 20:24:02 | spiritual | 1 | 81242 | 3 | 1.330 | 61084.2 |
120 | 2020-08-29 11:02:48 | spiritual | 1 | 81242 | 3 | 1.263 | 64324.6 |
119 | 2020-08-12 12:41:25 | spiritual | 1 | 81242 | 3 | 1.360 | 59736.8 |
118 | 2020-08-09 09:25:00 | spiritual | 1 | 81242 | 3 | 1.326 | 61268.5 |
117 | 2020-08-06 04:19:10 | spiritual | 1 | 81242 | 3 | 1.280 | 63470.3 |
116 | 2020-05-30 09:30:41 | spiritual | 1 | 81242 | 3 | 1.406 | 57782.4 |
115 | 2020-05-10 19:41:02 | spiritual | 1 | 81242 | 3 | 1.313 | 61875.1 |
114 | 2020-05-06 09:52:41 | spiritual | 1 | 81242 | 3 | 1.420 | 57212.7 |
113 | 2020-03-23 19:57:13 | spiritual | 1 | 81242 | 3 | 1.580 | 51419.0 |
112 | 2020-02-13 05:50:53 | spiritual | 4 | 165329 | 145 | 15.190 | 10884.1 |
111 | 2020-02-12 19:01:11 | spiritual | 4 | 165329 | 145 | 13.546 | 12205.0 |
110 | 2020-02-11 11:45:21 | spiritual | 4 | 165329 | 145 | 24.690 | 6696.2 |
109 | 2020-02-08 12:57:47 | spiritual | 1 | 81242 | 3 | 3.313 | 24522.2 |
108 | 2020-02-08 09:40:45 | spiritual | 4 | 165329 | 145 | 25.626 | 6451.6 |
107 | 2020-02-08 08:57:04 | spiritual | 1 | 81242 | 3 | 1.686 | 48186.2 |
106 | 2020-02-03 15:46:16 | spiritual | 1 | 81242 | 3 | 1.376 | 59042.2 |
105 | 2020-01-30 17:12:26 | spiritual | 1 | 81242 | 3 | 3.186 | 25499.7 |