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

138 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
penalises1191277(None) 
penalise101013761penalise_
penalised12108821penalised
penalizes20911841penalizes
canalises11515492canalises
finalises122911522finalises
legalises1038562legalises
metalises11315072metalises
penalities121313462penalities
penalize19912752penalize_
penalized211210232penalized
penalties11139502penalties
penises9318192pen__ises
penlites10312272pen_lites
realises82420182re_alises
alkalises13167483alkalises
anaclises1147863_anaclises
analyses11149963_analyses
annalists949063annalists
apetalies1148003apetali_es
banalizes201210093banalizes
bengalines1344803bengalines
bubalises1346323bubalises
canalise10816213canalise_
canalised12810913canalised
canalizes201113783canalizes
centralises1349293centralises
egalites9310503_egalites
enamines101112133_enamines
encloses10911053_encloses
englishes1345103_englishes
enlists749393_en_lists
enolases8411013_enolases
enosises8311003_enosises
equalises1847253equalises
finalise113112573finalise_
finalised13338013finalised
finalisms14318833finalisms
finalists123010163finalists
finalizes212810733finalizes
focalises14139953focalises
generalises12167823generalises
genoises939253gen_oises
idealises1047783idealises
kenosises1345143kenosises
legaleses1044393legaleses
legalise949493legalise_
legalised1145843legalised
legalisms1247163legalisms
legalists1047943legalists
legalizes1938673legalizes
localises111411463localises
mealies92821933me_ali_es
medalists1249373medalists
mentaleses1245953mentaleses
mentalisms1449313mentalisms
mentalists12410483mentalists
metalise10416053metalise_
metalised12310463metalised
metalists11412663metalists
metalizes20414243metalizes
moralises11314003moralises
nasalises948113nasalises
nebulises1145063nebulises
oxalises1538503_oxalises
paganises1239723paganises
palsies94420273p__alsies
panelists1148343panelists
paradises122513203paradises
paralyses1448283paralyses
parises94827183p__arises
pavises125315493p__avises
pealike131211273pe_alike_
pearlites1138233pearlites
peases85229473pe_a__ses
peavies122213403pe_avi_es
pedalier1137603pedali_er
pedaliers1245183pedaliers
peises84125043pe___ises
pelisse967063pe__lisse
pelisses1048483pe__lisses
pelites93821993pe__lites
pelvises1337273pe_lvises
pemolines1348623pemolines
penalising1347623penalising
penality13310713penali_ty
penances12312443pena_nces
penates93321593pena__tes
penknives1842393penknives
penlite9313243pen_lite_
pennies94218813pen_ni_es
penniless1144013penniless
pennines103112043pen_nines
pentoses10312893pen_toses
penuries10311663penuri_es
peploses1269463pe_ploses
pepluses1287013pe_pluses
percalines1449743percalines
perlites10316353pe_rlites
personalises1476523personalises
petaline10314883petaline_
petasoses1145443petasoses
petasuses1144373petasuses
phenacites1765403phenacites
phenakites1963863phenakites
phenazines2445133phenazines
plenaries11410383plenari_es
polarises11514073polarises
praises94121103p_ra_ises
pralines102217723p_ralines
praxises1739063p_raxises
proclises1339543proclises
ptyalisms1685303ptyalisms
realise73021813re_alise_
realised92214533re_alised
realiser82512563re_aliser
realisers9248323re_alisers
realisms102212163re_alisms
realists83014843re_alists
realizes173116843re_alizes
reanalyses1343503reanalyses
reraises8415643rera_ises
ruralises939123ruralises
secaloses1146913secaloses
serialises10811563serialises
signalises1145913signalises
specialises1546003specialises
tantalises101010103tantalises
tenailles946323tenailles
tennises82810133ten_nises
tetanises979873tetanises
totalises9311783totalises
valises103516263__valises
vandalises1446813vandalises
venalities131510723venalities
vernalizes2249323vernalizes
vitalises12310093vitalises
vocalises141710333vocalises

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411387.28320409.3
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.50223819.1
 
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.