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

222 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
wagoners123547(None) 
waggoners1443181waggoners
wagoner1136091wagoner_
agones75719862_agone_s
atoners75013952_atoners
fagoters1234862fagoters
goners74420172__goners
wagerers12247612wagerers
wagers105122202wag__ers
waggers124613082wag_gers
waggoner1343422waggoner_
wagoned1256222wagone_d
wagons103911212wagon__s
wakeners1535842wakeners
wantoners12116672wantoners
warners103315562wa_rners
adorers84411733_adorers
adorners9196623_adorners
agenes74720253_agene_s
agers65027853_ag__ers
aggers85817793_ag_gers
aginners954623_aginners
agone65924553_agone__
agonies83016623_agonies
agons66423783_agon__s
aliners74717723_aliners
almners9399563_almners
almoners1068133almoners
atoner64817193_atoner_
atones65225773_atone_s
avowers1336333_avowers
awakeners1643093awakeners
axones134614513_axone_s
baggers113915693bag_gers
baloneys1334663baloneys
banners94018713ba_nners
baroness101210063baroness
baronets101410903baronets
bayonets13135583bayonets
blazoners2043863blazoners
boners84825433__boners
bygones1335913bygone_s
cagers95624193cag__ers
caginess11310303caginess
cajolers17267133cajolers
cajones163311333cajone_s
caloyers1337343caloyers
caners84629203ca__ners
canners93822663ca_nners
canoers94318373cano_ers
canoness1039393canoness
caponiers1345733caponiers
carolers103314173carolers
cloners94514823_cloners
coroners104016223coroners
crayoners1444503crayoners
crooners103911393crooners
daggers103714913dag_gers
dagoes85714603dago_e_s
damners104112113da_mners
darners83815773da_rners
deboners11268113deboners
dragonets11134503dragonets
droners84114383_droners
eagers74523683eag__ers
earners74016453ea_rners
fagoter1135883fagoter_
falconers1445323falconers
fanners103914653fa_nners
favorers1465493favorers
fawners13388493fa_wners
gagers84021333gag__ers
gaggers103413663gag_gers
gagsters10317083gagsters
gainers84214593ga_iners
gammoners1444563gammoners
gaolers83511563ga_olers
garners83815983ga_rners
goers65520253__go_ers
gofers104711513__gofers
gomers94116883__gomers
gonefs10439873__gonefs
goner66025163__goner_
hagglers13326623hagglers
hangovers16144163hangovers
honers94324973__honers
imaginers1243693imaginers
intoners889933intoners
ironers74813553_ironers
jaconets1745613jaconets
jagers144415723jag__ers
jaggers164012893jag_gers
jargoneers1842333jargoneers
jargonels1743153jargonels
jawboners21133053jawboners
laborers10208383laborers
lagers74826143lag__ers
laggers94216243lag_gers
lagunes8148523lagune_s
lanners73618333la_nners
layovers1434073layovers
loners64225813__loners
magnets10311143mag_nets
mangonels1294373mangonels
manners93417833ma_nners
mariners103113863mariners
mooners94015343_mooners
naggers93812653nag_gers
orgones81010793orgone_s
pagers94423253pag__ers
panners93621273pa_nners
pardners11269193pardners
pardoners12208213pardoners
partners102711133partners
pawners124311073pa_wners
ratooners965833ratooners
raveners11309133raveners
reasoners947113reasoners
sageness92111983sageness
saggers94017083sag_gers
savorers1157223savorers
seasoners946263seasoners
signers84714443sig_ners
sooners73916643_sooners
stoners74817953_stoners
swagers114211023swag__ers
swaggers13407223swag_gers
swooners11336863swooners
taborers10268333taborers
taggers93514193tag_gers
tanners74018393ta_nners
tenoners858713tenoners
toners64128003__toners
vanners103612843va_nners
vaporers1336243vaporers
wabblers15398993wabblers
wadders123812443wa_dders
waddlers13298333waddlers
waders109120643wa__ders
waeness102512783wa_eness
wafers124316143wa__fers
wafflers17306323wafflers
wafters134112813wa_fters
wageless1237173wageless
wager95925053wag__er_
wagerer11328493wagerer_
wages95330933wag__e_s
wagger113616013wag_ger_
waggery15276903wag_gery
waggles123812003waggle_s
waggoned1443253waggone_d
waggons1235503waggon__s
wagon94312953wagon___
wagonage1343293wagonage
wagonages1443303wagonages
wagonette1343353wagonette
wagonettes1442913wagonettes
wagoning1336923wagoning
wahines133111173wahine_s
wailers103916803wa_ilers
waisters113811523waisters
waiters104218623wa_iters
waivers133410053wa_ivers
wakener1446913wakener_
wakers134822493wa__kers
walers94824463wa__lers
walkers143411473wa_lkers
walkovers1942613walkovers
wallopers14136273wallopers
wallowers15127653wallowers
waltzers2034003waltzers
wanders114221333wa_nders
wanes85040883wa__ne_s
wanglers123310033wanglers
wankers144514713wa_nkers
wanner94019623wa_nner_
wanness102610683wa_nness
wanters104420093wa_nters
wantoner1187563wantoner_
warblers13319103warblers
warders113416813wa_rders
wariness11313213wariness
warmers124514293wa_rmers
warmness1337063warmness
warmongers1643633warmongers
warner93717223wa_rner_
warpers123413583wa_rpers
warpowers1744553warpowers
warreners1236193warreners
warslers11328073warslers
washers134517523wa_shers
wasters104026593wa_sters
watchers163511793watchers
waterers112312783waterers
waters95030633wa__ters
waverers14318613waverers
wavers125022473wa__vers
waviness1437723waviness
waxers164014303wa__xers
waxiness1836723waxiness
weakeners1644163weakeners
weaners104613833w_eaners
weaponeers1542003weaponeers
weiners103913063w_einers
whiners134011573w_hiners
whoopers16286263whoopers
wideners12257993wideners
widowers1535113widowers
wieners103212483w_ieners
wigglers13257213wigglers
wingovers1643553wingovers
winners104316913w_inners
wonders113315993w__onders
wonners104312813w_onners
wooers93712443w__ooers
woofers133810583w_oofers
woolers104214023w_oolers
wrongers12327773w_rongers
yagers105114533yag__ers
yarners104312203ya_rners
yawners13367183ya_wners
zoners155115993__zoners

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.406440125.6
2DLD Change Limit1461622227.12620511.1
3Display Results2222220.0932387.1
 (SQL Overall)1786912227.62523434.9
 
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.