History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tollhouses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
176 | 2024-04-08 12:42:52 | tollhouses | 4 | 161450 | 167 | 30.406 | 5309.8 |
175 | 2024-04-08 12:42:55 | tollhouses | 2 | 108824 | 9 | 9.843 | 11056.0 |
174 | 2024-04-08 12:33:08 | tollhouses | 1 | 67641 | 4 | 1.110 | 60937.8 |
173 | 2024-03-29 16:43:42 | tollhouses | 1 | 67641 | 4 | 1.203 | 56226.9 |
172 | 2024-03-26 09:52:18 | tollhouses | 3 | 140603 | 32 | 11.140 | 12621.5 |
171 | 2024-03-26 01:58:31 | tollhouses | 1 | 67641 | 4 | 1.220 | 55443.4 |
170 | 2024-03-25 14:16:21 | tollhouses | 1 | 67641 | 4 | 0.983 | 68810.8 |
169 | 2024-03-24 18:39:47 | tollhouses | 3 | 140603 | 32 | 24.940 | 5637.7 |
168 | 2024-03-24 18:39:51 | tollhouses | 2 | 108824 | 9 | 3.703 | 29388.1 |
167 | 2024-03-21 20:43:03 | tollhouses | 4 | 161450 | 167 | 44.050 | 3665.2 |
166 | 2024-03-21 14:23:09 | tollhouses | 3 | 140603 | 32 | 19.283 | 7291.6 |
165 | 2024-03-21 14:22:53 | tollhouses | 2 | 108824 | 9 | 5.250 | 20728.4 |
164 | 2024-03-21 14:18:57 | tollhouses | 3 | 140603 | 32 | 14.876 | 9451.7 |
163 | 2024-03-21 14:18:53 | tollhouses | 2 | 108824 | 9 | 10.203 | 10665.9 |
162 | 2024-03-21 14:18:38 | tollhouses | 1 | 67641 | 4 | 4.000 | 16910.3 |
161 | 2024-03-21 14:18:29 | tollhouses | 1 | 67641 | 4 | 2.576 | 26258.2 |
160 | 2024-03-21 07:40:02 | tollhouses | 4 | 161450 | 167 | 28.440 | 5676.9 |
159 | 2024-03-19 13:39:02 | tollhouses | 4 | 161450 | 167 | 22.016 | 7333.3 |
158 | 2024-03-07 23:22:39 | tollhouses | 1 | 67641 | 4 | 1.203 | 56226.9 |
157 | 2024-03-06 19:01:53 | tollhouses | 1 | 67641 | 4 | 3.890 | 17388.4 |
156 | 2024-02-26 01:05:51 | tollhouses | 4 | 161450 | 167 | 18.173 | 8884.1 |
155 | 2024-02-18 07:54:13 | tollhouses | 4 | 161450 | 167 | 16.313 | 9897.0 |
154 | 2024-02-18 07:54:13 | tollhouses | 3 | 140603 | 32 | 10.033 | 14014.1 |
153 | 2024-02-18 07:54:14 | tollhouses | 2 | 108824 | 9 | 6.893 | 15787.6 |
152 | 2024-02-18 00:49:14 | tollhouses | 1 | 67641 | 4 | 1.186 | 57032.9 |
151 | 2024-02-10 07:36:53 | tollhouses | 4 | 161450 | 167 | 40.250 | 4011.2 |
150 | 2024-02-10 07:36:54 | tollhouses | 3 | 140603 | 32 | 22.426 | 6269.6 |
149 | 2024-02-10 07:36:54 | tollhouses | 2 | 108824 | 9 | 7.406 | 14694.0 |
148 | 2024-02-10 06:54:55 | tollhouses | 1 | 67641 | 4 | 2.470 | 27385.0 |
147 | 2024-02-07 12:56:30 | tollhouses | 1 | 67641 | 4 | 1.156 | 58513.0 |
146 | 2024-02-03 04:00:01 | tollhouses | 1 | 67641 | 4 | 1.110 | 60937.8 |
145 | 2024-01-26 04:56:51 | tollhouses | 1 | 67641 | 4 | 2.360 | 28661.4 |
144 | 2024-01-26 04:56:47 | tollhouses | 1 | 67641 | 4 | 2.436 | 27767.2 |
143 | 2024-01-15 11:49:51 | tollhouses | 1 | 67641 | 4 | 1.153 | 58665.2 |
142 | 2023-12-16 21:05:57 | tollhouses | 1 | 67641 | 4 | 1.143 | 59178.5 |
141 | 2023-10-31 07:14:09 | tollhouses | 1 | 67641 | 4 | 1.123 | 60232.4 |
140 | 2023-10-04 15:03:31 | tollhouses | 1 | 67641 | 4 | 1.046 | 64666.3 |
139 | 2023-04-03 15:53:03 | tollhouses | 1 | 67641 | 4 | 1.123 | 60232.4 |
138 | 2023-03-07 08:57:09 | tollhouses | 1 | 67641 | 4 | 1.080 | 62630.6 |
137 | 2023-01-15 06:45:20 | tollhouses | 1 | 67641 | 4 | 0.986 | 68601.4 |
136 | 2023-01-14 21:09:19 | tollhouses | 1 | 67641 | 4 | 0.983 | 68810.8 |
135 | 2022-12-03 18:21:02 | tollhouses | 1 | 67641 | 4 | 0.986 | 68601.4 |
134 | 2022-11-19 10:19:10 | tollhouses | 1 | 67641 | 4 | 1.063 | 63632.2 |
133 | 2022-11-08 18:27:12 | tollhouses | 1 | 67641 | 4 | 1.186 | 57032.9 |
132 | 2022-07-10 17:06:13 | tollhouses | 1 | 67641 | 4 | 0.986 | 68601.4 |
131 | 2022-07-08 12:15:43 | tollhouses | 1 | 67641 | 4 | 1.013 | 66773.0 |
130 | 2022-05-18 13:47:12 | tollhouses | 1 | 67641 | 4 | 1.096 | 61716.2 |
129 | 2022-03-06 19:31:31 | tollhouses | 1 | 67641 | 4 | 1.093 | 61885.6 |
128 | 2021-12-17 06:26:27 | tollhouses | 1 | 67641 | 4 | 1.233 | 54858.9 |
127 | 2021-11-05 16:10:30 | tollhouses | 1 | 67641 | 4 | 1.033 | 65480.2 |
126 | 2021-06-07 18:33:58 | tollhouses | 1 | 67641 | 4 | 1.123 | 60232.4 |
125 | 2021-05-13 21:57:35 | tollhouses | 1 | 67641 | 4 | 1.093 | 61885.6 |
124 | 2021-05-11 13:01:36 | tollhouses | 1 | 67641 | 4 | 1.030 | 65670.9 |
123 | 2021-02-14 05:07:33 | tollhouses | 1 | 67641 | 4 | 1.156 | 58513.0 |
122 | 2021-02-13 11:54:45 | tollhouses | 1 | 67641 | 4 | 1.030 | 65670.9 |
121 | 2021-01-26 17:27:52 | tollhouses | 1 | 67641 | 4 | 1.140 | 59334.2 |
120 | 2020-11-05 00:21:33 | tollhouses | 1 | 67641 | 4 | 1.030 | 65670.9 |
119 | 2020-11-02 08:10:09 | tollhouses | 1 | 67641 | 4 | 1.093 | 61885.6 |
118 | 2020-10-31 19:33:31 | tollhouses | 1 | 67641 | 4 | 1.033 | 65480.2 |
117 | 2020-10-14 22:35:45 | tollhouses | 1 | 67641 | 4 | 1.000 | 67641.0 |
116 | 2020-03-25 04:08:33 | tollhouses | 1 | 67641 | 4 | 1.140 | 59334.2 |
115 | 2020-03-18 12:39:03 | tollhouses | 1 | 67641 | 4 | 1.110 | 60937.8 |
114 | 2020-03-15 17:46:48 | tollhouses | 1 | 67641 | 4 | 1.186 | 57032.9 |
113 | 2020-02-29 06:01:21 | tollhouses | 1 | 67641 | 4 | 1.220 | 55443.4 |
112 | 2020-02-28 18:26:17 | tollhouses | 1 | 67641 | 4 | 2.813 | 24045.9 |
111 | 2020-02-13 16:27:22 | tollhouses | 1 | 67641 | 4 | 1.266 | 53428.9 |
110 | 2020-02-06 00:34:20 | tollhouses | 1 | 67641 | 4 | 2.516 | 26884.3 |
109 | 2020-02-01 04:13:29 | tollhouses | 1 | 67641 | 4 | 1.253 | 53983.2 |
108 | 2020-01-29 01:26:30 | tollhouses | 1 | 67641 | 4 | 1.156 | 58513.0 |
107 | 2020-01-27 07:43:56 | tollhouses | 1 | 67641 | 4 | 1.186 | 57032.9 |
106 | 2020-01-22 01:00:14 | tollhouses | 1 | 67641 | 4 | 2.266 | 29850.4 |
105 | 2020-01-17 11:27:15 | tollhouses | 1 | 67641 | 4 | 1.000 | 67641.0 |
104 | 2020-01-04 19:05:26 | tollhouses | 1 | 67641 | 4 | 1.233 | 54858.9 |
103 | 2020-01-03 02:39:53 | tollhouses | 1 | 67641 | 4 | 1.126 | 60071.9 |
102 | 2019-12-04 05:35:39 | tollhouses | 1 | 67641 | 4 | 1.126 | 60071.9 |
101 | 2019-09-01 23:40:23 | tollhouses | 1 | 67641 | 4 | 1.083 | 62457.1 |
100 | 2019-05-17 17:42:32 | tollhouses | 1 | 67641 | 4 | 0.993 | 68117.8 |
99 | 2019-02-17 09:24:39 | tollhouses | 1 | 67641 | 4 | 1.096 | 61716.2 |
98 | 2019-01-31 01:05:17 | tollhouses | 1 | 67641 | 4 | 0.976 | 69304.3 |
97 | 2019-01-13 19:21:15 | tollhouses | 1 | 67641 | 4 | 1.113 | 60773.6 |
96 | 2018-12-03 08:07:58 | tollhouses | 1 | 67641 | 4 | 0.983 | 68810.8 |
95 | 2018-08-27 14:36:42 | tollhouses | 1 | 67641 | 4 | 1.156 | 58513.0 |
94 | 2018-07-02 05:25:33 | tollhouses | 1 | 67641 | 4 | 1.003 | 67438.7 |
93 | 2018-04-16 18:44:42 | tollhouses | 1 | 67641 | 4 | 1.156 | 58513.0 |
92 | 2018-03-25 13:31:30 | tollhouses | 1 | 67641 | 4 | 1.383 | 48908.9 |
91 | 2018-03-24 07:33:09 | tollhouses | 1 | 67641 | 4 | 1.320 | 51243.2 |
90 | 2018-01-04 04:41:11 | tollhouses | 1 | 67641 | 4 | 1.343 | 50365.6 |
89 | 2017-12-31 20:12:25 | tollhouses | 1 | 67641 | 4 | 1.413 | 47870.5 |
88 | 2017-12-25 11:47:35 | tollhouses | 1 | 67641 | 4 | 1.336 | 50629.5 |
87 | 2017-12-12 08:51:36 | tollhouses | 1 | 67641 | 4 | 1.490 | 45396.6 |
86 | 2017-11-07 20:13:03 | tollhouses | 1 | 67641 | 4 | 1.440 | 46972.9 |
85 | 2017-09-14 21:47:30 | tollhouses | 1 | 67641 | 4 | 1.296 | 52192.1 |
84 | 2017-03-22 02:52:04 | tollhouses | 1 | 67641 | 4 | 1.436 | 47103.8 |
83 | 2017-03-18 17:57:27 | tollhouses | 1 | 67641 | 4 | 1.306 | 51792.5 |
82 | 2016-12-29 07:00:15 | tollhouses | 4 | 161450 | 167 | 15.230 | 10600.8 |
81 | 2016-12-26 17:10:42 | tollhouses | 3 | 140603 | 32 | 7.570 | 18573.7 |
80 | 2016-12-25 21:52:04 | tollhouses | 2 | 108824 | 9 | 4.066 | 26764.4 |
79 | 2016-12-25 20:31:58 | tollhouses | 1 | 67641 | 4 | 3.223 | 20987.0 |
78 | 2016-12-20 08:06:06 | tollhouses | 1 | 67641 | 4 | 1.683 | 40190.7 |
77 | 2016-12-19 17:18:29 | tollhouses | 1 | 67641 | 4 | 1.440 | 46972.9 |