History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nannie"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1125 | 2024-05-01 06:06:34 | nannie | 3 | 112716 | 482 | 11.893 | 9477.5 |
| 1124 | 2024-04-30 18:35:24 | nannie | 3 | 112716 | 482 | 11.530 | 9775.9 |
| 1123 | 2024-04-30 08:06:09 | nannie | 2 | 82551 | 24 | 5.453 | 15138.6 |
| 1122 | 2024-04-30 08:06:02 | nannie | 3 | 112716 | 482 | 6.343 | 17770.1 |
| 1121 | 2024-04-30 08:06:05 | nannie | 2 | 82551 | 24 | 2.860 | 28864.0 |
| 1120 | 2024-04-30 08:05:55 | nannie | 1 | 48755 | 3 | 1.640 | 29728.7 |
| 1119 | 2024-04-30 08:05:37 | nannie | 3 | 112716 | 482 | 5.906 | 19085.0 |
| 1118 | 2024-04-30 06:05:54 | nannie | 3 | 112716 | 482 | 6.173 | 18259.5 |
| 1117 | 2024-04-29 19:13:57 | nannie | 3 | 112716 | 482 | 5.233 | 21539.5 |
| 1116 | 2024-04-29 06:11:27 | nannie | 3 | 112716 | 482 | 6.420 | 17557.0 |
| 1115 | 2024-04-28 18:57:24 | nannie | 3 | 112716 | 482 | 9.000 | 12524.0 |
| 1114 | 2024-04-28 06:23:13 | nannie | 3 | 112716 | 482 | 6.190 | 18209.4 |
| 1113 | 2024-04-27 19:15:26 | nannie | 3 | 112716 | 482 | 6.673 | 16891.4 |
| 1112 | 2024-04-27 12:20:46 | nannie | 3 | 112716 | 482 | 16.563 | 6805.3 |
| 1111 | 2024-04-26 12:02:35 | nannie | 3 | 112716 | 482 | 5.906 | 19085.0 |
| 1110 | 2024-04-25 18:04:24 | nannie | 3 | 112716 | 482 | 6.796 | 16585.6 |
| 1109 | 2024-04-25 06:12:37 | nannie | 3 | 112716 | 482 | 5.716 | 19719.4 |
| 1108 | 2024-04-24 18:38:54 | nannie | 3 | 112716 | 482 | 6.283 | 17939.8 |
| 1107 | 2024-04-24 03:21:22 | nannie | 3 | 112716 | 482 | 17.813 | 6327.7 |
| 1106 | 2024-04-23 18:28:56 | nannie | 3 | 112716 | 482 | 14.390 | 7832.9 |
| 1105 | 2024-04-23 00:32:26 | nannie | 3 | 112716 | 482 | 5.126 | 21989.1 |
| 1104 | 2024-04-22 20:19:01 | nannie | 3 | 112716 | 482 | 5.360 | 21029.1 |
| 1103 | 2024-04-21 20:36:38 | nannie | 3 | 112716 | 482 | 27.703 | 4068.7 |
| 1102 | 2024-04-21 08:21:32 | nannie | 3 | 112716 | 482 | 8.906 | 12656.2 |
| 1101 | 2024-04-20 20:21:34 | nannie | 3 | 112716 | 482 | 4.796 | 23502.1 |
| 1100 | 2024-04-20 11:15:03 | nannie | 3 | 112716 | 482 | 9.673 | 11652.6 |
| 1099 | 2024-04-20 00:59:13 | nannie | 3 | 112716 | 482 | 7.956 | 14167.4 |
| 1098 | 2024-04-19 00:54:19 | nannie | 3 | 112716 | 482 | 14.093 | 7998.0 |
| 1097 | 2024-04-18 09:31:08 | nannie | 3 | 112716 | 482 | 20.750 | 5432.1 |
| 1096 | 2024-04-17 21:12:12 | nannie | 3 | 112716 | 482 | 17.283 | 6521.8 |
| 1095 | 2024-04-17 10:36:45 | nannie | 3 | 112716 | 482 | 6.000 | 18786.0 |
| 1094 | 2024-04-16 21:01:35 | nannie | 3 | 112716 | 482 | 11.220 | 10046.0 |
| 1093 | 2024-04-15 21:11:17 | nannie | 3 | 112716 | 482 | 15.343 | 7346.4 |
| 1092 | 2024-04-14 20:41:41 | nannie | 3 | 112716 | 482 | 9.033 | 12478.2 |
| 1091 | 2024-04-13 21:07:22 | nannie | 3 | 112716 | 482 | 8.970 | 12565.9 |
| 1090 | 2024-04-12 18:40:26 | nannie | 3 | 112716 | 482 | 5.813 | 19390.3 |
| 1089 | 2024-04-11 14:48:41 | nannie | 3 | 112716 | 482 | 10.533 | 10701.2 |
| 1088 | 2024-04-10 20:30:38 | nannie | 3 | 112716 | 482 | 8.563 | 13163.1 |
| 1087 | 2024-04-10 13:37:09 | nannie | 3 | 112716 | 482 | 14.750 | 7641.8 |
| 1086 | 2024-04-09 13:18:20 | nannie | 3 | 112716 | 482 | 5.406 | 20850.2 |
| 1085 | 2024-04-08 13:31:17 | nannie | 3 | 112716 | 482 | 6.656 | 16934.5 |
| 1084 | 2024-04-08 00:43:57 | nannie | 3 | 112716 | 482 | 17.670 | 6378.9 |
| 1083 | 2024-04-07 11:33:13 | nannie | 3 | 112716 | 482 | 11.626 | 9695.2 |
| 1082 | 2024-04-07 00:43:02 | nannie | 3 | 112716 | 482 | 13.390 | 8417.9 |
| 1081 | 2024-04-06 11:02:29 | nannie | 3 | 112716 | 482 | 12.093 | 9320.8 |
| 1080 | 2024-04-06 01:49:33 | nannie | 1 | 48755 | 3 | 2.983 | 16344.3 |
| 1079 | 2024-04-05 23:01:31 | nannie | 3 | 112716 | 482 | 7.563 | 14903.6 |
| 1078 | 2024-04-03 05:42:32 | nannie | 3 | 112716 | 482 | 18.406 | 6123.9 |
| 1077 | 2024-04-03 05:03:02 | nannie | 3 | 112716 | 482 | 13.753 | 8195.7 |
| 1076 | 2024-03-31 10:19:36 | nannie | 2 | 82551 | 24 | 5.923 | 13937.4 |
| 1075 | 2024-03-31 06:09:42 | nannie | 3 | 112716 | 482 | 13.220 | 8526.2 |
| 1074 | 2024-03-31 06:09:43 | nannie | 2 | 82551 | 24 | 8.716 | 9471.2 |
| 1073 | 2024-03-31 06:09:36 | nannie | 2 | 82551 | 24 | 6.670 | 12376.5 |
| 1072 | 2024-03-31 06:09:35 | nannie | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1071 | 2024-03-31 06:09:09 | nannie | 3 | 112716 | 482 | 8.330 | 13531.3 |
| 1070 | 2024-03-30 19:49:28 | nannie | 3 | 112716 | 482 | 15.706 | 7176.6 |
| 1069 | 2024-03-30 18:18:53 | nannie | 3 | 112716 | 482 | 11.330 | 9948.5 |
| 1068 | 2024-03-30 12:31:31 | nannie | 3 | 112716 | 482 | 10.403 | 10835.0 |
| 1067 | 2024-03-29 19:58:06 | nannie | 3 | 112716 | 482 | 10.686 | 10548.0 |
| 1066 | 2024-03-29 12:32:50 | nannie | 3 | 112716 | 482 | 8.546 | 13189.3 |
| 1065 | 2024-03-28 07:43:10 | nannie | 3 | 112716 | 482 | 6.546 | 17219.1 |
| 1064 | 2024-03-27 16:55:36 | nannie | 3 | 112716 | 482 | 6.050 | 18630.7 |
| 1063 | 2024-03-27 08:03:02 | nannie | 3 | 112716 | 482 | 6.500 | 17340.9 |
| 1062 | 2024-03-26 02:44:03 | nannie | 3 | 112716 | 482 | 5.953 | 18934.3 |
| 1061 | 2024-03-25 16:04:26 | nannie | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 1060 | 2024-03-25 16:04:07 | nannie | 3 | 112716 | 482 | 5.736 | 19650.6 |
| 1059 | 2024-03-25 02:10:23 | nannie | 3 | 112716 | 482 | 5.860 | 19234.8 |
| 1058 | 2024-03-24 05:02:53 | nannie | 3 | 112716 | 482 | 5.390 | 20912.1 |
| 1057 | 2024-03-23 13:57:16 | nannie | 3 | 112716 | 482 | 5.330 | 21147.5 |
| 1056 | 2024-03-23 04:56:11 | nannie | 3 | 112716 | 482 | 5.063 | 22262.7 |
| 1055 | 2024-03-22 09:54:13 | nannie | 3 | 112716 | 482 | 7.780 | 14487.9 |
| 1054 | 2024-03-21 09:51:31 | nannie | 3 | 112716 | 482 | 13.063 | 8628.6 |
| 1053 | 2024-03-20 08:14:07 | nannie | 3 | 112716 | 482 | 9.923 | 11359.1 |
| 1052 | 2024-03-18 20:53:34 | nannie | 3 | 112716 | 482 | 12.563 | 8972.1 |
| 1051 | 2024-03-17 20:47:27 | nannie | 3 | 112716 | 482 | 19.253 | 5854.5 |
| 1050 | 2024-03-17 03:01:25 | nannie | 3 | 112716 | 482 | 9.360 | 12042.3 |
| 1049 | 2024-03-16 03:04:28 | nannie | 3 | 112716 | 482 | 14.910 | 7559.8 |
| 1048 | 2024-03-14 21:39:05 | nannie | 3 | 112716 | 482 | 7.580 | 14870.2 |
| 1047 | 2024-03-13 20:14:52 | nannie | 3 | 112716 | 482 | 5.406 | 20850.2 |
| 1046 | 2024-03-12 21:19:50 | nannie | 3 | 112716 | 482 | 19.440 | 5798.1 |
| 1045 | 2024-03-12 12:29:54 | nannie | 3 | 112716 | 482 | 18.690 | 6030.8 |
| 1044 | 2024-03-12 12:01:02 | nannie | 3 | 112716 | 482 | 5.220 | 21593.1 |
| 1043 | 2024-03-11 13:06:01 | nannie | 3 | 112716 | 482 | 20.093 | 5609.7 |
| 1042 | 2024-03-10 22:54:01 | nannie | 3 | 112716 | 482 | 10.830 | 10407.8 |
| 1041 | 2024-03-10 14:02:10 | nannie | 3 | 112716 | 482 | 20.453 | 5511.0 |
| 1040 | 2024-03-07 01:29:58 | nannie | 3 | 112716 | 482 | 5.126 | 21989.1 |
| 1039 | 2024-03-06 23:51:34 | nannie | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 1038 | 2024-03-06 00:32:35 | nannie | 3 | 112716 | 482 | 12.876 | 8754.0 |
| 1037 | 2024-03-05 14:57:35 | nannie | 3 | 112716 | 482 | 5.923 | 19030.2 |
| 1036 | 2024-03-05 05:21:25 | nannie | 3 | 112716 | 482 | 7.253 | 15540.6 |
| 1035 | 2024-03-04 11:41:22 | nannie | 3 | 112716 | 482 | 7.296 | 15449.0 |
| 1034 | 2024-03-04 05:05:05 | nannie | 3 | 112716 | 482 | 7.610 | 14811.6 |
| 1033 | 2024-03-02 23:57:00 | nannie | 3 | 112716 | 482 | 5.313 | 21215.1 |
| 1032 | 2024-03-02 14:29:31 | nannie | 3 | 112716 | 482 | 6.953 | 16211.1 |
| 1031 | 2024-03-02 11:20:42 | nannie | 3 | 112716 | 482 | 11.080 | 10172.9 |
| 1030 | 2024-03-02 00:10:26 | nannie | 3 | 112716 | 482 | 6.766 | 16659.2 |
| 1029 | 2024-03-01 12:55:54 | nannie | 3 | 112716 | 482 | 5.376 | 20966.5 |
| 1028 | 2024-03-01 03:08:52 | nannie | 2 | 82551 | 24 | 2.796 | 29524.7 |
| 1027 | 2024-03-01 03:08:33 | nannie | 3 | 112716 | 482 | 6.486 | 17378.4 |
| 1026 | 2024-03-01 03:08:36 | nannie | 2 | 82551 | 24 | 2.873 | 28733.4 |