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

252 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
montane9131362(None) 
montage101211711montage
montanes101114521montanes
fontanel1145552fontanel
mintage101110122mintage
monotone10310152monotone
montaged12107762montaged
montages111412182montages
monte75829772mont__e
mundane1038072mundane
octane81411632_octane
pentane9415742pentane
pontine92419052pontine
soutane7312062soutane
tontine72316142tontine
antae56828293_anta_e
aortae65115473aorta_e
bondage1138253bondage
bonne75124713bon__ne
borane84620213bo_rane
botany1139263bo_tany
butane8313653_butane
centare93113703centare
cetane8315283_cetane
concave1439373concave
condone102616293condone
confine12315583confine
coniine9316803coniine
conine84528553con_ine
connate9315753connate
constant10515593constant
contact1144020683contact
contain9315833contain
contained12310893contained
container11311073container
contains10316533contains
conte76633203cont__e
contend103511893contend
content94326153content
continue10311123continue
contuse9311413contuse
convene123314323convene
costae85319683costa_e
costate94019273costate
cotan71521783co_tan_
cotans81317923co_tans
cottae84615703cotta_e
cottage104210573cottage
cowbane1437673cowbane
dentate8315153dentate
dentine83320243dentine
dogbane1135653dogbane
dogvane1243853dogvane
donate73619503don_ate
donne65520463don__ne
dotage82711613do_tage
eonian6311833eonian_
fondant11311143fondant
fontal9313143fonta_l
fontanels1244063fontanels
fontina1038633fontina
footage1148843footage
fortune1068303fortune
frontage1296243frontage
henbane1237353henbane
heptane1238363heptane
hogmane1336343hogmane
honan85319773hon_an_
honans94814503hon_ans
hostage113111233hostage
inane52820343_in_ane
insane6314893_insane
intake10510863_intake
intine61021983_intine
intone61115433_intone
ionone6313443ion_one
lantana739603lantana
lindane839033lindane
longan75612363longan_
longans84510813longans
maltase938903maltase
manage93818903man_age
manana84816073man_ana
manatee9317663manatee
mandate10315573mandate
mane65052033m___ane
manmade1237963manmade
mannan85413623mannan_
mannans93611523mannans
manta75629913manta__
mantas85725363manta_s
mantle84420923mant_le
meltage1037953meltage
menace103216943men_ace
menage93216543men_age
mensae84114053mensa_e
menta74424423menta__
mental84521603menta_l
mentee84121293ment_ee
menthene1347033menthene
metage93114453m_etage
metate82720533m_etate
methane123211793methane
minae75627723min_a_e
mintages111110513mintages
minting103020813minting
minyan1138173minyan_
minyans1237263minyans
mistake131312623mistake
mistune9310653mistune
moan65832023mo__an_
moaned94514173mo__aned
moaner84415113mo__aner
moans74624373mo__ans
moating104218153moating
moderne1037123moderne
moline84422033mo_line
molten83311813molten_
molting103517173molting
monad85519473mon_a_d
monades103713823mon_ades
monads94515303mon_ads
monas74732153mon_a_s
monde85723143mon__de
moneran9311113moneran_
monerans10310353monerans
monetary1346523monetary
monetise10311473monetise
monetize1949983monetize
mongoe94214983mon_goe
monie75631653mon__ie
monitive1349993monitive
monoamine1347203monoamine
monocle1139663monocle
monokine1448483monokine
monoplane1347483monoplane
monotint10413713monotint
monotones11410553monotones
monotony1347073monotony
monotype1545783monotype
monstrance1445233monstrance
montadale1242853montadale
montaging1346543montaging
montero9310133montero
montes84226933mont_es
month104818423mont__h
monthly1535673monthly
months113812933mont_hs
moonstone1146143moonstone
moorage1038743moorage
mooting103019363mooting
morae75831193mo_ra_e
moraine9314573moraine
morale85220553mo_rale
mordant10312403mordant
morgan9311373morgan_
morgans10310123morgans
mortal84616853morta_l
mortals93914013mortals
mortar83812043morta_r
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
mortgage1244213mortgage
mortice11711493mortice
mortise9713533mortise
moste75925083most__e
mote67048083mo_t__e
motile83818343mo_tile
motive113112143mo_tive
motte75526973mo_t_te
mottle84116053mo_ttle
moulage1037903moulage
mountable1346303mountable
mountain1046113mountain
mountains1146363mountains
mountainy1444013mountainy
mounting112711813mounting
mouton8410853mouton_
moutons9410313moutons
muntin82915183muntin_
munting103718773munting
muntins92715133muntins
mustang10267933mustang
mutant8317693m_utant
mutase82811993m_utase
mutate83017483m_utate
mutine84420373m_utine
nonage7313683non_age
nonbank1345903nonbank
nondance1148243nondance
nonfan948293nonfan_
nonfans1037533nonfans
nongame1038183nongame
nonman8412363nonman_
nontax1348413nonta_x
nontaxes1537853nontaxes
nonwage1137163nonwage
notate63217863no_tate
octan71313483_octan_
octanes91111393_octanes
octans81411143_octans
octant81216553_octant
octave11157343_octave
online6315843_online
onstage838363_onstage
outage72017533_outage
outate62923403_outate
pentanes10316083pentanes
pentene9313793pentene
phytane1545443phytane
pintano998993pintano
platane93112303platane
ponton83217643ponton_
pontons93315553pontons
poontang1143813poontang
portage103013643portage
portance12310123portance
postage103214853postage
potage92715903po_tage
pottage103310603pottage
poutine93316823poutine
remontant1148103remontant
rontgen835173rontgen
rootage839053rootage
rotate63320343ro_tate
routine72615903routine
sonance9310313son_ance
sonant6621953son_ant
sonatine8313323sonatine
soutanes8312933soutanes
stane55933003__stane
suntan62613003suntan_
suntans72111733suntans
tentage81010643tentage
tolane64316583to_lane
tonnage8168053tonnage
tonne54921433ton__ne
tontines82114733tontines
tramontane1253693tramontane
untame82513603_untame
untune62511603_untune
vantage11109893vantage
ventage11109623ventage
vintage11128143vintage
voltage1136863voltage
wantage11119623wantage
wonting113214103wonting
wonton93410963wonton_
wontons103310533wontons
zonae145116443zon_a_e
zonate154114923zon_ate

Search took 8 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 Limit1340272527.25318478.8
3Display Results2522520.0932709.7
 (SQL Overall)1786912527.75223051.0
 
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.