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

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

99 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
decolors118771(None) 
decolor1087031decolor_
decolours1274411decolours
recolors1078811recolors
bicolors1256162bicolors
colors86622372__colors
decalogs1245632decalogs
decoders122810412decoders
decolored1345662decolored
decolour1185012decolour
decorous1138852decorous
decors94017772dec__ors
decoyers14287712decoyers
discolors1246592discolors
dolors75115312d__olors
recolor978692recolor_
beclogs1237073bec_logs
bicolor1145613bicolor_
bicolours1343363bicolours
cologs96517353__cologs
colons86028683__colons
color76123743__color_
colours95913443__colours
dealers84118613de_alers
deboners11268113deboners
debtors1038533de_btors
decagons1235893decagons
decalog1136003decalo_g
decals93717713decal__s
decapods1444623decapods
decayers14307963decayers
deciders123510753deciders
deciles104417723decil_es
deckers144413833dec_kers
deckles143312803deckl_es
declare10411223dec_lare
declares11611313dec_lares
declass1038733dec_lass
declaws1336253dec_laws
decocts1237833deco_cts
decoder113712293decoder_
decodes113914983deco_des
decoloring1486313decoloring
decolorize2256063decolorize
decolorizes2345883decolorizes
decoloured1443083decoloured
decor84717573dec__or_
decorators1347873decorators
decorums1344993decorums
decos85522123dec__o_s
decouplers1573083decouplers
decoyer13348683decoyer_
decoys123911283dec__oys
decreers11277623decreers
decriers11299733decriers
defilers12439473defilers
delators92314823delators
deodars937623de_odars
deplore1039483de_plore
deplores1139533de_plores
deploys1336523de_ploys
deposers11359243deposers
desolators1146283desolators
detours858043deto_urs
develops14145323develops
devisors12347253devisors
devoirs1175783devo_irs
devolves15286263devolves
devours1166643devo_urs
dewools1145593dewo_ols
discolor1146423discolor_
discolours1343823discolours
doctors1039993doc_tors
dolor67617963d__olor_
dolours8438823d__olours
donors75115793d__onors
doors65022133d__o_ors
duologs935363d_uologs
ecology13218823_ecology
ecotours1044463_ecotours
escolars1045343escolars
hecklers17357123hecklers
hectors123513263hec_tors
lectors93415763lec_tors
miscolors1345863miscolors
noncolors1147033noncolors
oecology14227273oecology
overcolors15124823overcolors
recoilers11318153recoilers
recolored1246853recolored
recooks134711233reco_oks
recovers133511123recovers
rectors93520523rec_tors
sectors93116453sec_tors
seculars10219393seculars
settlors8255013settlors
temblors1244463temblors
tricolors11125803tricolors
vectors123212593vec_tors

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.420425454.8
2DLD Change Limit146162997.28320068.9
3Display Results99990.0303300.0
 (SQL Overall)178691997.73323107.6
 
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.