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

41 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
southrons124584(None) 
southron1145491southron_
southerns12347212southerns
boutons9310783bout__ons
boxthorns2143023boxthorns
deuterons1046783deuterons
erythrons1554973erythrons
isochrons1444233iso_chrons
moutons9410313mout__ons
neutrons838293neut_rons
outcrops1246853_outcrops
outcross1036823_outcross
outcrows1346653_outcrows
outdrops1136543_outdrops
outfrowns1543813_outfrowns
outgrins979823_outgrins
outgross936423_outgross
outgrows1236283_outgrows
outrows10311403_out_rows
outruns72911543_out_runs
outthrobs14103153_outthrobs
outthrows15123693_outthrows
outtrots838373_outtrots
scutcheons1752093scutcheons
shorthorns1643613shorthorns
solutions988883solut_ions
souchong1484513souch_ong
souchongs1593253souch_ongs
soupcons1244373sou_pcons
souters74422603souter__s
southbound1662063southbound
southern11438913southern_
southers114214453south_ers
southing122811823south_ing
southings13246233southings
southland1363713southland
southlands1463353southlands
southpaws1742183southpaws
souths95216603south___s
squadrons1943253squadrons
youthens1435383youth_ens

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 Limit148641417.14320809.3
3Display Results41410.0133153.8
 (SQL Overall)178691417.59223536.7
 
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.