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

227 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
maul6483072(None) 
caul65630001caul
haul75530451haul
mail65543451mail
mall64639371mall
marl66341621marl
maud75325401maud
mauls76524951mauls
maun65727211maun
maut65448451maut
miaul71612121miaul
saul45836521saul
waul76927311waul
aal39058672_aal
ail37171042_ail
al210674042_a_l
all36148232_all
ampul91110852ampul
amu58237322amu_
amus65529612amus
amyl95515102amyl
auk76234142_auk
auld54125362_auld
awl67635302_awl
baal67033112baal
babul96317712babul
bail65042802bail
bal56662722ba_l
ball66043322ball
baud74928422baud
baulk114914332baulk
bawl95326062bawl
call66838672call
carl65144782carl
cauld85318442cauld
caulk115315452caulk
cauls75727772cauls
dahl87019222dahl
dal47554952da_l
daub77423442daub
daut56443562daut
dual55928172dual
earl45838142earl
eau37450942eau_
eaux116618422eaux
email74715102email
fail74840242fail
fall75535312fall
farl76338552farl
fauld95214492fauld
fault85428312fault
faun76226622faun
faux146519072faux
foul77027582foul
gal46055512ga_l
gall56335992gall
gaol56925412gaol
gaud67025432gaud
gault65128482gault
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
gul45832792_gul
hail74839062hail
hall75741162hall
hamaul114210872hamaul
harl75740002harl
haulm104415412haulm
hauls86123732hauls
haut75949732haut
imaum9139642imaum
jail115529092jail
jarl115828132jarl
jauk155816092jauk
jaup135316422jaup
kail85131492kail
lall45531312lall
laud56527722laud
ma410060662ma__
maar66025062maar
mabe85733362mabe
mac78053932ma_c
mace87345792mace
mach116134482mach
mack125733652mack
macle96127002macle
macs86742512macs
macula103013672macula
macule104115272macule
mad68958712ma_d
made75440242made
madly115218132madly
mads76845372mads
mae57659112ma_e
maes66948402maes
mag67956482ma_g
mage75739132mage
magi76329532magi
mags75444532mags
magus85318752magus
maid75537662maid
maile75232222maile
maill74420792maill
mails76037782mails
maim85831492maim
main65345522main
mair66133782mair
make105537892make
mako105622362mako
male66052302male
malls76233432malls
malm85129982malm
malt66254812malt
mama86231592mama
man57465872ma_n
mana65341962mana
mane65052032mane
manful11610212manful
manly105022952manly
mano66536812mano
mans66354552mans
manual8313462manual
manus75924932manus
many95731862many
map77255122ma_p
maple95521142maple
maps86141052maps
maqui16249952maqui
mar57965952ma_r
mara67444572mara
marc87034632marc
mare64759332mare
mark105138062mark
marls75535162marls
marly106925612marly
mars66261872mars
mart66865982mart
mas58175822ma_s
masa65034722masa
mash96039402mash
mask105227362mask
mass66044942mass
mast65959962mast
mat58083942ma_t
mate65154222mate
math95437452math
mats65460292mats
matt65752662matt
mauds85519272mauds
mauled94817822mauled
mauler84416712mauler
maund85515452maund
mauts75927192mauts
mauve104013272mauve
maw87050102ma_w
mawn94424142mawn
maws96437142maws
max129045452ma_x
maxi137023562maxi
may88757632ma_y
maya95824592maya
mayo96524302mayo
mays96940032mays
maze155434982maze
mazy186419702mazy
meal65643172meal
mel56047482m_el
mell64935612mell
merl65830972merl
mewl95618322mewl
miauls8178712miauls
mil55752112m_il
mill66541482mill
mogul8310212mogul
moil65534092moil
mol56654592m_ol
moll66735702moll
mool67533862mool
moue65835572moue
mould86015752mould
moult74728722moult
mu46737482m_u_
mud67336862m_ud
mug65837692m_ug
mule65236972m_ule
mull65128802mull
mum76643612m_um
mun56143862m_un
mus55946752m_us
mut58357182m_ut
nail45838652nail
pail66141832pail
pal56761672pa_l
pall65039342pall
pawl95123262pawl
pul56138062_pul
rail46147762rail
sail45447162sail
sal36462882sa_l
sall44544682sall
sau36356572sau_
sauls55128122sauls
sault55834962sault
shaul85418102shaul
shul75823152shul
small74016262small
soul46435712soul
tael46030712tael
tail45443652tail
tall47240212tall
tau36856902tau_
taus46342732taus
taut47048962taut
vail75432552vail
vau66840872vau_
vault85823762vault
vaus75928922vaus
wail75238822wail
wall76236102wall
wauk115220592wauk
wauls86120552wauls
waur76819902waur
wawl105321942wawl
yaud87020082yaud
yauld95511182yauld
yaup96618482yaup
yawl104918972yawl

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298722270.97030795.9
3Display Results2272270.0633603.2
 (SQL Overall)1786912271.296137878.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.