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

108 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
outdoors93643(None) 
outdoers937511outdoers
outdoor836711outdoor_
outdoorsy1341781outdoorsy
outcooks1436722outcooks
outdoer849272outdoer_
outdoes8313122outd_oes
outdrops1136542outdrops
outfools1136532outfools
outfoots1136882outfoots
outlooks1236792outlooks
outpours1036682outpours
outroars838922outroars
outroots839872outroots
outsoars838852outsoars
authors10311853aut_hors
boudoirs1143703bou_doirs
cutdowns1443343cutdowns
doors65022133___doors
indoors838553_indoors
nutwoods1244263nutwoods
odors64514283o__d_ors
odours7418253o__dours
outblooms1342973outblooms
outboard1138323outboard
outboards1246213outboards
outboxes1737823outboxes
outcomes1239763outcomes
outcook1337203outcoo_k
outcrops1246853outcrops
outcross1036823outcross
outcrows1346653outcrows
outdare83113403outd_are
outdares92712463outdares
outdates93114743outdates
outdo6312703outd_o__
outdodge1143773outdodge
outdodges1243993outdodges
outdoing1039423outdoing
outdone8311643outd_one
outdoorsman146693outdoorsman
outdoorsmen146713outdoorsmen
outdrags1046583outdrags
outdraws1236233outdraws
outdress9137323outdress
outdrop1036193outdro_p
outdrove1236473outdrove
outduels945053outduels
outers64230173out__ers
outflows1445463outflows
outfool1037333outfoo_l
outfoot10411493outfoo_t
outfoxes1836743outfoxes
outglows1244933outglows
outgoes8312643out_goes
outgross936423outgross
outgrows1236283outgrows
outhears11810393outhears
outhomers1446063outhomers
outhowls1445723outhowls
outhumors1442593outhumors
outliers82610673outliers
outlook1138023outloo_k
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outplods11105613outplods
outplots1086363outplots
outpolls1046213outpolls
outport9714123out_port
outports1048273outports
outposts1037253outposts
outpour937423outpour_
outpowers1445193outpowers
outroar739513outroar_
outrocks1437903outrocks
outrolls847823outrolls
outroot7516563outroo_t
outrows10311403out_rows
outsavors1283113outsavors
outscoops1343403outscoops
outscore10169203outscore
outscores11178463outscores
outscorn10166143outscorn
outscorns11144883outscorns
outshoots1245393outshoots
outsnore8187683outsnore
outsnores9176773outsnores
outsoar739493outsoar_
outsoles8813113outsoles
outswore11168673outswore
outsworn11166663outsworn
outtowers1244763outtowers
outtrots838373outtrots
outvotes1137903outvotes
outwars10912793out_wars
outwears1197263outwears
outwore101912693out_wore
outwork141710353out_work
outworks15148973outworks
outworn101610753out_worn
pandoors11258983pandoors
putdowns1443523putdowns
sudors7311103su_d_ors
tandoors9258053tandoors
tutors6912333tut__ors
undoers82910583_undoers
unmoors945903_unmoors

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 Limit1461621086.59322169.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.06225303.2
 
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.