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

110 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
legalises103856(None) 
legaleses1044391legaleses
legalise949491legalise_
legalised1145841legalised
legalisms1247161legalisms
legalists1047941legalists
legalizes1938671legalizes
egalites9310502_egalites
legacies1139042legaci_es
legalese954752legalese_
legalism1148582legalis_m
legalist9512392legalis_t
legalities1148912legalities
legalize1839102legalize_
legalized2047522legalized
legalizer1946322legalizer
legalizers2044102legalizers
localises111411462localises
metalises11315072metalises
penalises11912772penalises
realises82420182re_alises
aegises8311373aeg__ises
alkalises13167483alkalises
bengalines1344803bengalines
bubalises1346323bubalises
canalises11515493canalises
clematises1445733clematises
degases93413103dega__ses
degasses10278363dega_sses
degausses1143203degausses
egalite8311563_egalite_
egises7312493_eg__ises
elegises9128823eleg__ises
equalises1847253equalises
finalises122911523finalises
focalises14139953focalises
globalises1354593globalises
idealises1047783idealises
illegalizes21133243illegalizes
lapises93513463l__apises
lealties8310793le_alties
leases65428113le_a__ses
legalising1245743legalising
legalistic1345273legalistic
legality1237623legali_ty
legals73412733legal___s
legatees9258433lega_tees
legates82917683lega__tes
legatine91311403legatine_
legations102711923legations
legists899593leg__ists
legless838013leg_les_s
leglike12136843leg_like_
levuloses1243323levuloses
lewises1039133le__wises
liaises7311053l_ia_ises
liberalises1346833liberalises
ligases82310713liga__ses
localise101511853localise_
localised12167863localised
localisms13148733localisms
localists11149793localists
localites111210433localites
localizes201510543localizes
logicises1256203logicises
loyalisms14156623loyalisms
loyalists12137473loyalists
mealies92821933me_ali_es
medalists1249373medalists
megadoses1344663megadoses
megaliths1544743megaliths
megalopses1543553megalopses
megasses11307743mega_sses
metalise10416053metalise_
metalised12310463metalised
metalists11412663metalists
metalizes20414243metalizes
moralises11314003moralises
nasalises948113nasalises
nebulises1145063nebulises
negatives1346583negatives
negliges1034833neg_liges
organises1048683organises
oxalises1538503_oxalises
paganises1239723paganises
penalise101013763penalise_
penalised12108823penalised
penalizes20911843penalizes
realise73021813re_alise_
realised92214533re_alised
realiser82512563re_aliser
realisers9248323re_alisers
realisms102212163re_alisms
realists83014843re_alists
realizes173116843re_alizes
regales83520793regal__es
regalities11410593regalities
regalness1045473regalness
reguluses1044253reguluses
reraises8415643rera_ises
ruralises939123ruralises
secaloses1146913secaloses
serialises10811563serialises
signalises1145913signalises
tetanises979873tetanises
totalises9311783totalises
valises103516263__valises
veganisms1545413veganisms
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 Limit1486411107.40620070.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.60823487.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.