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

343 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
oared6503065(None) 
bared85144481bared
cared86050091cared
dared75935011dared
eared65139501eared
fared95842341fared
hared95742181hared
pared86946761pared
rared65738321rared
roared75015391roared
soared74324291soared
tared69340051tared
wared96339871wared
aahed917816442aahed
abed79734132_abed
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
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
blared95018242blared
board85523002boar_d
boarded113910502boarded
boated94221972boated
bored85034302bored
bred75130972_bred
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
card710245872car_d
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cered85227442cered
chared125423692chared
coaled95022702coaled
coated94927042coated
coaxed165612512coaxed
cored85044222cored
cred76530882_cred
cured85932132cured
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
doated84118182doated
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
foaled104515962foaled
foamed126014402foamed
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715192glared
goaded94913712goaded
goaled85014362goaled
gored75227082gored
gyred105114092gyred
haded105227622haded
haed86338582ha_ed
haired105117172haired
haled95335822haled
hard85443502har_d
hare76255732hare_
harem104924452harem
hares86255542hares
harked145422552harked
harmed125218832harmed
harped124418402harped
hated95734022hated
hatred104814332hatred
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
hired95226262hired
hoard94918312hoar_d
hoarded12368342hoarded
hoaxed17378872hoaxed
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036292laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
loaded84616872loaded
loafed104011152loafed
loamed94414612loamed
loaned73816292loaned
loured74617402loured
lured65427492lured
maced108528692maced
maned86634102maned
mare64759332mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
moaned94514172moaned
moated94819002moated
moored93814172moored
mured85726702mured
nacred95212492nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119802neared
oaken95814382oaken
oar37057952oar__
oars46846032oar_s
oases55330982oases
oaten55222402oaten
oater55433732oater
oaves84925612oaves
ochred12328002ochred
ocrea73311822ocrea
odored8399222odored
offed12359162offed
ogled75915962ogled
ogre56320742ogre_
ogres65818632ogres
ohed87825182o_hed
oiled64429472oiled
okayed1434252okayed
oohed94214212oohed
oozed154214262oozed
oped76230152o_ped
opted84914272opted
orad56031692o_rad
orated74221502orated
orbed85516192orbed
ore36661832o_re_
oread64619602o_read
ores46056682o_res
outed65429062outed
overed102216622overed
owed86833872o_wed
owned95113232owned
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922042parged
parked134425142parked
parled94626282parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
pored85234512pored
poured95116742poured
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755802__red
roamed95215092roamed
roarer63914332roarer
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
seared75232842seared
sered65737292sered
shared105829062shared
shred98125612shred
sired66134282sired
snared74824552snared
soaked114717592soaked
soaped95817972soaped
soarer64522242soarer
sored66141782sored
soured74921862soured
spared95427492spared
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
tired65228902tired
toured74216152toured
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94330992waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
waved125223582waved
waxed166018482waxed
wired95327642wired
woaded115211602woaded
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

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 Filter178691538000.1701051123.5
2DLD Change Limit538003432.84618903.7
3Display Results3433430.1103118.2
 (SQL Overall)1786913433.12657162.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.