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

137 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
attested93629(None) 
attester836501attester
arrested939152arrested
attempted1442562attempted
attended1035762attended
attest62618612attest__
attesters935802attesters
attestor845462attestor
attests7278812attest_s
attrited947372attrited
coattested1342972coattested
detested10279622detested
obtested1135452obtested
retested92212532retested
tested74421522__tested
unattested1143372unattested
untested92612412untested
abetted1058323a_betted
absented1156613absented
accented13107773accented
accepted15105383accepted
accessed1385403accessed
accosted1345513accosted
acetated112010683acetated
actuated1138743actuated
adjusted1743613adjusted
advected1534533advected
adverted1336103adverted
affected1744793affected
agented939423a_gented
agisted938203a_gisted
alerted82512223a_lerted
altered83215733alte_red
amnestied1263633amnestied
anteater8311603anteater
antedated1146703antedated
anteed75616113ante__ed
aptest82917513aptest__
arrestee849443arrestee
arrester839253arrester
artiste73813693artiste_
artistes83213343artistes
assented957513assented
asserted957903asserted
assessed945023assessed
assisted936233assisted
attached14165703attached
attacked15125113attacked
attained997353attained
attainted1044693attainted
attemper12103633attemper
attempter1342963attempter
attend7258973atte__nd
attendee946403attendee
attender935913attender
attent62818323attent__
attenuated1183203attenuated
attestant945973attestant
attesting1036383attesting
attestors945753attestors
attired8238913att_ired
attorned955353attorned
attracted1246073attracted
attrite7311833attrite_
attrites8311563attrites
attritted1044493attritted
attuned835173att_uned
averted112211613a_verted
battened11259573batte_ned
battered113315053batte_red
bested94922753__bested
cathected1744543cathected
chested133811673_chested
contested12310693contested
crested103416533_crested
detected12289733detected
detester9239683detester
devested13239133devested
digested11208163digested
divested13268213divested
egested938123_egested
fattened12268283fatte_ned
fattest102913063fattest__
forested12312463forested
guested9157713_guested
harvested1644093harvested
infested12249643infested
ingested10259003ingested
invested12229693invested
jested144416503__jested
mattered112412903matte_red
molested11178243molested
nattered92011623natte_red
nested74720063__nested
obtected1344553obtected
patented1188893patented
pattened11299393patte_ned
pattered112714203patte_red
patterned1265743patterned
pretested12149113pretested
priested1138393priested
protested12159113protested
quested17168383_quested
rattened9218623ratte_ned
reested82916233_reested
renested92212953renested
rested74430783__rested
retasted92412113retasted
revested122612243revested
stetted82610403_stetted
stressed9128543stressed
talented938423talented
tasted74123973__tasted
tatted74920533tat__ted
tattered92011443tatte_red
teated74924023__teated
tented74221003__tented
testee64323303__testee
tester64227153__tester
testes65125823__testes
toasted84011923_toasted
treated83618703_treated
tressed83714263_tressed
trusted83412793_trusted
trysted11428273_trysted
tweeted11336583_tweeted
twisted11277433_twisted
unrested91914513unrested
untasted92011573untasted
untented92613413untented
unvested122210223unvested
uttered82712433utte_red
vested104217353__vested
wattest102412153wattest__
wrested113410933_wrested
yattered12239533yatte_red
zested164214043__zested

Search took 7 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.500357382.0
2DLD Change Limit1461621376.29623215.1
3Display Results1371370.0632174.6
 (SQL Overall)1786911376.85926052.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.