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

183 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
besetter1013797(None) 
begetter11136311begetter
besetters11136631besetters
resetter81511831resetter
bedwetter1542662bedwetter
beetler938032be_etler
begetters12135042begetters
besotted1135842besotted
bespatter1343142bespatter
betatter1035452betatter
better84723702b__etter
bonesetter1253182bonesetter
deserter91211602deserter
insetter8218592insetter
reletter81311022reletter
resetters9129462resetters
setter64023722__setter
upsetter1034642upsetter
abetter958323_abetter
absenter1086773absenter
assenter867703assenter
asserter877573asserter
bassetted1244693bassetted
baster85333593bas__ter
batter84928873b__atter
beater84729393b__eater
bedotted1234983bedotted
bedwetters1642273bedwetters
beefeater1443603beefeater
beefier12329093be_efier
beeper103714093be_e_per
beerier93613023be_erier
beetle8311673be_etle_
beetled1038213be_etled
beetlers1037393be_etlers
beetles9312083be_etles
beezer174010523be_e_zer
befitted14305723befitted
befretted1544373befretted
begotten1143243begotten
beheader1436043beheader
belittler1142493belittler
belter84720963b__elter
benefiter1443733benefiter
bereaver1346673bereaver
beretta938463berett_a
berettas1046733berettas
berserker1543223berserker
beseecher1643143beseecher
beseem1069083bese__em
beseemed1334853beseemed
beset76739133bese_t__
besetment1346953besetment
besets85718803bese_t_s
besetting12268423besetting
beshiver1634483beshiver
besieger1144673besieger
besmearer1343163besmearer
besmutted1442683besmutted
bespatters1442783bespatters
bested94922753bes__ted
bestir8311163bes__tir
bestower13126203bestower
bestrew1248003bes_trew
betatters1134963betatters
betted94721163b__etted
betters94422093b__etters
bettor83612223b__ettor
beveler124010683beve_ler
beveller13387663beveller
bimester1236163bimester
bisected1336203bisected
bisector1245193bisector
bister84922763bis__ter
bitter84622673b__itter
blatter94415653b_latter
bleater94515303b_leater
blether12459913b_lether
blotter94612853b_lotter
bonesetters1352633bonesetters
brevetted1543863brevetted
burette939853burette_
burettes1048953burettes
buster84726493bus__ter
bustier93916153bus_tier
bustler94012563bus_tler
butter84724233b__utter
casette9310393casette_
casettes1039653casettes
cementer1239193cementer
decenter112412163decenter
defeater122611663defeater
desalter938363desalter
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
detecter11298733detecter
detester9239683detester
emitter93211083_emitter
enfetter1145353enfetter
erecter93113393_erecter
ester54727713_es__ter
fester94723513fes__ter
fetter94120383__fetter
fretter103412753_fretter
genette838863genette_
genettes938303genettes
getter74117613__getter
hesitater1276923hesitater
inserter82312133inserter
insetted9249023insetted
insetters9187133insetters
jester134319153jes__ter
keester11319913ke_ester
letter63722583__letter
meeter83616503me_e_ter
mesentera1144653mesentera
mesentery1444843mesentery
misenter10310833misenter
musette938433musette_
musettes1037433musettes
nester64124183nes__ter
nestler73510443nes_tler
netter63722023__netter
newsletter13152133newsletter
pacesetter1452393pacesetter
pester84827593pes__ter
pesterer102412703pesterer
pestier94317403pes_tier
petter83924773__petter
pinsetter1145013pinsetter
presenter11311643presenter
rebutter10106273rebutter
recenter102715443recenter
reenter73217793re_enter
regretter1045973regretter
reheater113413033reheater
rejecter17258943rejecter
reletters9138783reletters
remitter102810323remitter
repeater102615443repeater
repenter102813863repenter
reseated93220263reseated
resected112514743resected
reseller83412223reseller
resented92716963resented
reserver11119633reserver
resettle837303resettle
resettled1035303resettled
resettles936563resettles
resister8311653resister
resorter8312183resorter
respecter1347443respecter
rester63832433res__ter
reutter71010093re_utter
reverter114812873reverter
revetted122210943revetted
rewetted12228353rewetted
rosette7310373rosette_
rosettes8310343rosettes
seater64534163__seater
semester1038903semester
settee63721023__settee
setters73822063__setters
settler73410653__settler
sitter63323383__sitter
teeter65420313te_e_ter
teether10349693te_ether
tester64227153tes__ter
testier74015643tes_tier
tetter64322453__tetter
typesetter1551823typesetter
unfetter1136753unfetter
upsetters1143653upsetters
vedette1166003vedette_
vedettes1265943vedettes
vetter93417643__vetter
wester94222893wes__ter
wetter93919443__wetter
whetter13348803_whetter
yester93417983yes__ter
zester153617793zes__ter
zestier163010223zes_tier

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.436409841.7
2DLD Change Limit1461621837.33019940.2
3Display Results1831830.0762407.9
 (SQL Overall)1786911837.84222786.4
 
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.