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

156 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
aspersed1142829(None) 
asperse94210661asperse_
asperser10408301asperser
asperses104111671asperses
appeased1335792appeased
asperated1239312asperated
asperges11318092asperges
aspers86220312aspers__
aspersers11377242aspersers
aspersor10336232aspersor
aspired1068172aspir_ed
asserted957902asserted
assessed945022assessed
dispersed13119782dispersed
abscessed1442703abscessed
absterged1353353absterged
accessed1385403accessed
accursed1354633accursed
adhered1239233adher_ed
adverse1145953adverse_
adverted1336103adverted
aeried74221863a__eried
alerted82512223a_lerted
altered83215733alter_ed
amerced1256523a_merced
ampere10514413amper_e_
amperes11313983amper_es
ampersand1443793ampersand
angered93013473anger_ed
answered1235493answer_ed
aperies9423203a_peries
apers76629133a_pers__
appealed1335603appealed
appeared1336143appeared
appease1137913appease_
appeaser1245953appeaser
appeases1238663appeases
appended1435483appended
apposed1247853a_pposed
appressed1445943appressed
apprised1337713apprised
ascared10399523ascar_ed
ascended1246513ascended
asceses938623asce_ses
asepses946363as_epses
ashlered1244623ashler_ed
askers105915403askers__
askeses1136463aske_ses
aspens85013353aspens__
asper75520433asper___
asperate10312373asperate
asperates11312553asperates
asperity1347223asperity
aspersing1237603aspersing
aspersion1146163aspersion
aspersive1445893aspersive
aspersors11386853aspersors
aspirated1247703aspirated
aspire8612123aspir_e_
aspirer967903aspir_er
aspires9612043aspir_es
aspises9611643asp_ises
assented957513assented
asserter877573asserter
assesses737383assesses
assorted956603assorted
assured858373assur_ed
asterisked1542893asterisked
asteroid9511193asteroid
asters65631603asters__
averred11237593a_verred
averse95811183a_verse_
averted112211613a_verted
capered123014043caper_ed
depermed1436453depermed
dispensed13158773dispensed
disperse111011353disperse_
disperser12109083disperser
disperses121211773disperses
emersed10138513_emersed
espoused1134853espoused
expensed18126413expensed
experted1838053experted
gaspers105014133gaspers__
hampered16239933hamper_ed
immersed1344833immersed
inversed12269283inversed
jaspers164310463jaspers__
kashered1636403kasher_ed
lamperses1345123lamperses
lappered13288213lapper_ed
mastered112614003master_ed
misparsed1446253misparsed
osiered837123osier_ed
pampered15229233pamper_ed
papered122513173paper_ed
parsed96323893__parsed
paupered13216943pauper_ed
peised94817683__peised
perked134617693__perked
permed115217353__permed
perse75429523__perse_
perses85428063__perses
perused103112193__perused
pursed95220883__pursed
raspers94415923raspers__
reperked15177793reperked
reversed122711613reversed
sabered103213023saber_ed
seised74218123_s_eised
sensed73918163_s_ensed
sered65737293_s_er_ed
serged84118773_s_erged
served104616813_s_erved
smerked14327283_smerked
spared95427493_spar_ed
sparged113512763_sparged
sparked143513143_sparked
sparred104512863_sparred
sparse84516343_sparse_
sparser94311483_sparser
speaned103411523_speaned
speared104314423_speared
specced14266703_specced
specked16329013_specked
speed85526623_spe__ed
speeded113310423_speeded
speeled103712453_speeled
speered103614813_speered
speiled104412123_speiled
speired103811103_speired
speise84614253_speise_
speises93813933_speises
spelled103714733_spelled
spense83912433_spense_
spenses92913573_spenses
spewed125512333_spe_wed
sphered133512313_spher_ed
spiered104412463_spier_ed
spired94921863_spir_ed
spirted103913073_spirted
spored94821793_spor_ed
sported104015433_sported
spoused10349653_spoused
spurned10339263_spurned
spurred103610623_spurred
spurted103111973_spurted
supered10316123super_ed
supersede1269483supersede
supersex1738423supersex
swerved1455703_swerved
tampered13279463tamper_ed
tapered102612933taper_ed
unversed122310433unversed
ushered1139153usher_ed
versed104515513__versed

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.423422437.4
2DLD Change Limit1461621566.86021306.4
3Display Results1561560.0602600.0
 (SQL Overall)1786911567.34324334.9
 
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.