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

299 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
copalm12501081(None) 
copal95621781copal_
copalms13367541copalms
copals105018941copals
calm85032362c__alm
coal66939252co_al_
coala77521122co_ala
coals76129602co_als
coaly105521592co_aly
cobalt10317392cobalt
comal95125132comal_
copay126516312copa_y
copays134911272copays
copula102812042copula
coral76033452coral_
corals85325142corals
coxal146116672coxal_
napalm1047262napalm
nopal75517102nopal_
nopals84914022nopals
opal66923522_opal_
opals75718352_opals
palm85331362__palm
appal95315223appal_
appall10379743appall
appals104812943appals
balm85534203__balm
becalm1239203becalm
boral75831703boral_
borals86721913borals
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
calf96339563c__alf
calk105527663c__alk
call66838673c__all
calms95222353c__alms
calo64936443c__alo
calx135722793c__alx
cam78058983c__a_m
canal75428043canal_
canals84421663canals
capable13313363capable
capably1639253capably
carpal103716253carpal_
carpale113414353carpale
carpals113414623carpals
catalo8314853catalo
cecal94619113cecal_
chalk144814603c_halk
cham115532313c_ha_m
charm126124663c_harm
chasm125518793c_hasm
chiasm13449103chiasm
choral115118493choral_
chorale124313353chorale
chorals124614103chorals
cicala10310053cicala
cicale10314503cicale
claim95616913c_laim
clam86332293c_la_m
clonal8310913clonal_
coach125919453co_ach
coact96130573co_act
coalas87418963co_alas
coaled95022703co_aled
coaler84121703co_aler
coapt96131523co_apt
coapts104614003coapts
coast75236263co_ast
coat67558343co_a_t
coati75624633co_ati
coats75634993co_ats
coax136922973co_a_x
coaxal15387303coaxal_
cobalts1139203cobalts
cobble123615263cobble
coble94823173co_ble
coca88030643coca__
cocain101315013cocain
cocas95926573coca_s
coccal9310223coccal_
cockle143913573cockle
coda77029343coda__
codable12311663codable
codas84724243coda_s
coddle104713853coddle
coelom10310423coelom
coeval1138893coeval_
coevals1237873coevals
coffle14359043coffle
coil66439653co_il_
coils75030083co_ils
coital84117053coital_
col59360353co__l_
cola66541393co__la
colas75436773cola_s
cold77338773co__ld
coldly12459953coldly
cole66956113co__le
collar83816173collar
colly104926773co_lly
cols66553083co__ls
colt67158243co__lt
coly96940533co__ly
coma87134853coma__
comade114415323comade
comae97128423coma_e
comake144413423comake
comas95833003coma_s
comate104124843comate
comely134213733comely
compact153712213compact
company1619711143company
compare135814993compare
compart134016003compart
compas125817063compa_s
compass13379563compass
compel124412893compel_
compels133210883compels
compile13312443compile
comply152810383comply
condom114215363condom
conium10415313conium
cool66940493co_ol_
coolly114811393coolly
cools75632633co_ols
cooly105525423co_oly
cop711162373cop___
copaiba1344483copaiba
cope86847383cop__e
copeck1636943copeck
coped105036843cop_ed
copen94826433cop_en
copens106119963copens
coper95336093cop_er
copers104629843copers
copes97747103cop_es
copied114618563copied
copier103722893copier
copies104130303copies
copilot11811263copilot
coping113927663coping
coplot10518273coplot
copout10418773copout
copped135221253copped
copper124321893copper
coppra12306833coppra
copra98115463cop_ra
coprah133710603coprah
coprahs14338153coprahs
copras103517153copras
cops86751373cop__s
copse95623923cop_se
copses104922473copses
copter109822013copter
copulae112810613copulae
copular113810603copular
copulas113811563copulas
copy116229803cop__y
copyable1736623copyable
coracle112011723coracle
corium10315723corium
corm85735373co__rm
corral83616253corral_
corrals93713853corrals
cosily113613853cosily
costal85419513costal_
costly114012333costly
cotan71521783cota_n
cotans81317923cotans
could86517713co_uld
couple104415963couple
covary1438743covary
cowage12310663cowage
coward12411673coward
cowl97530813co_wl_
cowls106922213co_wls
cowpat13312033cowpa_t
cowpats1437713cowpats
coxa136922963coxa__
coxae146115183coxa_e
coxalgy2042603coxalgy
coyly135614893co_yly
cozily20349703cozily
craal74117753craal_
craals84113303craals
cram85635493c_ra_m
cream95721343crea_m
culm85822383c__ulm
cupel9514303cupel_
cupels10310203cupels
cupola10317693cupola
cuprum1236743cuprum
cupula10328433cupula
cupule103410723cupule
cuspal1037883cuspal_
domal85619203domal_
dopa77220903dopa__
dopant9316133dopant
dopas85019063dopa_s
dopily123510463dopily
dotal64919623dotal_
embalm1236653embalm
empale102611263empale
foal76630923fo_al_
foals85721693fo_als
foam97127173fo_a_m
focal104917673focal_
foram105124933fora_m
goal55829303go_al_
goals65521293go_als
goral65125753goral_
gorals76917653gorals
halm95834973__halm
holm95628103ho__lm
hopple132910483hopple
horal86328673horal_
imbalm1246323imbalm
impala10256933impala
impale102811663impale
joram145816983jora_m
joual12311653joual_
jouals1338923jouals
koala95112213ko_ala
loam65630483lo_a_m
local74820273local_
locale83915653locale
locals83714503locals
loral55927823loral_
loyal84513483loyal_
malm85129973__malm
modal85919233modal_
modals93914443modals
mohalim1446023mohalim
molal75120343molal_
moral75533433moral_
morale85220553morale
morals85324633morals
napalms1144033napalms
nodal64717793nodal_
nopales93812523nopales
notal55221353notal_
octal71214723octal_
ogam75120033_oga_m
oorali6311263oorali
opah96218403_opa_h
opahs105411983_opahs
opium92812093_opium
oral47638123_oral_
orals55826483_orals
oval77119523_oval_
ovals85413393_ovals
pal56761673__pal_
pale66055013__pale
pall65039343__pall
palms94921753__palms
palmy126016733__palmy
palp85828573__palp
pals66951353__pals
paly95835533__paly
pam77858393__pa_m
papal95820673papal_
pipal95118353pipal_
pipals104213643pipals
poplar103611113poplar
popple92710983popple
psalm949273_psalm
pupal97616873pupal_
qualm163511183_qualm
realm75621623_realm
roam67132413ro_a_m
robalo838923robalo
ropable111611333ropable
ropily113312443ropily
royal85014703royal_
royals93711263royals
scopula1154993scopula
sepal77723003sepal_
sepals85217373sepals
spale74929213_spale
spall74919303_spall
spam85930043_spa_m
spasm94514173_spasm
tapalo839793tapalo
tepal76319583tepal_
tepals85415043tepals
tonal53724303tonal_
topaz16315323topa_z
topple104411323topple
total55321823total_
totals63115163totals
typal105311153typal_
vocal104715643vocal_
vocals113811583vocals
woald94813073wo_ald
zocalo1735803zocalo
zoeal144813783zoeal_
zonal145116853zonal_

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162996.68616858.5
3Display Results2992990.0963114.6
 (SQL Overall)1786912996.93825755.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.