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

224 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
resetters912946(None) 
besetters11136631besetters
reletters9138781reletters
resetter81511831resetter_
begetters12135042begetters
besetter10137972besetter_
deserters10129982deserters
insetters9187132insetters
presenters1239862presenters
rebutters1195092rebutters
reenters82915302re_enters
regretters1144092regretters
reheaters122010272reheaters
rejecters18257542rejecters
reletter81311022reletter_
remitters11328402remitters
repeaters112811992repeaters
repenters112511552repenters
resellers9299902resellers
reservers12138102reservers
resettles936562resettles
resisters9310452resisters
resorters939692resorters
respecters1445862respecters
resters74130402res__ters
reutters8138572re_utters
reverters122710432reverters
rosettes8310342rosette_s
setters73822062__setters
upsetters1143652upsetters
abetters1057173_abetters
absenters1156173absenters
assenters966993assenters
asserters956393asserters
bedwetters1642273bedwetters
beetlers1037393be_etlers
begetter11136313begetter_
bespatters1442783bespatters
betatters1134963betatters
betters94422093__betters
bonesetters1352633bonesetters
casettes1039653casette_s
cementers1338313cementers
decenters122410373decenters
defeaters13289103defeaters
desalters1037673desalters
deserter91211603deserter_
deservers13107293deservers
detecters12217753detecters
detesters10298303detesters
emitters10349643_emitters
enfetters1244463enfetters
erecters102611613_erecters
esters64627733_es__ters
festers104121393fes__ters
fetters103517903__fetters
fretters113410303_fretters
frisettes1295353frisette_s
genettes938303genette_s
getters84216103__getters
greeters92610113gre_e_ters
grisettes1094713grisette_s
hesitaters1374853hesitaters
inserters92210283inserters
insetter8218593insetter_
jesters144118193jes__ters
keesters12319593ke_esters
letters73819853__letters
meeters94714543me_e_ters
mesentera1144653mesentera
mesentery1444843mesentery
misenters1139533misenters
musettes1037433musette_s
nesters74422793nes__ters
nestlers8359223nes_tlers
netters73618583__netters
newsletters14141693newsletters
pacesetters1552023pacesetters
pesterers112510453pesterers
pesters93827093pes__ters
petters93722363__petters
pinsetters1244103pinsetters
preheaters1557193preheaters
presbyters1743183presbyters
presentees1247923presentees
presenter11311643presenter_
preservers15115693preservers
presettles1245023presettles
presters103419003pres__ters
preventers1547393preventers
rasters74629023ras__ters
ratters74422473r__atters
realters83614043re_alters
rebaters103413943re_baters
rebutter10106273rebutter_
recanters112310483recanters
receivers1436363receivers
recenter102715443recenter_
receptors1356923receptors
reciters102613113re_citers
redeemers1244813redeemers
reefers103312593re_e_fers
reekers113613143re_e_kers
reelers73520273re_e_lers
reenter73217793re_enter_
referrers12125373referrers
refilters1236103refilters
refuters11449613re_futers
regathers1336353regathers
registers1038893registers
regretter1045973regretter_
reheater113413033reheater_
reinters82614773re_inters
rejectees18235423rejectees
rejecter17258943rejecter_
rejectors18247613rejectors
relaters83218153re_laters
releasers937323releasers
relettered1144333relettered
remasters11310583remasters
remembers1544493remembers
remitter102810323remitter_
remittors11256283remittors
renegers9248793rene_gers
renewers11238183rene_wers
renters74224813r__enters
rentiers83311763re_ntiers
repattern1143663repattern
repatterns1242493repatterns
repealers11278843repealers
repeater102615443repeater_
repellers11278873repellers
repenter102813863repenter_
reporters1139173reporters
requesters1944323requesters
requiters18176553requiters
rescuers1037363res_cuers
reseated93220263reseate_d
reseats74319583reseat__s
resected112514743resecte_d
resects94115593resect__s
resecures1146733resecures
reseeds84012333rese__eds
reseeks11348623rese__eks
resees63827483rese__e_s
reseizes1759853reseize_s
reseller83412223reseller_
resemblers1443413resemblers
resented92716963resente_d
resents74221223resent__s
reserver11119633reserver_
reserves111011983reserve_s
resets65427613rese_t__s
resetting102816293resetting
resettle837303resett_le
resettled1035303resettled
reshapers1435493reshapers
reshowers15145473reshowers
residers93311883res_iders
resigners1036863resigners
resilvers12306503resilvers
resister8311653resister_
resistors947993resistors
resites74027793res_ite_s
reslates83619503reslate_s
resoftens1243713resoftens
resolders10258013resolders
resolvers12297833resolvers
resorter8312183resorter_
respecter1347443respecter_
respites10513243respite_s
restates83423433restate_s
rester63832433res__ter_
restless82713163res_tless
restorers95110113restorers
restores85222993res_tores
restress82511773res_tress
resumers1038083res_umers
retempers1345023retempers
retorters938773retorters
retreaters1047543retreaters
reuniters936423reuniters
reutter71010093re_utter_
revealers12318243revealers
revelers113414133reve_lers
revellers12319503revellers
revengers1336413revengers
revenuers1235983revenuers
reverers113113153reve_rers
reversers12298483reversers
reverter114812873reverter_
revetted122210943revette_d
revolters12297483revolters
rewetted12228353rewette_d
rewriters1236343rewriters
rimesters1137483rimesters
ritters74020623r__itters
riveters11228163rive_ters
rosette7310373rosette__
rosters73727543ros__ters
rotters74421393r__otters
rustlers8339853rus_tlers
seaters74028943__seaters
semesters1139123semesters
settees73513633__settees
setter64023723__setter_
settlers8289023__settlers
sitters74221553__sitters
teeters74018303te_e_ters
teethers11328713te_ethers
testers74124543tes__ters
tetters74320473__tetters
trendsetters1351073trendsetters
typesetters1651693typesetters
unfetters1244363unfetters
upsetter1034643upsetter_
vedettes1265943vedette_s
vetters104016323__vetters
westers105221963wes__ters
wetters103817753__wetters
whetters14246653_whetters
wresters112711733wres__ters
wrestlers12306103wres_tlers
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.420425454.8
2DLD Change Limit1486412246.87621617.4
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.38924183.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.