History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"patron"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1178 | 2024-04-28 01:01:00 | patron | 1 | 48755 | 7 | 2.033 | 23981.8 |
| 1177 | 2024-04-18 23:08:55 | patron | 2 | 82551 | 59 | 2.466 | 33475.7 |
| 1176 | 2024-04-18 23:08:24 | patron | 3 | 112716 | 622 | 5.216 | 21609.7 |
| 1175 | 2024-04-18 07:12:42 | patron | 3 | 112716 | 622 | 24.563 | 4588.9 |
| 1174 | 2024-04-17 07:09:36 | patron | 3 | 112716 | 622 | 5.453 | 20670.5 |
| 1173 | 2024-04-06 12:49:12 | patron | 1 | 48755 | 7 | 1.923 | 25353.6 |
| 1172 | 2024-04-06 05:46:21 | patron | 2 | 82551 | 59 | 2.906 | 28407.1 |
| 1171 | 2024-03-31 16:20:06 | patron | 3 | 112716 | 622 | 9.923 | 11359.1 |
| 1170 | 2024-03-31 16:20:08 | patron | 2 | 82551 | 59 | 2.983 | 27673.8 |
| 1169 | 2024-03-31 16:19:55 | patron | 3 | 112716 | 622 | 11.406 | 9882.2 |
| 1168 | 2024-03-31 16:20:03 | patron | 1 | 48755 | 7 | 1.000 | 48755.0 |
| 1167 | 2024-03-31 16:19:54 | patron | 2 | 82551 | 59 | 3.030 | 27244.6 |
| 1166 | 2024-03-31 16:19:52 | patron | 1 | 48755 | 7 | 2.093 | 23294.3 |
| 1165 | 2024-02-26 03:48:19 | patron | 1 | 48755 | 7 | 2.576 | 18926.6 |
| 1164 | 2024-02-16 05:03:09 | patron | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 1163 | 2024-01-31 06:27:52 | patron | 1 | 48755 | 7 | 1.063 | 45865.5 |
| 1162 | 2024-01-27 00:32:45 | patron | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 1161 | 2023-12-13 10:24:17 | patron | 3 | 112716 | 622 | 4.953 | 22757.1 |
| 1160 | 2023-12-07 18:56:06 | patron | 2 | 82551 | 59 | 2.576 | 32046.2 |
| 1159 | 2023-12-06 16:16:11 | patron | 3 | 112716 | 622 | 11.640 | 9683.5 |
| 1158 | 2023-12-05 18:41:13 | patron | 2 | 82551 | 59 | 2.513 | 32849.6 |
| 1157 | 2023-12-01 17:58:43 | patron | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 1156 | 2023-12-01 02:24:22 | patron | 3 | 112716 | 622 | 5.546 | 20323.8 |
| 1155 | 2023-12-01 02:24:20 | patron | 2 | 82551 | 59 | 2.686 | 30733.8 |
| 1154 | 2023-11-30 09:52:52 | patron | 3 | 112716 | 622 | 5.580 | 20200.0 |
| 1153 | 2023-11-20 11:47:15 | patron | 3 | 112716 | 622 | 5.656 | 19928.6 |
| 1152 | 2023-11-20 11:47:10 | patron | 2 | 82551 | 59 | 2.453 | 33653.1 |
| 1151 | 2023-11-13 13:39:16 | patron | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1150 | 2023-11-11 02:29:09 | patron | 3 | 112716 | 622 | 4.873 | 23130.7 |
| 1149 | 2023-11-11 02:29:06 | patron | 2 | 82551 | 59 | 2.280 | 36206.6 |
| 1148 | 2023-11-09 00:34:53 | patron | 1 | 48755 | 7 | 0.793 | 61481.7 |
| 1147 | 2023-11-02 02:44:16 | patron | 3 | 112716 | 622 | 6.076 | 18551.0 |
| 1146 | 2023-11-02 02:44:06 | patron | 3 | 112716 | 622 | 12.033 | 9367.2 |
| 1145 | 2023-11-02 02:44:05 | patron | 2 | 82551 | 59 | 2.843 | 29036.6 |
| 1144 | 2023-11-02 01:39:36 | patron | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1143 | 2023-10-27 17:51:05 | patron | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 1142 | 2023-10-21 07:51:35 | patron | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 1141 | 2023-10-18 00:45:28 | patron | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 1140 | 2023-10-12 13:13:14 | patron | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 1139 | 2023-10-11 15:38:25 | patron | 1 | 48755 | 7 | 1.033 | 47197.5 |
| 1138 | 2023-10-04 19:04:30 | patron | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1137 | 2023-09-23 09:27:36 | patron | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 1136 | 2023-09-16 10:04:28 | patron | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1135 | 2023-09-14 06:16:47 | patron | 3 | 112716 | 622 | 4.830 | 23336.6 |
| 1134 | 2023-09-11 08:11:37 | patron | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 1133 | 2023-09-03 19:40:09 | patron | 2 | 82551 | 59 | 2.483 | 33246.5 |
| 1132 | 2023-08-22 13:58:15 | patron | 3 | 112716 | 622 | 6.110 | 18447.8 |
| 1131 | 2023-07-05 12:19:48 | patron | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 1130 | 2023-06-23 04:33:12 | patron | 3 | 112716 | 622 | 5.356 | 21044.8 |
| 1129 | 2023-06-22 01:11:53 | patron | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 1128 | 2023-06-17 05:11:55 | patron | 3 | 112716 | 622 | 4.796 | 23502.1 |
| 1127 | 2023-04-12 09:04:53 | patron | 1 | 48755 | 7 | 0.856 | 56956.8 |
| 1126 | 2023-03-31 14:25:27 | patron | 3 | 112716 | 622 | 5.923 | 19030.2 |
| 1125 | 2023-03-15 10:19:32 | patron | 3 | 112716 | 622 | 4.936 | 22835.5 |
| 1124 | 2023-02-27 18:22:19 | patron | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 1123 | 2023-02-06 09:57:01 | patron | 3 | 112716 | 622 | 6.593 | 17096.3 |
| 1122 | 2023-02-03 18:40:01 | patron | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1121 | 2023-01-17 00:57:03 | patron | 2 | 82551 | 59 | 2.170 | 38041.9 |
| 1120 | 2022-12-21 01:34:05 | patron | 3 | 112716 | 622 | 5.076 | 22205.7 |
| 1119 | 2022-12-17 11:49:05 | patron | 3 | 112716 | 622 | 4.783 | 23566.0 |
| 1118 | 2022-12-02 23:15:53 | patron | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1117 | 2022-11-11 01:34:21 | patron | 3 | 112716 | 622 | 4.970 | 22679.3 |
| 1116 | 2022-11-05 22:06:49 | patron | 3 | 112716 | 622 | 4.766 | 23650.0 |
| 1115 | 2022-11-04 12:47:05 | patron | 3 | 112716 | 622 | 5.373 | 20978.2 |
| 1114 | 2022-11-04 02:47:23 | patron | 3 | 112716 | 622 | 5.080 | 22188.2 |
| 1113 | 2022-11-03 22:30:11 | patron | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 1112 | 2022-10-27 21:08:44 | patron | 2 | 82551 | 59 | 2.153 | 38342.3 |
| 1111 | 2022-10-05 10:14:06 | patron | 3 | 112716 | 622 | 4.796 | 23502.1 |
| 1110 | 2022-09-01 07:51:09 | patron | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 1109 | 2022-08-26 05:46:20 | patron | 3 | 112716 | 622 | 5.140 | 21929.2 |
| 1108 | 2022-08-23 13:26:30 | patron | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1107 | 2022-08-11 06:35:24 | patron | 3 | 112716 | 622 | 4.940 | 22817.0 |
| 1106 | 2022-07-29 09:59:30 | patron | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 1105 | 2022-07-29 05:00:02 | patron | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 1104 | 2022-07-26 21:17:08 | patron | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 1103 | 2022-07-21 16:45:10 | patron | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 1102 | 2022-07-17 23:29:00 | patron | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 1101 | 2022-05-25 14:29:38 | patron | 2 | 82551 | 59 | 2.436 | 33887.9 |
| 1100 | 2022-03-30 22:02:08 | patron | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 1099 | 2022-03-21 14:58:57 | patron | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1098 | 2022-01-18 09:12:08 | patron | 2 | 82551 | 59 | 2.390 | 34540.2 |
| 1097 | 2021-12-29 00:24:01 | patron | 3 | 112716 | 622 | 5.483 | 20557.4 |
| 1096 | 2021-12-27 13:56:17 | patron | 1 | 48755 | 7 | 0.983 | 49598.2 |
| 1095 | 2021-12-19 16:03:48 | patron | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 1094 | 2021-12-04 18:53:24 | patron | 3 | 112716 | 622 | 5.110 | 22057.9 |
| 1093 | 2021-11-12 01:19:57 | patron | 3 | 112716 | 622 | 5.203 | 21663.7 |
| 1092 | 2021-11-01 07:14:58 | patron | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 1091 | 2021-10-20 12:42:50 | patron | 2 | 82551 | 59 | 2.203 | 37472.1 |
| 1090 | 2021-10-09 06:18:08 | patron | 3 | 112716 | 622 | 4.783 | 23566.0 |
| 1089 | 2021-10-03 13:24:41 | patron | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 1088 | 2021-09-12 10:36:22 | patron | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 1087 | 2021-08-08 20:42:06 | patron | 3 | 112716 | 622 | 4.736 | 23799.8 |
| 1086 | 2021-07-30 07:13:26 | patron | 3 | 112716 | 622 | 4.846 | 23259.6 |
| 1085 | 2021-07-18 12:32:52 | patron | 3 | 112716 | 622 | 7.700 | 14638.4 |
| 1084 | 2021-07-16 16:58:41 | patron | 3 | 112716 | 622 | 5.610 | 20092.0 |
| 1083 | 2021-07-07 05:05:41 | patron | 3 | 112716 | 622 | 5.783 | 19490.9 |
| 1082 | 2021-07-03 15:43:53 | patron | 3 | 112716 | 622 | 5.673 | 19868.9 |
| 1081 | 2021-06-21 08:55:11 | patron | 2 | 82551 | 59 | 2.343 | 35233.0 |
| 1080 | 2021-06-12 05:08:35 | patron | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 1079 | 2021-06-02 00:55:05 | patron | 3 | 112716 | 622 | 5.530 | 20382.6 |