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

119 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
legalise94949(None) 
legalese954751legalese
legalised1145841legalised
legalises1038561legalises
legalism1148581legalism
legalist9512391legalist
legalize1839101legalize
egalite8311562_egalite
legacies1139042legacies
legaleses1044392legaleses
legalisms1247162legalisms
legalists1047942legalists
legality1237622legality
legalized2047522legalized
legalizer1946322legalizer
legalizes1938672legalizes
legals73412732legal_s_
legatine91311402legatine
leglike12136842leg_like
localise101511852localise
metalise10416052metalise
penalise101013762penalise
realise73021812re_alise
alkalise12178043alkalise
argalis84214193argalis_
begalls10319163begalls_
bengaline1245633bengaline
canalise10816213canalise
degamis11268443degamis_
egalites9310503_egalites
elegise8139393eleg__ise
equalise1748213equalise
finalise113112573finalise
focalise131210373focalise
globalise1245153globalise
hegaris11310433hegaris_
idealise938053idealise
illegalize20133313illegalize
lavalike1536283lavalike
leaflike1534713leaflike
lealties8310793le_alties
lease55230263le_a__se
legal65715943legal___
legalising1245743legalising
legalistic1345273legalistic
legalities1148913legalities
legalizers2044103legalizers
legally1138133legal_ly
legate72917453lega__te
legatee82814633lega_tee
legatees9258433legatees
legates82917683legates_
legating102313113legating
legation92412933legation
legatos82711183legatos_
legist71315253leg__ist
legless838013leg_less
levulose1143243levulose
liaise6310693l_ia_ise
liberalise1247593liberalise
ligase7259913liga__se
ligative1258803ligative
localised12167863localised
localises111411463localises
localism121310013localism
localist101613963localist
localite101411543localite
localize191410483localize
logicise1146113logicise
loyalism13167573loyalism
loyalist111511133loyalist
mealie82519813me_ali_e
mealies92821933me_alies
medalist11414213medalist
megadose1244493megadose
megalith1448243megalith
megasse10266243mega_sse
metalised12310463metalised
metalises11315073metalises
metalist10519353metalist
metalize19414783metalize
moralise10314913moralise
nasalise848863nasalise
nebulise1045743nebulise
negative1239083negative
neglige934873neg_lige
organise939323organise
paganise1139663paganise
pealike131211273pe_alike
peglike14136773peg_like
penalised12108833penalised
penalises11912773penalises
penalize19912753penalize
petaline10314883petaline
realised92214533re_alised
realiser82512563re_aliser
realises82420183re_alises
realism93115923re_alism
realist73225383re_alist
realize162717083re_alize
regale74821453regal__e
regales83520793regales_
regalia839223regali_a
regaling10315363regaling
regality1249313regality
reguline939503reguline
reraise7316313rera_ise
ruralise839643ruralise
secalose1046963secalose
sepaline10311343sepaline
serialise9912143serialise
signalise1046393signalise
tealike111111083te_alike
tetanise8610203tetanise
totalise8312503totalise
valise92917643__valise
veganism1446443veganism
vitalise11310743vitalise
vocalise131510813vocalise

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621197.09320606.5
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.57923577.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.