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

208 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
munched153411071munched
muncher143610371muncher
munches144215791munches
bunched154312412bunched
bunches144116032bunches
dunches133312582dunches
hunched163710492hunched
hunches153913462hunches
lunched133911822lunched
luncher123111412luncher
lunches124115442lunches
manche133515102manch_e
manches143818622manches
manchet143317782manchet
muches134718992mu_ches
mulched15307762mulched
mulches143210672mulches
munch124917102munch__
munchers15318772munchers
munchies1539252munchies
mutches143314282mutches
punched153512172punched
puncher143311672puncher
punches144816132punches
banshee121212453banshee
benched154713943benched
bencher144113483bencher
benches143918603benches
bouchee143313543bouchee
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
bunch125118603bunch__
bunchier1536153bunchier
bunchy16437463bunch_y
buncoed12378443buncoed
bungee96319773bun_gee
butcher143411163butcher
butches144315363butches
cinched153910863cinched
cinches144215773cinches
conchae143911643conchae
conches144019813conches
conchie143312683conchie
crunched16328163crunched
cruncher15338073cruncher
crunches153711353crunches
culches143710743culches
curches143512743curches
cutches143216463cutches
dunce86319263dunc__e
dunces95215753dunc_es
dunch115316263dunch__
euchre11137663eu_chre
finches153914193finches
fitchee152710783fitchee
fourchee1645383fourchee
glunched1544263glunched
glunches1436263glunches
gulches13398103gulches
haunched1744813haunched
haunches1656963haunches
hunch136416213hunch__
hutched16359883hutched
hutches153613523hutches
inched124514483_inched
incher114114033_incher
inches114419673_inches
juncoes16338073juncoes
kenches163912273kenches
kimchee1845603kimchee
kuchen1536653ku_chen
launched1475403launched
launcher1365563launcher
launches1387903launches
lichee114017973_lichee
lunch104917243lunch__
luncheon1344013luncheon
lunchers13349563lunchers
lungee75119813lun_gee
lurched13358033lurched
lurcher12338133lurcher
lurches123311663lurches
lychee143710893_lychee
lynched16376753lynched
lyncher15366553lyncher
lynches15378873lynches
macchie1647193macchie
mache125925303m_ach_e
maches134827233m_aches
machete14310883m_achete
machree1438513m_achree
manatee9317663manatee
manchets15269573manchets
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marchese15358913marchese
matched153513963matched
matcher143214283matcher
matches143219783matches
menschen1543713menschen
mensches1536303mensches
menshen1236813menshen
menshes12310453menshes
mentee84121293men_tee
menthene1347033menthene
merches144013763merches
miche126219243m_ich_e
miched143913393m_iched
miches134320733m_iches
mince95325233minc__e
minced114114913minc_ed
mincer104017363minc_er
minces104420803minc_es
mincier113512473mincier
mooched153910533mooched
moocher143610673moocher
mooches143714453mooches
mouched153612593mouched
mouches143815963mouches
much115224033mu_ch__
muchly1686203mu_chly
mucho125013443mu_ch_o
mucked153816093mu_cked
mucker143816393mu_cker
muckle143413583mu_ckle
mucose10149313mu_cose
mudhen1236883mu_dhen
muggee103612833mu_ggee
mulch124012973mulch__
mulcted12296693mulcted
munchable1844943munchable
munching16299973munching
munchkin1943233munchkin
mundane1038073mundane
mungoes103510463mungoes
munster93710523munster
murther1237953murther
muscae10410673musc_ae
muscle10310973musc_le
muscled1237783muscled
muscles11310563muscles
mushed124420843mu_shed
musher113820573mu_sher
mushes114124563mu_shes
mustee83922103mu_stee
mutch125016173mutch__
mynheer1542283myn_heer
nuchae11218513nu_chae
nuncle839363nunc_le
nuncles939843nuncles
ouched124316933ou_ched
ouches114322183ou_ches
ounce77019933ounc__e
ounces83617773ounc_es
paunched1645523paunched
paunches1568173paunches
pinched153812453pinched
pincher143812713pincher
pinches144117933pinches
punch125118423punch__
puncheon1544473puncheon
punchers152610073punchers
punchier1536413punchier
punchy16398523punch_y
quenched2334103quenched
quencher2234123quencher
quenches2236013quenches
quiche2057903quich_e
quiches2139333quiches
ranched133113603ranched
rancher123013633rancher
ranches123620113ranches
raunches1368053raunches
ruche104216763ru_ch_e
ruched124314633ru_ched
ruches114819583ru_ches
rushee93818773ru_shee
smutched16165923smutched
smutches15177273smutches
sunchoke1744773sunchoke
synched16277213synched
tenches123515523tenches
trochee122613883trochee
tusche1136783tusch_e
tusches1237903tusches
uncage93014873_uncage
uncake122813523_uncake
uncase83817433_uncase
unchewed1735803_unchewed
unchic1338643_unchic
unchoke16248193_unchoke
unciae83215313_unciae
uncle7317053_unc_le
uncles8317163_uncles
uncute82912133_uncute
undee65327273_un_dee
unfree9413203_unfree
unshed10313773_unshed
vouchee153411263vouchee
wenched163910913wenched
wencher153811133wencher
wenches152914133wenches
winched163110593winched
wincher153410653wincher
winches154714373winches

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.423422437.4
2DLD Change Limit1340272087.03019065.0
3Display Results2082080.0962166.7
 (SQL Overall)1786912087.54923670.8
 
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.