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

110 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
reactivating184475(None) 
deactivating1953451deactivating
activating1647852__activating
inactivating1853462inactivating
reactivation17176952reactivation
reactivations18176142reactivations
remotivating1864332remotivating
aestivating1545803ae_stivating
captivating1944883_captivating
deactivation18156083deactivation
deactivations19175063deactivations
estivating1447633_e_stivating
reactivate1545843reactivat__e
reactivated1744973reactivat_ed
reactivates1645613reactivat_es
reactivities1756163reactivities
reanimating1447223rea_nimating
recultivating1953013recultivating
reestimating1545933reestimating
revaccinating2152703revaccinating
activation15610134__activation
activations1669264__activations
activizing2545864__activizing
actuating1239224__act_uating
brachiating1944434brachi_ating
brecciating1844224bre_cci_ating
castigating1546004_castigating
cultivating1744944_cultivating
deactivate1644624deactivat__e
deactivated1843734deactivat_ed
deactivates1744394deactivat_es
deactivator1752844deactivat_or
deactivators1852574deactivators
deaminating1547974dea_minating
decapitating1854954decapitating
decimating1648744de_c_imating
deracinating1645224derac_inating
emaciating1546804emac_i_ating
eradiating1248724era_di_ating
eradicating1556624era_dicating
eructating1345684eruct__ating
estimating1348874_e_stimating
excavating2344104_exc_avating
festinating1547374fe_stinating
fractionating1953084fractionating
glaciating1445594glac_i_ating
inactivation1745094inactivation
inactivations1854244inactivations
lactating1239184_lact__ating
legitimating1653814legitimating
machinating1945614_machinating
masticating1647824_masticating
motivating1646804__motivating
negotiating1344244negoti_ating
nictitating1444384_nictitating
passivating1743784_passivating
patinating1339874_pa_tinating
quantitating2252924quantitating
radiating111112124r_a_di_ating
radicating1459064r_a_dicating
reaccenting1665014reac_centing
reaccepting1863894reac_cepting
reacting113317894reac____ting
reactivity1845394reactiv__ity
readdicting1643814readdi_cting
readmitting1544054readmi_tting
reallocating1573664reallocating
reanointing1244994reanoi_nting
rearticulating1753694rearticulating
reattempting1751654reattempting
reattributing1692114reattributing
recalibrating1852964recalibrating
receipting1546754re_cei_pting
receiving1538994re_ceiv__ing
reciting113118074re_c_i__ting
recoating121317464re_c__oating
recrating121318784re_c__rating
recreating131214574re_c_reating
rectifying1946374re_cti_fying
rededicating1744334rededicating
redictating1546804redict__ating
reelevating1544964re_elevating
reinitiating1345764reinitiating
reiterating12410494re_iterating
relativizing2553944relativizing
reluctating1445764reluct__ating
remediating1547134remedi_ating
remotivation1747424remotivation
remotivations1846684remotivations
renominating1546414renominating
renovating1447424re__novating
repatriating1545454repatriating
replicating1649094re_plicating
repudiating1546204repudi_ating
reradiating1347254reradi_ating
resinating11313734re__sinating
resituating1247544resit_uating
restating102319414re_st__ating
restituting12156564re_stituting
retaliating1248874retali_ating
retinting102215254re__ti_nting
retreating111414764re__treating
revalidating1744184revalidating
rusticating1446314r_usticating
salivating1447434_sa_livating
satiating10311804_sa_ti_ating
titivating1445324__titivating
tittivating1552594_tittivating
vaccinating1945174_vaccinating
ventilating1546334ve_ntilating

Search took 9 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.1401276364.3
2DLD Change Limit1247901108.31315011.4
3Display Results1101100.0761447.4
 (SQL Overall)1786911108.52920951.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.