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

236 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
minnow113558(None) 
minnows1234911minnows
winnow1234591winnow
indow95011662_indow
miaow1058352mi_aow
mignon937952mignon
minion83416242minion
minny104518662minn_y
minor74920062mi_nor
misknow1643212misknow
window1347362window
winnows1334532winnows
amino75425503ami_no_
annoy869713_annoy
besnow1145713besnow
billow114111223billow
bingo86020093bingo_
bingos95514793bingos
binned94414543binned
cannon84514443cannon
cannot83616773cannot
cineol8108203cineol
dingo74720793dingo_
dinned84317613dinned
dinner74217163dinner
dino56036753di_no_
dinos65428063di_nos
endow94510983_endow
enow77819873__enow
erenow937373erenow
finned104114603finned
finny114716753finn_y
fino76034693fi_no_
finos86226953fi_nos
ginned83813983ginned
ginner73915823ginner
ginny95314573ginn_y
ginzo1539613ginzo_
hinny115616673hinn_y
imino74315233imino_
incog838253_incog
indol63714873_indol
indows104210793_indows
inflow1235293_inflow
info75617353_info_
infos84311673_infos
ingot61221063_ingot
inion54620183_inion
inn36727433_inn__
inned64118423_inned
inner54920633_inner
inns46920933_inn_s
inro45920793_inro_
into45026153_into_
intown936153_intown
jingo134615213jingo_
jinn115420243jinn__
jinnee13411573jinnee
jinni125310633jinn_i
jinnis13489053jinnis
jinns126013843jinn_s
kino86233623ki_no_
kinos96626143ki_nos
know116115843__know
lingo66022113lingo_
linn46034593linn__
linnet6419423linnet
linns56123333linn_s
lino46343373li_no_
linos55631503li_nos
lintol6369473lintol
maintop1135143maintop
mallow114014743mallow
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
manna75522543mann_a
mannan85413623mannan
mannas85019803mannas
manned94418643manned
manner84020513manner
mannose939243mannose
mano66536813m_ano_
manor78023933m_anor
manos74933623m_anos
marrow112812603marrow
meadow1237403meadow
mellow114112223mellow
meno66031363m_eno_
mentor8414363mentor
meow95117883m__eow
miaou7513083mi_aou
miaows1145473mi_aows
micro94715993micro_
micron103714283micron
micros104115363micros
midnoon1044683midnoon
midtown1343673midtown
mien65028363mien__
miens76118303mien_s
mignons1037863mignons
mikron12318503mikron
mikvos1554023mikvos
mikvot1556763mikvot
mildew12319043mildew
milneb1095953milneb
milo65536103mi_lo_
milos75428013mi_los
mimeo96018683mimeo_
mimeos104511543mimeos
mina65136923mi_n_a
minae75627723mi_nae
minas75434113mi_nas
mince95325233mi_nce
minced114114913minced
mincer104017363mincer
minces104420803minces
mincy125817413mi_ncy
mind75434383mi_n_d
minded103817833minded
minder94822503minder
minds85427123mi_nds
mine67256173mi_n_e
mined85333353mi_ned
miner76933543mi_ner
miners84126633miners
mines75651953mi_nes
mingle93518783mingle
mingy115520183mi_ngy
mini65634563mi_n_i
minify1439253minify
minim97321603mi_nim
minima105512653minima
minims104514813minims
mining94225453mining
minings103912073minings
minions93314623minions
minis75432993mi_nis
minish115216303minish
minium106014423minium
mink106636533mi_n_k
minke115421763mi_nke
minkes124618783minkes
minks115829273mi_nks
minnies93617363minnies
minors85117103minors
mint66758063mi_n_t
minted94220583minted
minter84425103minter
mints76834043mi_nts
minty106323903mi_nty
minuet82621033minuet
minus75223933mi_nus
minute83414293minute
minx137723353mi_n_x
minxes154612983minxes
minyan1138173minyan
mirror848003mirror
misdo85413183misdo_
misgrow1344433misgrow
misknew1633883misknew
misknown1742533misknown
misknows1743063misknows
miso67229903mi_so_
misos76523293mi_sos
mistbow1443993mistbow
mondo85721233mondo_
mondos95217333mondos
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
mono66036723m_ono_
monos75930863m_onos
moonbow1443873moonbow
morrow113510093morrow
mow86650353m___ow
mungo84916053mungo_
mungos94311373mungos
munnion935863munnion
ninny84514933ninn_y
ninon55517383ni_non
ninons64913773ninons
now65950193___now
pennon8310643pennon
piano76118713piano_
pianos84315933pianos
pillow113110573pillow
pingo87122713pingo_
pingos95317673pingos
pinion83815893pinion
pinko115618253pinko_
pinkos125313873pinkos
pinna75320183pinn_a
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinned94818383pinned
pinner84521503pinner
pinny105222063pinn_y
pinon76024533pi_non
pinons86019943pinons
pinot78737293pi_not
pinto75625753pinto_
pintos86021293pintos
pinyon11459763pinyon
rainbow1243353rainbow
sannop837373sannop
signor73510353signor
sinew84718923si_new
sinned73818413sinned
sinner64320603sinner
snow76324793__snow
sunbow1145823sunbow
tannoy958353tannoy
tinned74317533tinned
tinner64119963tinner
tinny85317653tinn_y
tinpot8312513tinpot
topminnow165473topminnow
vino76128433vi_no_
vinos84723073vi_nos
widow1278933wi_dow
willow12369693willow
windows1447743windows
windowy1744643windowy
windrow1445853windrow
wingbow1643773wingbow
winned104017013winned
winner94219933winner
winnock1643893winnock
winnowed1543473winnowed
winnower1444253winnower
wino75933613wi_no_
winos84625043wi_nos
zinnia1536013zinnia

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162364.70323966.8
3Display Results2362360.0763105.3
 (SQL Overall)1786912365.17234549.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.