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

283 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
deodars93762(None) 
deodar837711deodar_
deodara945241deodara
deodaras1044691deodaras
cedars93312832ce_dars
dears65736882de__ars
debars94218042de_bars
decoders122810412decoders
dedans85915072de_dans
denars74621432de_nars
deodand1035712deodand
deodands1144602deodands
dewars105117072de_wars
doodads1035092doodads
feodary1444712feodary
beaders104120183beaders
bears75739043be__ars
bedders113513383bedders
beggars11378223beggars
beldams1237053beldams
bendays13327513bendays
benders104021063benders
bezoars1836793bezoars
boars75229603_bo_ars
boyars115611983_boyars
cedar84014323ce_dar_
cedarn9408443ce_darn
cedary12419603ce_dary
ceders93817673ce_ders
cellars93713693cellars
chadars1338293chadars
cheddars15234383cheddars
codas84724243_coda_s
coders95426983_coders
dadas75819863d_ada_s
damars93815003d_amars
dammars12308193dammars
danders93921183danders
darbars10510093darbars
deadens93410693deadens
deader84220473deader_
deadpans12205173deadpans
deads75726913de__ads
deairs74013783de_airs
dealers84118613dealers
deals65435343de__als
deans66131393de__ans
dear55343603de__ar_
deary95826843de__ary
debags104211063de_bags
debar85517863de_bar_
debark134210943de_bark
debarks14388493de_barks
debeaks1436103debeaks
debeard1137353debeard
debeards1235503debeards
deboners11268113deboners
debtors1038533debtors
decades113615513decades
decafs124010883de_cafs
decals93717713de_cals
decare93919153de_care
decares102818533de_cares
decays124612913de_cays
deciare10710663deciare
deciares11510633deciares
deciders123510753deciders
deckers144413833deckers
declare10411223declare
declares11611313declares
declass1038733declass
declaws1336253declaws
decoder113712293decoder_
decodes113914983decod_es
decolors1187713decolors
decors94017773de_cors
decoyers14287713decoyers
dedal75719023de_da_l
deeds75423763deed__s
deejays1843433deejays
deers64930523de__ers
deewans11306903deewans
defats105114553de_fats
defeats113511233defeats
defers105116943de_fers
defiers113913993defiers
defoams1336193defoams
defrags1236193defrags
defrays1436113defrays
degas75119163de_ga_s
deicers103612733deicers
dekare112811563de_kare
dekares122710873de_kares
delays104014053de_lays
deleads9379703deleads
deltas74414823delta_s
deluders10156433deluders
delvers113411993delvers
demark134211023de_mark
demarks14339233de_marks
demeans1039723demeans
demurs939773de_murs
denar65223293de_nar_
denari710917353de_nari
denary105316863de_nary
denials84114133denials
deniers84515183deniers
dentals83915393dentals
denuders10165873denuders
depart94720563de_part
departs104310683de_parts
deposals1145443deposals
deposers11359243deposers
derats74625063de_rats
derays105514253de_rays
deriders102411853deriders
dermas94116813derma_s
desmans1039003desmans
despairs1144943despairs
desugars1043373desugars
deters74724683de_ters
detours858043detours
devas96218883de_va_s
devoirs1175783devoirs
devours1166643devours
dewans105215143de_wans
dewar95817733de_war_
dewlaps1334663dewlaps
dhooras1135943dhooras
dinars75417563d_inars
diodes83915783diod_es
dioxans1555313dioxans
disbars10310323disbars
doats65224883d_o_ats
dobras94811913d_obras
dodders105511793dodders
dodgers105213823d_odgers
dodges96119083d_odges
dodoes85716103d_odoes
dodos75819393d_od_os
doers65225713d_o_ers
dogears937513dogears
dollars83311023dollars
dolors75115313d_olors
donas65926473d_ona_s
donors75115793d_onors
doodad936423dooda_d
doodies94218773doodies
doodlers10338843doodlers
doodles93614163doodles
doodoos9107623doodoos
doors65022133d_o_ors
doozers17419293doozers
dopas85019063d_opa_s
dopers95522483d_opers
dorrs65520593d_o_rrs
dors56747603d_o__rs
dosers75723633d_osers
dotard839053d_otard
dotards937253d_otards
doters74423913d_oters
douras75016723d_ouras
dowers104523293d_owers
dozers164815423d_ozers
drears74614253d_rears
droners84114383droners
drovers115212643drovers
durbars1077973durbars
ears46356593_e__ars
eggars8398973_eggars
eiders74321363_eiders
elders74817303_elders
embars103812883_embars
endears83710053_endears
enders74324053_enders
escars83913133_escars
eskars10357593_eskars
fears84829393fe__ars
fedoras1137923fedoras
feeders113712863feeders
fenders113717263fenders
feodaries1346373feodaries
feods99516853feod__s
feuars938653fe_uars
feudary1444273feudary
gaydars1235803gaydars
gears64628693ge__ars
gelders93812573gelders
genders93616783genders
geodes8412153geod_es
headers113819393headers
hears86737373he__ars
heders104119763he_ders
heeders114213743heeders
herders113914123herders
heydays1734143heydays
hoars85925553_ho_ars
hodads1147963_hodads
isobars936593isobars
jemadars1842543jemadars
jemidars1843423jemidars
jeopard1744113jeopard
jeopards1843683jeopards
jowars16369653_jowars
kebars124112493ke_bars
keddahs1642923keddahs
leaders83819603leaders
lears55938733le__ars
lekvars1432693lekvars
lenders84419643lenders
leopard1045293leopard
leopards1144753leopards
leotard846193leotard
leotards945303leotards
lidars7310783_lidars
medals94218063me_dals
medlars10259443medlars
melders103213913melders
menders103818803menders
modals93914463_modals
molars85517323_molars
nears55529423ne__ars
nectars938463nectars
needers84111903needers
oars46846033__o_ars
odahs95610083__odahs
odas57230263__oda_s
odors64514283__odors
pears75138613pe__ars
pedals94316033pe_dals
pedlars103210213pedlars
polars84419353_polars
qindars17267423qindars
radars71314673_radars
readers83823773readers
rears54739653re__ars
rebars84019833re_bars
redans75421023re_dans
redders93615343redders
redears82814453redears
regears83012463regears
rehears103312773rehears
renders83821673renders
reorders9198833reorders
retears72814923retears
rewears102911043rewears
roars55622243_ro_ars
sardars83112903sardars
sears54744913se__ars
secpars1138413secpars
sedans74816093se_dans
seders74420283se_ders
seeders83017113seeders
seggars9377783seggars
sendals81912273sendals
senders83022353senders
serdabs1035323serdabs
serovars1145233serovars
sewars94018633se_wars
shofars1335833shofars
sirdars8228213sirdars
soars54732513_so_ars
sodas64123543_soda_s
sofars94712783_sofars
sonars64818973_sonars
sowars94318013_sowars
tears55436463te__ars
tedders94010233tedders
tenders83719723tenders
teopans939203teopans
todays10458103_todays
tolars64817943_tolars
trocars959043trocars
velars93913723ve_lars
venders113717003venders
vendors113510223vendors
wears86030303we__ars
wedders123610723wedders
weeders113412933weeders
welders113313413welders
weldors11238003weldors
years84527673ye__ars
zedoary2043213zedoary

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit1340272837.25018486.5
3Display Results2832830.1102572.7
 (SQL Overall)1786912837.80022909.1
 
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.