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 “kinsmen” 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.

140 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
kinsmen133565(None) 
kinsman1335961kinsman
kinswomen1852752kinswomen
kirkmen1232922kirkmen
kismet123414622ki_smet
lensmen937882lensmen
linemen938632linemen
linesmen1046562linesmen
linkmen1335362linkmen
linksmen1443522linksmen
reinsmen1047072reinsmen
tinmen82310402tin_men
wingmen1336112wingmen
agnomen1036763agnomen
aidmen92610373ai_dmen
airmen82612353ai_rmen
almsmen1144583almsmen
bailsmen1244623bailsmen
bandsmen1356453bandsmen
batsmen1146883batsmen
birdmen1235833birdmen
bitumen1134503bitumen
bondmen1237893bondmen
bondsmen1345473bondsmen
busmen1039893_busmen
clansmen1245723clansmen
daysmen1335083daysmen
disme85716243di_sme_
dismes95617673di_smes
einstein844183einstein
firemen1238773firemen
foilsmen1354103foilsmen
gasmen93111563_gasmen
ginseng933433gins_eng
gownsmen1443373gownsmen
gunmen9348723gun_men
hangmen1337383hangmen
hitmen11239193hi_tmen
huntsmen1343273huntsmen
icemen1037893_icemen
insane6314893_insane
inset54430863_ins_et
inspan837513_inspan
instep838193_instep
junkmen2033633junkmen
kamseen1344013kamseen
kidskin1143833kidskin
kiester11329973kiester
kinase104210653kinase_
kinases113511123kinases
kinder113716843kin_der
kindle114414233kindle_
kindled133410543kindled
kindler12309983kindler
kindles123614843kindles
kindred13316953kindred
kine85643433kin__e_
kinema1236023kinem_a
kinemas1336893kinemas
kines95039133kin__es
kineses113111253kineses
kinetin11248263kinetin
kinged124215293kin_ged
kinglet123114043kinglet
kingpin1445003kingpin
kinin94917323kin__in
kinked104014753kin_ked
kinkier10319433kinkier
kins85747913kins___
kinship1645833kinship
kinswoman1852403kinswoman
kippen14299013ki_ppen
kipskin1243473kipskin
kirkman1243773kirkman
kismat123011673ki_smat
kismets13306883ki_smets
kissed114412853ki_ssed
kisser104212453ki_sser
kisses104217333ki_sses
kitchen16287683kitchen
kitten104611483ki_tten
knishes1438263knishes
landmen1038553landmen
landsmen1156603landsmen
lensman937563lensman
liftmen1234233liftmen
limen75426033li__men
linden7411453lin_den
lineman939123lineman
linen55728723lin__en
linesman1046253linesman
liniment1049533liniment
linkman1335393linkman
linksman1444153linksman
linseed838203linseed
linsey938993lins_ey
listen64816813li_sten
menshen1236813menshen
messmen1137393messmen
milkmen1565213milkmen
minster93914323minster
mismet103722373mi_smet
mispen10312173mi_spen
newsmen1235893newsmen
nomen75621623__nomen
nonmen8412833non_men
numen74216793__numen
oarsmen938093oarsmen
oilmen848313oi_lmen
oinomel946353oinomel
ointment1069233ointment
penmen10311493pen_men
pikemen1535333pikemen
pinken124513283pin_ken
pitmen102510793pi_tmen
plainsmen1343463plainsmen
pointmen1245423pointmen
reinsman1045833reinsman
rinse54820973rins_e_
rinsed75016353rins_ed
rinser64317213rins_er
rinses64720383rins_es
risen54621883ri_s_en
rodsmen1035833rodsmen
sandmen1039413sandmen
sidemen1037943sidemen
sinsyne1043303sinsyne
swingmen1443493swingmen
tinman82411143tin_man
tinsel639443tins_el
titmen8239883ti_tmen
tongmen1037123tongmen
townsmen1344073townsmen
unseen62012623_unseen
vanmen1138403van_men
vimen104114753vi__men
wingman1336383wingman
winsome1237463winsome_
winsomer1345773winsomer
wiremen1236903wiremen

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271405.86022871.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.31228309.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.