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

282 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
conchas14401331(None) 
canchas143212401canchas
concha134213281concha_
conchae143911641conchae
conchal144211581conchal
conches144019811conches
conchos144313961conchos
conchs134714901conch_s
cancha134411612cancha_
cinches144215772cinches
coaches144018692coaches
cocas95926572co_c_as
cocoas104915742co_coas
conceal113313012conceal
conceals123111012conceals
conch124620072conch__
conchie143312682conchie
conchies153214852conchies
concho134414262conch_o
conchy163710222conch_y
concurs11311472concurs
concuss1138062concuss
congas94417032con_gas
contras93015622contras
cooches143515832cooches
couches144020472couches
gotchas1334612gotchas
honchos15369572honchos
mochas13310662mo_chas
ponchos143410702ponchos
anchos114214893_anchos
benches143918603benches
boccias13307193boccias
boches134618523bo_ches
bonitas939453bonitas
botches143716023botches
bronchos15206173bronchos
bronchus15204743bronchus
bunches144116033bunches
cacas95627983c_ac_as
caches137926913c_aches
cancan10314103canc_an
cancans11311873cancans
cancels114113313cancels
cancers114018583cancers
cannas84518403can_nas
canolas9313993canolas
canthal12410053canthal
canthus1248713canthus
canulas9312853canulas
canvas113813333can_vas
catches144320773catches
centas85020703cen_tas
chachkas22173733chachkas
chacmas1638003chacmas
chicas135916473chic_as
chichis1737073chichis
chinches18369363chinches
cinch124516243cinch__
cinched153910863cinched
cinchonas1644013cinchonas
cinemas1138043cinemas
clachan1437183clachan
clachans1546413clachans
clachs133511323clach_s
clenches152910953clenches
cliches144213743cliches
clinches153910363clinches
cloacas1136233cloac_as
cloches144113713cloches
coach125919453coach__
coached153313843coached
coacher143714123coacher
coachers154312303coachers
coachman1744983coachman
coacts105314333coac_ts
coalas87418963co_alas
coanchor1545253coanchor
coanchors1645733coanchors
cobias104014993co_bias
cobras104014193co_bras
coca88030643co_c_a_
coccal9310223co_ccal
coccids11277213coccids
coccous1039003coccous
coccus979283co_ccus
cochair1446313co_chair
cochairs1545903co_chairs
cochin131313203co_chin
cochins141413103co_chins
cochleas1545273co_chleas
cocks135227163co_c_ks
cocoa98517883co_coa_
cocos95624693co_c_os
codas84724243co__das
codeias103911223codeias
cohos105921853co__hos
colas75436773co__las
colzas174010513co_lzas
comas95833003co__mas
commas124814573co_mmas
compas125817063co_mpas
conatus9310463conatus
concave1439373concave
concaves1538913concaves
concede12310103concede
concedes13311063concedes
conceit113218073conceit
conceits122813613conceits
concent114422513concent
concents122516603concents
concept133314443concept
concepts143110303concepts
concern113011963concern
concerns122710833concerns
concert113325223concert
concerts123016063concerts
conchoid1688043conchoid
conchoids1766273conchoids
concise11314473concise
conclave1556403conclave
conclaves1646543conclaves
concoct10312903concoct
concocts1138633concocts
concord12510343concord
concords1358593concords
concours1239473concours
concur10411103conc_ur
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333con_dos
cones76457423con__es
coneys115218423con_eys
confab1347063con_fab
confabs1435393confabs
confers124120093confers
confess12399903confess
confits122811423confits
conga85419873con_ga_
congeal104011683congeal
congeals11309853congeals
congees103517923congees
congers104223233congers
conges94928173con_ges
congius103210073congius
congoes103617303congoes
congos94219883con_gos
congous103615083congous
congrats11311433congrats
conical11316203conical
conics103920593con_ics
conies84338593con_ies
conines93827793conines
conins84327233con_ins
coniums11311863coniums
conkers133721043conkers
conks115525703con__ks
conners94023113conners
conns75024233con__ns
conoids10813883conoids
cons66057693con___s
consols92914073consols
consuls92412313consuls
contes84432913con_tes
contos84923233con_tos
contra83314703contra_
contrast102614783contrast
conus76726533con__us
conveys15308223conveys
convoys15267023convoys
cooch124916833cooch__
cooncan1147233coonc_an
cooncans1246273cooncans
coppras13327833coppras
coprahs14338153coprahs
copras103517153co_pras
copulas113811563copulas
corncobs1444723corncobs
corneas94717003corneas
corniches1666673corniches
coronas93916913coronas
coryzas2134803coryzas
coshes115022783co_shes
cottas84615573co_ttas
couch125320113couch__
couchant1549053couchant
couched154115793couched
coucher144515853coucher
couchers153513863couchers
coughs125514543cough_s
councils1246973councils
couths115715413couth_s
cowpeas1437273cowpeas
cranches153114543cranches
creches14313093creches
crotches153411303crotches
crouches153711293crouches
crunches153711353crunches
culches143710743culches
curches143512743curches
cutches143216463cutches
cycas126513823c_yc_as
dachas124113253_dachas
datchas1347423datchas
donas65926473don__as
dongas84914613don_gas
donnas75511323don_nas
douches134315233douches
dunches133312583dunches
enchase1239463_enchase
fincas113512073finc_as
finches153914193finches
gotcha1234633gotcha_
honcho14389383honch_o
hondas10313353hon_das
hooches153812523hooches
hotches153814363hotches
hunches153913463hunches
inches114419673_inches
kenches163912273kenches
kwachas1943063kwachas
loaches123613983loaches
lochan1139093lo_chan
lochans1248833lo_chans
lochs106715513lo_ch_s
lunches124115443lunches
lynches15378873lynches
manches143818623manches
mocha1249923mo_cha_
monachal1545703monachal
monas74732153mon__as
months113812933month_s
mooches143714453mooches
mouches143815963mouches
munches144215793munches
nachas114914193_nachas
nonas55126653non__as
noncash1245163nonc_ash
nonces84418833nonc_es
nonclass1046243nonclass
noncolas1048613noncolas
noncoms1139203noncoms
notches123513653notches
ocas66729633_o_c_as
orcas75918623_orc_as
orchis11710773_orchis
ouches114322183_ouches
pachas135017143_pachas
panchax2134983panchax
panochas1545653panochas
pinches144117933pinches
poaches144416943poaches
ponces104720843ponc_es
poncho133310123ponch_o
pooches143214163pooches
porches143815673porches
pouches144116743pouches
punches144816133punches
ranches123620113ranches
ranchos123911393ranchos
rhonchal1642673rhonchal
rhonchus1642053rhonchus
roaches123616213roaches
rotches123515703rotches
rouches124217893rouches
sconces113811453sconc_es
scooches15188413scooches
scorches15189143scorches
scotches15179473scotches
socas74026183so_c_as
sonatas7510293sonatas
synchs14408453synch_s
tenches123515523tenches
tongas74315523ton_gas
torches123715433torches
touches125118343touches
vincas113912453vinc_as
vouches153914113vouches
wenches152914133wenches
winches154714373winches
zonulas1637023zonulas

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 Limit1340272826.86019537.5
3Display Results2822820.0933032.3
 (SQL Overall)1786912827.35924282.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.