History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spencers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1195 | 2024-03-25 05:21:23 | spencers | 1 | 82945 | 4 | 1.470 | 56425.2 |
1194 | 2024-03-05 08:28:12 | spencers | 3 | 146162 | 347 | 13.796 | 10594.5 |
1193 | 2024-03-04 11:10:09 | spencers | 2 | 121059 | 30 | 8.563 | 14137.5 |
1192 | 2024-03-04 11:09:55 | spencers | 1 | 82945 | 4 | 1.563 | 53067.8 |
1191 | 2024-03-04 11:09:33 | spencers | 3 | 146162 | 347 | 8.033 | 18195.2 |
1190 | 2024-03-04 08:42:23 | spencers | 2 | 121059 | 30 | 12.310 | 9834.2 |
1189 | 2024-03-04 08:42:22 | spencers | 3 | 146162 | 347 | 8.860 | 16496.8 |
1188 | 2024-03-04 08:42:09 | spencers | 1 | 82945 | 4 | 1.640 | 50576.2 |
1187 | 2024-02-29 06:06:23 | spencers | 1 | 82945 | 4 | 1.500 | 55296.7 |
1186 | 2024-02-28 06:26:53 | spencers | 1 | 82945 | 4 | 1.563 | 53067.8 |
1185 | 2023-12-19 00:12:23 | spencers | 1 | 82945 | 4 | 1.516 | 54713.1 |
1184 | 2023-12-18 16:41:18 | spencers | 1 | 82945 | 4 | 1.516 | 54713.1 |
1183 | 2023-11-28 06:22:49 | spencers | 1 | 82945 | 4 | 1.360 | 60989.0 |
1182 | 2023-11-28 03:46:28 | spencers | 2 | 121059 | 30 | 3.253 | 37214.6 |
1181 | 2023-11-26 13:49:28 | spencers | 3 | 146162 | 347 | 6.643 | 22002.4 |
1180 | 2023-11-24 11:47:50 | spencers | 1 | 82945 | 4 | 1.296 | 64000.8 |
1179 | 2023-11-20 15:53:21 | spencers | 3 | 146162 | 347 | 6.876 | 21256.8 |
1178 | 2023-11-20 15:53:19 | spencers | 2 | 121059 | 30 | 3.640 | 33258.0 |
1177 | 2023-11-03 06:08:06 | spencers | 1 | 82945 | 4 | 1.296 | 64000.8 |
1176 | 2023-10-22 10:20:48 | spencers | 1 | 82945 | 4 | 1.343 | 61761.0 |
1175 | 2023-10-10 17:00:27 | spencers | 1 | 82945 | 4 | 1.390 | 59672.7 |
1174 | 2023-10-07 16:15:07 | spencers | 1 | 82945 | 4 | 1.420 | 58412.0 |
1173 | 2023-09-29 13:09:59 | spencers | 1 | 82945 | 4 | 1.393 | 59544.1 |
1172 | 2023-08-27 17:28:51 | spencers | 2 | 121059 | 30 | 3.216 | 37642.7 |
1171 | 2023-08-03 14:49:10 | spencers | 1 | 82945 | 4 | 1.266 | 65517.4 |
1170 | 2023-07-14 20:05:31 | spencers | 1 | 82945 | 4 | 1.313 | 63172.1 |
1169 | 2023-06-07 07:18:46 | spencers | 1 | 82945 | 4 | 1.280 | 64800.8 |
1168 | 2023-05-13 03:00:24 | spencers | 2 | 121059 | 30 | 3.186 | 37997.2 |
1167 | 2023-04-28 09:08:05 | spencers | 1 | 82945 | 4 | 1.326 | 62552.8 |
1166 | 2023-02-21 15:54:40 | spencers | 1 | 82945 | 4 | 1.263 | 65673.0 |
1165 | 2023-02-20 08:20:12 | spencers | 2 | 121059 | 30 | 3.140 | 38553.8 |
1164 | 2023-02-12 06:36:37 | spencers | 1 | 82945 | 4 | 1.423 | 58288.8 |
1163 | 2023-02-08 18:21:19 | spencers | 1 | 82945 | 4 | 1.280 | 64800.8 |
1162 | 2022-12-19 05:56:00 | spencers | 1 | 82945 | 4 | 1.423 | 58288.8 |
1161 | 2022-12-02 02:05:00 | spencers | 2 | 121059 | 30 | 3.673 | 32959.2 |
1160 | 2022-10-11 07:06:10 | spencers | 1 | 82945 | 4 | 1.280 | 64800.8 |
1159 | 2022-09-01 13:01:51 | spencers | 1 | 82945 | 4 | 1.406 | 58993.6 |
1158 | 2022-07-08 10:01:08 | spencers | 2 | 121059 | 30 | 3.373 | 35890.6 |
1157 | 2022-07-04 07:39:30 | spencers | 1 | 82945 | 4 | 1.326 | 62552.8 |
1156 | 2022-05-24 04:18:31 | spencers | 1 | 82945 | 4 | 1.296 | 64000.8 |
1155 | 2022-04-19 01:55:21 | spencers | 1 | 82945 | 4 | 1.656 | 50087.6 |
1154 | 2022-04-16 22:37:33 | spencers | 1 | 82945 | 4 | 1.406 | 58993.6 |
1153 | 2022-04-14 18:55:02 | spencers | 1 | 82945 | 4 | 1.953 | 42470.6 |
1152 | 2022-02-10 21:15:21 | spencers | 2 | 121059 | 30 | 3.140 | 38553.8 |
1151 | 2022-02-08 19:18:29 | spencers | 2 | 121059 | 30 | 3.173 | 38152.9 |
1150 | 2022-02-06 22:32:36 | spencers | 2 | 121059 | 30 | 3.830 | 31608.1 |
1149 | 2022-02-06 09:25:41 | spencers | 2 | 121059 | 30 | 5.060 | 23924.7 |
1148 | 2022-02-05 12:37:26 | spencers | 2 | 121059 | 30 | 3.640 | 33258.0 |
1147 | 2022-02-04 20:48:15 | spencers | 2 | 121059 | 30 | 3.233 | 37444.8 |
1146 | 2022-02-04 00:25:54 | spencers | 2 | 121059 | 30 | 6.873 | 17613.7 |
1145 | 2022-02-03 12:01:48 | spencers | 2 | 121059 | 30 | 3.830 | 31608.1 |
1144 | 2022-02-02 08:28:21 | spencers | 2 | 121059 | 30 | 3.233 | 37444.8 |
1143 | 2022-02-01 20:42:34 | spencers | 2 | 121059 | 30 | 3.906 | 30993.1 |
1142 | 2022-02-01 07:28:19 | spencers | 2 | 121059 | 30 | 3.830 | 31608.1 |
1141 | 2022-01-31 17:27:11 | spencers | 2 | 121059 | 30 | 3.423 | 35366.3 |
1140 | 2022-01-31 05:19:28 | spencers | 2 | 121059 | 30 | 3.296 | 36729.1 |
1139 | 2022-01-30 16:45:47 | spencers | 2 | 121059 | 30 | 3.283 | 36874.5 |
1138 | 2022-01-29 09:15:37 | spencers | 2 | 121059 | 30 | 3.486 | 34727.2 |
1137 | 2022-01-28 20:33:08 | spencers | 2 | 121059 | 30 | 3.236 | 37410.1 |
1136 | 2022-01-28 01:38:26 | spencers | 2 | 121059 | 30 | 3.360 | 36029.5 |
1135 | 2022-01-27 07:49:03 | spencers | 2 | 121059 | 30 | 3.673 | 32959.2 |
1134 | 2022-01-26 21:03:03 | spencers | 2 | 121059 | 30 | 3.856 | 31395.0 |
1133 | 2022-01-26 11:38:09 | spencers | 2 | 121059 | 30 | 3.656 | 33112.4 |
1132 | 2022-01-25 23:09:15 | spencers | 2 | 121059 | 30 | 3.470 | 34887.3 |
1131 | 2022-01-25 03:35:35 | spencers | 2 | 121059 | 30 | 3.486 | 34727.2 |
1130 | 2022-01-24 18:38:16 | spencers | 2 | 121059 | 30 | 3.686 | 32842.9 |
1129 | 2022-01-23 23:08:56 | spencers | 2 | 121059 | 30 | 3.470 | 34887.3 |
1128 | 2022-01-19 03:43:28 | spencers | 1 | 82945 | 4 | 1.423 | 58288.8 |
1127 | 2022-01-15 21:22:45 | spencers | 1 | 82945 | 4 | 1.470 | 56425.2 |
1126 | 2022-01-12 14:25:10 | spencers | 1 | 82945 | 4 | 1.313 | 63172.1 |
1125 | 2022-01-06 07:28:09 | spencers | 1 | 82945 | 4 | 1.343 | 61761.0 |
1124 | 2022-01-03 18:54:14 | spencers | 2 | 121059 | 30 | 4.030 | 30039.5 |
1123 | 2021-12-31 17:27:00 | spencers | 2 | 121059 | 30 | 3.813 | 31749.0 |
1122 | 2021-12-30 18:03:46 | spencers | 2 | 121059 | 30 | 3.750 | 32282.4 |
1121 | 2021-12-29 16:11:49 | spencers | 2 | 121059 | 30 | 3.716 | 32577.8 |
1120 | 2021-12-28 17:07:48 | spencers | 2 | 121059 | 30 | 3.313 | 36540.6 |
1119 | 2021-12-27 15:17:25 | spencers | 2 | 121059 | 30 | 3.423 | 35366.3 |
1118 | 2021-12-26 14:59:03 | spencers | 2 | 121059 | 30 | 3.486 | 34727.2 |
1117 | 2021-12-25 09:55:07 | spencers | 2 | 121059 | 30 | 3.673 | 32959.2 |
1116 | 2021-12-24 10:25:52 | spencers | 2 | 121059 | 30 | 3.250 | 37248.9 |
1115 | 2021-12-17 08:58:35 | spencers | 2 | 121059 | 30 | 3.596 | 33664.9 |
1114 | 2021-12-16 21:24:06 | spencers | 2 | 121059 | 30 | 3.953 | 30624.6 |
1113 | 2021-12-15 11:32:30 | spencers | 2 | 121059 | 30 | 3.470 | 34887.3 |
1112 | 2021-12-14 22:08:16 | spencers | 2 | 121059 | 30 | 3.296 | 36729.1 |
1111 | 2021-12-14 07:40:49 | spencers | 2 | 121059 | 30 | 3.640 | 33258.0 |
1110 | 2021-12-13 23:35:31 | spencers | 2 | 121059 | 30 | 3.873 | 31257.2 |
1109 | 2021-12-13 12:11:26 | spencers | 2 | 121059 | 30 | 4.283 | 28265.0 |
1108 | 2021-12-13 05:15:04 | spencers | 3 | 146162 | 347 | 6.406 | 22816.4 |
1107 | 2021-12-12 18:16:51 | spencers | 2 | 121059 | 30 | 3.736 | 32403.4 |
1106 | 2021-12-12 07:02:05 | spencers | 2 | 121059 | 30 | 3.763 | 32170.9 |
1105 | 2021-12-06 02:14:53 | spencers | 2 | 121059 | 30 | 3.296 | 36729.1 |
1104 | 2021-12-02 09:41:29 | spencers | 2 | 121059 | 30 | 4.033 | 30017.1 |
1103 | 2021-12-01 20:25:59 | spencers | 2 | 121059 | 30 | 3.703 | 32692.1 |
1102 | 2021-12-01 08:00:56 | spencers | 2 | 121059 | 30 | 3.236 | 37410.1 |
1101 | 2021-11-30 13:43:48 | spencers | 2 | 121059 | 30 | 4.186 | 28920.0 |
1100 | 2021-11-29 19:35:42 | spencers | 2 | 121059 | 30 | 3.640 | 33258.0 |
1099 | 2021-11-29 08:25:58 | spencers | 2 | 121059 | 30 | 3.703 | 32692.1 |
1098 | 2021-11-22 01:39:18 | spencers | 2 | 121059 | 30 | 3.766 | 32145.2 |
1097 | 2021-11-19 01:52:26 | spencers | 2 | 121059 | 30 | 3.640 | 33258.0 |
1096 | 2021-11-16 00:04:31 | spencers | 2 | 121059 | 30 | 3.500 | 34588.3 |