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 “dotard” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

423 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
dotard83905(None) 
dotards937251dotards
board85523002bo_ard
boyard125411282boyard
costard104113352costard
coward12411672coward
dastard9279702dastard
datary10310242datary
doated84118182doated
dotage82711612dotage
dotal64919622dota_l
dotardly1343842dotardly
doted75227072dot_ed
doter65428622doter_
doters74423912doters
dotted84717522dotted
hoard94918312ho_ard
holard10410572holard
leotard846192leotard
notary92310712notary
petard95013802petard
retard75018932retard
ritard74812082ritard
rotary92411302rotary
toward10311062toward
votary12248332votary
aboard9312613aboard
afeard1058263afeard
altar55520643altar_
altars64518153altars
attar56516693attar_
attars64515313attars
award97118043_award
bard75648863__bard
bastard103012423bastard
bayard124411663bayard
beard86024963_beard
boar66134293bo_ar_
boards94616933bo_ards
boars75229603bo_ars
boart78835933bo_art
boated94221973boated
boatyard1444073boatyard
bogart9617193bogart
bolar75123473bolar_
bollard103210503bollard
bombard1437333bombard
bota66236503bota__
botany1139263botany
botas75328783bota_s
boyar106013763boyar_
boyards13399323boyards
boyars115611983boyars
briard94311293briard
bustard10389723bustard
canard9314763canard
card710245873__card
chard116124743_chard
coated94927033coated
collard103712923collard
cord76740923co__rd
costar85518613costar_
costards113510783costards
costars94217993costars
cotan71521783cota_n
cotans81317923cotans
coted85033853cot_ed
cottar84613813cottar_
cottars94412233cottars
covary1438743covary
cowards1339613cowards
custard10389973custard
dad58456163d__a_d
damar84117733damar_
damars93814993damars
darb76033533d__arb
dare55848863d__are
dared75935013d__ared
dark95133213d__ark
darn56434623d__arn
dart55857873d__art
dastards10278083dastards
data56026653data__
dated75530993dat_ed
dater65332313dater_
daters74827363daters
datura738023datura
dead65434243d_ea_d
dear55343603d_ear_
dears65736883d_ears
deary95826843d_eary
debar85517863debar_
debark134210943debark
debars94218043debars
debeard1137353debeard
decare93919153decare
dekare112811563dekare
demand104314253demand
demark134211023demark
denar65223293denar_
denari710917353denari
denars74621433denars
denary105316863denary
deodand1035713deodand
deodar837713deodar_
deodara945243deodara
deodars937623deodars
depart94720563depart
desand84812633desand
detach12310413detach
detail74516433detail
detain74617383detain
deter65028043deter_
deters74724683deters
dewar95817733dewar_
dewars105117073dewars
diary95016973d_iary
diehard1237053diehard
dietary1158663dietary
dinar66319893dinar_
dinars75417563dinars
disarm9310473disarm
discard11310213discard
dita56032523dita__
ditas65923673dita_s
doat56947673do_a_t
doats65224883do_ats
dobra85013103do_bra
dobras94811913dobras
dobro84412213do_bro
docked145018333docked
dockyard1943283dockyard
doctor938993doctor_
doctored1245613doctored
doctors1039983doctors
dodged107514683dodged
doer57734703do_er_
doers65225713do_ers
doffed14428503doffed
dogcart1148043dogcart
dogear838193dogear_
dogeared1145793dogeared
dogears937513dogears
dogged106017703dogged
doiled84817293doiled
doited85016633doited
doled75430913do_led
dollar74110983dollar_
dollars83311023dollars
dolled83518073dolled
dolor67617963dolor_
dolors75115313dolors
domain9511323domain
domal85619203doma_l
domed95423263do_med
dona55529633dona__
donas65926473dona_s
donate73619503donate
donated93513863donated
donned85015743donned
donnerd9427813donnerd
donor64418193donor_
donors75115793donors
doodad936423doodad
doomed104113293doomed
door56928513do_or_
doors65022133do_ors
dooryard1343373dooryard
dopa77220903dopa__
dopant9316133dopant
dopas85019063dopa_s
doped95326713do_ped
doper86128393doper_
dopers95522483dopers
dor47253923do__r_
dorado838813dorado
dore56353303do__re
dork96531463do__rk
dorm76834623do__rm
dorp76028053do__rp
dorr56627723do__rr
dorrs65520593do_rrs
dors56747603do__rs
dorsad8408973dorsad
dory85836233do__ry
dosage82810003dosage
dosed76626913do_sed
doser66228563doser_
dosers75723633dosers
dossed84516633dossed
dot47573183dot___
dotages92311793dotages
dote55442883dot__e
dotes65836693dot_es
doth86225713dot__h
dotier73917033dotier
doting84821913doting
dots55647663dot__s
dottel73610893dottel
dotter74419343dotter
dotters83715973dotters
dottle74212503dottle
dottrel834463dottrel
dotty94516103dot_ty
doty86128223dot__y
dour56330433do_ur_
doura66518663do_ura
dourah10479813dourah
douras75016723douras
doused84821163doused
dowed104632613do_wed
dower95027703dower_
dowered122811553dowered
dowers104523293dowers
dowery134311663dowery
downed115314783downed
downward1644443downward
dowry126312483do_wry
dowsed115015013dowsed
dozed165619353do_zed
dozer158419273dozer_
dozers164815423dozers
dread74419023drea_d
drear65016903drear_
drears74614253drears
dreary104611673dreary
dryad10477583drya_d
duad66521413d_ua_d
dullard936603dullard
dwarf126015243d_warf
dyad96415453d_ya_d
echard1249223echard
fard85639063__fard
ford86835493fo__rd
forward1438293forward
foulard11257283foulard
froward1436673froward
goad66830983go_a_d
goliard936073goliard
gonad75216053gona_d
gourd71011903go_urd
guard74415543_guard
hard85443503__hard
hazard1938403hazard
heard95222753_heard
hoar76729163ho_ar_
hoards104912623ho_ards
hoars85925543ho_ars
hoary114516763ho_ary
hodad10311353hoda_d
holards1148433holards
horary12310383horary
hotbed123310673hotbed
hotrod1048793hotrod
hotted104319933hotted
inward10310333inward
iota45127833iota__
iotas54821113iota_s
izzard15135243izzard
jeopard1744113jeopard
jota116423623jota__
jotas125717443jota_s
jotted143615173jotted
jowar155211433jowar_
jowars16369653jowars
lard56742003__lard
leopard1045293leopard
leotards945303leotards
liard65418593_liard
lizard16369233lizard
load56730603lo_a_d
lobar7313013lobar_
lord55032083lo__rd
lota47233503lota__
lotah85315853lota_h
lotahs9479873lotahs
lotas55926303lota_s
lotted74222403lotted
lyard95113213_lyard
mazard1838763mazard
moated94819003moated
molar75223093molar_
molars85517323molars
monad85519473mona_d
monarda1046613monarda
mortar83812043mortar_
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
motor75317293motor_
motored1039933motored
motors84616593motors
mustard10359533mustard
nard56634453__nard
nomad86016183noma_d
nonart6319193nonart
nota46830773nota__
notal55221353nota_l
notate63217863notate
notated82713663notated
notecard1144113notecard
noted65123843not_ed
noter55025643noter_
noters64020993noters
oar37057953_o_ar_
oared65030653_o_ared
oars46846033_o_ars
octad81510653octa_d
onward1039053onward
ootid61416693oot_id
orad56031693_ora_d
osar46820953_osar_
ottar54313993ottar_
ottars64112223ottars
outadd837803outadd
outward11811403outward
ovary1149113_ovary
pard76441323__pard
petards104311153petards
pochard1537363pochard
polar75623453polar_
polars84419353polars
pollard103511143pollard
poniard1037583poniard
postcard1346523postcard
potage92715903potage
potash1138273potash
potato8513433potato
potshard1444533potshard
potted94624013potted
poulard10299733poulard
regard85215773regard
retards85015003retards
reward106017633reward
ritards8439943ritards
road56332113ro_a_d
roar46328573ro_ar_
roared75015393ro_ared
roars55622233ro_ars
roband92310723roband
rosary92810353rosary
rota45834343rota__
rotas54827723rota_s
rotate63320343rotate
rotated82715293rotated
rotor55519733rotor_
rotors64917933rotors
rotted74524433rotted
rotund737293rotund
sard55344243__sard
satara6315533satara
shard96125963_shard
sitar54820543sitar_
sitars65417593sitars
soar46838673so_ar_
soared74324293so_ared
soars54732513so_ars
sofar86115493sofar_
sofars94712783sofars
soland75115043soland
solar55927343solar_
sonar56523423sonar_
sonars64818973sonars
sord56237203so__rd
sotted74121393sotted
souari6311373souari
sowar85821343sowar_
sowars94318003sowars
staid66722073_staid
stand65923283_stand
star48037763_star_
stare54440263_stare
stared75429873_stared
stark95425623_stark
stars55836573_stars
start55642313_start
sward94221463_sward
tabard9313333tabard
tad47959823__ta_d
tar37570693__tar_
tardo65321103__tardo
tardy94720463__tardy
tare45957623__tare
tared69340053__tared
tarn46842723__tarn
taro46846913__taro
tarp66936413__tarp
tars46763953__tars
tart47566183__tart
tatar56122063tatar_
tatars64619793tatars
tetrad73612053tetrad
toad55830183to_a_d
togaed84711343togaed
tolar55524113tolar_
tolars64817923tolars
total55321823tota_l
totaled839693totaled
totals63115163totals
toted64929483tot_ed
toter55932133toter_
toters65026363toters
totted74319953totted
towards1138783towards
trad55630913__trad
turd56027623__turd
unitard838003unitard
upward12147163upward
vaward13498723vaward
visard103910123visard
vizard19458853vizard
volar86917413volar_
voted93919143vot_ed
voter85121053voter_
voters95017443voters
ward86542253__ward
wizard19377713wizard
woad85523943wo_a_d
woald94813073wo_ald
word89832003wo__rd
wotted104115713wotted
yard85633253__yard
zonary1838793zonary

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164236.31317854.6
3Display Results4234230.1263357.1
 (SQL Overall)1786914236.57927160.8
 
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.