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

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

171 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
decerebrating195320(None) 
cerebrating1646662__cerebrating
decelerating1645592decele_rating
decerebration1884192decerebration
decerebrations1993742decerebrations
celebrating1646113__celebrating
decerebrate1664013decerebrat__e
decerebrated1853313decerebrat_ed
decerebrates1753593decerebrat_es
degenerating1545663degene_rating
deteriorating1553393deteriorating
reverberating1953203reverberating
accelerating1753734accele_rating
acerbating1546294_acer_b_ating
cerebration1547924__cerebration
cerebrations1646964__cerebrations
concelebrating2172594concelebrating
deaerating12311564d__eae_rating
decarbonating1953234decarbonating
deceleration1547174decele_ration
decelerations1646424decele_rations
deconsecrating2053634deconsecrating
decorating14312074dec___orating
decorticating1984244decorticating
decreasing1446514dec_re__asing
decrepitating1953024decrepitating
defenestrating19112544defenestrating
deliberating1645124delibe_rating
denervating1645924dener__vating
deprecating1777284de_pre_cating
depreciating1845034de_preciating
depredating1655694de_pre_dating
desecrating1548094d__esecrating
desegregating1752734desegre_gating
desiderating1544694deside_rating
deuterating1347274de_ute_rating
recalibrating1852964recalibrating
recreating131214584rec_re__ating
recuperating1744994recupe_rating
regenerating1446334regene_rating
acierating1348325_ac_ie_rating
aerobraking1852835__aerobraking
asseverating1652275asseve_rating
calibrating1645355__calibrating
celebration1546465__celebration
celebrations1645745__celebrations
cerebrate1348655__cerebrat__e
cerebrated1546345__cerebrat_ed
cerebrates1447915__cerebrat_es
cocreating15310295coc_re__ating
corelating13511585__core_lating
creating113921955__c_re__ating
cremating14312205__c_re_mating
debating123213735d____eb_ating
decapitating1854955dec_apitating
decarburizing2861865decarburizing
deceasing1338405dec__e__asing
decelerate1347515decele_rat__e
decelerated1545925decele_rat_ed
decelerates1446795decele_rat_es
decelerator1453995decele_rat_or
decelerators1553495decele_rators
decentering1546485decenter__ing
decentring1446755dece_ntr__ing
decerning1337295dec__e_r_ning
decertifying2292795decer_tifying
decimating1648765dec___imating
decollating1545975dec__ollating
decompensating2262525decompensating
deconcentrating2163085deconcentrating
decreeing1335525dec_re___eing
decrypting1943215dec_r__ypting
decussating1543195dec__ussating
defeating142311975d__efe__ating
defecating17237785d__efe_cating
deferring1436145defer__r__ing
deflagrating1852665de_flagrating
deforesting1654795defore__sting
degeneration1447285degene_ration
degenerations1546355degene_rations
degenerative1754965degene_rative
degreasing1345425de_gre__asing
dehydrating2043655d__ehydrating
delectating1545995d__electating
delegating1337675d__ele_gating
delineating1346375deline__ating
demarcating1745205demar__cating
demergering1653595demerger__ing
demeriting1448685d__eme_riting
demonstrating17104765demonstrating
denigrating14146925d__enigrating
denitrating13128335d__enitrating
deorbiting1445155de_or_b_iting
deprograming1963365de_programing
depurating1438645d__e_purating
derating103222285d____e_rating
deregulating1554015dere_gulating
derogating1348635d__er_ogating
deselecting1544475desele__cting
deserting11713145d__ese_r_ting
deterioration14145285deterioration
deteriorations15164695deteriorations
deteriorative1762585deteriorative
deterring1138625deter__r__ing
deverbative2053625dever_b_ative
elucubrating1751875_elucubrating
enervating1488435_ener__vating
entreating11811555_entre__ating
enumerating1445005_enume_rating
estreating11710365_estre__ating
exacerbating2452355exacer_b_ating
execrating2047885___execrating
exenterating2054215_exenterating
exonerating1945555_exone_rating
exuberating2144175_exube_rating
federating1548855__fede_rating
generating12310385__gene_rating
iceboating1543355_ic__eboating
incarcerating1852585incarcerating
incinerating1554725incine_rating
incorporating1854125incorporating
intenerating1346725intene_rating
lacerating1349455lac__e_rating
lucubrating1652785luc__ubrating
macerating1549545mac__e_rating
mercurating1645955__mercurating
necessitating1662375necessitating
overbeating17410485_over_beating
overbraking2147145_over_braking
overeating141016535_overe__ating
overrating14814205_over__rating
penetrating1447665__penetrating
perennating1445545__perennating
perforating1747025__perforating
perorating13313135__per_orating
perpetrating1745205pe_rpetrating
perseverating1952525perseve_rating
reaccelerating19101845reaccele_rating
rebating112418345____reb_ating
recementing1645225receme__nting
recirculating1853535recirculating
reconsecrating1954195reconsecrating
recrating121318795____recrating
redecorating16115055rede_corating
redefeating1645335redefe__ating
reelevating1544965re_ele_vating
reembracing1852705re_e_mbracing
reerecting1339975re_ere__cting
regrating111316215____regrating
reintegrating1554615reintegrating
reiterating12410495re_ite_rating
remunerating1545425remune_rating
reoperating1449025re_ope_rating
reprobating1647105re_prob_ating
rerepeating1447185__rerepeating
resegregating1652845resegre_gating
retreating111414775re_tre__ating
revegetating1753685revege_tating
reverberation1893885reverberation
reverberations19113585reverberations
reverberative2162135reverberative
revibrating1745575__revibrating
secreting1279825sec_re___ting
segregating1445455se_gre_gating
serrating10513205__ser__rating
ulcerating1346985ulc__e_rating
uncreating13310475unc_re__ating
undereating1369555undere__ating
underrating1388255under__rating
venerating14410055__vene_rating
vociferating2182465vocife_rating

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 Filter1786911247900.376475242.0
2DLD Change Limit1247901718.65614416.6
3Display Results1711710.0931838.7
 (SQL Overall)1786911719.12519582.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.