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

101 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
attesters93580(None) 
attester836501attester_
attestors945751attestors
anteaters939342anteaters
arresters948192arresters
attempers13103502attempers
attempters1442662attempters
attenders1045272attenders
attested936292atteste_d
attestor845462attestor_
attests7278812attest__s
detesters10298302detesters
testers74124542__testers
abetters1057173a_betters
absenters1156173absenters
accepters15114603accepters
adjusters1744163adjusters
affecters1763933affecters
alterers82512493alte_rers
ammeters1237693amme_ters
ancestors1147233ancestors
anteater8311603anteater_
arrestees946233arrestees
arrester839253arrester_
arrestors958033arrestors
artistes83213343artiste_s
assenters966993assenters
asserters956393asserters
assisters936353assisters
asters65631603a___sters
ateliers837883a_teliers
attachers14134883attachers
attackers15144013attackers
attainers9115593attainers
attemper12103633attemper_
attempter1342963attempter_
attendees1044053attendees
attender935913attender_
attest62618613attest___
attestant945973attestant
attestants1053903attestants
attesting1036383attesting
attracters1245113attracters
attrites8311563attrite_s
averters11249513a_verters
batteners11238163batte_ners
batterers113110713batte_rers
bimesters1336343bimesters
catheters1437013cathe_ters
contesters12410183contesters
cytasters1483663cytasters
detecters12217753detecters
detester9239683detester_
diesters92513603_diesters
digesters11257883digesters
dopesters1237283dopesters
esters64627733___esters
fatteners12236873fatte_ners
festers104121393__festers
foresters12312533foresters
gamesters1236733gamesters
harvesters1644143harvesters
infesters12237713infesters
jesters144118193__jesters
jokesters2044443jokesters
keesters12319593_keesters
kiesters123310153_kiesters
maltsters1135193malt_sters
molesters1198873molesters
nesters74422793__nesters
patterers112410123patte_rers
pesters93827093__pesters
presters103419003_presters
protesters12169383protesters
questers17168763_questers
ratteners9237263ratte_ners
resters74130403__resters
rimesters1137483rimesters
semesters1139123semesters
tapsters10318803_tapsters
tasters74225643__tasters
tatters74520483tat__ters
teeters74018303__teeters
tenters73921103__tenters
testees74215913__testees
tester64227153__tester_
testes65125823__teste_s
tetters74320473__tetters
theaters114211903_theaters
tipsters10278513_tipsters
toasters83912723_toasters
treaters83615843_treaters
trusters83112263_trusters
trysters11298373_trysters
tweeters11287143_tweeters
twisters11268173_twisters
utterers8218653utte_rers
wattmeters1543603wattmeters
westers105221963__westers
wresters112711733_wresters
zesters163517293__zesters

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.406440125.6
2DLD Change Limit1486411017.01621186.0
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.46823927.6
 
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.