History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upstair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1219 | 2024-04-17 00:07:40 | upstair | 4 | 151207 | 803 | 13.300 | 11368.9 |
1218 | 2024-04-16 18:16:31 | upstair | 4 | 151207 | 803 | 13.283 | 11383.5 |
1217 | 2024-04-16 06:25:20 | upstair | 1 | 69583 | 3 | 1.186 | 58670.3 |
1216 | 2024-04-16 01:17:16 | upstair | 4 | 151207 | 803 | 17.906 | 8444.5 |
1215 | 2024-04-15 21:20:35 | upstair | 4 | 151207 | 803 | 19.093 | 7919.5 |
1214 | 2024-04-14 23:38:13 | upstair | 4 | 151207 | 803 | 22.906 | 6601.2 |
1213 | 2024-03-28 23:53:45 | upstair | 1 | 69583 | 3 | 3.483 | 19977.9 |
1212 | 2024-03-14 09:25:15 | upstair | 3 | 134027 | 62 | 12.686 | 10565.0 |
1211 | 2024-03-14 09:25:14 | upstair | 2 | 107671 | 13 | 7.140 | 15080.0 |
1210 | 2024-03-14 09:25:02 | upstair | 1 | 69583 | 3 | 1.093 | 63662.4 |
1209 | 2024-03-07 11:55:25 | upstair | 1 | 69583 | 3 | 1.360 | 51164.0 |
1208 | 2024-03-01 13:50:35 | upstair | 4 | 151207 | 803 | 27.470 | 5504.4 |
1207 | 2024-02-27 00:41:15 | upstair | 4 | 151207 | 803 | 11.970 | 12632.2 |
1206 | 2024-02-14 23:38:40 | upstair | 4 | 151207 | 803 | 26.800 | 5642.1 |
1205 | 2024-02-13 13:14:53 | upstair | 4 | 151207 | 803 | 25.580 | 5911.1 |
1204 | 2024-02-12 11:23:56 | upstair | 1 | 69583 | 3 | 1.156 | 60192.9 |
1203 | 2024-02-11 12:05:37 | upstair | 4 | 151207 | 803 | 9.736 | 15530.7 |
1202 | 2024-02-08 09:14:32 | upstair | 4 | 151207 | 803 | 21.283 | 7104.6 |
1201 | 2024-02-07 09:30:38 | upstair | 4 | 151207 | 803 | 15.530 | 9736.4 |
1200 | 2024-01-25 17:49:50 | upstair | 4 | 151207 | 803 | 24.753 | 6108.6 |
1199 | 2024-01-24 16:38:41 | upstair | 4 | 151207 | 803 | 11.546 | 13096.1 |
1198 | 2024-01-23 16:53:36 | upstair | 4 | 151207 | 803 | 24.233 | 6239.7 |
1197 | 2024-01-23 03:06:27 | upstair | 4 | 151207 | 803 | 24.736 | 6112.8 |
1196 | 2024-01-22 13:03:03 | upstair | 4 | 151207 | 803 | 9.830 | 15382.2 |
1195 | 2024-01-09 03:32:35 | upstair | 1 | 69583 | 3 | 1.063 | 65459.1 |
1194 | 2023-12-29 07:47:00 | upstair | 1 | 69583 | 3 | 1.093 | 63662.4 |
1193 | 2023-12-22 11:29:41 | upstair | 1 | 69583 | 3 | 1.250 | 55666.4 |
1192 | 2023-11-25 16:03:51 | upstair | 4 | 151207 | 803 | 11.216 | 13481.4 |
1191 | 2023-11-25 07:23:54 | upstair | 1 | 69583 | 3 | 1.203 | 57841.2 |
1190 | 2023-11-23 00:33:23 | upstair | 4 | 151207 | 803 | 11.940 | 12663.9 |
1189 | 2023-11-20 15:20:36 | upstair | 4 | 151207 | 803 | 11.283 | 13401.3 |
1188 | 2023-11-04 03:51:53 | upstair | 1 | 69583 | 3 | 1.016 | 68487.2 |
1187 | 2023-11-03 07:05:08 | upstair | 1 | 69583 | 3 | 1.093 | 63662.4 |
1186 | 2023-10-31 21:40:25 | upstair | 1 | 69583 | 3 | 2.296 | 30306.2 |
1185 | 2023-10-30 19:19:40 | upstair | 4 | 151207 | 803 | 12.656 | 11947.5 |
1184 | 2023-10-27 02:43:12 | upstair | 4 | 151207 | 803 | 11.016 | 13726.1 |
1183 | 2023-10-26 17:25:05 | upstair | 1 | 69583 | 3 | 1.190 | 58473.1 |
1182 | 2023-10-21 00:48:32 | upstair | 4 | 151207 | 803 | 16.376 | 9233.5 |
1181 | 2023-10-18 05:38:48 | upstair | 1 | 69583 | 3 | 1.033 | 67360.1 |
1180 | 2023-10-17 21:56:48 | upstair | 4 | 151207 | 803 | 13.623 | 11099.4 |
1179 | 2023-10-15 04:33:28 | upstair | 1 | 69583 | 3 | 1.106 | 62914.1 |
1178 | 2023-09-29 01:14:42 | upstair | 1 | 69583 | 3 | 1.110 | 62687.4 |
1177 | 2023-08-26 18:17:03 | upstair | 4 | 151207 | 803 | 12.203 | 12391.0 |
1176 | 2023-08-26 01:29:52 | upstair | 4 | 151207 | 803 | 10.690 | 14144.7 |
1175 | 2023-08-20 12:52:07 | upstair | 4 | 151207 | 803 | 10.546 | 14337.9 |
1174 | 2023-08-19 00:34:46 | upstair | 4 | 151207 | 803 | 10.016 | 15096.5 |
1173 | 2023-08-14 13:20:35 | upstair | 1 | 69583 | 3 | 1.063 | 65459.1 |
1172 | 2023-08-06 14:34:01 | upstair | 4 | 151207 | 803 | 13.266 | 11398.1 |
1171 | 2023-08-04 13:48:37 | upstair | 4 | 151207 | 803 | 10.266 | 14728.9 |
1170 | 2023-08-02 17:11:29 | upstair | 4 | 151207 | 803 | 14.830 | 10196.0 |
1169 | 2023-07-31 15:46:03 | upstair | 4 | 151207 | 803 | 11.893 | 12713.9 |
1168 | 2023-06-30 16:17:59 | upstair | 4 | 151207 | 803 | 9.860 | 15335.4 |
1167 | 2023-06-29 15:59:50 | upstair | 4 | 151207 | 803 | 9.733 | 15535.5 |
1166 | 2023-06-23 07:33:28 | upstair | 4 | 151207 | 803 | 10.360 | 14595.3 |
1165 | 2023-05-31 17:03:34 | upstair | 1 | 69583 | 3 | 1.016 | 68487.2 |
1164 | 2023-05-12 20:27:07 | upstair | 1 | 69583 | 3 | 1.033 | 67360.1 |
1163 | 2023-03-08 11:24:29 | upstair | 1 | 69583 | 3 | 1.170 | 59472.6 |
1162 | 2022-12-30 11:07:00 | upstair | 1 | 69583 | 3 | 1.156 | 60192.9 |
1161 | 2022-12-29 19:58:40 | upstair | 1 | 69583 | 3 | 1.140 | 61037.7 |
1160 | 2022-09-18 15:46:03 | upstair | 1 | 69583 | 3 | 1.046 | 66522.9 |
1159 | 2022-07-27 00:57:43 | upstair | 1 | 69583 | 3 | 1.076 | 64668.2 |
1158 | 2022-06-29 00:19:18 | upstair | 4 | 151207 | 803 | 9.576 | 15790.2 |
1157 | 2022-05-12 13:33:47 | upstair | 4 | 151207 | 803 | 13.360 | 11317.9 |
1156 | 2022-05-09 11:36:28 | upstair | 4 | 151207 | 803 | 11.533 | 13110.8 |
1155 | 2022-04-28 08:50:51 | upstair | 1 | 69583 | 3 | 1.046 | 66522.9 |
1154 | 2022-02-09 00:33:54 | upstair | 1 | 69583 | 3 | 1.173 | 59320.5 |
1153 | 2022-02-03 19:38:12 | upstair | 1 | 69583 | 3 | 1.060 | 65644.3 |
1152 | 2022-02-01 16:47:00 | upstair | 1 | 69583 | 3 | 1.030 | 67556.3 |
1151 | 2021-09-13 21:42:59 | upstair | 1 | 69583 | 3 | 1.110 | 62687.4 |
1150 | 2021-09-10 16:48:58 | upstair | 1 | 69583 | 3 | 1.156 | 60192.9 |
1149 | 2021-07-29 22:50:14 | upstair | 4 | 151207 | 803 | 9.423 | 16046.6 |
1148 | 2021-07-15 06:03:03 | upstair | 1 | 69583 | 3 | 1.093 | 63662.4 |
1147 | 2021-07-04 05:27:00 | upstair | 4 | 151207 | 803 | 12.236 | 12357.6 |
1146 | 2021-06-27 05:08:36 | upstair | 4 | 151207 | 803 | 10.720 | 14105.1 |
1145 | 2021-06-14 04:36:05 | upstair | 4 | 151207 | 803 | 9.920 | 15242.6 |
1144 | 2021-06-12 07:33:00 | upstair | 4 | 151207 | 803 | 9.596 | 15757.3 |
1143 | 2021-06-03 02:07:58 | upstair | 1 | 69583 | 3 | 1.390 | 50059.7 |
1142 | 2021-05-30 14:01:32 | upstair | 4 | 151207 | 803 | 11.093 | 13630.8 |
1141 | 2021-05-29 19:13:42 | upstair | 4 | 151207 | 803 | 9.733 | 15535.5 |
1140 | 2021-05-17 21:08:14 | upstair | 1 | 69583 | 3 | 1.206 | 57697.3 |
1139 | 2021-05-16 07:12:51 | upstair | 1 | 69583 | 3 | 1.190 | 58473.1 |
1138 | 2021-05-09 20:30:12 | upstair | 4 | 151207 | 803 | 12.250 | 12343.4 |
1137 | 2021-05-08 19:28:00 | upstair | 1 | 69583 | 3 | 1.250 | 55666.4 |
1136 | 2021-04-29 23:38:57 | upstair | 4 | 151207 | 803 | 11.030 | 13708.7 |
1135 | 2021-04-24 19:27:34 | upstair | 4 | 151207 | 803 | 11.436 | 13222.0 |
1134 | 2021-04-23 19:12:06 | upstair | 4 | 151207 | 803 | 10.563 | 14314.8 |
1133 | 2021-04-22 17:10:46 | upstair | 4 | 151207 | 803 | 11.423 | 13237.1 |
1132 | 2021-03-24 07:42:59 | upstair | 4 | 151207 | 803 | 9.873 | 15315.2 |
1131 | 2021-02-26 14:27:28 | upstair | 4 | 151207 | 803 | 9.736 | 15530.7 |
1130 | 2021-02-24 14:05:56 | upstair | 4 | 151207 | 803 | 10.423 | 14507.1 |
1129 | 2021-02-19 06:03:27 | upstair | 4 | 151207 | 803 | 10.330 | 14637.7 |
1128 | 2021-01-25 00:46:08 | upstair | 4 | 151207 | 803 | 9.690 | 15604.4 |
1127 | 2021-01-06 08:39:01 | upstair | 1 | 69583 | 3 | 1.080 | 64428.7 |
1126 | 2020-12-25 01:52:40 | upstair | 4 | 151207 | 803 | 9.766 | 15483.0 |
1125 | 2020-12-21 01:53:31 | upstair | 4 | 151207 | 803 | 10.033 | 15071.0 |
1124 | 2020-11-12 02:03:01 | upstair | 4 | 151207 | 803 | 11.186 | 13517.5 |
1123 | 2020-10-23 17:13:00 | upstair | 4 | 151207 | 803 | 9.830 | 15382.2 |
1122 | 2020-10-03 15:12:54 | upstair | 1 | 69583 | 3 | 1.080 | 64428.7 |
1121 | 2020-09-14 17:30:38 | upstair | 1 | 69583 | 3 | 1.076 | 64668.2 |
1120 | 2020-09-05 07:15:20 | upstair | 4 | 151207 | 803 | 9.830 | 15382.2 |