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

412 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
baled8543644(None) 
abled86926831abled
baaed85218161baaed
bailed94726651bailed
baked126130771baked
bald76432901bal_d
balded105417511balded
bale66353841bale_
baler75635271baler
bales76250081bales
balked135219411balked
balled94926891balled
baned85436351baned
bared85144481bared
based85331581based
bated85935531bated
bawled124415691bawled
bayed115423021bayed
bled75729311b_led
haled95335821haled
naled65525051naled
paled85538721paled
waled94330991waled
aahed917816442aahed
abased96514992abased
abated95918452abated
abed79734132_abed
able66340532able_
abler75624312abler
ables75935542ables
aced79540882_aced
aged67334252_aged
ahed89536252_ahed
ailed66240282ailed
ale36572342_ale_
alec66430062_alec
alee46652322_alee
alef76340692_alef
ales47067102_ales
aped78538152_aped
awed88436032_awed
axed128829612_axed
axled135315812axled
babbled113612862babbled
babe86835822babe_
babel95821692babel
babes95834112babes
babied114913512babied
bached145519892bached
backed155725722backed
bad67763152ba__d
bade75140882bade_
badged114814782badged
baffed154812172baffed
baffled16418062baffled
bagel85116792bagel
bagged114519902bagged
bailee84526012bailee
bailer85425252bailer
bailey115015672bailey
baited95319242baited
bake105637512bake_
baker115629542baker
bakes117035372bakes
bal56662722bal__
balas76937212balas
balder95318862balder
balds85524642balds
baldy115518932baldy
baleen8613052baleen
balers85626932balers
balk105132222bal_k
balker124519162balker
balks114926292balks
balky145418242balky
ball66043322bal_l
ballad94315322ballad
baller83825202baller
ballet84733972ballet
balls76236412balls
bally105530102bally
balm85534202bal_m
balms95723922balms
balmy125217472balmy
bals66354042bal_s
balsa77920412balsa
bammed133913242bammed
band76740902ba_nd
banded105223172banded
bane65250422bane_
banes74945582banes
banged104923722banged
banked135021442banked
banned94721342banned
barbed115121312barbed
bard75648862ba_rd
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barley115116762barley
barned95623582barned
barred95725792barred
base64847022base_
baser74828922baser
bases75644352bases
bashed126225702bashed
basked135218602basked
basted95227232basted
bate66552422bate_
bates75846342bates
bathed125518742bathed
batted95623652batted
battled104213122battled
baud74928422ba_ud
baulked14465622baulked
bawd105520842ba_wd
bawler114315052bawler
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
bed67950622b__ed
belied95022162belied
belled94626182belled
belted94020632belted
biased94012222biased
bided95424962bided
bield84614652bield
biked125320032biked
bile66147182bile_
biles75542142biles
bilged105513182bilged
bilked134012942bilked
billed94224902billed
biped104718832biped
birled94416992birled
blade85923332blade
bladed104717762bladed
blae66134642blae_
blamed116017952blamed
bland85320452bland
blared95018242blared
blawed124713892blawed
blazed184314712blazed
bleb85425222b_leb
bleed85019802bleed
blend85317452b_lend
blet66247672b_let
blew94722432b_lew
blued84520322blued
boated94221972boated
boded95124962boded
boiled95020952boiled
bold75432812bol_d
bole66448692bole_
boles75448602boles
bolled94722652bolled
bolted94617802bolted
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
bowled125018132bowled
boxed154318612boxed
braced115420602braced
brailed103914012brailed
braked135318692braked
braved124817442braved
brawled133910122brawled
brayed124615782brayed
brazed184717082brazed
bred75130972b_red
breed85526692breed
bugled104918132bugled
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
burled94825382burled
bused85624492bused
butled94818602butled
byrled12437172byrled
cabled114819872cabled
caged95426362caged
caked126128622caked
calked134617402calked
called94126732called
calmed114816382calmed
calved125215452calved
caned85838092caned
caped104931802caped
cared86050092cared
cased86032412cased
caved116227562caved
cawed116627062cawed
coaled95022702coaled
coled85540752coled
dale55643982dale_
daledh1133742daledh
dales66439742dales
dared75935012dared
dated75530992dated
dawed106222812dawed
dazed165919362dazed
deled75326542deled
dialed84716452dialed
doled75430912doled
eagled82914042eagled
eared65139502eared
eased65430402eased
eaved95924502eaved
fabled124216382fabled
faced117727652faced
faded105025242faded
failed105421602failed
faked135225482faked
famed115928342famed
fared95842342fared
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
filed95331902filed
fled85429772_fled
foaled104515962foaled
gabled105518452gabled
gaed66031512ga_ed
gaged85522312gaged
gale56347322gale_
galea64722932galea
gales65442482gales
galled84622852galled
gamed95126392gamed
gaoled84814492gaoled
gaped96123532gaped
gated75329772gated
gazed165520332gazed
gled65631142_gled
goaled85014352goaled
haded105227622haded
haed86338582ha_ed
hailed104122742hailed
hale76052832hale_
haler85033522haler
hales85449842hales
halid94424972halid
haloed104717592haloed
halted105019602halted
halved134813902halved
hared95742182hared
hated95734022hated
hauled104415212hauled
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
healed105121442healed
holed95634132holed
idled74915212idled
isled64615992isled
jaded144417032jaded
jailed144917422jailed
japed156217632japed
jawed165517372jawed
kale86533752kale_
kales95730982kales
laced87132642laced
laded74232612laded
ladled85013482ladled
laked105731122laked
lalled74218752lalled
lamed85235292lamed
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
led46254552__led
maced108528692maced
macled116718112macled
mailed95326752mailed
male66052292male_
males75049792males
malfed12369752malfed
malled94626102malled
malted94819852malted
maned86634092maned
marled95523162marled
mated85537782mated
mauled94817822mauled
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
muled85824432muled
nailed74021492nailed
naked105320852naked
naleds7469132naleds
named85223062named
oared65030652oared
ogled75915962ogled
oiled64429472oiled
paced106931682paced
paged95926782paged
pale66055012pale_
palea75028662palea
paler75436932paler
pales75753802pales
palet74650802palet
palled94625162palled
palmed114314642palmed
palped114513642palped
paned85437182paned
pared86946762pared
parled94626272parled
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pealed95322802pealed
piled85232992piled
pled75231432_pled
poled84934842poled
puled84926522puled
raced87635312raced
raged74829452raged
railed74727542railed
raked105831422raked
rale45050562rale_
rales54947492rales
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
riled65833252riled
ruled65822522ruled
sabed86526812sabed
sailed74327762sailed
salad65321832salad
sale44959702sale_
salep77022952salep
sales56055592sales
salted74121202salted
salved103916422salved
saned65636272saned
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scaled94822442scaled
sealed74328362sealed
shaled105023952shaled
sled55334372_sled
soled65835172soled
staled74728102staled
tabled94020042tabled
tailed74424662tailed
talced93811002talced
tale46154162tale_
taler56034862taler
tales55451372tales
talked114015402talked
tamed85528512tamed
taped85327422taped
tared69340052tared
tawed95926192tawed
taxed135620292taxed
tiled64832942tiled
toled65934922toled
unbaled103315962unbaled
unled64021072unled
vailed104619292vailed
vale74937342vale_
vales85434262vales
valet84337872valet
valid94618382valid
valued104011152valued
valved136711042valved
vaned94622422vaned
vealed103916322vealed
vialed105112592vialed
voled95323722voled
waded106024752waded
waged104822782waged
wailed104823592wailed
waked135626752waked
wale74546432wale_
waler84229262waler
wales86142832wales
walked145313782walked
walled104021292walled
waned95831782waned
wared96339872wared
wauled104713962wauled
waved125223582waved
wawled133811702wawled
waxed166018482waxed
whaled134612032whaled
wiled95231552wiled
wyled124611842wyled
yald86920602yal_d
yawed126022452yawed
yawled13459982yawled

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.0931921408.6
2DLD Change Limit538004121.78330173.9
3Display Results4124120.1103745.5
 (SQL Overall)1786914121.98689975.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.