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

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

73 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
commercialising247227(None) 
commercializing3362711commercializing
commercialise21184163commercialis__e
commercialised23193013commercialis_ed
commercialises22173813commercialis_es
commercialism20184183commercialis__m
commercialisms21183663commercialis_ms
commercialist21204683commercialis__t
commercialistic2292113commercialistic
commercialists22183823commercialis_ts
commercialities2363303commercialities
commerciality2463384commercial__ity
commercialize30184034commercial__ize
commercialized32203524commerciali_zed
commercializes31193784commerciali_zes
commercials1954304commercial_s___
commercial1855285commercial_____
commercially2354135commercial___ly
commercing1955975commerc_____ing
communalizing2952865comm__unalizing
conceptualising2272675conceptualising
immortalising1862565_immor_talising
materialising16114495_mater_ialising
memorialising1853065__memorialising
serialising12167005___ser_ialising
socialising1445645so____cialising
specialising1754015__spe_cialising
centralising1555936c___entralising
collectivising2271906colle_ctivising
colonializing2553606co__lonializing
commemorating1953076commemora__ting
commencing1946186commenc_____ing
commensalism1764956comme_nsalis__m
commensalisms1873756comme_nsalis_ms
commentating1957046comme_nta__ting
communicating2254876communica__ting
communising1844966comm____unising
comprising1748636co_mpr____ising
compromising2152926co_mpr__omising
conceptualizing3173086conceptualizing
conservatizing2983096conser_vatizing
contextualizing3462496contextualizing
cosmeticizing2992256cosme_ti_cizing
counterclaiming2262926countercla_iming
dematerializing28163566demater_ializing
externalising2153396_exter_nalising
focalising1645626fo____c_alising
formalising1754866fo___r_malising
generalising1454106_gener__alising
immaterializing29102806immater_ializing
immortalizing2753376_immor_talizing
internalising1455626_inter_nalising
liberalising1564126_liber__alising
localising1345976lo____c_alising
lowercasing1751776lo_werc_a__sing
materializing2595976_mater_ializing
memorializing2764816__memorializing
mercerising1653836___merc_erising
merchandising2261816___merchandising
metalising1348946___me__talising
mineralising1595156_miner__alising
moralising1347626___mor__alising
musicalising1753016__music_alising
normalising1444976no___r_malising
overcalling1747326_o_verc_al_ling
overclaiming2045086_o_vercla_iming
overpraising1846136_o_verpra_ising
rematerializing27153526remater_ializing
serializing21149406___ser_ializing
socializing2347346so____cializing
specializing2655506__spe_cializing
sterilising1245026__ster_i_lising
vocalising1645526vo____c_alising

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 Filter178691950240.1261418182.5
2DLD Change Limit95024738.03011833.6
3Display Results73730.0461587.0
 (SQL Overall)178691738.20221786.3
 
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.