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

136 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
asperges1131809(None) 
asperses104111671asperses
absterges1244762absterges
amperages1447682amperages
amperes11313982amper_es
aperies9423202a_peries
asperates11312552asperates
aspers86220312asper__s
asperse94210662asperse_
aspersed11428292aspersed
asperser10408302asperser
aspersers11377242aspersers
aspires9612042aspir_es
auberges1146672auberges
serges74225972_s_erges
sparges104016342_sparges
spurges104111652_spurges
absterge1154083absterge_
absterged1353353absterged
acreages1138373acreages
adheres11310163adher_es
aeries64737783a__eries
alleges84212573alle_ges
allergen9135893allergen
allergens10145173allergens
allergies10137783allergies
amberies122514683amberies
amerces1149853a_merces
amperage1347743amperage_
ampere10514413amper_e_
anergies9310453a_nergies
apercus1136573a_percus
apers76629133a_per__s
apexes1539133a_pe_xes
appeases1238663appeases
apres75426403a_p_r_es
arteries8321483arteries
asceses938623asce_ses
asepses946363as_epses
askers105915403asker__s
askeses1136463aske_ses
asparagus1242913asparagus
aspects1146743aspe_cts
aspens85013353aspe__ns
asper75520433asper___
asperate10312373asperate
asperated1239313asperated
aspergill1252913aspergill
aspergills1372663aspergills
asperities1249763asperities
asperity1347223asperity
aspersor10336233aspersor
aspersors11386853aspersors
aspirates1139613aspirates
aspire8612123aspir_e_
aspired1068173aspir_ed
aspirer967903aspir_er
aspirers1066493aspirers
aspirins1037733aspirins
aspises9611643asp_ises
asserted957903asserted
asserter877573asserter
asserters956393asserters
asserts74311793asser_ts
assesses737383assesses
assuages936273assuages
assures7611403assur_es
asswages1255053asswages
asterias8317013asterias
asters65631603aster__s
auberge1045633auberge_
avenges1157543a_venges
averages1249183a_verages
casernes103810753cas_ernes
demerges12129503demerges
deterges101510093deterges
disperses121211773disperses
diverges13258313diverges
duperies11312813duperies
emerges101310883_emerges
emperies12314563emperies
epergnes1156713_epergnes
gaspers105014133gasper__s
immerges1345393immerges
japeries17311463japeries
jaspers164310463jasper__s
lamperses1345123lamperses
masteries111018493masteries
merges94122493__merges
moperies12313873moperies
naperies10313903naperies
parges94529543__parges
peages94321853__peages
peres76246643__per_es
perses85428063__perses
pipeages1336423pipeages
poperies12316793poperies
purges94421763__purges
raspers94415923rasper__s
remerges111110203remerges
roperies10315763roperies
sarges75128593_s_arges
sedges83817813_s_edges
seres55448893_s_er_es
serge64727473_s_erge_
serged84118773_s_erged
serger73819743_s_erger
sergers83815633_s_ergers
series64540973_s_eries
serves94423653_s_erves
sieges73816833_sie_ges
sledges94511573_sledges
spares84834553_spar_es
sparge94216053_sparge_
sparged113512763_sparged
sparger103613083_sparger
spargers11389733_spargers
species11314133_species
speises93813933_speises
spences113413923_spences
spenses92913573_spenses
sperms102512603_sper_ms
spheres123114353_spher_es
spires84628113_spir_es
splurges1145163_splurges
sponges10311043_sponges
spores84726613_spor_es
sprees85620643_sp_rees
sprues84515763_sp_rues
spurge93711323_spurge_
steres63929533_ster_es
surges73924593_s_urges
swerves1377533_swerves
upsurges11144803upsurges
verges104320183__verges
wasteries121115343wasteries

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.420425454.8
2DLD Change Limit1461621366.90621164.5
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.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.