History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"record"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1182 | 2024-04-05 07:18:06 | record | 3 | 112716 | 567 | 20.456 | 5510.2 |
1181 | 2024-04-05 07:18:06 | record | 2 | 82551 | 63 | 8.936 | 9238.0 |
1180 | 2024-03-30 01:47:47 | record | 2 | 82551 | 63 | 2.966 | 27832.4 |
1179 | 2024-03-29 21:29:08 | record | 2 | 82551 | 63 | 2.750 | 30018.5 |
1178 | 2024-03-29 20:41:11 | record | 3 | 112716 | 567 | 15.500 | 7272.0 |
1177 | 2024-03-29 13:56:04 | record | 2 | 82551 | 63 | 4.373 | 18877.4 |
1176 | 2024-03-29 13:55:39 | record | 3 | 112716 | 567 | 7.970 | 14142.5 |
1175 | 2024-03-28 08:43:21 | record | 3 | 112716 | 567 | 5.123 | 22002.0 |
1174 | 2024-03-12 19:34:16 | record | 3 | 112716 | 567 | 19.283 | 5845.4 |
1173 | 2024-03-12 19:34:17 | record | 2 | 82551 | 63 | 7.123 | 11589.4 |
1172 | 2024-03-12 19:34:11 | record | 2 | 82551 | 63 | 5.860 | 14087.2 |
1171 | 2024-03-12 19:34:09 | record | 1 | 48755 | 4 | 0.983 | 49598.2 |
1170 | 2024-03-12 19:33:42 | record | 3 | 112716 | 567 | 6.700 | 16823.3 |
1169 | 2024-03-11 17:10:55 | record | 3 | 112716 | 567 | 14.283 | 7891.6 |
1168 | 2024-03-04 17:59:27 | record | 2 | 82551 | 63 | 2.466 | 33475.7 |
1167 | 2024-02-28 05:46:16 | record | 1 | 48755 | 4 | 1.300 | 37503.8 |
1166 | 2024-01-30 14:21:43 | record | 1 | 48755 | 4 | 0.906 | 53813.5 |
1165 | 2024-01-29 06:44:10 | record | 2 | 82551 | 63 | 2.470 | 33421.5 |
1164 | 2024-01-29 06:33:02 | record | 3 | 112716 | 567 | 5.830 | 19333.8 |
1163 | 2024-01-28 07:33:47 | record | 2 | 82551 | 63 | 2.173 | 37989.4 |
1162 | 2024-01-28 07:33:23 | record | 3 | 112716 | 567 | 4.910 | 22956.4 |
1161 | 2024-01-26 11:12:51 | record | 3 | 112716 | 567 | 5.983 | 18839.4 |
1160 | 2024-01-21 01:23:48 | record | 3 | 112716 | 567 | 5.093 | 22131.6 |
1159 | 2024-01-12 08:58:33 | record | 3 | 112716 | 567 | 4.940 | 22817.0 |
1158 | 2024-01-06 00:55:24 | record | 1 | 48755 | 4 | 0.796 | 61250.0 |
1157 | 2023-12-28 00:45:23 | record | 1 | 48755 | 4 | 0.843 | 57835.1 |
1156 | 2023-12-20 05:28:38 | record | 3 | 112716 | 567 | 4.923 | 22895.8 |
1155 | 2023-12-18 11:44:44 | record | 3 | 112716 | 567 | 5.563 | 20261.7 |
1154 | 2023-12-18 11:44:46 | record | 2 | 82551 | 63 | 2.580 | 31996.5 |
1153 | 2023-12-15 18:30:04 | record | 3 | 112716 | 567 | 5.673 | 19868.9 |
1152 | 2023-12-09 11:33:12 | record | 3 | 112716 | 567 | 9.390 | 12003.8 |
1151 | 2023-12-09 11:33:14 | record | 2 | 82551 | 63 | 2.580 | 31996.5 |
1150 | 2023-11-29 15:26:45 | record | 2 | 82551 | 63 | 2.186 | 37763.5 |
1149 | 2023-11-25 06:46:20 | record | 2 | 82551 | 63 | 2.423 | 34069.7 |
1148 | 2023-11-24 01:12:21 | record | 3 | 112716 | 567 | 5.173 | 21789.3 |
1147 | 2023-11-12 09:11:09 | record | 1 | 48755 | 4 | 0.890 | 54780.9 |
1146 | 2023-11-11 01:21:31 | record | 1 | 48755 | 4 | 0.783 | 62266.9 |
1145 | 2023-11-10 23:06:28 | record | 1 | 48755 | 4 | 0.860 | 56691.9 |
1144 | 2023-11-07 09:30:04 | record | 1 | 48755 | 4 | 0.890 | 54780.9 |
1143 | 2023-10-29 18:16:38 | record | 1 | 48755 | 4 | 0.796 | 61250.0 |
1142 | 2023-10-29 10:01:42 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1141 | 2023-10-27 16:12:36 | record | 1 | 48755 | 4 | 0.813 | 59969.2 |
1140 | 2023-10-27 06:18:22 | record | 3 | 112716 | 567 | 6.920 | 16288.4 |
1139 | 2023-10-22 13:36:08 | record | 3 | 112716 | 567 | 5.843 | 19290.8 |
1138 | 2023-10-22 01:17:15 | record | 3 | 112716 | 567 | 4.906 | 22975.1 |
1137 | 2023-10-20 17:59:42 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1136 | 2023-10-18 00:33:46 | record | 2 | 82551 | 63 | 2.953 | 27955.0 |
1135 | 2023-10-17 23:48:54 | record | 1 | 48755 | 4 | 0.783 | 62266.9 |
1134 | 2023-10-17 07:41:40 | record | 3 | 112716 | 567 | 5.203 | 21663.7 |
1133 | 2023-10-15 22:10:53 | record | 2 | 82551 | 63 | 2.500 | 33020.4 |
1132 | 2023-10-15 01:36:22 | record | 3 | 112716 | 567 | 5.686 | 19823.4 |
1131 | 2023-10-10 23:16:53 | record | 1 | 48755 | 4 | 0.860 | 56691.9 |
1130 | 2023-10-04 12:54:24 | record | 1 | 48755 | 4 | 0.763 | 63899.1 |
1129 | 2023-09-30 04:15:04 | record | 3 | 112716 | 567 | 5.593 | 20153.0 |
1128 | 2023-09-28 01:28:57 | record | 3 | 112716 | 567 | 6.720 | 16773.2 |
1127 | 2023-09-25 16:38:53 | record | 1 | 48755 | 4 | 0.813 | 59969.2 |
1126 | 2023-09-21 14:47:01 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1125 | 2023-09-21 11:41:09 | record | 3 | 112716 | 567 | 5.546 | 20323.8 |
1124 | 2023-08-24 19:02:52 | record | 2 | 82551 | 63 | 2.483 | 33246.5 |
1123 | 2023-08-23 03:43:18 | record | 1 | 48755 | 4 | 0.763 | 63899.1 |
1122 | 2023-07-06 01:29:57 | record | 1 | 48755 | 4 | 0.826 | 59025.4 |
1121 | 2023-07-01 20:05:57 | record | 3 | 112716 | 567 | 5.890 | 19136.8 |
1120 | 2023-05-23 11:18:35 | record | 1 | 48755 | 4 | 0.763 | 63899.1 |
1119 | 2023-05-08 07:16:32 | record | 2 | 82551 | 63 | 2.173 | 37989.4 |
1118 | 2023-03-25 08:20:00 | record | 3 | 112716 | 567 | 4.796 | 23502.1 |
1117 | 2023-03-22 10:33:26 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1116 | 2023-03-20 15:26:07 | record | 1 | 48755 | 4 | 0.813 | 59969.2 |
1115 | 2023-02-15 19:47:28 | record | 2 | 82551 | 63 | 2.343 | 35233.0 |
1114 | 2023-02-14 16:25:08 | record | 3 | 112716 | 567 | 5.640 | 19985.1 |
1113 | 2023-01-07 12:47:08 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1112 | 2023-01-02 01:30:57 | record | 3 | 112716 | 567 | 5.453 | 20670.5 |
1111 | 2022-12-24 04:08:45 | record | 3 | 112716 | 567 | 4.783 | 23566.0 |
1110 | 2022-12-24 03:44:09 | record | 3 | 112716 | 567 | 5.626 | 20034.8 |
1109 | 2022-12-23 23:14:57 | record | 3 | 112716 | 567 | 5.000 | 22543.2 |
1108 | 2022-12-23 03:43:23 | record | 3 | 112716 | 567 | 5.126 | 21989.1 |
1107 | 2022-12-22 03:43:59 | record | 3 | 112716 | 567 | 4.923 | 22895.8 |
1106 | 2022-12-21 03:43:40 | record | 3 | 112716 | 567 | 5.753 | 19592.6 |
1105 | 2022-12-06 03:20:05 | record | 3 | 112716 | 567 | 10.660 | 10573.7 |
1104 | 2022-12-05 03:31:44 | record | 3 | 112716 | 567 | 5.483 | 20557.4 |
1103 | 2022-12-04 03:18:22 | record | 3 | 112716 | 567 | 5.063 | 22262.7 |
1102 | 2022-12-03 03:20:02 | record | 3 | 112716 | 567 | 4.813 | 23419.1 |
1101 | 2022-12-02 03:18:16 | record | 3 | 112716 | 567 | 4.703 | 23966.8 |
1100 | 2022-12-01 03:18:56 | record | 3 | 112716 | 567 | 4.766 | 23650.0 |
1099 | 2022-12-01 01:45:20 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |
1098 | 2022-11-27 18:49:06 | record | 1 | 48755 | 4 | 0.826 | 59025.4 |
1097 | 2022-11-27 03:44:47 | record | 3 | 112716 | 567 | 4.750 | 23729.7 |
1096 | 2022-11-25 13:27:51 | record | 2 | 82551 | 63 | 2.310 | 35736.4 |
1095 | 2022-11-17 22:18:40 | record | 3 | 112716 | 567 | 7.826 | 14402.8 |
1094 | 2022-11-13 23:02:18 | record | 3 | 112716 | 567 | 5.813 | 19390.3 |
1093 | 2022-11-12 16:24:02 | record | 3 | 112716 | 567 | 6.190 | 18209.4 |
1092 | 2022-11-11 06:04:59 | record | 3 | 112716 | 567 | 5.750 | 19602.8 |
1091 | 2022-11-10 21:28:48 | record | 3 | 112716 | 567 | 5.690 | 19809.5 |
1090 | 2022-11-09 09:36:09 | record | 3 | 112716 | 567 | 6.203 | 18171.2 |
1089 | 2022-11-08 12:46:44 | record | 3 | 112716 | 567 | 6.220 | 18121.5 |
1088 | 2022-11-07 18:41:42 | record | 3 | 112716 | 567 | 5.513 | 20445.5 |
1087 | 2022-11-06 15:07:26 | record | 3 | 112716 | 567 | 6.300 | 17891.4 |
1086 | 2022-10-28 03:09:28 | record | 3 | 112716 | 567 | 4.826 | 23356.0 |
1085 | 2022-10-18 20:57:16 | record | 3 | 112716 | 567 | 4.783 | 23566.0 |
1084 | 2022-10-17 03:50:37 | record | 3 | 112716 | 567 | 4.780 | 23580.8 |
1083 | 2022-10-05 18:39:14 | record | 1 | 48755 | 4 | 0.766 | 63648.8 |