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 “accelerates” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
accelerates155444(None) 
accelerate1444911accelerate_
accelerated1653941accelerated
accelerants1552542accelerants
accelerator1573262accelerator
accelerators1682942accelerators
decelerates1446792decelerates
reaccelerates1761982reaccelerates
accelerando16141533accelerando
accelerandos17191293accelerandos
accelerant1453733accelera_nt
accelerating1753733accelerating
acceleration1654813acceleration
accelerations1754193accelerations
accelerative1953453accelerative
accentuates1553063accentuates
acclimates1645913acc_limates
acculturates1663503acculturates
acierates11310813a_c_ierates
acoelomates1554123acoelomates
ameerates1149063a_me_erates
asseverates1452653asseverates
celebrates1447683__celebrates
decelerate1347513decelerate_
decelerated1545923decelerated
reaccelerate1662133reaccelerate_
reaccelerated1861843reaccelerated
ablegates1246804a__blegates
accedences1454164accede_nces
acceders1334804acceder___s
accelerometer19101354accelerometer
accelerometers2081264accelerometers
accentuate1453524accentuate_
accentuated1652704accentuated
accessaries15173554accessaries
acclimate1546234acc_limate_
acclimated1745154acc_limated
accolades1445434accol__ades
accretes1238124acc___retes
acculturate1554324acculturate_
acculturated1753194acculturated
accumulates1752944accumulates
accurate12410664acc__urate_
acerate92818914a_c__erate_
acerated113114004a_c__erated
acerbates1347264a_ce_rbates
acetates102013064a_c__etates
acetylates1543854a_cetylates
acierate10311814a_c_ierate_
acierated1238304a_c_ierated
acoelomate1454364acoelomate_
acrylates1446684acryl__ates
aculeate1039924a_cule_ate_
aculeated1247734a_cule_ated
acylates1339744a_cyl__ates
adulterates1244204adulterates
aerates74627494a____erates
aliterates101510764a_literates
alliterates11106264alliterates
ameerate1039634a_me_erate_
ameliorates1354254a_meliorates
asperates11312554a__sperates
asseverate1352694asseverate_
asseverated1552144asseverated
celebrate1348094__celebrate_
celebrated1556234__celebrated
celeries10316314__celer_ies
celerities1289774__celerities
celestes10310014__cele_stes
celibates1358634__celibates
cellmates1347514__cellmates
cerates95428254__c__erates
cerebrates1447914__cerebrates
chelates132713854_chel__ates
chlorates142512274__chlorates
coelomates1497574_coelomates
concelebrates19113584concelebrates
cooperates1469614_cooperates
crenelates1266194_crenelates
deaerates10313644__deaerates
decelerator1453994decelerator
decelerators1553494decelerators
decerebrates1753594decerebrates
degenerates1346454degenerates
delegates1139844__delegates
elevates111110424___elevates
emeerates1149374_eme_erates
federates13310154__federates
generates10312724__generates
incinerates1346034incinerates
intenerates1148094intenerates
lacerates112413784lac__erates
macerates132113574mac__erates
nucleates1148564nuc_le_ates
recuperates1545604recuperates
reelevates1345634_reelevates
regenerates1247474regenerates
relegates10310944__relegates
sclerites1139444_sc_lerites
selenates91611364__selenates
tolerates9312124__tolerates
ulcerates1148854ulc__erates
uncelebrated1753394uncelebrated
valerates12310544__valerates
venerates12312264__venerates
vociferates1982544vociferates

Search took 10 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 Filter1786911488190.500357382.0
2DLD Change Limit1488191069.15616253.7
3Display Results1061060.0631682.5
 (SQL Overall)1786911069.71918385.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.