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 “unjoint” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
unjoint144923(None) 
unjoints1544431unjoints
adjoint15108282adjoint
anoint6423632an_oint
conjoint17410372conjoint
enjoin1357832enjoin_
enjoins1457332enjoins
gunpoint1146672gunpoint
joint125227722__joint
undoing9312242undoing
unjoined16248442unjoined
unjointed1755582unjointed
adjoin14107293adjoin_
adjoins1585983adjoins
adjoints16103873adjoints
anoints7311063an_oints
appoint11612483appoint
aroint6328153_aroint
banjoist1745143banjoist
buncoing13337813buncoing
bunkoing15355643bunkoing
cojoin1539503cojoin_
cojoins1638993cojoins
conjoin1638203conjoin_
conjoins1738133conjoins
disjoint1649233disjoint
endpoint1147103endpoint
enjoined16215723enjoined
enjoiner15225653enjoiner
enjoying1935003enjoying
gunflint1245943gunflint
gunpoints1243273gunpoints
ingoing9311023ingoing
join116724833__join_
joins125818413__joins
joints133811453__joints
joist125125653__joist
nonpoint10411863nonpoint
ongoing938793ongoing
outpoint10311513outpoint
penpoint1249453penpoint
pinpoint1248993pinpoint
point75338733__point
rejoin134012243rejoin_
rejoins143111383rejoins
subjoin1645443subjoin_
subjoins1745453subjoins
unaging9510933unaging
unakin10310963unakin_
unbeing1039373unbeing
unbent83216593un_bent
unbind93011433un_bind
unbolt83013893unbo_lt
unbonnet1047173unbonnet
unborn83310813unborn_
unbound10158393unbound
unbowing1436993unbowing
unboxing1836113unboxing
unbuilt948003unbuilt
unburnt977413unburnt
uncini8310153un_cini
uncoil8811853uncoi_l
uncoils979533uncoils
uncoined111813023uncoined
undine7817263un_dine
undoings1035793undoings
undone7914253undo_ne
undying1238503undying
unfit84518563un_fi_t
unfixt16398423un_fixt
unfond10149113unfo_nd
unfound11127393unfound
ungirt71112713un_girt
ungot61718063ungo__t
unguent839123unguent
union54519793unio_n_
unionist8410353unionist
unions64216753unio_ns
unit45140073un__i_t
uniting8315823uniting
unjointing1843963unjointing
unjust1337873unj_ust
unkent103116053un_kent
unkind113310573un_kind
unkink9308713un_kink
unknit1068593unkni_t
unlink104011013un_link
unlit55025463un_li_t
unloving1277483unloving
unmeant9510903unmeant
unmixt15378703un_mixt
unmoving1436253unmoving
unmown11296093unmown_
unnoisy1044243unnoisy
unpent83117373un_pent
unpin72613243un_pin_
unpins82312383un_pins
unpliant1047143unpliant
unpointed1237153unpointed
unquiet16310663unquiet
unrent63219783un_rent
unrobing1138063unrobing
unroot6315553unro_ot
unround8138503unround
unsent63820963un_sent
unshift1387413unshift
unsling8313643unsling
unsound8158433unsound
unsown9328433unsown_
unspent92610893unspent
unspilt938853unspilt
unspoilt1044883unspoilt
unthink1457003unthink
untorn63012343untorn_
untwine1038623untwine
untwist1047713untwist
untying1138943untying
unvoice12126153unvoice
unwind102610543un_wind
unwit84417523un_wi_t
unwon84512343unwo_n_
unworn93411333unworn_
unwound11126613unwound
unyoking1636183unyoking
unyoung1184053unyoung
upgoing1135353upgoing

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271268.73615341.9
3Display Results1261260.0931354.8
 (SQL Overall)1786911269.24919320.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.