History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sublessee"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
187 | 2024-05-15 07:06:52 | sublessee | 2 | 121436 | 6 | 5.140 | 23625.7 |
186 | 2024-05-12 01:50:32 | sublessee | 4 | 165329 | 242 | 39.953 | 4138.1 |
185 | 2024-05-12 01:50:35 | sublessee | 2 | 121436 | 6 | 13.796 | 8802.3 |
184 | 2024-05-12 01:47:38 | sublessee | 1 | 81242 | 2 | 3.140 | 25873.2 |
183 | 2024-05-12 01:24:40 | sublessee | 3 | 148641 | 31 | 23.360 | 6363.1 |
182 | 2024-05-12 01:24:39 | sublessee | 2 | 121436 | 6 | 8.610 | 14104.1 |
181 | 2024-05-12 01:23:25 | sublessee | 1 | 81242 | 2 | 4.530 | 17934.2 |
180 | 2024-05-03 17:21:29 | sublessee | 4 | 165329 | 242 | 14.186 | 11654.4 |
179 | 2024-05-03 11:21:20 | sublessee | 1 | 81242 | 2 | 5.343 | 15205.3 |
178 | 2024-05-03 10:21:43 | sublessee | 3 | 148641 | 31 | 11.940 | 12449.0 |
177 | 2024-05-03 10:21:28 | sublessee | 4 | 165329 | 242 | 23.826 | 6939.0 |
176 | 2024-05-03 10:21:31 | sublessee | 2 | 121436 | 6 | 4.186 | 29010.0 |
175 | 2024-05-03 04:55:32 | sublessee | 1 | 81242 | 2 | 1.596 | 50903.5 |
174 | 2024-05-02 20:55:40 | sublessee | 1 | 81242 | 2 | 1.470 | 55266.7 |
173 | 2024-04-19 11:06:30 | sublessee | 3 | 148641 | 31 | 24.326 | 6110.4 |
172 | 2024-04-17 14:12:49 | sublessee | 3 | 148641 | 31 | 21.046 | 7062.7 |
171 | 2024-04-17 14:12:51 | sublessee | 2 | 121436 | 6 | 4.936 | 24602.1 |
170 | 2024-04-17 14:02:54 | sublessee | 1 | 81242 | 2 | 1.690 | 48072.2 |
169 | 2024-04-08 00:18:22 | sublessee | 4 | 165329 | 242 | 28.266 | 5849.0 |
168 | 2024-04-07 11:15:07 | sublessee | 1 | 81242 | 2 | 3.393 | 23944.0 |
167 | 2024-04-03 17:23:42 | sublessee | 2 | 121436 | 6 | 13.250 | 9165.0 |
166 | 2024-04-03 10:01:32 | sublessee | 2 | 121436 | 6 | 9.110 | 13330.0 |
165 | 2024-04-03 05:19:33 | sublessee | 4 | 165329 | 242 | 15.843 | 10435.5 |
164 | 2024-04-02 17:40:35 | sublessee | 4 | 165329 | 242 | 56.566 | 2922.8 |
163 | 2024-03-31 22:26:18 | sublessee | 4 | 165329 | 242 | 43.300 | 3818.2 |
162 | 2024-03-31 22:26:20 | sublessee | 3 | 148641 | 31 | 16.970 | 8759.0 |
161 | 2024-03-31 22:26:19 | sublessee | 2 | 121436 | 6 | 10.440 | 11631.8 |
160 | 2024-03-31 22:25:16 | sublessee | 1 | 81242 | 2 | 1.500 | 54161.3 |
159 | 2024-03-30 07:47:04 | sublessee | 1 | 81242 | 2 | 1.703 | 47705.2 |
158 | 2024-03-12 03:29:19 | sublessee | 1 | 81242 | 2 | 4.733 | 17165.0 |
157 | 2024-03-09 16:02:02 | sublessee | 3 | 148641 | 31 | 21.656 | 6863.7 |
156 | 2024-03-08 05:08:56 | sublessee | 3 | 148641 | 31 | 17.860 | 8322.6 |
155 | 2024-03-08 05:08:56 | sublessee | 2 | 121436 | 6 | 11.813 | 10279.9 |
154 | 2024-03-08 05:02:07 | sublessee | 1 | 81242 | 2 | 1.656 | 49059.2 |
153 | 2024-03-01 06:30:48 | sublessee | 1 | 81242 | 2 | 1.470 | 55266.7 |
152 | 2024-03-01 06:30:43 | sublessee | 1 | 81242 | 2 | 2.890 | 28111.4 |
151 | 2024-02-15 16:42:35 | sublessee | 4 | 165329 | 242 | 21.860 | 7563.1 |
150 | 2024-02-14 17:47:18 | sublessee | 4 | 165329 | 242 | 24.533 | 6739.0 |
149 | 2024-02-14 17:13:26 | sublessee | 3 | 148641 | 31 | 25.643 | 5796.6 |
148 | 2024-02-14 17:13:27 | sublessee | 4 | 165329 | 242 | 15.000 | 11021.9 |
147 | 2024-02-14 17:13:30 | sublessee | 2 | 121436 | 6 | 8.516 | 14259.7 |
146 | 2024-02-14 17:07:38 | sublessee | 1 | 81242 | 2 | 3.173 | 25604.2 |
145 | 2024-02-13 04:05:30 | sublessee | 1 | 81242 | 2 | 1.593 | 50999.4 |
144 | 2024-02-02 02:37:55 | sublessee | 1 | 81242 | 2 | 1.263 | 64324.6 |
143 | 2024-01-31 06:01:35 | sublessee | 1 | 81242 | 2 | 1.423 | 57092.1 |
142 | 2024-01-30 06:46:14 | sublessee | 1 | 81242 | 2 | 1.283 | 63321.9 |
141 | 2024-01-30 06:45:59 | sublessee | 1 | 81242 | 2 | 1.483 | 54782.2 |
140 | 2024-01-11 01:43:46 | sublessee | 1 | 81242 | 2 | 1.500 | 54161.3 |
139 | 2023-12-27 12:01:11 | sublessee | 1 | 81242 | 2 | 1.360 | 59736.8 |
138 | 2023-12-07 13:14:24 | sublessee | 2 | 121436 | 6 | 3.486 | 34835.3 |
137 | 2023-12-03 22:12:55 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
136 | 2023-11-27 07:27:14 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
135 | 2023-09-12 00:17:48 | sublessee | 1 | 81242 | 2 | 1.483 | 54782.2 |
134 | 2023-09-04 13:18:41 | sublessee | 2 | 121436 | 6 | 3.220 | 37713.0 |
133 | 2023-06-27 08:22:02 | sublessee | 1 | 81242 | 2 | 1.266 | 64172.2 |
132 | 2023-04-08 07:34:07 | sublessee | 1 | 81242 | 2 | 1.233 | 65889.7 |
131 | 2023-01-20 23:17:10 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
130 | 2022-12-16 12:30:09 | sublessee | 2 | 121436 | 6 | 3.436 | 35342.3 |
129 | 2022-11-16 23:50:40 | sublessee | 1 | 81242 | 2 | 1.513 | 53696.0 |
128 | 2022-09-01 11:54:46 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
127 | 2022-08-05 07:44:08 | sublessee | 2 | 121436 | 6 | 3.076 | 39478.5 |
126 | 2022-07-07 17:35:35 | sublessee | 1 | 81242 | 2 | 1.436 | 56575.2 |
125 | 2022-07-05 13:27:53 | sublessee | 1 | 81242 | 2 | 1.296 | 62686.7 |
124 | 2021-05-08 10:33:03 | sublessee | 1 | 81242 | 2 | 1.440 | 56418.1 |
123 | 2021-05-07 22:49:37 | sublessee | 1 | 81242 | 2 | 1.436 | 56575.2 |
122 | 2021-04-03 21:22:11 | sublessee | 1 | 81242 | 2 | 1.393 | 58321.6 |
121 | 2021-02-12 04:33:26 | sublessee | 1 | 81242 | 2 | 1.266 | 64172.2 |
120 | 2020-11-18 17:58:46 | sublessee | 1 | 81242 | 2 | 1.406 | 57782.4 |
119 | 2020-11-12 00:59:11 | sublessee | 1 | 81242 | 2 | 1.263 | 64324.6 |
118 | 2020-11-01 01:54:13 | sublessee | 1 | 81242 | 2 | 1.440 | 56418.1 |
117 | 2020-10-31 12:01:05 | sublessee | 1 | 81242 | 2 | 1.453 | 55913.3 |
116 | 2020-10-28 02:27:55 | sublessee | 1 | 81242 | 2 | 1.410 | 57618.4 |
115 | 2020-10-04 14:03:08 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
114 | 2020-03-25 11:37:56 | sublessee | 1 | 81242 | 2 | 1.390 | 58447.5 |
113 | 2020-03-14 12:25:30 | sublessee | 1 | 81242 | 2 | 1.393 | 58321.6 |
112 | 2020-03-05 08:03:25 | sublessee | 1 | 81242 | 2 | 1.420 | 57212.7 |
111 | 2020-02-26 04:01:35 | sublessee | 1 | 81242 | 2 | 1.623 | 50056.7 |
110 | 2020-02-12 12:16:03 | sublessee | 1 | 81242 | 2 | 1.610 | 50460.9 |
109 | 2020-02-09 10:32:30 | sublessee | 1 | 81242 | 2 | 6.410 | 12674.3 |
108 | 2020-02-01 07:43:05 | sublessee | 1 | 81242 | 2 | 1.610 | 50460.9 |
107 | 2020-01-30 17:28:35 | sublessee | 1 | 81242 | 2 | 1.516 | 53589.7 |
106 | 2020-01-20 17:08:58 | sublessee | 1 | 81242 | 2 | 1.640 | 49537.8 |
105 | 2020-01-19 00:31:30 | sublessee | 1 | 81242 | 2 | 1.593 | 50999.4 |
104 | 2020-01-16 18:37:22 | sublessee | 1 | 81242 | 2 | 3.390 | 23965.2 |
103 | 2019-12-31 20:06:42 | sublessee | 1 | 81242 | 2 | 1.576 | 51549.5 |
102 | 2019-12-27 01:20:30 | sublessee | 1 | 81242 | 2 | 1.483 | 54782.2 |
101 | 2019-12-02 23:10:45 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
100 | 2019-09-03 17:15:43 | sublessee | 1 | 81242 | 2 | 1.233 | 65889.7 |
99 | 2019-07-25 11:38:30 | sublessee | 1 | 81242 | 2 | 1.253 | 64838.0 |
98 | 2019-05-25 17:58:16 | sublessee | 1 | 81242 | 2 | 1.250 | 64993.6 |
97 | 2019-02-21 15:49:47 | sublessee | 1 | 81242 | 2 | 1.350 | 60179.3 |
96 | 2019-01-31 15:59:36 | sublessee | 1 | 81242 | 2 | 1.226 | 66265.9 |
95 | 2018-10-04 04:42:53 | sublessee | 1 | 81242 | 2 | 1.450 | 56029.0 |
94 | 2018-07-04 22:55:44 | sublessee | 1 | 81242 | 2 | 1.600 | 50776.3 |
93 | 2018-06-06 01:01:43 | sublessee | 1 | 81242 | 2 | 1.433 | 56693.6 |
92 | 2018-02-19 07:53:37 | sublessee | 1 | 81242 | 2 | 2.020 | 40218.8 |
91 | 2018-01-09 18:00:33 | sublessee | 1 | 81242 | 2 | 1.746 | 46530.4 |
90 | 2018-01-09 17:54:12 | sublessee | 1 | 81242 | 2 | 1.783 | 45564.8 |
89 | 2017-07-27 03:43:35 | sublessee | 1 | 81242 | 2 | 1.653 | 49148.2 |
88 | 2016-11-29 19:36:32 | sublessee | 1 | 81242 | 2 | 2.066 | 39323.3 |