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

253 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
eagerer824882(None) 
wagerer11328491wagerer
caperer113013402caperer
caterer92815942caterer
eager65526972eag__er
eagerest9510272eagerest
eagerly1136052eagerly
eagers74523682eager_s
eagre64315322eag_re_
eagres74014572eag_res
enterer72015632enterer
etagere836532etagere_
etageres936862etageres
lagered92311152lagered
paperer113111902paperer
taperer92511792taperer
wagered12299332wagered
wagerers12247612wagerers
waterer103314072waterer
waverer13319522waverer
acerber1135243_acerber
adherer1137573adherer
adorer74713453_adorer
aerier64823153_a_erier
agee56241493_age_e_
agene65621583_agene_
agenes74720253_agenes
ager55935843_ag__er
agers65027853_ager_s
agger76420893_ag_ger
agree65226033_ag_ree
agreed84712503_agreed
agrees74915323_agrees
airer54927893_a_irer
alerter72111513_alerter
alterer72714003alterer
ameer75618983_ame_er
amercer1146373_amercer
angered93013473angered
augurer8136343augurer
averter102410553_averter
badgered1336213badgered
bagger104619203bag_ger
baggier113611643baggier
banterer102811773banterer
barer74535803ba__rer
barterer102711633barterer
batterer102713213batterer
bearer85323913bea__rer
beavered1437503beavered
bergere1068913bergere_
bergeres1189113bergeres
cager85229223cag__er
cagers95624193cager_s
cagier93715933cag_ier
capered123014043capered
caperers122611723caperers
career85822243care_er
careerer1038583careerer
carer74942333ca__rer
catered103117773catered
caterers102814403caterers
cheerer123511753cheerer
coherer122912783coherer
coverer123113523coverer
dagger95017303dag_ger
daggered12246403daggered
dangered11248513dangered
dapperer1335763dapperer
darer65230793da__rer
deadener1036743deadener
dearer74822803dea__rer
dewaterer1343713dewaterer
eagerness1046263eagerness
eagle64219483eag_le_
eagled82914043eag_led
eagles73819163eag_les
eaglet73722583eag_let
eared65139503ea__red
earlier72612743earlier
earner63617223ea_rner
easeled8159863easeled
easier64218463ea_sier
easter65027983ea_ster
easterner945053easterner
eater54639843ea__ter
eateries8324313eateries
eaters65535953eater_s
eatery95316353eater_y
edger75215953edg__er
edgers84413923edger_s
edgier8469733edg_ier
eerier64320023e__erier
eger55923573e_g__er
egers65120373e_ger_s
egger74414413e_g_ger
eggers84612583egger_s
egret63327313e_g_ret
emeer74815363e_me_er
emperor1155483emperor
enameler1045883enameler
endurer83210363endurer
enfever1344643enfever
engager9278603engager
engender1046633engender
ensurer73011903ensurer
entered82718883entered
enterers82214153enterers
evener91010623e_vener
expirer1635993expirer
faggier12309843faggier
fagoter1135883fagoter
fairer95212063fa_irer
fakeer13378743fake_er
falterer11239863falterer
farer86733143fa__rer
favorer1355883favorer
fearer94820183fea__rer
fetterer11207813fetterer
figurer11215863figurer
fingerer12127223fingerer
gager74726293gag__er
gagers84021333gager_s
gagger95016513gag_ger
gagster9317633gagster
galere73716683galere_
galeres83514343galeres
gatherer12147913gatherer
haeres94017033ha_eres
haggler12328933haggler
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
havered144011453havered
haverel13397153haverel
hearer94323643hea__rer
hoverer13319823hoverer
jabberer1944023jabberer
jaeger14397193ja_eger
jager134318133jag__er
jagers144415723jager_s
jaggeder1842783jaggeder
jagger154016003jag_ger
jaggier16339183jaggier
jeerer13389933_jeerer
kedgeree1444383kedgeree
kegeler1245493kegeler
laagered1055853laagered
labeler92310183labeler
laborer9249513laborer
lager65132863lag__er
lagers74826143lager_s
lagger85919833lag_ger
latherer111310453latherer
laveer94110423lave_er
layered11259413layered
leaguer835793leag_uer
leaguered1143223leaguered
letterer8259223letterer
lingerer9118303lingerer
manurer938583manurer
marrer83716673ma_rrer
maturer938983maturer
meager94515203meag__er
meagerly1444003meagerly
meagre9349323meag_re_
meanderer1244733meanderer
measurer1035953measurer
merer75126233__merer
miterer92511333miterer
nagger84016123nag_ger
naggier9309153naggier
nakeder1254363nakeder
nearer64618893nea__rer
offerer1335543offerer
orderer8127943orderer
pager84728203pag__er
pagers94423253pager_s
palterer102411283palterer
pamperer14228333pamperer
panderer112210913panderer
papered122513173papered
paperers122410453paperers
parer75839903pa__rer
patterer103112173patterer
pepperer1145283pepperer
pesterer102412713pesterer
pewterer13256313pewterer
quaverer2054583quaverer
queerer16106503queerer
ragee65432663rage_e_
ragees74618663rage_es
raggeder1143263raggeder
rarer54731703ra__rer
raveler104212463raveler
ravener104110743ravener
rearer64928913rea__rer
renderer9239743renderer
reverer103815833reverer
rogered939553rogered
sabered103213023sabered
sager65432053sag__er
sagger84321073sag_ger
saggered11237553saggered
saggier92912063saggier
sagier73717163sag_ier
savorer1057883savorer
seafarer1144843seafarer
searer65432023sea__rer
serer55935513__serer
severer103511563severer
sheerer103813843sheerer
slaverer11196993slaverer
sneerer73512313sneerer
soberer93110353soberer
staggerer1143923staggerer
steerer73113633steerer
sugarer837323sugarer
swaggerer1442943swaggerer
tabered103311593tabered
taborer9269293taborer
tagger84017713tag_ger
tamperer12248893tamperer
tapered102612933tapered
taperers10269773taperers
taverner1134423taverner
tearer64822903tea__rer
teaseler8176583teaseler
temperer12227723temperer
tenderer9228733tenderer
utterer71910463utterer
vaguer10448443vag_uer
vaporer1236983vaporer
veneerer1145033veneerer
verderer1245373verderer
wafered14288433wafered
wager95925053wag__er
wagers105122203wager_s
wagger113616013wag_ger
wagoner1136093wagoner
wakener1446913wakener
wanderer122210123wanderer
watered113014953watered
waterers112312783waterers
waterier11312083waterier
wavered142910433wavered
waverers14318613waverers
weakener1534913weakener
wearer94319403wea__rer
yager95616753yag__er
yagers105114533yager_s
yammerer15225483yammerer
yarer84321573ya__rer

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272536.26621389.6
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.74926476.7
 
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.