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

442 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
bared8514448(None) 
baaed85218161baaed
baked126130771baked
baled85436441baled
baned85436351baned
barbed115121311barbed
bard75648861bar_d
barde85330771barde
barded105426421barded
bare65460521bare_
barer74535801barer
bares75457131bares
barfed125416381barfed
barged105822641barged
barked135027311barked
barned95623581barned
barred95725791barred
based85331581based
bated85935531bated
bayed115423021bayed
blared95018241blared
bored85034301bored
bred75130971b_red
cared86050091cared
dared75935011dared
eared65139501eared
fared95842341fared
hared95742181hared
oared65030651oared
pared86946761pared
rared65738321rared
tared69340051tared
wared96339871wared
aahed917816442aahed
abased96514992abased
abated95918452abated
abed79734132_abed
abled86926832abled
aced79540882_aced
acred87126352acred
aged67334252_aged
ahed89536252_ahed
aired66032922aired
aped78538152_aped
arced88224162_arced
are37874572_are_
area45843392_area
ares45871022_ares
arid57642712_arid
armed86324432_armed
awed88436032_awed
axed128829612_axed
babe86835812babe_
babel95821692babel
babes95834112babes
babied114913502babied
bached145519892bached
backed155725722backed
bad67763152ba__d
bade75140882bade_
badged114814782badged
baffed154812172baffed
bagel85116792bagel
bagged114519902bagged
bailed94726652bailed
baited95319242baited
bake105637512bake_
baker115629542baker
bakes117035372bakes
bald76432902ba_ld
balded105417512balded
bale66353842bale_
baler75635272baler
bales76250082bales
balked135219412balked
balled94926892balled
bammed133913242bammed
band76740902ba_nd
banded105223172banded
bane65250422bane_
banes74945582banes
banged104923722banged
banked135021442banked
banned94721342banned
bar58070552bar__
barb85240062bar_b
barbe95328282barbe
barbel104317072barbel
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barbs95928192barbs
barca91319432barca
bardes95026932bardes
bards87139642bards
barege94713542barege
barely114716792barely
barest85327692barest
barf95844402bar_f
barfs104826002barfs
barge85631022barge
bargee94624442bargee
barges94528252barges
baric96125692baric
bark106242152bar_k
barker124822862barker
barks115735812barks
barky145721612barky
barley115116762barley
barm86739602bar_m
barmen105418532barmen
barms96128462barms
barmy125218762barmy
barn66444642bar_n
barney115314452barney
barns76335142barns
barny105821732barny
baron78131242baron
barre75929542barre
barrel84517872barrel
barren85317612barren
barres84427542barres
barret84930482barret
bars66564092bar_s
bartend1038752bartend
barter85525372barter
barye105021492barye
baryes116218502baryes
base64847022base_
baser74828922baser
bases75644352bases
bashed126225702bashed
basked135218602basked
basted95227232basted
bate66552422bate_
bates75846342bates
bathed125518742bathed
batted95623652batted
baud74928422ba_ud
bawd105520842ba_wd
bawled124415692bawled
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
beard86024962bear_d
bearded114212132bearded
bearer85323912bearer
bed67950622b__ed
beret74946362beret
bermed115217722bermed
bewared13310112bewared
biased94012222biased
bided95424962bided
biked125320032biked
biped104718832biped
bird76128312bir_d
birded104414302birded
birled94416992birled
birred94713202birred
bladed104717762bladed
blamed116017952blamed
blare75826232blare_
blares85021632blares
blawed124713892blawed
blazed184314712blazed
bleared104211252bleared
bled75729312b_led
bleed85019802bleed
blued84520322blued
board85523002boar_d
boarded113910502boarded
boated94221972boated
boded95124962boded
boned85133242boned
booed85127272booed
bore66051332bore_
borer75131272borer
bores76448252bores
borked135117292borked
bowed114533422bowed
boxed154318612boxed
braced115420602braced
brad75234342b_rad
brae65639112brae_
braes75735052braes
braid85822262braid
braked135318692braked
brand85124492brand
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bread85523112b_read
brede85520502b_rede
bree67241262b_ree
breed85526692breed
bren65629562b_ren
brew95023562b_rew
burd75534262bur_d
buret77444012buret
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burred95820722burred
bused85624492bused
byre95023852byre_
byres104421382byres
byrled12437172byrled
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
card710245872car_d
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822292carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cered85227442cered
chared125423692chared
cored85044222cored
cred76530882_cred
cured85932132cured
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dured75025402dured
earned74818332earned
eased65430402eased
eaved95924502eaved
erred65915672erred
faced117727652faced
faded105025242faded
faired105915772faired
faked135225482faked
famed115928342famed
farad95720672farad
farced125216532farced
fard85639062far_d
farded114518952farded
fare76354462fare_
farer86733142farer
fares85852872fares
farmed125117652farmed
farted105121782farted
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
feared106320432feared
fired94829742fired
flared105317602flared
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715192glared
gored75227082gored
gyred105114092gyred
haded105227622haded
haed86338582ha_ed
haired105117172haired
haled95335822haled
hard85443502har_d
hare76255732hare_
harem104924452harem
hares86255542hares
harked145422552harked
harmed125218832harmed
harped124418402harped
hated95734022hated
hatred104814332hatred
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
hired95226262hired
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036292laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
lured65427492lured
maced108528692maced
maned86634092maned
mare64759322mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
mured85726702mured
nacred95212492nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119802neared
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pored85234512pored
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755802__red
roared75015392roared
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
seared75232842seared
sered65737292sered
shared105829062shared
shred98125612shred
sired66134282sired
snared74824552snared
soared74324292soared
sored66141782sored
spared95427482spared
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
tired65228902tired
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94330992waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
waved125223582waved
waxed166018482waxed
wired95327642wired
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

Search took 5 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 Limit538004423.44015639.5
3Display Results4424420.4201052.4
 (SQL Overall)1786914423.95345203.9
 
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.