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

146 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
conjoin163820(None) 
cojoin1539501co_join
conjoins1738131conjoins
conjoint17410371conjoint
cojoins1638992co_joins
conin76232722con__in
conjoined1965462conjoined
conjoiner1855932conjoiner
conoid9818882con_oid
contain9315832contain
donjon1436462donjo_n
enjoin1357832_enjoin
adjoin14107293_adjoin
benzoin1846263benzoin
bonbon10310073bonbo_n
cajon144513903c_ajo_n
canakin131810833canakin
canikin13189753canikin
cannon84514443canno_n
canon74725303can_o_n
canton85722993canto_n
canyon114512033canyo_n
canzoni1836153canzoni
cinerin9313823cinerin
coalbin1137533coalbin
cocain101315013co_cain
coccoid11299283coccoid
cochin131313203co_chin
cocoon10312263co_coon
codein94916723co_dein
codlin94516443co_dlin
codon86522853co_do_n
coffin14339813co_ffin
cogon89120903co_go_n
coin66645353c___oin
coition9314313coition
cojoined1856293co_joined
colicin11313743colicin
colin76231693co__lin
colloid10312883colloid
colon78630193co_lo_n
coloni85619203co_loni
common12310803commo_n
complin13312073complin
conation101420883conation
conceit113218073conceit
concern113011963concern
conchie143312683conchie
conchoid1688043conchoid
concoct10312903concoct
concord12510343concord
condemn1237113condemn
condign1147733condign
condo85322593condo__
condoes104319203condoes
condole102914953condole
condoling13510373condoling
condom114215363condo_m
condoms124214083condoms
condone102616293condone
condoning1339783condoning
condor94616973condo_r
condors104018573condors
condos94322333condo_s
conduit10713083conduit
confine12315583con_fine
confit113316403con_fit
conform14310463conform
confound1445903confound
congaing1239823congaing
congii957363con_gii
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
coni65534803con__i_
conic95329793con__ic
conidia1069303conidia
conidian1168383conidian
coniine9316803con_iine
conine84528553con__ine
coning94331823con__ing
conins84327233con__ins
coniosis1048133coniosis
conjoiners1955403conjoiners
conjoining2046103conjoining
conjointly2252793conjointly
conjure16109073conjure
conjuring1937913conjuring
conking143618453con_king
conn66229133con___n
conning103718753con_ning
connote9311613connote
connoting12310023connoting
conoids10813883con_oids
conquian1945733conquian
consign1038773consign
consol82614113conso_l
console92715983console
consoling12310873consoling
consols92914073consols
consort91319903consort
contains10316533contains
contemn1137803contemn
conto76027173conto__
contort91422343contort
contos84923233conto_s
contour939973contour
convoke16207173convoke
convoking1935743convoking
convoy14348543convo_y
convoying1835983convoying
convoys15267023convoys
cooing94024923co__oing
coon67248943co__o_n
coonskin1444393coonskin
cordon95017293cordo_n
cormoid12310403cormoid
cortin82423153co_rtin
cotton8312993cotto_n
couloir936153couloir
coupon102810993coupo_n
cousin8517163co_usin
covin105621123co__vin
cowskin1645553cowskin
disjoin1547643disjoin
donjons1536733donjons
enjoins1457333_enjoins
glonoin875673glon_oin
gonion73612833gonio_n
join116724833___join
misjoin1637693misjoin
monsoon938493monsoon
nonjoiner1665333nonjoiner
nonpoint10411863nonpoint
ongoing938793_ongoing
onion54320973_onio_n
ponton83217643ponto_n
pontoon93010703pontoon
rejoin134012243_rejoin
ronion63315643ronio_n
ronyon9309133ronyo_n
subjoin1645443subjoin
unjoint1449233_unjoint
wonton93410963wonto_n

Search took 8 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.406440125.6
2DLD Change Limit1340271466.93619323.4
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.38824186.7
 
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.