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 |
| 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 |
| 1073 | 2025-04-16 07:44:36 | johns | 1 | 28756 | 4 | 1.560 | 18433.3 |
| 1072 | 2025-04-12 06:41:30 | johns | 1 | 28756 | 4 | 3.796 | 7575.3 |
| 1071 | 2025-04-06 11:30:15 | johns | 2 | 53800 | 78 | 3.610 | 14903.0 |
| 1070 | 2025-04-01 23:19:30 | johns | 2 | 53800 | 78 | 6.296 | 8545.1 |
| 1069 | 2025-03-31 14:50:25 | johns | 2 | 53800 | 78 | 10.486 | 5130.7 |
| 1068 | 2025-03-31 06:54:03 | johns | 1 | 28756 | 4 | 1.330 | 21621.1 |
| 1067 | 2025-03-31 06:50:08 | johns | 3 | 83667 | 1401 | 26.220 | 3191.0 |
| 1066 | 2025-03-30 05:03:16 | johns | 1 | 28756 | 4 | 1.266 | 22714.1 |
| 1065 | 2025-03-29 14:15:25 | johns | 3 | 83667 | 1401 | 30.656 | 2729.2 |
| 1064 | 2025-03-27 19:32:35 | johns | 3 | 83667 | 1401 | 25.016 | 3344.5 |
| 1063 | 2025-03-24 13:17:31 | johns | 3 | 83667 | 1401 | 3.843 | 21771.3 |
| 1062 | 2025-03-17 10:37:12 | johns | 1 | 28756 | 4 | 1.033 | 27837.4 |
| 1061 | 2025-03-14 23:20:53 | johns | 1 | 28756 | 4 | 1.016 | 28303.1 |
| 1060 | 2025-03-13 00:17:30 | johns | 1 | 28756 | 4 | 2.000 | 14378.0 |
| 1059 | 2025-03-06 17:17:38 | johns | 3 | 83667 | 1401 | 17.690 | 4729.6 |
| 1058 | 2025-02-27 23:47:47 | johns | 3 | 83667 | 1401 | 18.906 | 4425.4 |
| 1057 | 2025-02-27 22:18:27 | johns | 3 | 83667 | 1401 | 21.266 | 3934.3 |
| 1056 | 2025-02-27 22:18:26 | johns | 2 | 53800 | 78 | 10.606 | 5072.6 |
| 1055 | 2025-02-27 21:27:59 | johns | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1054 | 2025-02-27 21:25:05 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1053 | 2025-02-27 21:04:10 | johns | 1 | 28756 | 4 | 2.846 | 10104.0 |
| 1052 | 2025-02-24 22:09:30 | johns | 2 | 53800 | 78 | 3.736 | 14400.4 |
| 1051 | 2025-02-24 15:20:03 | johns | 2 | 53800 | 78 | 7.546 | 7129.6 |
| 1050 | 2025-02-24 13:13:39 | johns | 2 | 53800 | 78 | 7.173 | 7500.3 |
| 1049 | 2025-02-24 02:48:14 | johns | 3 | 83667 | 1401 | 19.563 | 4276.8 |
| 1048 | 2025-02-21 02:23:27 | johns | 3 | 83667 | 1401 | 19.516 | 4287.1 |