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

224 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
coprahs1433815(None) 
coprah133710601coprah_
copras103517151copra_s
cobras104014192cobra_s
copals105018942cop_als
copays134911272cop_ays
copperahs18323892copperahs
coppras13327832coppra_s
copra98115462copra__
corals85325142co_rals
corrals93713852corrals
dourahs11487252dourahs
hoorahs13399612hoorahs
horahs126313872ho_rahs
opahs105411982_op_ahs
torahs95115642to_rahs
borals86721913bo_rals
boras75938303bo_ra_s
caphs124515373cap__hs
capias10318353capia_s
caporals1238923caporals
capris10415083capr_is
captans111612053captans
carats85929023c_arats
carpals113414633carpals
casbahs1436463casbahs
chalahs15289883chalahs
charas114223613chara_s
chetahs15347073chetahs
chorals124614113chorals
chuppahs2042073chuppahs
citrals91111673citrals
coalas87418963coala_s
coals76129603co__als
coats75635003co__ats
cobias104014993cobia_s
cobra95214403cobra__
cocas95926573co_ca_s
cocoas104915743cocoa_s
codas84724243co_da_s
coerces11311943coerces
coevals1237883coevals
cognacs1256043cognacs
cogways1634633cogways
coheads13289233coheads
coirs75221053coir__s
colas75436773co_la_s
coleads102911423coleads
collars93816573collars
colzas174010513colza_s
comas95833003co_ma_s
combats13311683combats
commas124814573comma_s
compares143816433compares
comparts144210833comparts
compas125817063compa_s
compass13379563compass
compress1439053compress
comrade12139213comrade
comrades13149773comrades
conchas144013313conchas
conchs134714903co_nchs
confabs1435393confabs
congas94417033conga_s
congrats11311433congrats
contras93015623contra_s
coolths1236013coolths
copal95621783cop_a_l
copalm125010813cop_alm
copalms13367543copalms
copay126516313cop_a_y
copecks1745873copecks
copens106119963cop_ens
copers104629843cop_ers
copes97747103cop__es
copiers114215963copiers
copies104130313cop_ies
copings124111843copings
copious11311963copious
coplots11511593coplots
copouts11311083copouts
copperah17304903copperah_
copperas14308573coppera_s
coppers133519753coppers
coppra12306833coppra__
cops86751373cop___s
copses104922483cop_ses
copters113621283copters
copulas113811573copulas
copycats1745083copycats
copyreads1743323copyreads
coral76033453co_ra_l
corbans11313173corbans
cords86030623co_r_ds
corers85231073co_rers
cores76361853co_r_es
corgis9314413co_rgis
corks116028273co_r_ks
corms95626223co_r_ms
corns76034763co_r_ns
cornus84816563co_rnus
corporals1347273corporals
corps95927043co_r_ps
corpses113913813corpses
corpus106015293co_rpus
corrade101111043corrade
corrades111211263corrades
corral83616253corra_l
corries94026803corries
cors66656443co_r__s
corsacs1139013corsacs
corses84433463co_rses
corves115122523co_rves
costars94218013costars
cotans81317923co_tans
cottars94412243cottars
cottas84615573cotta_s
cougars1038443cougars
coughs125514543co_ughs
courage10310993courage
courages11311393courages
courant9317973courant
courants10310803courants
courlans10117613courlans
courses94218893courses
courts84216173cour_ts
couths115715413co_uths
cowards1339613cowards
cowpats1437713cowpats
cowpeas1437273cowpea_s
cowries124218013cowries
crabs95421393c__rabs
crags85622573c__rags
crams96229153c__rams
craps95328643c__raps
crash109120013c__rash
crass76328043c__rass
craws105723123c__raws
cuirass934973cuirass
cuppas12458593cuppa_s
cuprous1149743cuprous
cuprums1334453cuprums
curaghs1334583c_uraghs
currachs1544543currachs
curraghs1442883curraghs
currans9310613currans
cypres1338523cypr_es
cypress1434653cypress
cyprians1544213cyprians
cyprus1335363cypr_us
dobras94811913dobra_s
dopas85019063dop_a_s
dourah10479813dourah_
douras75016723doura_s
ephahs1435503_ephahs
forams115115913fo_rams
forays124813003fo_rays
fourths13374953fourths
gerahs1039413_gerahs
goorals838713goorals
gorals76917653go_rals
hijrahs2043443hijrahs
hookahs17446663hookahs
hoorah124411113hoorah_
hoorays13418383hoorays
horah117922053ho_rah_
horas86333103ho_ra_s
houdahs1434243houdahs
howdahs1733613howdahs
huppahs1743333huppahs
hurrahs13336773hurrahs
jarrahs1735453jarrahs
jorams154810533jo_rams
kophs145010933kop__hs
koppas14407603koppa_s
koras95927113ko_ra_s
korats105416063ko_rats
loofahs13364623loofahs
lorans65117603lo_rans
lotahs9479873lo_tahs
mollahs12328283mollahs
moolahs12347383moolahs
morals85324643mo_rals
moras76438783mo_ra_s
morass84614503mo_rass
morays114613883mo_rays
morphs13149433mo_rphs
nopals84914023nop_als
norths96812323no_rths
obeahs1135863_obeahs
odahs95610083_o_dahs
okras94410973_okra_s
oompahs1434263oompahs
opah96218403_op_ah_
opals75718353_op_als
operas8312453_opera_s
orals55826483_o_rals
poplars113910333poplars
poppas93710713poppa_s
prahu105013973__prahu
prahus11458243__prahus
prams96125513__prams
praos74923563__praos
prats76333393__prats
praus74621753__praus
prays105022433__prays
qophs19507813qop__hs
ripraps1134943ripraps
rupiahs1253333rupiahs
sirrahs10377303sirrahs
sophs104916023sop__hs
soprani937403soprani
soprano937003soprano
sopranos1046433sopranos
soras55041013so_ra_s
sovrans1036483sovrans
sprags95715823_sprags
sprats85819933_sprats
sprays115913643_sprays
surahs94515543_surahs
tophs105220053top__hs
torah87125273to_rah_
toras55540373to_ra_s
worths127812893wo_rths

Search took 10 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.420425454.8
2DLD Change Limit1340272249.09614734.7
3Display Results2242240.0762947.4
 (SQL Overall)1786912249.59218629.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.