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

260 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
mintage10111012(None) 
mintages111110511mintages
montage101211711montage
vintage11128141vintage
incage93513622_incage
innage73011572_innage
intake10510862_intake
linage7713402lin_age
lineage878982lineage
linkage1295962linkage
manage93818902man_age
meltage1037952meltage
menage93216542men_age
metage93114452m_etage
milage93414122mi_lage
mileage10299312mileage
millage103112742millage
minae75627722min_a_e
mirage92313652mi_rage
mispage12310522mispage
mistake131312612mistake
montaged12107762montaged
montages111412182montages
montane91313622montane
sinkage1287262sinkage
tentage81010642tentage
unitage838992unitage
vantage11109892vantage
ventage11109622ventage
vintager12104822vintager
vintages12118272vintages
wantage11119622wantage
windage1237932windage
agiotage1043563agiotage
anlage72514223_anlage
antae56828293_anta_e
bandage11311023bandage
binate8419773bin_ate
binge85125513bin__ge
bistate9313813bistate
blindage1243683blindage
bondage1138253bondage
cartage10312593cartage
centare93113703centare
chantage1446633chantage
clientage1242713clientage
coinage10310553coin_age
cottage104210573cottage
cuttage10318343cuttage
dentate8315153dentate
dictate10311663dictate
dinge75627303din__ge
dotage82711613_dotage
driftage1342933driftage
dunnage9175213dunnage
ecotage1036883ecotage
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
finagle11238313fin_agle
finale94116763fin_ale
flotage1136673flotage
footage1148833footage
frontage1296243frontage
hinge95323443hin__ge
hostage113111233hostage
image81411283_i_mage
imitate9310873imitate
inane52820343_in_ane
incaged114010443_incaged
incages103013883_incages
incase83615283_incase
infare9313083_infare
ingate73018233_ingate
inhale9411513_inhale
inlace82513043_inlace
inmate82917353_inmate
innages82911303_innages
innate63917313_innate
insane6314883_insane
instate71616473_instate
intact8314663_intact
intagli845013_intagli
intakes11310943_intakes
integer837993_integer
interage9314483_interage
intime81014263_intime
intine61021973_intine
intone61115423_intone
invade10157853_invade
kinase104210653kin_ase
linages8813173lin_ages
lindane839023lindane
lineages979183lineages
lineate7815153lineate
linkages1385953linkages
mage75739123m___age
maintain1077713maintain
maltase938903maltase
managed113212603man_aged
manager103413583man_ager
manages103418963man_ages
manatee9317663manatee
mandate10315573mandate
manege94113203man_ege
mange84930183man__ge
manmade1237963manmade
manta75629903manta__
mantas85725363manta_s
mantle84420923mant_le
massage1039893massage
meltages1148243meltages
menace103216943men_ace
menages103615393men_ages
mensae84114043mensa_e
menta74424423menta__
mental84521603menta_l
mentee84121293ment_ee
message1037833message
metages102714973m_etages
metate82720533m_etate
midge95016543mi__dge
midrange1244433midrange
migrate101314163migrate
milages103114403mi_lages
mileages11249693mileages
militate10311673militate
millages113212893millages
mina65136903min_a__
minable112315073minable
minaret9520683min_aret
minas75434113min_a_s
mince95325233min__ce
mine67256153min___e
mineable121611053mineable
mingle93518783min_gle
mingy115520183min__gy
mining94225443mining_
minings103912073minings
ministate1147263ministate
minke115421763min__ke
mint66758043mint___
minted94220583mint_ed
minter84425103mint_er
minters93822463minters
mintier93615993mintier
minting103020813minting
mints76834043mint__s
minty106323903mint__y
minute83414293min_ute
minutiae1045583minutiae
minyan1138173minya_n
minyans1237263minyans
mirages102213533mi_rages
misate81222693mi_sate
misdate101413963misdate
misease92713043misease
misgauge1244253misgauge
misgave13298283misgave
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
misname11119483misname
mispaged1438243mispaged
mispages13311183mispages
misrate91319143misrate
misstate10711333misstate
mistaken14147823mistaken
mistaker14109323mistaker
mistakes141213403mistakes
mistime11312613mistime
mistrace12312633mistrace
mistune9310653mistune
mistype14126523mistype
misusage1145173misusage
mite66249403mi_t__e
mitogen1036963mi_togen
mitre75522423mi_t_re
mixture1635413mixture
montanes101114523montanes
monte75829773mont__e
moorage1038733moorage
mortgage1244213mortgage
moulage1037903moulage
multiage1147983multiage
mundane1038073mundane
mutagen1056603m_utagen
mutase82811983m_utase
mutate83017483m_utate
nictate9310223nictate
nonage7313683non_age
nonwage1137163nonwage
onstage838363onstage
outage72017533_outage
pentane9415743pentane
pillage103412593pillage
pilotage1145373pilotage
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinta75727053pinta__
pintada1096073pintada
pintado1096573pintado
pintail9311173pintail
pintano998993pintano
pintas85021393pinta_s
pintle83818263pint_le
pinwale1257843pinwale
pipage1199143pi_page
pipeage1236203pipeage
portage103013643portage
postage103214853postage
potage92715903_potage
pottage103310603pottage
qintar15359143qinta_r
qintars16268573qintars
restage83316183restage
rivage1038843ri_vage
rootage839043rootage
scutage1036333scutage
septage1078403septage
signage937773signage
silage72715303si_lage
singe65731133sin__ge
sinkages1386853sinkages
sinuate7412153sinuate
spinage10289653spin_age
stage65330193__stage
syntagm1343303syntagm
tankage12257773tankage
tannage8209583tannage
tentages91011043tentages
tillage83111333tillage
tinge64626613tin__ge
tintype1243033tintype
tinware1038593tinware
tonnage8168053tonnage
tunnage8166373tunnage
uintaite8127353uintaite
uncage93014873_uncage
unitages938273unitages
untame82513603_untame
upstage10167443upstage
vantages12119023vantages
ventages12119763ventages
village113610823village
vintagers13123893vintagers
visage1049083vi_sage
vitae84217633vi_ta_e
vittae93910993vitta_e
vittate10409723vittate
voltage1136863voltage
waftage14115323waftage
wantages12109023wantages
wastage11109253wastage
wattage1186983wattage
windages1338263windages
wintle94014603wint_le
zincate1838533zincate
zingare1737133zingare

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.1561145455.1
2DLD Change Limit1340272607.28018410.3
3Display Results2602600.0932795.7
 (SQL Overall)1786912607.52923733.7
 
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.