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
minds85427121minds
mines75651951mines
minis75432991minis
minks115829271minks
mint66758061mint_
minty106323901minty
minus75223931minus
mists76633901mists
mitts75523751mitts
pints75936221pints
tints56030921tints
ains46158882ain_s
airts55626342airts
aits46355532ai_ts
aments85219802aments
amines84727982amines
amins75534322amin_s
ants47243472_ants
aunts55227632aunts
bents76033692bents
binds86627472binds
bines76946792bines
binits85716672binits
bins66548252bin_s
bint67355042bint_
bionts8612392bionts
bits66148162bi_ts
bitts75022592bitts
bunts75729802bunts
cants77036942cants
cents74730332cents
chints115117832chints
cines75239682cines
cists76624532cists
cunts76125122cunts
dents65031802dents
diets66026642diets
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dint56759052dint_
dirts66824462dirts
dits56450522di_ts
dunts65828412dunts
elints65816422elints
emits75421472emi_ts
faints94818782faints
feints94813872feints
fiats85324482fiats
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fists85527542fists
fits76043462fi_ts
flints95617452flints
fonts86124752fonts
gents65729612gents
giants74713502giants
gifts96214962gifts
gilts64924262gilts
ginks104319562ginks
gins55543952gin_s
girts65423622girts
gists66026192gists
gits55744592gi_ts
glints75714212glints
haints94417582haints
hants86335402hants
hents87330742hents
hilts86924412hilts
hinds96721472hinds
hins76447992hin_s
hint77455742hint_
hists86328372hists
hits75545132hi_ts
hunts86826172hunts
imines84918352imines
inks86926502_inks
inns46920932_inns
ins35945602_in_s
inti46626082_inti
intis55121642_intis
into45026152_into
its35538832_i_ts
jilts124717412jilts
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
joints133811452joints
kilts95122182kilts
kinas95626912kinas
kinds106221822kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747912kin_s
kists95822112kists
kits86441772ki_ts
knits93914742knits
lifts85719062lifts
lilts55822802lilts
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lint416266232lint_
linty87126562linty
lists56628692lists
lits46252492li_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
mibs85330482mi_bs
micas96823052micas
micks135525372micks
mics87435152mi_cs
midis85923412midis
mids76541792mi_ds
midst85922552midst
midsts95510052midsts
miens76118302miens
miffs134512882miffs
miggs96311372miggs
mights123516252mights
migs76935322mi_gs
mikes115129892mikes
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mi_ls
milt65455812milt_
milty104720072milty
mimes95732022mimes
mina65136922min_a
minae75627722minae
mince95325232mince
minces104420802minces
mincy125817412mincy
mind75434382min_d
mine67256172min_e
mined85333352mined
miner76933542miner
miners84126632miners
mingy115520182mingy
mini65634562min_i
minim97321602minim
minims104514812minims
minish115216302minish
mink106636532min_k
minke115421762minke
minkes124618782minkes
minny104518662minny
minor74920062minor
minors85117102minors
minted94220582minted
minter84425102minter
minters93822472minters
minuets9259852minuets
minute83414292minute
minutes93513442minutes
minx137723352min_x
minxes154612982minxes
mips85534082mi_ps
mires75640882mires
mirks115122142mirks
mirs66940572mi_rs
mirth106418892mirth
mirths114912992mirths
mis58162622mi__s
mises74740562mises
misos76523292misos
miss65339422mi_ss
mist66154532mist_
misty106120452misty
mite66249412mi_te
mites75141802mites
mitis75425992mitis
mitt66145492mi_tt
mity95528212mi_ty
mixes147224402mixes
mixt136831922mixt_
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
nits45741642ni_ts
oinks94819912oinks
omits75018262omi_ts
paints85921832paints
pants76536922pants
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pinots85920272pinots
pins65558452pin_s
pint66963172pint_
pinta75727052pinta
pintas85021392pintas
pinto75625752pinto
pintos86021292pintos
pits66348742pi_ts
points85618532points
prints84320102prints
punts75828002punts
quints154316562quints
rants55935342rants
remints95117292remints
rents55935182rents
rifts85718642rifts
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
riots54922012riots
runts55927632runts
saints65122422saints
sifts84918922sifts
silts55330822silts
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
sits45050202si_ts
snits54124832snits
stints65119762stints
suints64617782suints
taints64520532taints
tents56434212tents
tilts55325612tilts
tincts84510802tincts
tines54848422tines
tings65329202tings
tins45251302tin_s
tint46758862tint_
tits46145042ti_ts
units54923432units
vents86125932vents
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wants87932212wants
wilts85023502wilts
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
wists86728522wists
wits76044872wi_ts
wonts87621542wonts
yins75335122yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_s
zits136030292zi_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.313570897.8
2DLD Change Limit538003201.59333772.8
3Display Results3203200.0764210.5
 (SQL Overall)1786913201.98290156.9
 
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.