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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
scandalised155352(None) 
scandalise1344891scandalise_
scandalises1444801scandalises
scandalized2454051scandalized
canalised12810912_can_alised
scandaled1344662scandal__ed
scandalize2244612scandalize_
scandalizes2344532scandalizes
scandalled1443072scandal_led
vandalised1545152_vandalised
canalise10816213_can_alise_
canalises11515493_can_alises
canalized21611693_can_alized
sandaled1039243s_andal__ed
sandalled1145903s_andal_led
scandaling14195453scandali_ng
scandalising1653253scandalising
scandals1136993scandal_s__
signalised1244243sign_alised
standardised15182393standardised
tantalised11126983_tantalised
vandalise1347673_vandalise_
vandalises1446813_vandalises
vandalized2445813_vandalized
alkalised14155264__alkalised
analysed12166914__an_alysed
banalized21118704_ban_alized
caddised13315894_ca_d_dised
canaled103615564_can_al__ed
canalize19914494_can_alize_
canalizes201113784_can_alizes
canalled1139584_can_al_led
candied113816024_cand__i_ed
candled113815744_cand_l__ed
cannabises1444434_cannabises
cannibalised17142264_cannibalised
canonised1256714_can_onised
canvased14246224_canva__sed
canvassed15274044_canva_ssed
capitalised1684854_capitalised
cartelised1344914_cartelised
centralised1446604_centralised
fantasised14104344_fantasised
finalised13338014_fin_alised
mandamused1652094_mandamused
nasalised1045914_na_salised
penalised12108834_pen_alised
recanalized2346674recan_alized
sacralized2246984s_acralized
sandaling112010564s_andali_ng
sandals82715204s_andal_s__
sandalwood1551744s_andalwood
sandblasted1552114s_andblasted
sandflies1346514s_andfli_es
sandlike1339714s_and_like_
sanitised10147354s_an_itised
scandal1038674scandal____
scandalizing2554114scandalizing
scandalling1543444scandalling
scandalous1343594scandal_ous
scandalously1862394scandalously
serialised1188284s_erialised
signalise1046394sign_alise_
signalises1145914sign_alises
signalized2145734sign_alized
socialised1345944s_ocialised
soundalike1552284soundalike_
soundalikes1651914soundalikes
specialised1654534specialised
stabilised13104594sta_bilised
standardise13173144standardise_
standardises14213084standardises
standardized24222404standardized
tantalise91210824_tantalise_
tantalises101010104_tantalises
tantalized20118924_tantalized
vandalish1645994_vandalis_h
vandalism1546874_vandalis_m
vandalisms1645804_vandalisms
vandalize2246794_vandalize_
vandalizes2346464_vandalizes

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 Limit148819818.26618003.8
3Display Results81810.0302700.0
 (SQL Overall)178691818.71920494.4
 
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.