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

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

121 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
scandalizes234453(None) 
scandalises1444801scandalises
scandalize2244611scandalize_
scandalized2454051scandalized
canalizes201113782_can_alizes
scandalise1344892scandalise_
scandalised1553522scandalised
vandalizes2346462_vandalizes
banalizes201210093_ban_alizes
canalises11515493_can_alises
canalize19914493_can_alize_
canalized21611693_can_alized
recanalizes2247043recan_alizes
sacralizes2148233s_acralizes
sandflies1346513s_andfli_es
scandaled1344663scandal__ed
scandaling14195453scandali_ng
scandalizing2554113scandalizing
scandalled1443073scandal_led
scandalous1343593scandal_ous
scandals1136993scandal___s
signalizes2046463sign_alizes
soundalikes1651913soundalikes
standardizes23212763standardizes
tantalizes19109943_tantalizes
vandalises1446813_vandalises
vandalize2246793_vandalize_
vandalized2445813_vandalized
actualizes2145904ac_tualizes
alkalizes22157354__alkalizes
analyzes20157194__an_alyzes
animalizes2148204__animalizes
annualizes1945084_annualizes
banalize191010934_ban_alize_
banalized21118704_ban_alized
canailles1148274_can_ailles
canalise10816214_can_alise_
canalised12810914_can_alised
canaries10318944_can_ari_es
candies104125614_cand__i_es
candles104422344_cand_l__es
cannabises1444434_cannabises
cannibalizes25143114_cannibalizes
canonizes2049594_can_onizes
cantabiles1445764_cantabiles
capitalizes2466914_capitalizes
capsulizes2383294_capsulizes
carbolizes23178164_carbolizes
cartelizes2147634_cartelizes
catalyzes2346054_ca_talyzes
centralizes2249424_centralizes
channelizes2552994channelizes
evangelizes2452504evangelizes
fantasizes2295464_fantasizes
feudalizes2344524_feudalizes
finalizes212810744_fin_alizes
labializes2145794_labializes
landlines1039764_land_lines
landslides1284184_landslides
macadamizes2751924macadamizes
mandolines1347104_mandolines
nasalizes1847234_na_salizes
penalizes20911854_pen_alizes
quandaries2064414quandari_es
racializes2148464_racializes
randomizes2244384_randomizes
reanalyzes2243224rean_alyzes
recanalize2147254recan_alize_
recanalized2346674recan_alized
sacralize2048974s_acralize_
sacralized2246984s_acralized
sandaled1039244s_andal__ed
sandaling112010564s_andali_ng
sandalled1145904s_andal_led
sandals82715204s_andal___s
sandlike1339714s_and_like_
sandlings11238094s_and_lings
sandpiles1246304s_and_piles
sanitizes181210134s_an_itizes
scandal1038674scandal____
scandalising1653254scandalising
scandalling1543444scandalling
scandias1137864scand__i_as
scandiums1443984scand__iums
scanties103215424scan__ti_es
scantlings1393314scan_tlings
scapolites1455694sca_polites
schematizes2785004schematizes
schmaltzes2652464sc_hmaltzes
schmalzes2543164sc_hmal_zes
secondaries1454044secondari_es
sensualizes2044714sensualizes
serializes19912054s_erializes
sexualizes2646534s_exualizes
shadflies1643834sha_dfli_es
shandies122714114shand__i_es
signalises1145914sign_alises
signalize1946914sign_alize_
signalized2145734sign_alized
slenderizes2152914slenderizes
socializes2148404s_ocializes
sodalites10128694s__odalites
soundalike1552284soundalike_
specializes2446444specializes
stabilizes21116064sta_bilizes
standardises14213084standardises
standardize22212754standardize_
standardized24222404standardized
standpipes1543074stand_pipes
stannaries1045784stannari_es
strandlines1244964strand_lines
tantalises101010104_tantalises
tantalites1099284_tantalites
tantalize181010574_tantalize_
tantalized20118924_tantalized
tantalizer19107284_tantalizer
tantalizers2084264_tantalizers
vandalise1347674_vandalise_
vandalised1545154_vandalised
vandalisms1645804_vandalisms
vernalizes2249324vern_alizes

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191218.34317837.6
3Display Results1211210.0631920.6
 (SQL Overall)1786911218.82920239.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.