History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pestier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1173 | 2025-01-25 22:59:22 | pestier | 1 | 69583 | 8 | 5.563 | 12508.2 |
| 1172 | 2025-01-23 22:45:05 | pestier | 1 | 69583 | 8 | 5.126 | 13574.5 |
| 1171 | 2025-01-20 05:50:47 | pestier | 1 | 69583 | 8 | 6.250 | 11133.3 |
| 1170 | 2024-12-28 09:14:02 | pestier | 1 | 69583 | 8 | 4.203 | 16555.6 |
| 1169 | 2024-12-21 01:45:13 | pestier | 1 | 69583 | 8 | 4.140 | 16807.5 |
| 1168 | 2024-11-16 19:39:32 | pestier | 1 | 69583 | 8 | 4.250 | 16372.5 |
| 1167 | 2024-10-27 03:13:52 | pestier | 1 | 69583 | 8 | 5.406 | 12871.4 |
| 1166 | 2024-10-25 11:43:52 | pestier | 1 | 69583 | 8 | 4.203 | 16555.6 |
| 1165 | 2024-10-17 12:58:01 | pestier | 1 | 69583 | 8 | 5.686 | 12237.6 |
| 1164 | 2024-09-22 09:36:01 | pestier | 1 | 69583 | 8 | 5.593 | 12441.1 |
| 1163 | 2024-09-18 23:29:25 | pestier | 1 | 69583 | 8 | 9.533 | 7299.2 |
| 1162 | 2024-09-15 12:35:46 | pestier | 1 | 69583 | 8 | 5.310 | 13104.1 |
| 1161 | 2024-09-04 14:50:45 | pestier | 1 | 69583 | 8 | 11.033 | 6306.8 |
| 1160 | 2024-09-04 06:08:33 | pestier | 1 | 69583 | 8 | 10.720 | 6491.0 |
| 1159 | 2024-08-20 00:10:10 | pestier | 1 | 69583 | 8 | 5.266 | 13213.6 |
| 1158 | 2024-08-17 09:26:30 | pestier | 1 | 69583 | 8 | 7.090 | 9814.2 |
| 1157 | 2024-08-16 09:37:59 | pestier | 1 | 69583 | 8 | 7.063 | 9851.8 |
| 1156 | 2024-08-14 06:42:24 | pestier | 1 | 69583 | 8 | 9.563 | 7276.3 |
| 1155 | 2024-08-08 05:05:30 | pestier | 3 | 134027 | 749 | 19.126 | 7007.6 |
| 1154 | 2024-08-07 23:19:50 | pestier | 3 | 134027 | 749 | 39.350 | 3406.0 |
| 1153 | 2024-08-07 19:59:16 | pestier | 3 | 134027 | 749 | 22.720 | 5899.1 |
| 1152 | 2024-08-06 17:29:09 | pestier | 3 | 134027 | 749 | 13.173 | 10174.4 |
| 1151 | 2024-08-06 08:00:34 | pestier | 3 | 134027 | 749 | 22.986 | 5830.8 |
| 1150 | 2024-08-06 07:59:15 | pestier | 3 | 134027 | 749 | 14.126 | 9488.0 |
| 1149 | 2024-08-06 04:15:59 | pestier | 1 | 69583 | 8 | 4.456 | 15615.6 |
| 1148 | 2024-07-25 04:43:27 | pestier | 1 | 69583 | 8 | 4.843 | 14367.7 |
| 1147 | 2024-07-20 18:34:26 | pestier | 1 | 69583 | 8 | 3.436 | 20251.2 |
| 1146 | 2024-07-16 18:55:32 | pestier | 1 | 69583 | 8 | 4.750 | 14649.1 |
| 1145 | 2024-07-14 08:50:21 | pestier | 2 | 107671 | 78 | 11.140 | 9665.3 |
| 1144 | 2024-07-14 07:46:51 | pestier | 1 | 69583 | 8 | 3.250 | 21410.2 |
| 1143 | 2024-07-07 17:20:44 | pestier | 1 | 69583 | 8 | 6.516 | 10678.8 |
| 1142 | 2024-06-30 06:48:52 | pestier | 1 | 69583 | 8 | 2.326 | 29915.3 |
| 1141 | 2024-06-29 05:56:54 | pestier | 1 | 69583 | 8 | 5.436 | 12800.4 |
| 1140 | 2024-06-27 16:54:43 | pestier | 3 | 134027 | 749 | 25.533 | 5249.2 |
| 1139 | 2024-06-26 22:21:41 | pestier | 1 | 69583 | 8 | 5.330 | 13055.0 |
| 1138 | 2024-06-21 09:08:22 | pestier | 3 | 134027 | 749 | 20.313 | 6598.1 |
| 1137 | 2024-06-20 15:21:43 | pestier | 3 | 134027 | 749 | 29.283 | 4577.0 |
| 1136 | 2024-06-20 10:39:03 | pestier | 3 | 134027 | 749 | 29.800 | 4497.6 |
| 1135 | 2024-06-19 20:31:51 | pestier | 3 | 134027 | 749 | 36.143 | 3708.2 |
| 1134 | 2024-06-18 14:28:13 | pestier | 3 | 134027 | 749 | 25.486 | 5258.8 |
| 1133 | 2024-06-18 09:06:12 | pestier | 3 | 134027 | 749 | 42.050 | 3187.3 |
| 1132 | 2024-06-18 04:49:55 | pestier | 3 | 134027 | 749 | 31.046 | 4317.0 |
| 1131 | 2024-06-08 09:10:23 | pestier | 1 | 69583 | 8 | 2.516 | 27656.2 |
| 1130 | 2024-05-30 04:00:45 | pestier | 1 | 69583 | 8 | 4.750 | 14649.1 |
| 1129 | 2024-05-30 01:39:52 | pestier | 1 | 69583 | 8 | 4.643 | 14986.6 |
| 1128 | 2024-05-15 08:23:14 | pestier | 2 | 107671 | 78 | 3.640 | 29579.9 |
| 1127 | 2024-05-15 08:22:29 | pestier | 3 | 134027 | 749 | 7.236 | 18522.2 |
| 1126 | 2024-05-14 21:44:20 | pestier | 3 | 134027 | 749 | 21.126 | 6344.2 |
| 1125 | 2024-05-14 20:23:55 | pestier | 3 | 134027 | 749 | 7.266 | 18445.8 |
| 1124 | 2024-05-14 09:11:18 | pestier | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 1123 | 2024-05-07 09:01:56 | pestier | 3 | 134027 | 749 | 9.060 | 14793.3 |
| 1122 | 2024-04-28 21:02:32 | pestier | 3 | 134027 | 749 | 9.923 | 13506.7 |
| 1121 | 2024-04-25 19:34:46 | pestier | 3 | 134027 | 749 | 17.253 | 7768.3 |
| 1120 | 2024-04-25 10:34:02 | pestier | 3 | 134027 | 749 | 9.563 | 14015.2 |
| 1119 | 2024-04-23 03:52:40 | pestier | 3 | 134027 | 749 | 17.470 | 7671.8 |
| 1118 | 2024-04-23 00:51:54 | pestier | 3 | 134027 | 749 | 6.533 | 20515.4 |
| 1117 | 2024-04-17 01:54:40 | pestier | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 1116 | 2024-04-13 18:41:09 | pestier | 3 | 134027 | 749 | 21.753 | 6161.3 |
| 1115 | 2024-04-12 22:38:54 | pestier | 3 | 134027 | 749 | 14.206 | 9434.5 |
| 1114 | 2024-03-23 07:29:59 | pestier | 1 | 69583 | 8 | 1.360 | 51164.0 |
| 1113 | 2024-03-05 09:00:30 | pestier | 3 | 134027 | 749 | 7.283 | 18402.7 |
| 1112 | 2024-03-04 09:21:28 | pestier | 3 | 134027 | 749 | 20.033 | 6690.3 |
| 1111 | 2024-03-04 09:15:49 | pestier | 3 | 134027 | 749 | 23.313 | 5749.0 |
| 1110 | 2024-03-03 04:19:45 | pestier | 3 | 134027 | 749 | 6.376 | 21020.5 |
| 1109 | 2024-03-02 06:39:59 | pestier | 3 | 134027 | 749 | 23.703 | 5654.4 |
| 1108 | 2024-02-29 21:40:10 | pestier | 3 | 134027 | 749 | 7.733 | 17331.8 |
| 1107 | 2024-02-28 20:49:19 | pestier | 3 | 134027 | 749 | 7.313 | 18327.2 |
| 1106 | 2024-02-28 14:55:35 | pestier | 3 | 134027 | 749 | 12.000 | 11168.9 |
| 1105 | 2024-02-28 04:11:56 | pestier | 3 | 134027 | 749 | 9.610 | 13946.6 |
| 1104 | 2024-02-27 08:34:49 | pestier | 3 | 134027 | 749 | 8.623 | 15543.0 |
| 1103 | 2024-02-27 00:45:51 | pestier | 3 | 134027 | 749 | 7.170 | 18692.7 |
| 1102 | 2024-02-26 10:48:32 | pestier | 3 | 134027 | 749 | 13.956 | 9603.5 |
| 1101 | 2024-02-25 22:16:52 | pestier | 3 | 134027 | 749 | 8.516 | 15738.3 |
| 1100 | 2024-02-24 23:46:05 | pestier | 3 | 134027 | 749 | 6.190 | 21652.2 |
| 1099 | 2024-02-23 23:38:40 | pestier | 3 | 134027 | 749 | 7.923 | 16916.2 |
| 1098 | 2024-02-23 04:14:29 | pestier | 3 | 134027 | 749 | 7.830 | 17117.1 |
| 1097 | 2024-02-22 14:22:41 | pestier | 3 | 134027 | 749 | 21.283 | 6297.4 |
| 1096 | 2024-02-21 20:15:43 | pestier | 3 | 134027 | 749 | 10.326 | 12979.6 |
| 1095 | 2024-02-20 00:33:58 | pestier | 3 | 134027 | 749 | 24.406 | 5491.6 |
| 1094 | 2024-02-19 05:54:05 | pestier | 3 | 134027 | 749 | 9.656 | 13880.2 |
| 1093 | 2024-02-18 00:02:17 | pestier | 3 | 134027 | 749 | 10.003 | 13398.7 |
| 1092 | 2024-02-16 05:26:18 | pestier | 3 | 134027 | 749 | 5.906 | 22693.4 |
| 1091 | 2024-02-14 04:25:59 | pestier | 3 | 134027 | 749 | 15.076 | 8890.1 |
| 1090 | 2024-02-13 11:46:01 | pestier | 3 | 134027 | 749 | 21.906 | 6118.3 |
| 1089 | 2024-02-12 16:42:56 | pestier | 3 | 134027 | 749 | 8.610 | 15566.4 |
| 1088 | 2024-02-11 14:07:07 | pestier | 3 | 134027 | 749 | 8.873 | 15105.0 |
| 1087 | 2024-02-11 04:01:02 | pestier | 3 | 134027 | 749 | 6.050 | 22153.2 |
| 1086 | 2024-02-10 02:47:03 | pestier | 3 | 134027 | 749 | 6.703 | 19995.1 |
| 1085 | 2024-02-09 03:55:07 | pestier | 3 | 134027 | 749 | 7.436 | 18024.1 |
| 1084 | 2024-02-08 00:33:28 | pestier | 3 | 134027 | 749 | 17.910 | 7483.4 |
| 1083 | 2024-02-06 06:35:23 | pestier | 3 | 134027 | 749 | 7.423 | 18055.6 |
| 1082 | 2024-02-05 03:30:20 | pestier | 3 | 134027 | 749 | 7.156 | 18729.3 |
| 1081 | 2024-02-04 12:12:10 | pestier | 3 | 134027 | 749 | 7.673 | 17467.4 |
| 1080 | 2024-02-03 06:48:34 | pestier | 3 | 134027 | 749 | 6.546 | 20474.6 |
| 1079 | 2024-02-02 14:06:07 | pestier | 3 | 134027 | 749 | 7.063 | 18975.9 |
| 1078 | 2024-02-01 13:31:35 | pestier | 3 | 134027 | 749 | 5.860 | 22871.5 |
| 1077 | 2024-01-31 19:53:22 | pestier | 3 | 134027 | 749 | 6.013 | 22289.5 |
| 1076 | 2024-01-30 16:29:35 | pestier | 3 | 134027 | 749 | 10.906 | 12289.3 |
| 1075 | 2024-01-29 18:25:45 | pestier | 3 | 134027 | 749 | 7.266 | 18445.8 |
| 1074 | 2024-01-28 15:15:48 | pestier | 3 | 134027 | 749 | 5.860 | 22871.5 |