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

116 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
aspersing123760(None) 
appeasing1446342appeasing
asperating1349562asperating
aspersion1146162aspersion
aspersions1246102aspersions
aspersive1445892aspersive
aspiring1138872aspir_ing
asserting1038662asserting
assessing1045172assessing
dispersing1449302dispersing
abscessing1543313abscessing
absterging1453353absterging
accessing1445833accessing
adhering1338883adher_ing
adverting1437223adverting
alerting91312383a_lerting
altering91917113alter_ing
amercing1337193a_mercing
ampersand1443793ampersand
angering102113803anger_ing
answering1345803answer_ing
appealing1446493appealing
appearing1436893appearing
appending1536283appending
appetising1544513appetising
apposing1337403a_pposing
apprising1447963apprising
ascending1336283ascending
ashlering1344153ashler_ing
aspergill1252913aspergill
asperity1347223asper_ity
aspers86220313aspers___
asperse94210663aspers__e
aspersed11428293aspers_ed
asperser10408303aspers_er
aspersers11377243aspersers
asperses104111673aspers_es
aspersor10336233aspers_or
aspersors11386853aspersors
aspirating1348363aspirating
aspirin937823aspir_in_
aspirins1037733aspir_ins
assenting1038163assenting
assorting1037303assorting
assuring937773assur_ing
asterisking1652963asterisking
averring12239063a_verring
averting122512733a_verting
capering132414963caper_ing
deperming1537113deperming
dispensing1448233dispensing
espousing1265003espousing
expensing1946003expensing
experting1938053experting
hampering1738863hamper_ing
immersing1445123immersing
inversing1389623inversing
kashering1736253kasher_ing
lappering14258843lapper_ing
mastering122315303master_ing
misparsing1546613misparsing
pampering1638383pamper_ing
papering132213313paper_ing
parsing103819553__parsing
paupering1437273pauper_ing
peising103416763__peising
perking143716463__perking
perming123416093__perming
perusing11811063__perusing
pursing103715553__pursing
reperking1638703reperking
reversing132611483reversing
sabering112113743saber_ing
seising84018863_s_eising
sensing84116953_s_ensing
serging93416673_s_erging
sering74731813_s_er_ing
serving113014983_s_erving
smerking15258473_smerking
sparging122611133_sparging
sparing104823873_spar_ing
sparking152812543_sparking
sparling112714533_sparling
sparring113112223_sparring
speaking153212493_speaking
speaning113512243_speaning
spearing113216103_spearing
speccing15306643_speccing
specking17359733_specking
speeding122810933_speeding
speeling112713123_speeling
speering113116323_speering
speiling113612973_speiling
speiring113711263_speiring
spelling113315233_spelling
spending122712433_spending
spermine12311433_spermine
spewing133110453_spe_wing
sphering142811943_spher_ing
spiering112713353_spier_ing
spiring103918183_spir_ing
spirting112913633_spirting
sporing104319413_spor_ing
sporting112415463_sporting
spousing11198733_spousing
spring94526013_sp_r_ing
spurning11258663_spurning
spurring11339763_spurring
spurting113111633_spurting
sterling93615553_sterling
supering11317683super_ing
swerving1546113_swerving
tampering1438453tamper_ing
tapering112112503taper_ing
ushering1258923usher_ing
versing112314193__versing

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.420425454.8
2DLD Change Limit1486411167.45619935.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.92222556.3
 
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.