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

161 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
adjoin1410729(None) 
adjoins1585981adjoins
adjoint15108281adjoint
adjoined1743512adjoined
adjoints16103872adjoints
adjourn1563432adjourn
adnoun757032adnoun
adorn64917092ad_orn
adown95611662ad_own
adroit7518792adroit
aloin55227422a_loin
cojoin1539502cojoin
djin12911632_dj_in
enjoin1357832enjoin
join116724832__join
rejoin134012242rejoin
aboil72217543a_boil
aboon74918703a_boon
acetin8314693acetin
acorn75616623a_corn
actin74922553a_ctin
action84719683action
acyloin1247463acyloin
adagio847673adagio
adding93914963ad_ding
addling10229833addling
adenine8311213adenine
adenoid959253adenoid
adios65822863adio_s
adipic1137263adipic
adit56443653ad__it
adjoining1844033adjoining
adjourns1662863adjourns
adjure1435843adjure
adjuring1735103adjuring
adjust1447183adjust
adman84517903ad_man
admen84516183ad_men
admit8319493ad_mit
admix1557733ad_mix
adnouns835453adnouns
ado49146873ad_o__
adobe84814713ad_obe
adobo84711593ad_obo
adonis7314063adonis
adopt81219743ad_opt
adore65723673ad_ore
adoring9412523adoring
adorns74212613ad_orns
ados57633513ad_o_s
adoze155713833ad_oze
adsorb946953adsorb
adwoman1345433adwoman
adwomen1345683adwomen
adzing174110013ad_zing
aeon45634613a_eo_n
again65218123a_gain
agin56132713a__gin
agon56531883a_go_n
ain37579093a___in
ajowan1634893a_jowan
akin86328033a__kin
alanin6317273alanin
aldrin7311243aldrin
alevin92511513alevin
alexin132311483alexin
algin65718763a_lgin
algoid83011473algoid
aloins65022203a_loins
alumin8513543alumin
amain74922913a_main
amboina1137963amboina
amidin94015673amidin
amin66042253a__min
amnion84812053amnion
ancon75718233anco_n
android9311513android
anilin6417793anilin
anion55028813anio_n
anoint6423633a_noint
anon46134853a_no_n
anyon85615223anyo_n
appoint11612483appoint
apron7318833apro_n
argon65520593argo_n
aroid65428343a_roid
aroint6328153a_roint
arshin9312173arshin
arson55118833arso_n
askoi9507803askoi_
assoil688543assoil
aswoon947013aswoon
atropin9311583atropin
attain6311753attain
attorn6310793attorn
atwain937813atwain
autoing8314043autoing
auxin121411913a_uxin
avidin103510843avidin
avion84218343avio_n
avoid95516683a_void
axion1211316913axio_n
axon115524303a_xo_n
ayin76331743a__yin
azlon144312873azlo_n
azoic162912063a_zoic
azon135725053a_zo_n
cajon144513903cajo_n
coin66645353__coin
cojoins1638993cojoins
conjoin1638203conjoin
dacoit9415453dacoit
dadoing1038523dadoing
dahoon1039053dahoon
dakoit11310353dakoit
din46459463_d__in
dioxin14118783_dioxin
disjoin1547643disjoin
djinn1355633_djinn
djins1368453_dj_ins
doing74923583_d_oing
doit56347853_d_oit
don46757653_d_o_n
down86427493_d_own
drain65222893_drain
droid74218543_droid
droit65127123_droit
drown95515823_drown
eloin55923203_eloin
enjoins1457333enjoins
essoin638193essoin
fadein1068843fad_ein
foin77231563__foin
gadjo1436913gadjo__
gadoid9310463gad_oid
gadroon938173gadroon
gaijin1445983gaij_in
groin65521083_groin
hadji16839893hadj_i_
hadjis17439653hadj_is
hadron102913753hadro_n
heroin94420593heroin
jin106443933__j_in
john145512903__john
joins125818413__joins
joint125227723__joint
ladron73413323ladro_n
ladykin1543963ladykin
loin46838723__loin
madzoon1996063madzoon
misjoin1637693misjoin
odeon6411483odeo_n
padroni10278613padroni
quoin144012323_quoin
radioing1039383radioing
radon64620503rad_o_n
recoin84320293recoin
rejoins143111383rejoins
subjoin1645443subjoin
udon56017743ud_o_n
unjoint1449233unjoint

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161614.87323130.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911615.04535419.4
 
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.