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

50 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
scouthered164364(None) 
scouther1356942scouther__
scouthers1445992scouther_s
scuttered12166422sc_uttered
smothered1545682smo_thered
accoutered1542773accout_ered
bothered142110393_bo_thered
brothered1546003bro_thered
cluttered12185933_cluttered
coauthored1642423_coauthored
cohered133514693_co__hered
coinhered1536593_coinhered
coshered14610293_co_shered
cottered112511733_co_ttered
countered12312993_countered
couther123914623_couther__
mothered142310103_mo_thered
pothered142311043_po_thered
scattered12197353sc_attered
sceptered1444723scept_ered
scoured103811153scou___red
scouted104112033scout___ed
scouter93313323scout_er__
scouters103411303scout_er_s
scouthering1743483scouthering
scowdered1643733sco_wdered
scunnered1243803sc_unnered
scuppered1643933sc_uppered
shouldered1542233shouldered
shuttered13156333s_huttered
slathered13148533s_lathered
slithered13136623s_lithered
smoothened1642483smoothened
smotherer1444633smo_therer
smouldered1441963smouldered
southed114313993s_outh__ed
souther104116303s_outher__
southerly1544173s_outherly
southern11438913s_outher_n
southerns12347213s_outherns
southers114214453s_outher_s
spluttered13153173spluttered
sputtered12166323s_puttered
stoutened1053573stout_ened
stouthearted16112503stouthearted
stuttered10145763s_tuttered
swithered16135463s_withered
vouchered1843853_vouchered
wuthered15157433__wuthered
youthened1644143_youthened

Search took 10 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 Filter1786911406030.220812231.8
2DLD Change Limit140603509.26315179.0
3Display Results50500.0501000.0
 (SQL Overall)178691509.53318744.5
 
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.