History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johns"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1173 | 2026-03-07 09:06:13 | johns | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1172 | 2026-03-07 03:47:30 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1171 | 2026-03-05 05:22:46 | johns | 2 | 53800 | 78 | 1.436 | 37465.2 |
| 1170 | 2026-02-25 12:51:18 | johns | 3 | 83667 | 1401 | 3.873 | 21602.6 |
| 1169 | 2026-02-24 02:06:46 | johns | 3 | 83667 | 1401 | 5.873 | 14246.0 |
| 1168 | 2026-02-23 13:16:14 | johns | 3 | 83667 | 1401 | 4.156 | 20131.6 |
| 1167 | 2026-02-21 10:43:49 | johns | 3 | 83667 | 1401 | 3.420 | 24464.0 |
| 1166 | 2026-02-19 08:24:28 | johns | 3 | 83667 | 1401 | 3.640 | 22985.4 |
| 1165 | 2026-02-18 21:54:53 | johns | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1164 | 2026-02-15 15:01:19 | johns | 2 | 53800 | 78 | 2.936 | 18324.3 |
| 1163 | 2026-02-15 14:11:10 | johns | 2 | 53800 | 78 | 1.563 | 34421.0 |
| 1162 | 2026-02-13 09:10:28 | johns | 3 | 83667 | 1401 | 18.140 | 4612.3 |
| 1161 | 2026-02-13 09:09:54 | johns | 3 | 83667 | 1401 | 11.440 | 7313.5 |
| 1160 | 2026-02-12 08:59:14 | johns | 2 | 53800 | 78 | 1.670 | 32215.6 |
| 1159 | 2026-02-10 22:57:01 | johns | 3 | 83667 | 1401 | 19.233 | 4350.2 |
| 1158 | 2026-01-30 12:55:02 | johns | 3 | 83667 | 1401 | 3.813 | 21942.6 |
| 1157 | 2026-01-25 08:08:48 | johns | 3 | 83667 | 1401 | 9.626 | 8691.8 |
| 1156 | 2026-01-21 20:36:06 | johns | 2 | 53800 | 78 | 2.376 | 22643.1 |
| 1155 | 2026-01-17 03:00:45 | johns | 3 | 83667 | 1401 | 17.770 | 4708.3 |
| 1154 | 2026-01-04 08:09:01 | johns | 3 | 83667 | 1401 | 8.826 | 9479.6 |
| 1153 | 2026-01-02 17:15:41 | johns | 3 | 83667 | 1401 | 19.093 | 4382.1 |
| 1152 | 2025-12-28 06:33:51 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1151 | 2025-12-27 22:22:46 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1150 | 2025-12-18 17:32:29 | johns | 3 | 83667 | 1401 | 3.846 | 21754.3 |
| 1149 | 2025-12-11 04:02:44 | johns | 3 | 83667 | 1401 | 3.936 | 21256.9 |
| 1148 | 2025-12-08 11:20:35 | johns | 3 | 83667 | 1401 | 6.500 | 12871.8 |
| 1147 | 2025-12-02 12:51:36 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1146 | 2025-12-01 23:46:38 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1145 | 2025-12-01 06:43:04 | johns | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 1144 | 2025-11-25 12:16:38 | johns | 3 | 83667 | 1401 | 6.513 | 12846.2 |
| 1143 | 2025-11-20 19:36:15 | johns | 1 | 28756 | 4 | 0.686 | 41918.4 |
| 1142 | 2025-11-20 00:42:49 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1141 | 2025-11-18 12:31:01 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1140 | 2025-11-18 12:29:54 | johns | 1 | 28756 | 4 | 2.690 | 10690.0 |
| 1139 | 2025-11-15 17:17:19 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1138 | 2025-11-14 15:01:07 | johns | 3 | 83667 | 1401 | 4.966 | 16848.0 |
| 1137 | 2025-11-07 02:03:28 | johns | 3 | 83667 | 1401 | 17.313 | 4832.6 |
| 1136 | 2025-11-07 02:03:09 | johns | 3 | 83667 | 1401 | 13.110 | 6381.9 |
| 1135 | 2025-11-07 02:02:57 | johns | 3 | 83667 | 1401 | 16.203 | 5163.7 |
| 1134 | 2025-11-06 17:49:34 | johns | 3 | 83667 | 1401 | 3.656 | 22884.8 |
| 1133 | 2025-10-24 22:50:17 | johns | 3 | 83667 | 1401 | 3.796 | 22040.8 |
| 1132 | 2025-10-22 17:17:33 | johns | 3 | 83667 | 1401 | 9.233 | 9061.7 |
| 1131 | 2025-10-20 03:34:01 | johns | 1 | 28756 | 4 | 1.140 | 25224.6 |
| 1130 | 2025-09-20 11:31:50 | johns | 3 | 83667 | 1401 | 3.390 | 24680.5 |
| 1129 | 2025-09-14 04:58:38 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1128 | 2025-09-06 14:55:30 | johns | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1127 | 2025-08-25 03:25:46 | johns | 1 | 28756 | 4 | 3.080 | 9336.4 |
| 1126 | 2025-08-17 15:09:33 | johns | 3 | 83667 | 1401 | 8.873 | 9429.4 |
| 1125 | 2025-08-17 11:53:40 | johns | 3 | 83667 | 1401 | 15.356 | 5448.5 |
| 1124 | 2025-08-17 09:28:45 | johns | 3 | 83667 | 1401 | 15.156 | 5520.4 |
| 1123 | 2025-08-16 05:34:27 | johns | 1 | 28756 | 4 | 1.016 | 28303.1 |
| 1122 | 2025-08-15 16:28:43 | johns | 3 | 83667 | 1401 | 8.703 | 9613.6 |
| 1121 | 2025-08-14 07:58:33 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1120 | 2025-08-10 12:14:04 | johns | 1 | 28756 | 4 | 0.936 | 30722.2 |
| 1119 | 2025-08-05 06:31:55 | johns | 1 | 28756 | 4 | 2.623 | 10963.0 |
| 1118 | 2025-08-04 21:07:10 | johns | 1 | 28756 | 4 | 1.236 | 23265.4 |
| 1117 | 2025-08-03 00:46:19 | johns | 1 | 28756 | 4 | 2.313 | 12432.3 |
| 1116 | 2025-08-01 05:46:35 | johns | 1 | 28756 | 4 | 2.780 | 10343.9 |
| 1115 | 2025-07-31 19:09:38 | johns | 3 | 83667 | 1401 | 10.940 | 7647.8 |
| 1114 | 2025-07-29 14:57:37 | johns | 3 | 83667 | 1401 | 9.530 | 8779.3 |
| 1113 | 2025-07-28 07:40:45 | johns | 3 | 83667 | 1401 | 15.420 | 5425.9 |
| 1112 | 2025-07-28 02:56:47 | johns | 2 | 53800 | 78 | 2.983 | 18035.5 |
| 1111 | 2025-07-27 02:02:52 | johns | 1 | 28756 | 4 | 2.313 | 12432.3 |
| 1110 | 2025-07-26 21:40:54 | johns | 2 | 53800 | 78 | 7.890 | 6818.8 |
| 1109 | 2025-07-26 21:31:31 | johns | 1 | 28756 | 4 | 0.923 | 31154.9 |
| 1108 | 2025-07-25 05:14:10 | johns | 1 | 28756 | 4 | 0.923 | 31154.9 |
| 1107 | 2025-07-24 17:15:31 | johns | 1 | 28756 | 4 | 1.033 | 27837.4 |
| 1106 | 2025-07-24 06:11:44 | johns | 1 | 28756 | 4 | 3.453 | 8327.8 |
| 1105 | 2025-07-23 07:05:15 | johns | 1 | 28756 | 4 | 4.096 | 7020.5 |
| 1104 | 2025-07-22 09:33:07 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1103 | 2025-07-15 10:36:16 | johns | 1 | 28756 | 4 | 2.516 | 11429.3 |
| 1102 | 2025-07-13 07:06:14 | johns | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1101 | 2025-07-11 16:19:52 | johns | 1 | 28756 | 4 | 3.436 | 8369.0 |
| 1100 | 2025-07-08 18:34:00 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1099 | 2025-07-04 20:44:07 | johns | 1 | 28756 | 4 | 3.296 | 8724.5 |
| 1098 | 2025-07-02 05:27:56 | johns | 1 | 28756 | 4 | 2.033 | 14144.6 |
| 1097 | 2025-06-20 05:05:55 | johns | 1 | 28756 | 4 | 2.483 | 11581.2 |
| 1096 | 2025-06-16 11:56:22 | johns | 1 | 28756 | 4 | 0.936 | 30722.2 |
| 1095 | 2025-06-13 23:58:49 | johns | 2 | 53800 | 78 | 8.203 | 6558.6 |
| 1094 | 2025-06-13 06:16:11 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1093 | 2025-06-08 11:59:04 | johns | 2 | 53800 | 78 | 8.330 | 6458.6 |
| 1092 | 2025-06-05 23:55:02 | johns | 2 | 53800 | 78 | 7.923 | 6790.4 |
| 1091 | 2025-06-03 20:42:30 | johns | 1 | 28756 | 4 | 3.733 | 7703.2 |
| 1090 | 2025-06-02 05:28:51 | johns | 1 | 28756 | 4 | 3.000 | 9585.3 |
| 1089 | 2025-06-02 04:33:04 | johns | 1 | 28756 | 4 | 2.343 | 12273.2 |
| 1088 | 2025-05-27 20:56:03 | johns | 1 | 28756 | 4 | 0.560 | 51350.0 |
| 1087 | 2025-05-27 03:29:16 | johns | 1 | 28756 | 4 | 2.440 | 11785.2 |
| 1086 | 2025-05-17 04:21:17 | johns | 1 | 28756 | 4 | 3.470 | 8287.0 |
| 1085 | 2025-05-16 06:40:39 | johns | 3 | 83667 | 1401 | 15.813 | 5291.0 |
| 1084 | 2025-05-14 18:18:06 | johns | 3 | 83667 | 1401 | 9.800 | 8537.4 |
| 1083 | 2025-05-14 13:49:44 | johns | 3 | 83667 | 1401 | 19.550 | 4279.6 |
| 1082 | 2025-05-12 07:22:14 | johns | 1 | 28756 | 4 | 1.936 | 14853.3 |
| 1081 | 2025-05-12 07:00:42 | johns | 3 | 83667 | 1401 | 15.876 | 5270.0 |
| 1080 | 2025-05-11 00:12:07 | johns | 3 | 83667 | 1401 | 18.076 | 4628.6 |
| 1079 | 2025-05-07 23:19:02 | johns | 1 | 28756 | 4 | 3.266 | 8804.7 |
| 1078 | 2025-05-05 16:26:24 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1077 | 2025-05-03 20:33:32 | johns | 1 | 28756 | 4 | 2.123 | 13545.0 |
| 1076 | 2025-04-19 20:07:53 | johns | 1 | 28756 | 4 | 0.986 | 29164.3 |
| 1075 | 2025-04-18 04:49:46 | johns | 1 | 28756 | 4 | 1.766 | 16283.1 |
| 1074 | 2025-04-16 11:40:02 | johns | 1 | 28756 | 4 | 2.403 | 11966.7 |