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

359 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
daunders1027847(None) 
danders93921181da_nders
daunder9348891daunder_
daunters9329841daunters
launders9358741launders
maunders11348341maunders
banders104324562ba_nders
blunders113911332blunders
bounders114314102bounders
damners104112112damn_ers
dancers103413092da_ncers
dander811222992da_nder_
dandlers103912052da_ndlers
dangers94818212da_ngers
darners83815772darn_ers
daubers104610422dau_bers
daundered1294422daundered
daunter83811752daunter_
denuders10165872denuders
dunkers123512192d_unkers
founders123911662founders
funders113813932_funders
ganders93521702ga_nders
handers114224332ha_nders
haunters11329532haunters
hounders123111702hounders
landers84026212la_nders
lauders84012892lau_ders
launder8309142launder_
maunder10328682maunder_
panders103423732pa_nders
plunders11329822plunders
pounders113113262pounders
rounders92613682rounders
sanders84025942sa_nders
saunters82911742saunters
sounders93214102sounders
sunders84120052_sunders
taunters8259262taunters
thunders1236942thunders
vaunters11327742vaunters
wanders114221332wa_nders
zanders173015792za_nders
abiders104011083_abiders
adders84315703_a_dders
aiders74524633_a_iders
alders74218423_a_lders
amenders11288343amenders
angers75222543_a_ngers
asunder856223asunder_
augers73818703_au_gers
aulder7511453_aulder_
bander93928223ba_nder_
bangers104020353ba_ngers
bankers133919093ba_nkers
banners94018713ba_nners
banters94623113ba_nters
benders104021063_benders
binders103920743_binders
blenders115210993blenders
blinders113911143blinders
blunder103813143blunder_
blungers11469843blungers
bonders104120663_bonders
boulders113010023boulders
bouncers12309353bouncers
bounder104215533bounder_
branders114313093branders
budders113812103_budders
bundlers11399183_bundlers
bunkers133715953_bunkers
bunters94717113_bunters
calenders1237403calenders
cancers114018583ca_ncers
candlers114214103ca_ndlers
candors104216763ca_ndors
caners84629193ca_n_ers
cankers134418753ca_nkers
canners93822663ca_nners
canoers94318373ca_noers
canters94827723ca_nters
carders104820353ca_rders
caulkers14375643caulkers
causers94014783cau_sers
chaunters1455813chaunters
chudders15235553chudders
chunters133910893chunters
cinders104617753_cinders
clunkers14327543clunkers
counters103320183counters
cunners93913463_cunners
dabbers123813213da_bbers
dabblers13379363dabblers
dabsters1137053dabsters
dackers143417043da_ckers
daggers103714913da_ggers
daikers124010313da_ikers
dalliers93610613dalliers
damagers1237063damagers
dammers123214273da_mmers
damndest1276003damndest
damndests1392793damndests
damneder1243763damneder_
damner95213433damn_er_
dampers123915693da_mpers
dancer94817613da_ncer_
dances95120653da_nce_s
dandered112110963da_ndered
dandier93714573da_ndier_
dandies94121443da_ndies
dandler94414273da_ndler_
dandles94218533da_ndles
danger83722823da_nger_
danglers103610593danglers
danker114319663da_nker_
danseurs933433da_nseurs
darers75921873da__rers
darndest1067223darndest
darndests1183143darndests
darneder1033983darneder_
darnels83710433darn_els
darner74017303darn_er_
darters84017603da_rters
dashers115016863da_shers
daters74827363da__ters
dauber94112013dau_ber_
daubery13396213dau_bery
daubes94913703dau_be_s
daubier1037093daubier_
daughters1443983daughters
daundering1364463daundering
daunted93810193daunte_d
dauntless1033663dauntless
daunts75014083daun__ts
dauties83315763dautie_s
dawdlers13375673dawdlers
dazzlers1733233dazzlers
debunkers1642703debunkers
deciders123510753deciders
decoders122810413decoders
defenders1436363defenders
degenders1236083degenders
deluders10156433deluders
demanders13247573demanders
deniers84515183d_eniers
denuder9167603denuder_
denudes91510043denude_s
deriders102411853deriders
diners75525953d_in_ers
dingers94321373d_ingers
dinners83915433d_inners
dividers13257213dividers
dodders105511793d_odders
doublers11288493doublers
doubters11257373doubters
dousers84817273dou_sers
downers113912773down_ers
drainers92811253drain_ers
drinkers13277823drinkers
droners84114383dron_ers
drubbers13386023drubbers
drudgers11326843drudgers
druidess1043083druidess
drummers13316163drummers
drunker12326633drunker_
druthers1275793druthers
dubbers124011823d_ubbers
duckers143214713d_uckers
dudes75424373d_u_de_s
duelers83412053d_uelers
duendes938193duende_s
duffers143410093d_uffers
duikers12369383d_uikers
dumpers123412663d_umpers
dunces95215753d_unce_s
dunes65332173d_un_e_s
dunker113616463d_unker_
dunner73913823d_unner_
dunness8298983d_unness
dupers94615603d_u_pers
dusters84918353d_usters
earners74016453earn_ers
eluders8409903elu_ders
emenders11319033emenders
enders74324053__enders
faders105117463fa__ders
fainters11349693fainters
fanners103914653fa_nners
fawners13388493fawn_ers
fenders113717263_fenders
finders113717873_finders
flaunters1234503flaunters
flinders12439263flinders
flounders1374603flounders
flunkers15347533flunkers
founder114312563founder_
funder104016083_funder_
funkers143712063_funkers
gadders103611503ga_dders
gainers84214593gain_ers
gander84322763ga_nder_
gangers94418603ga_ngers
garners83815983garn_ers
gaudery1234743gau_dery
gauffers1563833gauffers
gaugers94211703gau_gers
gaunter82910713gaunter_
genders93616783_genders
glanders103811503glanders
grinders103410423grinders
grounders1156773grounders
grungers10298503grungers
grunters9359023grunters
guarders1035873guarders
guiders94111103_guiders
gunners83111723_gunners
hander104526433ha_nder_
handlers124014143ha_ndlers
hangers113120813ha_ngers
hankers144218133ha_nkers
haulers104012443hau_lers
hauliers1176713hauliers
haunter103111153haunter_
hinders113718503_hinders
hounder113412233hounder_
hungers114013303_hungers
hunkers143314333_hunkers
hunters103915723_hunters
jaunces16307423jaunce_s
joinders16337203joinders
judders16347793_judders
junkers184010863_junkers
ladders94115173la_dders
laders74927763la__ders
lancers93616643la_ncers
lander74028483la_nder_
landlers94312833la_ndlers
lanners73618323la_nners
larders83516943la_rders
lauder73815013lau_der_
laughers1235923laughers
launces9329003launce_s
launchers1454333launchers
laundered1185023laundered
launderer1094513launderer
launderers1183873launderers
laundress1042813laundress
laundry1133513laund_ry
lavenders1334753lavenders
lenders84419643_lenders
loungers9449003loungers
lungers83817083_lungers
lunkers113414603_lunkers
madders113513213ma_dders
malanders1237023malanders
mangers103521263ma_ngers
manners93417833ma_nners
manurers1037593manurers
maulers94213303mau_lers
maundered1394943maundered
maunderer1294193maunderer
maunderers1383753maunderers
maundies1137853maundies
maunds9519653maund__s
meanders1168833meanders
menders103818803_menders
minders103720113_minders
moulders11348333moulders
mounters103712493mounters
mudders113211103_mudders
murders103311363_murders
padders113312873pa_dders
painters103013023painters
pander93725523pa_nder_
paniers94717333pa_niers
panners93621273pa_nners
panniers10488853panniers
panzers184012013pa_nzers
paraders113113113paraders
pardners11269193pardners
paupers114311073pau_pers
pausers94113223pau_sers
pawners124311073pawn_ers
pinders103720473_pinders
plunder103810493plunder_
plungers11379393plungers
plunkers14328323plunkers
ponders103618843_ponders
pouncers12349203pouncers
pounder103313993pounder_
pruners93710723prun_ers
punkers133714853_punkers
punners94114233_punners
punters93617033_punters
raiders84615143ra_iders
rangers83621043ra_ngers
rankers113217463ra_nkers
ranters73323643ra_nters
refunders1334973refunders
relaunders1153103relaunders
renders83821673_renders
roundels9217743roundels
rounder83514593rounder_
rudders93210643_rudders
runners74212453_runners
sander74828533sa_nder_
sangers84421943sa_ngers
saucers93712133sau_cers
sauciers1076733sauciers
saugers83914053sau_gers
saunter72913453saunter_
scunners10357303scunners
senders83022353_senders
shudders13316643shudders
shunners11317743shunners
shunters113210733shunters
slanders94014013slanders
sonders83820713_sonders
sounder83315383sounder_
spenders113211743spenders
spudders12255633spudders
squanders1934443squanders
standers93514303standers
stunners8277923stunners
sunder74019823_sunder_
sundews11398153_sundews
tandems1037633ta_ndems
tankers113416913ta_nkers
tanners74018393ta_nners
taunter73111453taunter_
tenders83719723_tenders
thunder1136963thunder_
thundery1533823thundery
tinders84219173_tinders
trundlers10214993trundlers
tuners64417343_tun_ers
udders83911293__udders
under64624213__under_
undoers82910573__undoers
vanners103612843va_nners
vaulters11206163vaulters
vaunter10309603vaunter_
venders113717003_venders
wadders123812443wa_dders
waders109120643wa__ders
wander104423713wa_nder_
wankers144514713wa_nkers
wanters104420093wa_nters
warders113416813wa_rders
warners103315563warn_ers
winders113721263_winders
wonders113315993_wonders
yarders113211593ya_rders
yarners104312203yarn_ers
yaupers12337663yau_pers
yawners13367183yawn_ers
youngers12336933youngers
younkers15295763younkers
zander163417113za_nder_

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461623597.34619896.8
3Display Results3593590.1402564.3
 (SQL Overall)1786913597.65623340.0
 
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.