Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “handinesses” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

186 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
handinesses15141027(None) 
bandinesses14109731bandinesses
hardinesses151110211hardinesses
randinesses121311201randinesses
sandinesses12911391sandinesses
bawdinesses17126322bawdinesses
candidnesses1685392candidnesses
canninesses1368852canninesses
chancinesses1945032chancinesses
fancinesses1638142fancinesses
gaudinesses1337852gaudinesses
hairinesses14198942hairinesses
hamminesses1835772hamminesses
handednesses1765642handednesses
handiness132110932handine_s_s
handpresses1753652handpresses
happinesses1876162happinesses
hardnesses141810542hard_nesses
hastinesses141210692hastinesses
hazinesses2239222ha_zinesses
headinesses1539842headinesses
lankinesses1539012lankinesses
manginesses1499592manginesses
manlinesses13910192manlinesses
ranginesses121210112ranginesses
shadinesses1538642sha_dinesses
tanginesses1278882tanginesses
tardinesses121110242tardinesses
unhandinesses1753712unhandinesses
windinesses1557812windinesses
zaninesses19310382zan_inesses
achinesses1539303_achinesses
acidnesses1337253_acidnesses
airinesses102613613_airinesses
angrinesses1247283_angrinesses
antsinesses1148753_antsinesses
aridnesses1139933_aridnesses
artinesses10815203_artinesses
ashinesses1339163_ashinesses
avidnesses1436463_avidnesses
badnesses1239253ba_d_nesses
bagginesses1545953bagginesses
baldnesses1337653bald_nesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandiness122310243bandine_s_s
battinesses13169453battinesses
beadinesses1449563beadinesses
blandnesses1446623bland_nesses
boninesses121111453bon_inesses
bonninesses1337353bonninesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
campinesses1737113campinesses
canonesses1238413can_onesses
cattinesses13129703cattinesses
charinesses1639563cha_rinesses
chattinesses1755153chattinesses
crankinesses1846143crankinesses
daffinesses1834843daffinesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
danknesses1536253dan_knesses
dinginesses1337473dinginesses
dowdinesses1635723dowdinesses
earlinesses11311033earlinesses
easinesses10314433ea_sinesses
fattinesses14118973fattinesses
fondnesses1437703fond_nesses
funkinesses18137003funkinesses
funninesses14106873funninesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
giddinesses1435303giddinesses
grandnesses1348113grand_nesses
halenesses13312033ha_lenesses
halfnesses1636263ha_lfnesses
hardiness132310353hardine_s_s
harnesses121812073ha__rnesses
harshnesses1745853harshnesses
heartinesses1547993heartinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hoarinesses14310213hoarinesses
hokinesses1758943h_okinesses
holinesses13511493h_olinesses
hominesses15510853h_ominesses
horninesses1458993horninesses
horsinesses1439543horsinesses
huffinesses2034123huffinesses
humidnesses1744583humidnesses
humpinesses18106243humpinesses
hungrinesses1643853hungrinesses
huskinesses18136533huskinesses
inkinesses1439423_inkinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
kindlinesses1744243kindlinesses
kindnesses1537213kind_nesses
kinkinesses1435873kinkinesses
lacinesses12312113la_cinesses
lanknesses1437503lan_knesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
madnesses1239833ma_d_nesses
maltinesses13310223maltinesses
massinesses12128693massinesses
matinesses12314533ma_tinesses
mazinesses2139913ma_zinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
muddinesses1535273muddinesses
nappinesses1555923nappinesses
nastinesses111110733nastinesses
nattinesses11119313nattinesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
pastinesses13911713pastinesses
pawkinesses2036153pawkinesses
phoninesses1636453phon_inesses
puninesses121110753pun_inesses
punkinesses17127223punkinesses
rabidnesses1476123rabidnesses
racinesses12313503ra_cinesses
raininesses11310473raininesses
rancidnesses1544883rancidnesses
randiness102511443randine_s_s
randomnesses1553533randomnesses
ranknesses1438093ran_knesses
rapidnesses1476463rapidnesses
raspinesses1338013raspinesses
readinesses12611263readinesses
reedinesses1259553reedinesses
rowdinesses1536963rowdinesses
ruddinesses1336033ruddinesses
runninesses11137693runninesses
runtinesses111210953runtinesses
sadnesses10310303sa_d_nesses
saltinesses11311443saltinesses
sandiness102111713sandine_s_s
sanenesses10412693san_enesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338963saucinesses
savvinesses1735663savvinesses
scantinesses1437313scantinesses
seedinesses1259203seedinesses
shabbinesses1953433shabbinesses
shagginesses1743963shagginesses
shakinesses1837613sha_kinesses
shininesses1448293shin_inesses
shoddinesses1743783shoddinesses
slanginesses1346963slanginesses
snakinesses1538553snakinesses
sunninesses11148383sunninesses
swankinesses1944783swankinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tarrinesses11129083tarrinesses
tartinesses111011493tartinesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawdrinesses1643433tawdrinesses
tawninesses1436153tawninesses
tidinesses1139223_tidinesses
tininesses10311163tin_inesses
tinninesses1136863tinninesses
trendinesses1346323trendinesses
validnesses1576023validnesses
vapidnesses1774893vapidnesses
wackinesses2036653wackinesses
wannesses1239233wan__nesses
warinesses131514523wa_rinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
weedinesses1557073weedinesses
whininesses1746183whin_inesses
woodinesses15127463woodinesses
wordinesses15138873wordinesses

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911216330.1431249587.4
2DLD Change Limit1216331865.34322764.9
3Display Results1861860.0932000.0
 (SQL Overall)1786911865.57932029.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.