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

342 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
awarder113589(None) 
awarded1236221awarded
awardee1137551awardee
awarders1245071awarders
warder104020271_warder
abrader1038642abrader
awaiter1057442awaiter
award97118042award__
awardees1243992awardees
awards107113452award_s
aware86420022awar_e_
awkwarder2051622awkwarder
boarder103910322boarder
carder94524182_carder
dwarfer1433682dwarfer
guarder936462guarder
harder105022402_harder
hazarder2143602hazarder
hoarder11329232hoarder
larder73720972_larder
rewarder12208232rewarder
swarded1238152swarded
swarmer1247802swarmer
wadder114215482_wadder
wader95325362_wa_der
wander104423712_wander
warded115021042_warded
warden104515512_warden
warders113416812_warders
warier93722892_warier
warmer113816732_warmer
warner93717222_warner
warper114015582_warper
yarder103813972_yarder
abaser86414343aba_ser
abater85518123aba_ter
abider95314463a_bider
aborter939923aborter
abrade9313053abrade_
abraded1138643abraded
abraders1137343abraders
abrades10312073abrades
absurder11134353absurder
acceder1235353acceder
accorder1395223accorder
acerber1135233acerber
acrider1038623acrider
adapter1036173adapter
adder75419593__adder
adorer74713443ador_er
adorner8246973adorner
aerier64823153a_erier
aider65431133__aider
airer54927893a_ir_er
airier64619363a_irier
alarmed1037733alarmed
alder65421913__alder
alerter72111513alerter
amasser9418733amasser
amender10349613amender
amercer1146373amercer
anadem939183ana_dem
angrier839023angrier
ardeb8314523__ardeb
ardor64617863__ardor
arider74717743a_rider
armer76924443__armer
arrayer10136703arrayer
asunder856223asunder
aulder7511453a_ulder
averter102410553averter
avoider1155813avoider
awaited1146963awaited
awaiters1146643awaiters
awake125014783awa_ke_
awaked14579203awa_ked
awaken13468863awa_ken
awakener1543433awakener
awakes135012473awa_kes
awarding1356043awarding
aweather1434263aweather
badder103817513_badder
balder95318863_balder
bander93928223_bander
barber104419323_barber
barde85330773_barde_
barded105426423_barded
bardes95026933_bardes
barer74535803_bar_er
barker124822863_barker
barter85525373_barter
beader94623793bea_der
bearded114212133bearded
bearer85323913bear_er
birder94915493_birder
bladder11429153bladder
blader93618583bla_der
blander103715163blander
boarded113910503boarded
boarders11408623boarders
border94419973_border
braider105112993braider
brander103915823brander
carded105424903_carded
carders104820353_carders
career85822243_career
carer74942333_car_er
carper104923633_carper
carter84932273_carter
carver114420143_carver
charger133914063charger
charier124317903charier
charmer144913663charmer
charter123918303charter
coarser93211193coarser
corder94322873_corder
dander811222993_dander
darer65230793_dar_er
darker114718693_darker
darner74017303_darner
darter75320363_darter
deader84220473dea_der
dearer74822803dear_er
dwarfed1533483dwarfed
dwarves1434463dwarves
earner63617223_earner
evader1036813eva_der
fader94421513_fa_der
farcer115016083_farcer
farded114518953_farded
fardel104712593_fardel
farer86733143_far_er
farmer115017373_farmer
fearer94820183fear_er
forwarder1644133forwarder
gadder93714713_gadder
gander84322763_gander
garden84215083_garden
garner73917003_garner
garter74420513_garter
girder84312063_girder
gladder10398313gladder
glarier84112203glarier
grader84919693gra_der
grander93315873grander
guarded1036153guarded
guarders1035873guarders
hander104526433_hander
harden105718533_harden
hardier114721543_hardier
harmer114719553_harmer
harper115018403_harper
hazarded2243643hazarded
hazarders2243023hazarders
header104422543hea_der
hearer94323643hear_er
herder104516463_herder
hoarded12368343hoarded
hoarders12307433hoarders
hoarier104211743hoarier
hoarser10388393hoarser
ladder84617623_ladder
lader65633723_la_der
lander74028483_lander
larded84319093_larded
larders83516943_larders
lardier83518343_lardier
larger74417513_larger
larker104519243_larker
lauder73815013_lauder
leader74824653lea_der
learier73415663learier
learner7319383learner
loader74316303loa_der
madder103515593_madder
marauder1144553marauder
marker124420393_marker
marrer83716673_marrer
meander1049973meander
murder93613783_murder
nearer64618893near_er
order65019363__order
padder103415493_padder
pander93725523_pander
parader103914863_parader
pardee93922023_pardee
pardner10239473_pardner
parer75839903_par_er
parker124121373_parker
parser84822373_parser
pearler9310363pearler
pearter9412743pearter
quarter163211853quarter
raider74318743_raider
rarer54731703_rar_er
reader73628293rea_der
rearer64928913rear_er
reorder8239483reorder
retarder9229433retarder
rewarded13229523rewarded
rewarders13226453rewarders
roarer63914333roar_er
sadder82916973_sadder
sander74828533_sander
sardar73013173_sardar
scarcer113911373scarcer
scareder1135783scareder
scarer84524603scar_er
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
searer65432023sear_er
shader104218763sha_der
sharer95025483shar_er
sharker144313813sharker
sharper124312703sharper
slander84015443slander
smarter94113133smarter
snarer64620843snar_er
snarler73610633snarler
soarer64522243soar_er
spader94317133spa_der
sparer84524963spar_er
sparger103613073sparger
sparker133914353sparker
sparser94311483sparser
staider83912613staider
stander84316163stander
starer64027363star_er
starker114114693starker
starter73817873starter
starver104611993starver
swabber14297963swabber
swager104013613swa_ger
swagger12389333swagger
swamper14349313swamper
swanker14369483swanker
swapper14359703swapper
sward94221463sward__
swards105415133sward_s
sware85828213swar_e_
swarmed1367483swarmed
swarmers1346323swarmers
swasher134011503swasher
swather134213593swather
swatter104113323swatter
swayer125210973swa_yer
swearer10349953swear_er
swerver1365733swerver
tabarded1234743tabarded
tardier859719993_tardier
tarter64023563_tarter
tawdrier12133433tawdrier
tearer64822903tear_er
tearier73815613tearier
thwarter1433393thwarter
trader75218753tra_der
twaddler13314643twaddler
twanger11327433twanger
twirler10285203twirler
unawarded1444923unawarded
unwarier1136883unwarier
varier94619353_varier
vaward13498723vaward__
vawards14457573vaward_s
wacker154920123_wacker
wadded124014173_wadded
wadders123812443_wadders
waddler124010793_waddler
wade85237063_wa_de_
waded106024753_wa_ded
waders109120643_wa_ders
wades95634143_wa_des
wafer114417643_wa_fer
wafter124114613_wafter
wager95925053_wa_ger
wagger113616013_wagger
wailer93720323_wailer
waiter94321253_waiter
waiver124212713_waiver
waker125526593_wa_ker
waler84229263_wa_ler
walker133913993_walker
wanders114221333_wanders
wanier93920683_wanier
wanker134219973_wanker
wanner94019623_wanner
wanter94423053_wanter
warbler123211463_warbler
ward86542253_ward__
wardenry1542973_wardenry
wardens113711903_wardens
wards97734403_ward_s
ware76254723_war_e_
wared96339873_war_ed
wares88250583_war_es
warked144421213_warked
warmed124516893_warmed
warmers124514293_warmers
warned104018913_warned
warners103315563_warners
warped124816413_warped
warpers123413583_warpers
warred104019843_warred
warren95012853_warren
warsler10289893_warsler
warted104223233_warted
wartier103413913_wartier
washer124720393_washer
waster95228943_waster
water84733313_wa_ter
watter93221983_watter
waver115025703_wa_ver
wavier124613083_wavier
waxer154317483_wa_xer
waxier16439903_waxier
wearer94319403wear_er
wearier103613283wearier
wedder113612293_wedder
weeder103315513_weeder
weirder1144923weirder
welder102914413_welder
widder112913973_widder
wider94826353_w_ider
wilder103616473_wilder
winder104025263_winder
wirer85124953_wir_er
wirier94215553_wirier
wonder103617813_wonder
worded114316623_worded
wordier112511203_wordier
worker134715113_worker
wormer114514913_wormer
worser95117523_worser
wrier84521753_w_rier
wryer11489303_w_ryer
yarded114714023_yarded
yarders113211593_yarders
yarer84321573_yar_er
yarner93313063_yarner
yearner10336873yearner
zander163417113_zander

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.1561145455.1
2DLD Change Limit1340273427.03019065.0
3Display Results3423420.1103109.1
 (SQL Overall)1786913427.29624491.6
 
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.