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

162 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
mulled9472155(None) 
bulled94626491bulled
culled94022471culled
dulled84719421dulled
fulled103820651fulled
gulled84521371gulled
hulled103920011hulled
lulled74516441lulled
malled94626111malled
melled95023021melled
milled94326171milled
muled85824431mu_led
mullen83714761mullen
muller83820351muller
mullet84126821mullet
mulley114013451mulley
nulled74318271nulled
pulled94322191pulled
balled94926892balled
belled94626192belled
billed94224902billed
bolled94722652bolled
bugled104918132bugled
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bullet84528612bullet
bullied104514812bullied
burled94825382burled
butled94818602butled
called94126732called
celled94420322celled
culler84322252culler
cullet84727312cullet
cullied104012352cullied
culmed114610592culmed
curled95021652curled
dilled84122222dilled
dolled83518072dolled
dueled84813662dueled
duelled9359752duelled
duller74017702duller
felled103720302felled
filled104922262filled
fueled104913602fueled
fuelled11369192fuelled
fugled114813692fugled
fuller94220382fuller
furled104717052furled
galled84622862galled
gelled84718892gelled
gilled84521632gilled
guiled84315382guiled
gulfed114810012gulfed
gullet74924832gullet
gulley104213162gulley
gullied93812062gullied
gulped104610372gulped
helled104024702helled
hilled104022222hilled
hulked144611302hulked
huller93919102huller
hulloed11369792hulloed
hurled104617452hurled
jelled144916062jelled
killed113918772killed
lalled74218752lalled
lolled74315822lolled
luller63415482luller
macled116718112macled
mailed95326752mailed
malfed12369762malfed
mallee84525592mallee
mallei84414632mallei
mallet84433052mallet
malted94819862malted
marled95523162marled
mauled94817822mauled
melded104714712melded
melted94219062melted
mewled123710052mewled
milded104416152milded
milked134612572milked
mille75029132mille_
miller84625412miller
milles84526562milles
millet84030742millet
milted93919942milted
misled94719312misled
mobled113213182mobled
moiled94318862moiled
molded104414082molded
molted94217472molted
moulded11348062moulded
moulted103310312moulted
mucked153816092mucked
mudded114511382mudded
muddled124111592muddled
muffed154210592muffed
muffled16377782muffled
mugged114113832mugged
mulched15307762mulched
mulcted12296692mulcted
mule65236972mu_le_
mules75034292mu_les
muley104819282mu_ley
mull65128802mull__
mulla74317112mull_a
mullah113710732mullah
mullas84215932mullas
mullein9278562mullein
mullens93611312mullens
mullers93217302mullers
mullets93614782mullets
mulleys12299202mulleys
mulls75124152mull_s
mumbled143010762mumbled
mummed104411552mummed
mumped133813162mumped
muraled10410832muraled
muralled1136422muralled
mured85726702mu_red
muscled1237782muscled
mused85524582mu_sed
mushed124420842mushed
mussed94418902mussed
musted93321072musted
muted85023382mu_ted
muzzled18267752muzzled
nilled73919452nilled
nurled74016232nurled
outled74020342outled
palled94625162palled
pilled94222752pilled
polled94022002polled
puled84926522pu_led
puller83820812puller
pullet84026332pullet
pulley113713402pulley
pulped114612532pulped
pulsed94013722pulsed
purled94520752purled
quelled17279272quelled
quilled17329282quilled
rilled74525652rilled
rolled74220242rolled
ruled65822522ru_led
sculled102911692sculled
skulled12317402skulled
smelled103511862smelled
sulked114314702sulked
sullen62914292sullen
sullied83714482sullied
tilled74722952tilled
tolled73819032tolled
tulle54019932tulle_
tulles63218892tulles
unled64021072_unled
walled104021292walled
welled103820212welled
willed104722452willed
yelled104116252yelled

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511622.98327673.8
3Display Results1621620.0463521.7
 (SQL Overall)1786911623.38952726.8
 
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.