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

74 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
outstands104554(None) 
outstand938041outstand_
outlands988562out_lands
outspans1038222outspan_s
outspends1294122outspends
outstares91610182outstares
outstarts9176322outstarts
outstates91710752outstates
outstays1156622outsta_ys
outstunts943612outstunts
upstands1144092_upstands
bedstands1343503bedstands
bookstands1752533bookstands
bustards11308513bu_stards
cabstands1453733cabstands
custards11338393cu_stards
homestands1644033homestands
husbands1444763hu_sbands
inkstands1443193inkstands
lotuslands1151773lotuslands
mustangs11255973mu_stangs
mustards11297883mu_stards
outadds936203ou__tadds
outboards1246213outboards
outfinds1235643out_finds
outflanks1643233outflanks
outland81212343out_land_
outleads9278763outlea_ds
outmans92413283out_man_s
outplans10259533outplan_s
outranks12298823out_ranks
outreads9289003outrea_ds
outsaid81210923outs_aid_
outsails8139863outs_ails
outsang83411273outs_an_g
outsays102710403outs_a_ys
outscolds12113653outscolds
outshames1445923outshames
outshines1238613outshines
outsings93410333outs_ings
outsins73417863outs_in_s
outskates13177153outskates
outsmarts11155143outsmarts
outsoars838853outsoa_rs
outspan938743outspan__
outspeeds12114233outspeeds
outspend11126203outspend_
outstanding1344553outstanding
outstare81410693outsta_re
outstared10188423outstared
outstart81611283outsta_rt
outstate81411993outsta_te
outstated10169813outstated
outstay1047683outsta__y
outstayed13185933outstayed
outsteers936033outsteers
outstood945933outstood_
outstride1085783outstride
outstrides1154753outstrides
outstrips1145213outstrips
outstrode1065423outstrode
outstudy1242923outst_udy
outstunt847223outstun_t
outswings1354353outswings
outtakes12310033out_takes
outtalks1236503out_talks
outtasks1235633out_tasks
outthanks1653153outthanks
outwards1299123out_wards
outwinds1235363out_winds
southlands1463353southlands
stands75118053___stands
upstand1045343_upstand_
withstands1752293withstands

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 Filter1786911486410.436409841.7
2DLD Change Limit148641747.42320024.4
3Display Results74740.0461608.7
 (SQL Overall)178691747.90522604.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.