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

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

125 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
penalize1991275(None) 
penalise101013761penalise
penalized211210241penalized
penalizes20911851penalizes
banalize191010932banalize
canalize19914492canalize
finalize202711022finalize
legalize1839102legalize
metalize19414782metalize
pealike131211272pe_alike
penalised12108832penalised
penalises11912772penalises
penality13310712penality
penlite9313242pen_lite
petaline10314882petaline
realize162717082re_alize
vernalize2159842vernalize
alkalize21177633alkalize
analyze19167013_analyze
annualize1845613annualize
banalized21118703banalized
banalizes201210093banalizes
beanlike14146843beanlike
bengaline1245633bengaline
canalise10816213canalise
canalized21611693canalized
canalizes201113783canalizes
centralize2149963centralize
dualize1759763_dualize
egalite8311563_egalite
enamine91214313_enamine
equalize2648023equalize
eternalize19118503eternalize
feudalize2254873feudalize
finalise113112573finalise
finalized22279243finalized
finalizer21307923finalizer
finalizes212810743finalizes
focalize22139503focalize
generalize20198453generalize
henlike1448693hen_like
hepatize2248233hepatize
idealize1847873idealize
legalise949493legalise
legalized2047523legalized
legalizer1946323legalizer
legalizes1938673legalizes
localize191410483localize
mealie82519813me_ali_e
melanize19410303melanize
metalise10416053metalise
metalized21412183metalized
metalizes20414243metalizes
metallize2067153metallize
moralize19313923moralize
nasalize1748183nasalize
nebulize1955153nebulize
paganize2048633paganize
panelized2147033panelized
paralyze2246623paralyze
peaklike13115373peaklike
pealing104123203pe_aling
pearlite1039443pearlite
pearlized2145563pearlized
pectize20259913pe_ctize
pedalier1137603pedalier
pedaling122412133pedaling
peglike14136773pe_glike
pelite84323003pe__lite
pemoline12310273pemoline
penal75228373penal___
penalities121313473penalities
penalizing2249923penalizing
penally121111773penal_ly
penalties11139513penalties
penalty1267743penal_ty
penance11313443pena_nce
penile82219603pen__ile
penknife1752543penknife
penlites10312273pen_lites
pennine93712953pen_nine
pensile92713543pen_sile
pensive122610393pen_sive
peptize20279483pe_ptize
percaline13410953percaline
perlite9317323pe_rlite
personalize2287333personalize
petallike1554633petallike
phenacite1686103phenacite
phenakite1864233phenakite
phenazine2345643phenazine
pinelike14188613pinelike
pintsize1955103pintsize
pluralize2045773pluralize
polarize19512653polarize
praline93019743p_raline
pyrolize2248133pyrolize
realise73021813re_alise
realized182514223re_alized
realizer172412113re_alizer
realizes173116843re_alizes
reanalyze2143233reanalyze
recanalize2147253recanalize
ruralize1739233ruralize
sensualize1945103sensualize
sepaline10311343sepaline
serialize18812633serialize
sexualize2546903sexualize
signalize1946913signalize
specialize2347193specialize
tantalize181010573tantalize
tealike111111083te_alike
tenaille846813tenaille
tentlike1236903tentlike
tetanize17109953tetanize
totalize17311523totalize
unalike11311533_unalike
vandalize2246793vandalize
velarize2048773velarize
venality1438683venality
verbalize2348833verbalize
vernalized2348423vernalized
vernalizes2249323vernalizes
vitalize20310503vitalize
vocalize221310153vocalize

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621257.70618967.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.15521911.8
 
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.