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 “mints” with Change Limit: [1] [2]

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

320 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
mints7683404(None) 
bints76130181bints
dints67431311dints
hints87330621hints
lints57137191lints
milts75430711milts
minas75434111minas
minds85427131minds
mines75651951mines
minis75432991minis
minks115829271minks
mint66758071mint_
minty106323901minty
minus75223931minus
mists76633901mists
mitts75523751mitts
pints75936221pints
tints56030921tints
ains46158892ain_s
airts55626342airts
aits46355542ai_ts
aments85219802aments
amines84727982amines
amins75534322amin_s
ants47243472_ants
aunts55227632aunts
bents76033692bents
binds86627482binds
bines76946792bines
binits85716672binits
bins66548262bin_s
bint67355052bint_
bionts8612392bionts
bits66148172bi_ts
bitts75022592bitts
bunts75729802bunts
cants77036942cants
cents74730332cents
chints115117832chints
cines75239682cines
cists76624532cists
cunts76125122cunts
dents65031802dents
diets66026642diets
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652052din_s
dint56759062dint_
dirts66824462dirts
dits56450532di_ts
dunts65828412dunts
elints65816422elints
emits75421472emi_ts
faints94818782faints
feints94813872feints
fiats85324482fiats
finds95424832finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849102fin_s
fists85527542fists
fits76043472fi_ts
flints95617452flints
fonts86124752fonts
gents65729612gents
giants74713502giants
gifts96214962gifts
gilts64924262gilts
ginks104319562ginks
gins55543962gin_s
girts65423622girts
gists66026192gists
gits55744602gi_ts
glints75714212glints
haints94417582haints
hants86335402hants
hents87330742hents
hilts86924412hilts
hinds96721482hinds
hins76448002hin_s
hint77455752hint_
hists86328372hists
hits75545142hi_ts
hunts86826172hunts
imines84918352imines
inks86926502_inks
inns46920932_inns
ins35945612_in_s
inti46626082_inti
intis55121642_intis
into45026152_into
its35538842_i_ts
jilts124717412jilts
jinks165019332jinks
jinns126013842jinns
jins115635022jin_s
joints133811452joints
kilts95122192kilts
kinas95626922kinas
kinds106221832kinds
kines95039142kines
kings105825572kings
kinks84926092kinks
kinos96626152kinos
kins85747922kin_s
kists95822122kists
kits86441782ki_ts
knits93914752knits
lifts85719062lifts
lilts55822802lilts
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059062lin_s
lint416266242lint_
linty87126562linty
lists56628692lists
lits46252502li_ts
lunts55826902lunts
mains75635112main_s
maists85817572maists
malts76331752malts
manas76240432manas
manats84623462manats
manes76648962manes
manos74933622manos
mans66354552man_s
manta75629912manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
manus75924932manus
marts77442232marts
masts77035762masts
mats65460292m_ats
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
melts74930102melts
mends84927692mends
menta74424422menta
menus75822842menus
mibs85330492mi_bs
micas96823052micas
micks135525372micks
mics87435162mi_cs
midis85923422midis
mids76541802mi_ds
midst85922562midst
midsts95510052midsts
miens76118302miens
miffs134512882miffs
miggs96311372miggs
mights123516252mights
migs76935332mi_gs
mikes115129892mikes
milds86422062milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045342mi_ls
milt65455822milt_
milty104720072milty
mimes95732022mimes
mina65136932min_a
minae75627722minae
mince95325232mince
minces104420802minces
mincy125817412mincy
mind75434392min_d
mine67256182min_e
mined85333352mined
miner76933542miner
miners84126632miners
mingy115520182mingy
mini65634572min_i
minim97321602minim
minims104514812minims
minish115216302minish
mink106636542min_k
minke115421762minke
minkes124618782minkes
minny104518662minny
minor74920062minor
minors85117102minors
minted94220582minted
minter84425102minter
minters93822472minters
minuets9259852minuets
minute83414292minute
minutes93513442minutes
minx137723362min_x
minxes154612982minxes
mips85534092mi_ps
mires75640882mires
mirks115122142mirks
mirs66940582mi_rs
mirth106418892mirth
mirths114912992mirths
mis58162632mi__s
mises74740562mises
misos76523292misos
miss65339432mi_ss
mist66154542mist_
misty106120452misty
mite66249422mi_te
mites75141802mites
mitis75425992mitis
mitt66145502mi_tt
mity95528222mi_ty
mixes147224402mixes
mixt136831932mixt_
moats75827642moats
molts76032092molts
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262mon_s
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162m_ots
motts76527002motts
mounts84115072mounts
munis75022002munis
muns65535922mun_s
musts75527442musts
muts64839982m_uts
mutts75120252mutts
mynas105815232mynas
nines55937342nines
ninth8314582ninth
ninths936932ninths
nits45741652ni_ts
oinks94819912oinks
omits75018262omi_ts
paints85921832paints
pants76536922pants
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinots85920272pinots
pins65558462pin_s
pint66963182pint_
pinta75727052pinta
pintas85021392pintas
pinto75625752pinto
pintos86021292pintos
pits66348752pi_ts
points85618532points
prints84320102prints
punts75828002punts
quints154316562quints
rants55935342rants
remints95117292remints
rents55935182rents
rifts85718642rifts
rinds64826152rinds
rings65029172rings
rinks94827102rinks
rins46153202rin_s
riots54922012riots
runts55927632runts
saints65122422saints
sifts84918922sifts
silts55330822silts
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755282sin_s
sinus55523852sinus
sits45050212si_ts
snits54124832snits
stints65119762stints
suints64617782suints
taints64520532taints
tents56434212tents
tilts55325612tilts
tincts84510802tincts
tines54848422tines
tings65329212tings
tins45251312tin_s
tint46758872tint_
tits46145052ti_ts
units54923432units
vents86125932vents
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wants87932212wants
wilts85023502wilts
winds95425612winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949182win_s
wists86728522wists
wits76044882wi_ts
wonts87621542wonts
yins75335132yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735012zin_s
zits136030302zi_ts

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538003201.64032804.9
3Display Results3203200.0933440.9
 (SQL Overall)1786913202.09385375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.