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

185 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
altercating145560(None) 
alternating1245711alternating
altercation1347012altercation
altercations1446372altercations
acerbating1546283a_cerbating
acierating1348313acier_ating
adulterating1453243adulter_ating
aerating92821003a__er_ating
alerting91312383al_er__ting
alienating1147223alie_nating
alleviating1553593alleviating
alliterating1354273alliter_ating
allocating1347383al_locating
alteration10612903alter_ation
alterations11511663alter_ations
altercate1147853altercat__e
altercated1345453altercat_ed
altercates1247553altercat_es
altering91917113alter___ing
alternation1147623alternation
alternations1246773alternations
alternative1454683alternative
antedating1277553ante_dating
asperating1349563asper_ating
attenuating1253103attenuating
attracting1346563a_ttracting
interacting14411713interacting
iterating10314253_iter_ating
lacerating1349443lacer_ating
lateraling11148803later_aling
maltreating1455513malt_reating
ulcerating1346983ulcer_ating
abdicating1686154a_bdicating
abnegating1444464abne_gating
abreacting1544534abreac_ting
abstracting1645184abstracting
acetylating1753274acetylating
activating1647854act_ivating
actuating1239224act__uating
advecting1645114adve_c_ting
adverting1437224adver__ting
advocating1744484a_dvocating
affecting1845234affe_c_ting
affricating2043964affricating
afterpain1443394afterpa_in_
afterpains1553514afterpa_ins
aggregating1343584aggregating
alkylating1843534al_kylating
alterant8614964alter_a__nt
alterities10411044alter_ities
alternant977134alterna__nt
alternate948114alternat__e
alternated1145724alternat_ed
alternately1452774alternately
alternates1047874alternat_es
alternatives1553254alternatives
alternator1044554alternat_or
alternators1154104alternators
amercing1337194a_merc__ing
anteceding1443954ante_ceding
anteverting1544334anteverting
anticaking1747604ant_icaking
antiquating2146434antiquating
appreciating1954084appreciating
arcading1239764a___rcading
aspirating1348364aspir_ating
asserting1038664asser__ting
asterisking1652964asterisking
astricting1357834ast_ricting
attempting1542924atte_mpting
attesting1036384atte__sting
attriting1048684a_ttr_iting
attritting1144764a_ttritting
auspicating1644604auspicating
automating1389304aut_omating
autorotating1373844autorotating
averaging1446504a_ver_aging
averting122512734a_ver__ting
berating113220764__ber_ating
bifurcating1952614bifurcating
bleating113514504bl_e__ating
calibrating1645344calibr_ating
castrating1349774cast_r_ating
catenating1348684cate_nating
cleating113518134cl_e__ating
cybernating1952854cybernating
deaerating12311564deaer_ating
defecating17237784defe_cating
demarcating1745204demarcating
denervating1645924denervating
deprecating1777284deprecating
derating103222284__der_ating
desecrating1548094desecrating
detecting13259984dete_c_ting
detracting1438714det_racting
deuterating1347274deuter_ating
electing112113784el_e_c_ting
elevating1338204el_e_vating
elutriating1245074elutriating
enervating1488434_enervating
entreating11811554ent_reating
estreating11710364est_reating
execrating2047884_execrating
extenuating1943574extenuating
extirpating2143744extirpating
extracting2047224ext_racting
extricating2146694extricating
faltering132211114falter___ing
federating1548854feder_ating
filtrating1445974filt_r_ating
furcating1537784__furcating
generating12310384gener_ating
haltering132212004halter___ing
hibernating1753174hibernating
imprecating1844904imprecating
innervating1546364innervating
integrating1349494integrating
intercalating1656504intercalating
interceding1568044interceding
intercepting1748874intercepting
intercutting1545944intercutting
interesting12411124interesting
interfacing1747704interfacing
interlacing1449054interlacing
interlaying1547574interlaying
intermatting1547174intermatting
intreating11614014int_reating
lariating10311784_l_ariating
lateralling1244634lateralling
laterizing2049094later_izing
laureating1146394_laureating
legating102313114_l_e_gating
liberating1349254liber_ating
librating1239054_libr_ating
locating11311504_l__ocating
lowercasing1751774lowercasing
lubricating1644714_lubricating
macerating1549534macer_ating
masticating1647834mast_icating
masturbating1772674masturbating
maturating13108574matur_ating
metricating1647364metricating
moderating1448804moder_ating
motorcading1752784motorcading
nitrating10312674nit_r_ating
numerating1357234numer_ating
obliterating1553394obliter_ating
obsecrating1644134obsecrating
obturating1346574obtur_ating
operating12313724_oper_ating
outeating10814494oute__ating
outrating10916404out_r_ating
overacting16310914_overacting
overcasting1748514_overcasting
overeating141016534_overeating
overhating17910954_overhating
overrating14814204_overrating
paltering122612894palter___ing
patriating13510204pat_riating
placating1438514pl__acating
pleating112916054pl_e__ating
pretreating1448894pretreating
recrating121318794__recrating
reiterating12410494reiter_ating
retracting13311934ret_racting
retreating111414774ret_reating
saturating11119204satur_ating
seriating10916404__seriating
serrating10513204__serrating
striating10914194_st_riating
terracing1237704__terracing
threating131010054__threating
throating1398404__throating
titrating10310114tit_r_ating
tolerating1148594toler_ating
treating92519614__t_reating
ultimating1386804ult_imating
ultratiny1246704ult_r_atiny
underacting1547524underacting
undercoating1645374undercoating
undereating1369554undereating
underrating1388254underrating
uppercasing1852764uppercasing
urticating1347354urt_icating
venerating14410054vener_ating

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.436409841.7
2DLD Change Limit1488191858.87616766.4
3Display Results1851850.0931989.2
 (SQL Overall)1786911859.40518999.6
 
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.