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

142 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
conjoins173813(None) 
cojoins1638991co_joins
conjoin1638201conjoin_
conjoint17410371conjoint
cojoin1539502co_join_
conins84327232con__ins
conjoined1965462conjoined
conjoiner1855932conjoiner
conjoiners1955402conjoiners
conoids10813882con_oids
contains10316532contains
donjons1536732donjo_ns
enjoins1457332_enjoins
adjoins1585983_adjoins
benzoins1945573benzoins
bonbons1139333bonbo_ns
canakins142010463canakins
canikins14219163canikins
cannons94412883canno_ns
canons85522063can_o_ns
cantons95221203canto_ns
canyons124511593canyo_ns
cinerins10414103cinerins
coalbins1237083coalbins
cocains111313923co_cains
coccoids12176793coccoids
cochins141413103co_chins
cocoons11310563co_coons
codeins103715483co_deins
codlins104116243co_dlins
codons96119463co_do_ns
coffins153110193co_ffins
cogons96818113co_go_ns
coins75834553c___oins
coitions10312853coitions
cojoined1856293co_joined
cojones163512103co_jones
colicins12312853colicins
colins85229043co__lins
collins93419833co_llins
colloids11310173colloids
colons86028683co_lo_ns
commons13311043commo_ns
complins14313113complins
conations111318903conations
conceits122813613conceits
concerns122710833concerns
conchies153214853conchies
conchoids1766273conchoids
concocts1138633concocts
concords1358593concords
concours1239473concours
condemns1336293condemns
condoes104319203condo_es
condoles113015803condoles
condoling13510373condoling
condoms124214083condo_ms
condone102616293condo_ne
condones112817393condones
condoning1339783condoning
condores113315643condores
condors104018573condo_rs
condos94322333condo__s
conduits111210063conduits
confine12315583con_fine
confines13315653con_fines
confits122811423con_fits
conforms1538873conforms
confound1445903confound
confounds1544323confounds
congaing1239823congaing
congius103210073con_gius
congoes103617303congo_es
congos94219883congo__s
congous103615083congo_us
conics103920593con__ics
conies84338593con__ies
coniine9316803con_iine
coniines10415363con_iines
conin76232723con__in_
conine84528553con__ine
conines93827793con__ines
coning94331823con__ing
conioses10313313conioses
coniosis1048133coniosis
conjoining2046103conjoining
conjointly2252793conjointly
conjures17119913conjures
conjuring1937913conjuring
conking143618453con_king
conning103718753con_ning
connotes10311453connotes
connoting12310023connoting
conns75024233con___ns
conoid9818883con_oi_d
conquians2045183conquians
consigns1137533consigns
consoles103216153consoles
consoling12310873consoling
consols92914073conso_ls
consorts101512343consorts
contain9315833contain_
contemns1237403contemns
contorts101112643contorts
contos84923233conto__s
contours1039653contours
convokes17247703convokes
convoking1935743convoking
convoying1835983convoying
convoys15267023convo_ys
cooing94024923co__oing
coons76737283co__o_ns
coonskins1544183coonskins
cordons104415763cordo_ns
cortins92421333co_rtins
cottons9312193cotto_ns
couloirs1045993couloirs
coupons112710563coupo_ns
cousins9516003co_usins
covins114618063co__vins
cowskins1745263cowskins
disjoins1647623disjoins
donjon1436463donjo_n_
enjoin1357833_enjoin_
glonoins955843glon_oins
joins125818413___joins
misjoins1736913misjoins
monsoons1047343monsoons
nonjoiner1665333nonjoiner
nonjoiners1764933nonjoiners
nonpoint10411863nonpoint
ongoing938793_ongoing
onions64016433_onio_ns
pontons93315553ponto_ns
pontoons10279313pontoons
rejoins143111383_rejoins
ronions73313343ronio_ns
ronyons10258433ronyo_ns
subjoins1745453subjoins
unjoint1449233_unjoint
unjoints1544433_unjoints
wontons103310533wonto_ns

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621427.48319532.5
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.96922423.3
 
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.