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

81 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
adjoint1510828(None) 
adjoin14107271adjoin_
adjoins1585981adjoins
adjoints16103871adjoints
adjoined1743512adjoined
adroit7518782adroi_t
anoint6423632a_noint
appoint11612482appoint
aroint6328152a_roint
joint125227722__joint
unjoint1449232unjoint
account11109043account
adamant101110443adamant
addict10711203ad_dict
adding93914963ad_ding
addling10229833addling
adenine8311213adenine
adit56443653ad__i_t
adjacent18134313adjacent
adjoining1844033adjoining
adjourn1563423adjourn
adjourns1662853adjourns
adjunct1753573adjunct
adjuring1735093adjuring
adjust1447173adj_ust
adjutant1664453adjutant
adjuvant1983023adjuvant
admit8319493ad_mi_t
admixt1637333ad_mixt
adnoun757033adnoun_
adnouns835453adnouns
adonis7314063ad_onis
adopt81219743ad_o_pt
adoring9412523adoring
adorn64917093ad_orn_
adorns74212613ad_orns
adown95611663ad_own_
adrift10313113ad_rift
advent102613753ad_vent
adzing174110013ad_zing
aloin55227413a_loin_
aloins65022203a_loins
altoist7313393altoist
amboina1137953amboina
amount8414483a_mount
anoints7311063a_noints
appoints1286403appoints
aroints7313133a_roints
aroynt9312893a_roynt
asquint16208323asquint
attaint7313473attaint
autoing8314043autoing
banjoist1745143banjoist
cojoin1539493cojoin_
cojoins1638993cojoins
conjoint17410373conjoint
dacoit9415443dacoi_t
dadoing1038523dadoing
dakoit11310333dakoi_t
dint56759053_d__int
disjoint1649233disjoint
djin12911633_dj_in_
djinn1355633_dj_inn
djins1368453_dj_ins
doing74923583_d_oing
doit56347853_d_oi_t
droit65127123_droi_t
endpoint1147103endpoint
enjoin1357833enjoin_
enjoins1457333enjoins
join116724833__join_
joins125818413__joins
joints133811453__joints
joist125125653__joist
midpoint13117493midpoint
point75338733__point
radioing1039383radioing
rejoin134012243rejoin_
rejoins143111383rejoins
unjoints1544433unjoints
waypoint1645333waypoint

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027818.71615377.1
3Display Results81810.0631285.7
 (SQL Overall)178691818.93519999.0
 
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.