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

148 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
besetters1113664(None) 
begetters12135041begetters
besetter10137981besetter_
resetters9129461resetters
bedwetters1642272bedwetters
beetlers1037402be_etlers
begetter11136312begetter_
bespatters1442782bespatters
betatters1134962betatters
betters94422092b__etters
bonesetters1352632bonesetters
deserters10129982deserters
insetters9187132insetters
reletters9138782reletters
resetter81511832resetter_
setters73822062__setters
upsetters1143652upsetters
abetters1057173_abetters
absenters1156173absenters
assenters966993assenters
asserters956393asserters
basters94930303bas__ters
batters94626013b__atters
beaters94925043b__eaters
bedwetter1542663bedwetter_
beefeaters1553233beefeaters
beepers113612383be_e_pers
beetler938043be_etler_
beetles9312083be_etle_s
beezers18349243be_e_zers
beheaders1545153beheaders
bejeebers2042283bejeebers
belittlers1242023belittlers
belters93819413b__elters
benefiters1543343benefiters
bereavers1446123bereavers
berettas1046733berett_as
berserkers1642953berserkers
beseechers1742683beseechers
beseems1175913bese__ems
besetment1346953besetment
besetments1445293besetments
besets85718803bese_t__s
besetting12268423besetting
beshivers1743713beshivers
besiegers1244053besiegers
besmearers1442833besmearers
besotted1135843besotte_d
bespatter1343143bespatter_
bestirs9311133bes__tirs
bestowers14135333bestowers
bestrews1335603bes_trews
betatter1035453betatter_
better84723703b__etter_
bettors93312473b__ettors
bevelers13389463beve_lers
bevellers14276143bevellers
bimesters1336343bimesters
bisectors1345733bisectors
bisters93922613bis__ters
bitters94920363b__itters
blatters104414093b_latters
bleaters103412323b_leaters
blethers13429613b_lethers
blotters104110983b_lotters
bonesetter1253183bonesetter_
burettes1048953burette_s
busters94724133bus__ters
bustiers103810053bus_tiers
bustlers104210623bus_tlers
butters94521723b__utters
casettes1039653casette_s
cementers1338313cementers
decenters122410373decenters
defeaters13289103defeaters
desalters1037673desalters
deserter91211603deserter_
deservers13107293deservers
detecters12217753detecters
detesters10298303detesters
emitters10349643_emitters
enfetters1244463enfetters
erecters102611613_erecters
esters64627733_es__ters
festers104121393fes__ters
fetters103517903__fetters
fretters113410303_fretters
genettes938303genette_s
getters84216103__getters
hesitaters1374853hesitaters
inserters92210283inserters
insetter8218593insetter_
jesters144118193jes__ters
keesters12319593ke_esters
letters73819853__letters
meeters94714543me_e_ters
mesentera1144653mesentera
mesentery1444843mesentery
misenters1139533misenters
musettes1037433musette_s
nesters74422793nes__ters
nestlers8359233nes_tlers
netters73618583__netters
newsletters14141693newsletters
pacesetters1552023pacesetters
pesterers112510463pesterers
pesters93827093pes__ters
petters93722363__petters
pinsetters1244103pinsetters
presenters1239863presenters
rebutters1195093rebutters
reenters82915303re_enters
regretters1144093regretters
reheaters122010273reheaters
rejecters18257543rejecters
reletter81311023reletter_
remitters11328403remitters
repeaters112811993repeaters
repenters112511553repenters
resellers9299933resellers
reservers12138103reservers
resettles936563resettles
resisters9310453resisters
resorters939693resorters
respecters1445863respecters
resters74130403res__ters
reutters8138573re_utters
reverters122710433reverters
rosettes8310343rosette_s
seaters74028943__seaters
semesters1139123semesters
settees73513633__settees
setter64023723__setter_
settlers8289023__settlers
sitters74221553__sitters
teeters74018303te_e_ters
teethers11328713te_ethers
testers74124543tes__ters
tetters74320473__tetters
typesetters1651693typesetters
unfetters1244363unfetters
upsetter1034643upsetter_
vedettes1265943vedette_s
vetters104016323__vetters
westers105221963wes__ters
wetters103817753__wetters
whetters14246653_whetters
zesters163517293zes__ters

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411486.53022762.8
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.02925422.0
 
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.