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

66 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
outstood94593(None) 
outscold11115252outscold
outscoop1243992outscoop
outshoot1149162outshoot
outsold8109072outs_old
outstand938042outstand
outstrode1065412outstrode
outtold8107602out_told
upstood1044242_upstood
footstool1272603footstool
nutwood1144953nut_wood
ousted73720583ou_st_ed
outbloom1244003outbloom
outcook1337203out_cook
outcrowd1444933outcrowd
outdoor836703out_door
outfool1037333out_fool
outfoot10411493out_foot
outlook1138023out_look
outplod10106343out_plod
outroot7516563out_root
outsaid81210923outs_aid
outsavor1194253outsavor
outscolds12113653outscolds
outscooped1542843outscooped
outscoops1343403outscoops
outscore10169203outscore
outscored12207073outscored
outscorn10166143outscorn
outshone1149343outshone
outshoots1245383outshoots
outshot10312103outs_hot
outshout1149483outshout
outsized18209733outsized
outsmoke1445753outsmoke
outsmoked1644773outsmoked
outsnore8187683outsnore
outsnored10175983outsnored
outsoar739493outs_oar
outsole71013433outs_ole
outsped101110323outs_ped
outspeed11117933outspeed
outspend11126203outspend
outspoke1446493outspoke
outstands1045543outstands
outstare81410693outstare
outstared10188423outstared
outstart81611283outstart
outstate81411993outstate
outstated10169813outstated
outstay1047683outst_ay
outstayed13185933outstayed
outstays1156623outstays
outsteer837553outsteer
outstride1085773outstride
outstrip1045073outstrip
outstroke1365213outstroke
outstrove1264713outstrove
outstudy1242923outstudy
outstunt847223outstunt
outswore11168673outswore
outsworn11166663outsworn
outtrot7312613out_trot
outvoted1237273outvoted
stood65517713___stood
withstood1651873withstood

Search took 9 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.1531167915.0
2DLD Change Limit146162668.47017256.4
3Display Results66660.0332000.0
 (SQL Overall)178691668.65620643.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.