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

129 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
attester83650(None) 
attested936291attested
attesters935801attesters
attestor845461attestor
anteater8311602anteater
arrester839252arrester
attemper12103632attemper
attempter1342962attempter
attender935912attender
attest62618612attest__
attestors945752attestors
attests7278812attest_s
detester9239682detester
tester64227152__tester
abetter958323a_better
absenter1086773absenter
accepter14144933accepter
adepter1036113a_depter
adjuster1644353adjuster
affecter1644523affecter
alerter72111513a_lerter
alterer72713993alte_rer
ammeter1148393amme_ter
ancestor1046853ancestor
anteaters939343anteaters
antsier7410773ant_sier
aptest82917513aptest__
arrested939153arrested
arrestee849443arrestee
arresters948193arresters
arrestor847653arrestor
artiste73813693artiste_
artistes83213343artistes
artsier768943art_sier
assenter867703assenter
asserter877573asserter
assister836753assister
aster55434893a___ster
atelier7311623a_telier
attacher13125713attacher
attacker14144983attacker
attainer8116913attainer
attempers13103503attempers
attempted1442563attempted
attempters1442663attempters
attended1035763attended
attendee946403attendee
attenders1045273attenders
attent62818323attent__
attestant945973attestant
attesting1036383attesting
attracter1146093attracter
attrite7311833attrite_
attrited947373attrited
attrites8311563attrites
atwitter1143673atwitter
auguster943953auguster
averter102410553a_verter
battener10369393batte_ner
batterer102713213batte_rer
bimester1236163bimester
catheter1338153cathe_ter
coattested1342973coattested
contester11311183contester
cutesier1045623cutesier
cytaster1383863cytaster
detecter11298733detecter
detested10279623detested
detesters10298303detesters
diester83013683_diester
digester10258433digester
dopester1137253dopester
ester54727713___ester
fattener11268113fatte_ner
fattest102913063fattest__
fester94723513__fester
forester11313673forester
gamester1137323gamester
harvester1544333harvester
honester1139713honester
infester11239433infester
jester134319153__jester
jokester1934443jokester
keester11319913_keester
kiester11329973_kiester
maltster1035303malt_ster
modester1197483modester
molester1099373molester
nester64124183__nester
obtested1135453obtested
patienter1145553patienter
patterer103112173patte_rer
pester84827593__pester
prester93519623_prester
protester111510483protester
quester161410023_quester
rattener8238533ratte_ner
rester63832433__rester
retested92212533retested
rimester1037813rimester
semester1038903semester
tapster9299273_tapster
taster64930573__taster
tatter64024573tat__ter
teeter65420313__teeter
tenter64623933__tenter
tested74421523__tested
testee64323303__testee
testers74124543__testers
testes65125823__testes
testier74015643__testier
tetter64322453__tetter
theater104014253_theater
tipster9299053_tipster
toaster74414463_toaster
treater74219833_treater
truster73114313_truster
tryster10369513_tryster
tweeter10288533_tweeter
twister10308953_twister
unattested1143373unattested
untested92612413untested
utterer71910463utte_rer
wattest102412153wattest__
wattmeter1443723wattmeter
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
zester153617793__zester

Search took 9 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.450397091.1
2DLD Change Limit1461621297.53319402.9
3Display Results1291290.0462804.3
 (SQL Overall)1786911298.02922255.7
 
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.