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

67 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
adjoined174351(None) 
adjoin14107292adjoin__
adjoins1585982adjoin_s
adjoint15108282adjoin_t
adjoints16103872adjoints
adjourned1842062adjourned
adorned9256892ad_orned
cojoined1856292cojoined
enjoined16215722enjoined
joined144613072__joined
rejoined16318592rejoined
unjoined16248442unjoined
acorned10238283a_corned
adenine8311213adenine_
adenines9310193adenines
adjoining1844033adjoining
adjudged1941913adjudged
adjured1634883adj_ured
adjusted1743613adjusted
admired1135703ad_mired
admixed1833733ad_mixed
adopted1136263ad_opted
adored84714243ad_o_red
adorner8246983ad_orner
adroiter946193adroiter
adsorbed1243443adsorbed
advised12136043ad_vised
affined1436413a_ffined
alined75221403a__lined
anointed938343a_nointed
appointed1444803appointed
aproned10311503apro_ned
arointed939003a_rointed
assoiled935023assoiled
astonied978983astonied
atoned75417543a_to_ned
attained997353attained
attorned955363attorned
avoided1235553a_voided
coined94523603__coined
conjoined1965463conjoined
defined123813823_defined
dined76431993_d__ined
disjoined1845833disjoined
divined12329693_divined
doiled84817293_d_oiled
doited85016633_d_oited
donned85015743_d_onned
downed115314783_d_owned
drained93713253_drained
droned84616863_dro_ned
drowned12419903_drowned
dwined114610213_d_wined
eloined8149813_eloined
enjoiner15225653enjoiner
foined105915013__foined
gadrooned1243403gadrooned
groined92710813_groined
joiner134114133__joiner
jointed15378503__jointed
misjoined1945453misjoined
quoined1735783_quoined
recoined113614433recoined
rejoiced18296923rejoiced
subjoined1944233subjoined
uncoined111813023uncoined
unjointed1755583unjointed

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.453394461.4
2DLD Change Limit146162677.53019410.6
3Display Results67670.0332030.3
 (SQL Overall)178691678.01622291.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.