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

206 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
conchie14331268(None) 
conchae143911641conchae
conchies153214851conchies
cochin131313202co_chin
concave1439372concave
concede12310102concede
conceit113218072conceit
conceive1539232conceive
conch124620072conch__
concha134213282conch_a
conchal144211582conchal
conchas144013312conchas
conches144019812conches
concho134414262conch_o
conchoid1688042conchoid
conchos144313962conchos
conchs134714902conch_s
conchy163710222conch_y
concise11314472concise
couthie121810552couthie
hoochie1537802hoochie
banshie12129543banshie
boccie123311453bo_ccie
boche124216953bo_ch_e
bolshie1247123bolshie
bonnie85314853bon_nie
botchier15287143botchier
bouchee143313543bouchee
boychik2143943boychik
bronchi14176313bronchi_
bronchia15195993bronchia
bunchier1536153bunchier
cache125122483c_ach_e
cancha134411613canch_a
canchas143212403canchas
cannie83819363can_nie
canthi11310973canthi_
catchier15329863catchier
chichi1637093chichi_
chichier1836023chichier
chichis1737073chichis
chinchier1944633chinchier
cinch124516243cinch__
cinched153910863cinched
cinches144215773cinches
cinching163310223cinching
cliche133712453clich_e
cloche134312373cloch_e
coach125919453coach__
coached153313843coached
coacher143714123coacher
coaches144018693coaches
coaching164011963coaching
coachmen1745013coachmen
coactive1598623coactive
coanchor1545253coanchor
cocain101315013co_cain
cocaine111315173co_caine
cocci82812673co_cci_
coccic8298943co_ccic
coccid102910743co_ccid
coccoid11299283coccoid
cochair1446313co_chair
cochins141413103co_chins
cochlea1435343co_chlea
cockier154013623co_ckier
cockle143913573co_ckle
coincide1346493coincide
collie83621993co_llie
commie124215523co_mmie
conative131214623conative
concaved1636223concaved
concaves1538913concaves
conceal113313013conceal
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceited14310423conceited
conceits122813613conceits
conceived1746713conceived
conceiver1657413conceiver
conceives1639233conceives
concent114422513concent
concept133314443concept
concern113011963concern
concert113325223concert
conchoids1766273conchoids
conciser12310243conciser
conclave1556403conclave
conclude1344673conclude
concoct10312903concoct
concord12510343concord
concrete12411083concrete
concubine1545753concubine
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
condole102914953condole
condone102616293condone
conduce12139233conduce
conduit10713083conduit
condyle13247053condyle
cone67256963con___e
confide13310203confide
confine12315583confine
confit113316403con_fit
confuse1238853confuse
confute1239263confute
conge85227593con__ge
congee96024473con_gee
congii957363con_gii
coni65534803con__i_
conic95329793con__ic
conidia1069303conidia
conies84338593con__ies
coniine9316803coniine
conin76232723con__in
conine84528553con_ine
conjoin1638203conjoin
conjure16109073conjure
connate9315753connate
connive1238993connive
connote9311613connote
conoid9818883con_oid
conscribe1545923conscribe
console92715983console
conspire1257873conspire
consume11510133consume
contain9315833contain
conte76633203con__te
contrite10318543contrite
contrive13311353contrive
contuse9311413contuse
convene123314323convene
convoke16207173convoke
cooch124916833cooch__
cooches143515833cooches
cookie123716043co_okie
coolie83821603co_olie
coontie9311423coontie
cootie84223093co_otie
copihue1444143copihue
corbie103618203co_rbie
corncake1645263corncake
corncrib1443903corncrib
corniche1575923cornich_e
corrie83621223co_rrie
cosie74728263co__sie
coterie9417403coterie
couch125320113couch__
couched154115793couched
coucher144515853coucher
couches144020473couches
couching163213263couching
council1137473counc_il
couthier13218913couthier
cowhide1636143co_whide
cowpie133511513co_wpie
cowrie113814283co_wrie
cozie163519133co__zie
creche13310763crech_e
crunchier1644683crunchier
donsie7613643don_sie
douche124613223douch_e
honcho14389383honch_o
honchoed1745733honchoed
honchos15369573honchos
honkie133011673hon_kie
hoochies1639603hoochies
lochia1158313lo_chia
louche115212663louch_e
macchie1647193macchie
manche133515103manch_e
monie75631653mon__ie
munchies1539253munchies
nitchie1247233nitchie
nonce75719823nonc__e
noncore9411953noncore
noncrime12116603noncrime
nonwhite1445703nonwhite
ochre103411593_o_chre
once65423083_onc__e
orchid1289573_orchid
orchil1158653_orchil
orchis11710773_orchis
poachier1556823poachier
ponce95222513ponc__e
poncho133310123ponch_o
ponchoed1646133ponchoed
ponchos143410703ponchos
pouchier1546803pouchier
punchier1536413punchier
rhonchi1542493rhonchi_
rotche114311983rotch_e
rouche114714313rouch_e
sconce104711723sconc__e
scrunchie1643033scrunchie
sonship12108653sonship
sonsie6614863son_sie
techie11511723_techie
torchier1337463torchier
touche114916173touch_e
touchier1347383touchier
toughie1187593toughie
unchic1338643_unchic
vouchee153411263vouchee

Search took 7 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 Limit1340272066.20321606.8
3Display Results2062060.0802575.0
 (SQL Overall)1786912066.68926714.2
 
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.