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

107 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
decolor108703(None) 
decolors1187711decolors
decolour1185011decolour
recolor978691recolor
bicolor1145612bicolor
color76123742__color
decalog1136002decalog
decoder113712292decoder
decolored1345662decolored
decolours1274412decolours
decor84717572dec__or
decoyer13348682decoyer
discolor1146422discolor
dolor67617962d__olor
recolors1078812recolors
beclog1136863bec_log
bicolors1256163bicolors
bicolour1243693bicolour
colog86619933__colog
colon78630193__colon
colors86622373__colors
colour85915093__colour
dealer74122143de_aler
deboner103110483deboner
debtor938333de_btor
decagon1135863decagon
decal85523233decal__
decalogs1245633decalogs
decals93717713decal_s
decapod1335433decapod
decayer13339353decayer
decider114213183decider
decile94619213decil_e
deciles104417723deciles
decker135215993dec_ker
deckle1312012453deckl_e
deckles143312803deckles
declare10411223dec_lare
declaw1266703dec_law
deco76125973dec__o_
decoct11313783deco_ct
decocts1237833decocts
decode104414743deco_de
decoded123212383decoded
decoders122810413decoders
decodes113914983decodes
decoloring1486313decoloring
decolorize2256063decolorize
decoloured1443083decoloured
decorator1248573decorator
decorous1138853decorous
decors94017773deco_rs
decorum1246943decorum
decos85522123dec__os
decoupler14113833decoupler
decoy115716313dec__oy
decoyed14358333decoyed
decoyers14287713decoyers
decoys123911283deco_ys
decreer10269123decreer
decrier102713553decrier
defiler113911883defiler
delator83015033delator
deodar837713de_odar
deplore1039483de_plore
deploy1237583de_ploy
deposer104011843deposer
desolator1046673desolator
detour778193deto_ur
develop13145033develop
devisor11357043devisor
devoir1076033devo_ir
devolve14316063devolve
devour1076703devo_ur
dewool1047403dewo_ol
dewools1145593dewools
dipolar1056853dipolar
discolors1246593discolors
discolour1244173discolour
doctor938993doc_tor
dolors75115313d__olors
dolour75710133d__olour
donor64418193d__onor
door56928513d__o_or
duolog835803d_uolog
ecology13218823_ecology
ecotour944363_ecotour
escolar946053escolar
heckler16278573heckler
hector113312653hec_tor
lector83514993lec_tor
miscolor1245603miscolor
noncolor1046513noncolor
oecology14227273oecology
overcolor14134803overcolor
recoiler103210493recoiler
recolored1246853recolored
recook125513923reco_ok
recover124312623recover
rector84019753rec_tor
sector83415933sec_tor
secular92211533secular
settlor7314733settlor
temblor1144093temblor
tricolor10115833tricolor
unicolor1043493unicolor
vector113212063vec_tor

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271075.90622693.4
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.34228175.8
 
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.