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

137 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
outdress913732(None) 
outpress10118181outpress
buttress1035882buttress
coatdress1243192coatdress
outbless1037962outbless
outcross1036822outcross
outdares92712462outdare_s
outdoers937512outdoers
outdoes8313122outdoe_s
outdrags1046582outdrags
outdraws1236232outdraws
outdream1144712outdream
outdreams1243552outdreams
outdressed12235322outdressed
outdresses11236822outdresses
outdrew1137142outdre_w
outdrops1136542outdrops
outduels945052outduels
outgross936422outgross
outguess944982outguess
sundress936982sundress
tutoress845092tutoress
undress838892_undress
actress948533act_ress
address956103_address
authoress1245173authoress
boundless1235183boundless
boundness1235943boundness
budless1038873bu_dless
cateress102311613cateress
coutures10311993couture_s
cuteness1039673cuteness
cutgrass1144343cutgrass
dress65319833___dress
duress74712063du__ress
eldress835003_eldress
fortress1136753fort_ress
futures10310263future_s
goutiness1038763goutiness
gutless82610713gut_less
hotpress1344303hotpress
housedress1443313housedress
hundreds1344003hundreds
huntress1144833huntress
laundress1042813laundress
loudness937013lou_dness
mattress1036533mattress
mouthless1444713mouthless
murderess1243593murderess
muteness1039013muteness
nutgrass943933nutgrass
oddness935313o_ddness
ogress7529503o__gress
oldness836403o_ldness
oppress1135993o_ppress
oratress834553oratress
outages82317323outage_s
outbegs1036483out_begs
outbrags1136693outbrags
outbreak1444773outbreak
outbreaks1544073outbreaks
outbred10311263outbre_d
outbreed1138503outbreed
outbreeds1244223outbreeds
outclass1037203outclass
outcries10313573outcries
outcrops1246853outcrops
outcrows1346653outcrows
outcurses1145803outcurses
outdare83113403outdare__
outdared102711513outdare_d
outdates93114743outdates
outdoer849273outdoe_r
outdoors936433outdoors
outdrag937003outdr_ag
outdrank1345433outdrank
outdraw1136903outdr_aw
outdrawn1245013outdrawn
outdreamt1244203outdreamt
outdressing13104783outdressing
outdrink1346553outdrink
outdrinks1443683outdrinks
outdrive1236893outdrive
outdrives1346703outdrives
outdrop1036193outdr_op
outdrove1236473outdrove
outdrunk1343473outdrunk
outduel837303outdue_l
outers64230173out__ers
outfeels1135063outfeels
outfires1139863outfire_s
outgoes8312643outgoe_s
outgrew1136713outgre_w
outgrins979823outgrins
outgrows1236283outgrows
outkeeps1443583outkeeps
outkiss1137783out_kiss
outlets73616363out_lets
outliers82610673outliers
outlies72421993outlie_s
outpass939713out_pass
outprays13236933outprays
outpreen1046913outpreen
outpreens1144603outpreens
outpressed13126153outpressed
outpresses12157253outpresses
outre53922203out_re__
outread82811093out_read
outreads9289003out_reads
outrigs82811263out_rigs
outrows10311403out_rows
outruns72911543out_runs
outrush1037043out_rush
outsees72616433out_sees
outserts8309803outserts
outsets73514923out_sets
outtrots838373outtrots
outvies102214243outvie_s
outweeps1344013outweeps
overdress1346593overdress
pantdress1243363pantdress
porteress1137933porteress
portress1038323port_ress
redress82511873_redress
roundness1047013roundness
ruthless1135413ruthless
soundless1035533soundless
soundness1036963soundness
stress66616673_st_ress
suppress1236443suppress
sutures7314223suture_s
tress55423163__t_ress
undrest8313013_undrest
votaress1144223votaress
votress1035483vot_ress
wardress12256163wardress
woundless1334033woundless

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.423422437.4
2DLD Change Limit1461621376.75021653.6
3Display Results1371370.0602283.3
 (SQL Overall)1786911377.23324705.0
 
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.