History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aggie"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1114 | 2025-12-02 20:13:02 | aggie | 1 | 28756 | 3 | 0.610 | 47141.0 |
| 1113 | 2025-11-30 20:34:59 | aggie | 2 | 53800 | 66 | 2.673 | 20127.2 |
| 1112 | 2025-11-25 04:36:15 | aggie | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1111 | 2025-11-23 09:40:59 | aggie | 2 | 53800 | 66 | 1.796 | 29955.5 |
| 1110 | 2025-11-23 01:53:43 | aggie | 3 | 83667 | 833 | 3.860 | 21675.4 |
| 1109 | 2025-11-23 01:52:00 | aggie | 2 | 53800 | 66 | 1.610 | 33416.1 |
| 1108 | 2025-11-19 02:00:24 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1107 | 2025-11-15 01:15:22 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1106 | 2025-11-11 13:47:50 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1105 | 2025-10-21 02:46:40 | aggie | 3 | 83667 | 833 | 13.623 | 6141.6 |
| 1104 | 2025-10-21 02:45:49 | aggie | 3 | 83667 | 833 | 19.673 | 4252.9 |
| 1103 | 2025-10-21 02:44:45 | aggie | 3 | 83667 | 833 | 30.376 | 2754.4 |
| 1102 | 2025-10-21 02:43:42 | aggie | 3 | 83667 | 833 | 37.376 | 2238.5 |
| 1101 | 2025-10-21 02:01:45 | aggie | 3 | 83667 | 833 | 23.686 | 3532.3 |
| 1100 | 2025-10-15 10:47:53 | aggie | 3 | 83667 | 833 | 3.873 | 21602.6 |
| 1099 | 2025-10-09 16:35:31 | aggie | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 1098 | 2025-10-01 22:26:31 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1097 | 2025-09-25 04:36:54 | aggie | 1 | 28756 | 3 | 1.093 | 26309.2 |
| 1096 | 2025-09-22 05:56:45 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1095 | 2025-09-22 02:00:17 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1094 | 2025-09-20 19:34:04 | aggie | 3 | 83667 | 833 | 4.360 | 19189.7 |
| 1093 | 2025-09-12 10:49:08 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1092 | 2025-08-31 04:08:49 | aggie | 1 | 28756 | 3 | 1.466 | 19615.3 |
| 1091 | 2025-08-24 23:18:53 | aggie | 1 | 28756 | 3 | 2.233 | 12877.7 |
| 1090 | 2025-08-24 21:50:39 | aggie | 2 | 53800 | 66 | 6.390 | 8419.4 |
| 1089 | 2025-08-24 11:30:27 | aggie | 1 | 28756 | 3 | 1.156 | 24875.4 |
| 1088 | 2025-08-17 06:07:23 | aggie | 1 | 28756 | 3 | 1.373 | 20943.9 |
| 1087 | 2025-08-12 05:26:30 | aggie | 1 | 28756 | 3 | 1.203 | 23903.6 |
| 1086 | 2025-08-03 23:53:11 | aggie | 1 | 28756 | 3 | 2.423 | 11867.9 |
| 1085 | 2025-08-03 02:41:41 | aggie | 2 | 53800 | 66 | 5.390 | 9981.4 |
| 1084 | 2025-08-01 19:07:23 | aggie | 2 | 53800 | 66 | 6.983 | 7704.4 |
| 1083 | 2025-08-01 03:01:20 | aggie | 3 | 83667 | 833 | 9.080 | 9214.4 |
| 1082 | 2025-07-31 11:50:35 | aggie | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1081 | 2025-07-31 07:28:15 | aggie | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 1080 | 2025-07-30 20:44:21 | aggie | 1 | 28756 | 3 | 1.576 | 18246.2 |
| 1079 | 2025-07-28 03:48:05 | aggie | 3 | 83667 | 833 | 11.643 | 7186.0 |
| 1078 | 2025-07-28 01:09:49 | aggie | 3 | 83667 | 833 | 10.220 | 8186.6 |
| 1077 | 2025-07-27 06:40:49 | aggie | 3 | 83667 | 833 | 25.236 | 3315.4 |
| 1076 | 2025-07-25 10:08:10 | aggie | 1 | 28756 | 3 | 2.423 | 11867.9 |
| 1075 | 2025-07-25 03:06:05 | aggie | 1 | 28756 | 3 | 1.296 | 22188.3 |
| 1074 | 2025-07-24 18:22:22 | aggie | 1 | 28756 | 3 | 1.110 | 25906.3 |
| 1073 | 2025-07-24 01:12:22 | aggie | 1 | 28756 | 3 | 2.483 | 11581.2 |
| 1072 | 2025-07-10 15:15:52 | aggie | 1 | 28756 | 3 | 1.673 | 17188.3 |
| 1071 | 2025-07-10 07:23:18 | aggie | 1 | 28756 | 3 | 2.376 | 12102.7 |
| 1070 | 2025-07-07 19:33:33 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1069 | 2025-07-03 22:53:14 | aggie | 1 | 28756 | 3 | 3.530 | 8146.2 |
| 1068 | 2025-06-30 22:56:04 | aggie | 2 | 53800 | 66 | 1.813 | 29674.6 |
| 1067 | 2025-06-30 14:35:25 | aggie | 2 | 53800 | 66 | 7.800 | 6897.4 |
| 1066 | 2025-06-29 18:33:26 | aggie | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1065 | 2025-06-29 06:49:27 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1064 | 2025-06-25 22:51:59 | aggie | 1 | 28756 | 3 | 1.376 | 20898.3 |
| 1063 | 2025-06-23 12:18:55 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1062 | 2025-06-20 03:14:08 | aggie | 3 | 83667 | 833 | 19.533 | 4283.4 |
| 1061 | 2025-06-18 13:01:42 | aggie | 1 | 28756 | 3 | 2.546 | 11294.6 |
| 1060 | 2025-06-16 08:19:48 | aggie | 3 | 83667 | 833 | 16.343 | 5119.4 |
| 1059 | 2025-06-16 05:34:32 | aggie | 3 | 83667 | 833 | 15.470 | 5408.3 |
| 1058 | 2025-06-15 20:49:02 | aggie | 3 | 83667 | 833 | 16.500 | 5070.7 |
| 1057 | 2025-06-14 12:04:28 | aggie | 3 | 83667 | 833 | 11.406 | 7335.3 |
| 1056 | 2025-06-10 06:25:07 | aggie | 1 | 28756 | 3 | 1.793 | 16037.9 |
| 1055 | 2025-06-10 04:12:49 | aggie | 1 | 28756 | 3 | 1.640 | 17534.1 |
| 1054 | 2025-06-04 05:33:28 | aggie | 3 | 83667 | 833 | 28.173 | 2969.8 |
| 1053 | 2025-06-02 23:16:34 | aggie | 1 | 28756 | 3 | 2.186 | 13154.6 |
| 1052 | 2025-05-30 08:27:33 | aggie | 1 | 28756 | 3 | 1.000 | 28756.0 |
| 1051 | 2025-05-25 22:52:14 | aggie | 1 | 28756 | 3 | 1.186 | 24246.2 |
| 1050 | 2025-05-23 18:08:52 | aggie | 1 | 28756 | 3 | 0.543 | 52957.6 |
| 1049 | 2025-05-23 03:18:11 | aggie | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1048 | 2025-05-19 22:58:01 | aggie | 2 | 53800 | 66 | 5.873 | 9160.6 |
| 1047 | 2025-05-19 03:09:21 | aggie | 2 | 53800 | 66 | 1.673 | 32157.8 |
| 1046 | 2025-05-17 05:51:55 | aggie | 1 | 28756 | 3 | 1.406 | 20452.3 |
| 1045 | 2025-05-16 12:24:56 | aggie | 2 | 53800 | 66 | 7.970 | 6750.3 |
| 1044 | 2025-05-16 03:54:19 | aggie | 2 | 53800 | 66 | 4.623 | 11637.5 |
| 1043 | 2025-05-14 20:36:03 | aggie | 2 | 53800 | 66 | 1.686 | 31909.8 |
| 1042 | 2025-05-14 03:30:26 | aggie | 2 | 53800 | 66 | 8.016 | 6711.6 |
| 1041 | 2025-05-11 18:04:50 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1040 | 2025-05-10 05:54:30 | aggie | 1 | 28756 | 3 | 2.656 | 10826.8 |
| 1039 | 2025-05-10 04:41:56 | aggie | 1 | 28756 | 3 | 1.046 | 27491.4 |
| 1038 | 2025-05-01 23:27:51 | aggie | 1 | 28756 | 3 | 1.173 | 24514.9 |
| 1037 | 2025-04-28 14:01:09 | aggie | 2 | 53800 | 66 | 8.343 | 6448.5 |
| 1036 | 2025-04-27 06:49:06 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1035 | 2025-04-25 20:21:59 | aggie | 3 | 83667 | 833 | 18.783 | 4454.4 |
| 1034 | 2025-04-24 05:14:45 | aggie | 3 | 83667 | 833 | 13.833 | 6048.4 |
| 1033 | 2025-04-22 21:49:50 | aggie | 1 | 28756 | 3 | 2.640 | 10892.4 |
| 1032 | 2025-04-21 07:45:16 | aggie | 3 | 83667 | 833 | 28.030 | 2984.9 |
| 1031 | 2025-04-20 20:45:04 | aggie | 3 | 83667 | 833 | 18.533 | 4514.5 |
| 1030 | 2025-04-18 12:18:07 | aggie | 1 | 28756 | 3 | 1.000 | 28756.0 |
| 1029 | 2025-04-18 02:16:31 | aggie | 3 | 83667 | 833 | 20.216 | 4138.7 |
| 1028 | 2025-04-17 22:37:38 | aggie | 2 | 53800 | 66 | 8.016 | 6711.6 |
| 1027 | 2025-04-08 05:35:09 | aggie | 1 | 28756 | 3 | 3.953 | 7274.5 |
| 1026 | 2025-04-08 04:27:47 | aggie | 1 | 28756 | 3 | 2.380 | 12082.4 |
| 1025 | 2025-03-31 00:43:27 | aggie | 1 | 28756 | 3 | 1.890 | 15214.8 |
| 1024 | 2025-03-27 09:17:35 | aggie | 1 | 28756 | 3 | 3.873 | 7424.7 |
| 1023 | 2025-03-23 14:24:49 | aggie | 2 | 53800 | 66 | 6.533 | 8235.1 |
| 1022 | 2025-03-21 22:32:20 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1021 | 2025-03-17 16:11:00 | aggie | 1 | 28756 | 3 | 3.640 | 7900.0 |
| 1020 | 2025-03-11 14:28:01 | aggie | 3 | 83667 | 833 | 20.093 | 4164.0 |
| 1019 | 2025-03-11 14:04:00 | aggie | 3 | 83667 | 833 | 16.360 | 5114.1 |
| 1018 | 2025-03-08 17:23:46 | aggie | 1 | 28756 | 3 | 2.300 | 12502.6 |
| 1017 | 2025-03-07 22:34:01 | aggie | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1016 | 2025-03-06 17:55:40 | aggie | 2 | 53800 | 66 | 5.593 | 9619.2 |
| 1015 | 2025-03-05 17:01:16 | aggie | 2 | 53800 | 66 | 8.606 | 6251.5 |