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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
advertizing2514430(None) 
advertising16143611advertising
adverting1437222advert__ing
advertisings17131782advertisings
advecting1645113advect__ing
adventuring1652973adventuring
advertize2245383advertiz__e
advertized2443793advertiz_ed
advertizes2344673advertiz_es
amortizing2246403a_mortizing
appetizing2445403appe_tizing
averting122512733a_vert__ing
expertizing3044623expertizing
maderizing2346463mad_er_izing
overtiming1699073_overtiming
overtiring141210203_overtiring
adhering1338884adher___ing
advantaging1751784advantaging
advection1545554advecti_on_
advections1645554advecti_ons
adventitia1452604adventiti_a
adventitial1552114adventitial
adventitias1552274adventitias
adversities1564354adversities
advertent1356594advert__ent
advertise1346104advert__ise
advertised1544094adverti_sed
advertiser1443614adverti_ser
advertisers1552544advertisers
advertises1445914adverti_ses
advertizement28172484advertizement
advertorial1552624advertorial
advising1336154adv___ising
agatizing2087474a__gatizing
agenizing2046334a_ge_nizing
alerting91312384a_lert__ing
amortising1345974a_mortising
aphorizing2546474aphor_izing
appertaining1752514appertaining
appetising1544514appe_tising
apprizing2347194a_ppr_izing
arborizing2256644arbor_izing
aromatizing2346634aromatizing
ascertaining1551924ascertaining
asserting1038664assert__ing
averaging1446504a_ver_aging
averring12239064a_ver__ring
avianizing2345554a_vianizing
azotizing1846014a__zotizing
bacterizing2546104bacter_izing
cauterizing2345944cauter_izing
concertizing2655634concertizing
deputizing2344804_deputizing
derailing112011314_d_erailing
deriding112512934_d_er_iding
deriving132510744_d_er_iving
destining11311434_d_estining
digitizing2245354_digitizing
dimerizing2346774dimer_izing
diverting142410334divert__ing
energizing2145374_energizing
erotizing1949964___erotizing
eternizing2046764_eternizing
etherizing2346854ether_izing
everting122213134_evert__ing
fiberizing2545054fiber_izing
heroizing2248494__heroizing
idealizing2147294id_ealizing
inverting131013224invert__ing
laterizing2049094later_izing
magnetizing2454404magne_tizing
modernizing2444104modernizing
monetizing2247304mone_tizing
novelizing2345274nove_lizing
obverting1536304obvert__ing
odorizing2046114od_or_izing
overliving1747394_overliving
overmining1649114_overmining
overmixing2346414_overmixing
overprizing2648034_overprizing
overriding1548514_overriding
overtaking1878894_overtaking
overtaxing2157694_overtaxing
overtipping1945234_overtipping
overtoiling1547194_overtoiling
overturing1499414_overturing
palletizing2344914palle_tizing
pauperizing2544504pauper_izing
pectizing2348014__pectizing
peptizing2347114__peptizing
poetizing2148684_poe_tizing
pulverizing2653664pulver_izing
reverting132315134revert__ing
scientizing2353944scientizing
soberizing2246754sober_izing
sovietizing2453534sovietizing
suberizing2247744suber_izing
supersizing2347024supersizing

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 Filter1786911488190.420425454.8
2DLD Change Limit148819988.15618246.6
3Display Results98980.0462130.4
 (SQL Overall)178691988.62220725.0
 
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.