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

358 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
cougars103842(None) 
cougar958781cougar_
chukars1634272chukars
cigars9910712c_igars
codgers115113922codgers
collars93816572collars
congas94417032conga_s
congers104223232congers
costars94217992costars
cottars94412232cottars
coughers14399952coughers
coughs125514542coug_hs
couters93827282couters
gougers94911762gougers
nougats8427412nougats
oculars948362oculars
soucars938412soucars
sugars7312422_sugars
agars66120643__agars
ajugas1435263ajuga_s
alegars838933alegars
aoudads973753aoudads
augers73818703_augers
augurs7399963_augurs
beggars11378223beggars
boars75229603bo__ars
bogans95714813bo_gans
bogart9617193bo_gart
bogarts1047743bo_garts
boogers104514633boogers
boughs125414373boug_hs
bougies103715183bougies
boxcars1834773boxcars
boyars115611983bo_yars
cadgers114711993cadgers
caesars9410723caesars
cagers95624183c_agers
calcars11312653calcars
cars67364763c___ars
causals91411183causals
causers94014783causers
caviars1238623caviars
cedars93312833c_edars
cellars93713693cellars
chadars1338273chadars
chars105936633c__hars
chimars144010573chimars
choughs16576623choug_hs
chousers134610183chousers
chuddars15253453chuddars
chufas14397673chufa_s
chuggers1554853chuggers
chugs115511943chug__s
chukar1534633chukar_
chukkars1642003chukkars
churrs115111513chu_rrs
cigar8911793c_igar_
clears84116563c_lears
cloggers12437283cloggers
cloughs13517053cloug_hs
clours85215083clou__rs
clouters10399793clouters
coalas87418963coala_s
coalers94419333coalers
coals76129603co__als
coarse84813893co__arse
coaters93525773coaters
coats75634993co__ats
coaxers164311063coaxers
cobbers134114753cobbers
cobias104014983cobia_s
cobras104014193cobra_s
cocas95926573co_ca_s
cochairs1545893cochairs
cockers153618333cockers
cocoas104915743cocoa_s
codas84724243co_da_s
codders114114443codders
coders95426973co_ders
codger105814843codger_
coevals1237873coevals
coffers154112693coffers
cognacs1256043cognacs
cogons96818113co_gons
cogs77340033co_g__s
cogways1634633cogways
coheads13289233coheads
coheirs1236753coheirs
coignes103912153coignes
coigns94410063coig_ns
coilers93619903coilers
coiners93620753coiners
coirs75221053co__irs
colas75436773co_la_s
coleads102911423coleads
collar83816173collar_
collard103712923collard
collards113310193collards
colors86622373co_lors
colours95913413colours
colters93522433colters
colugos1035693colug_os
colzas174010503colza_s
comas95833003co_ma_s
combats13311683combats
combers134516613combers
comers105328083co_mers
commas124814573comma_s
compare135814993compare
compares143816433compares
compart134016003compart
comparts144210833comparts
compas125817063compa_s
compass13379563compass
concurs11311453concurs
condors104018553condors
confabs1435393confabs
confers124120093confers
conga85419873conga__
congaed11399743congaed
congeals11309853congeals
congees103517923congees
conger95024273conger_
conges94928173cong_es
congius103210073congius
congoes103617303congoes
congos94219883cong_os
congous103615083congous
congrats11311433congrats
conkers133721043conkers
conners94023113conners
contras93015603contras
cooers84324563co_oers
cookers134619463cookers
coolers93522493coolers
coopers114019483coopers
cooters94525713cooters
copals105018943co_pals
copays134911273co_pays
copers104629843co_pers
copiers114215963copiers
coppers133519753coppers
coppras13327833coppras
coprahs14338153coprahs
copras103517153copra_s
copters113621273copters
copular113810603copular_
copulas113811563copula_s
corals85325143co_rals
corbans11313173corbans
corders104520873corders
corers85231073co_rers
corgis9314403corg_is
corkers134118853corkers
corners94723313corners
corrals93713853corrals
cors66656443co___rs
corsacs1139013corsacs
corsairs1046863corsairs
corulers1039763corulers
coshers123618173coshers
costar85518613costar_
costard104113353costard
costards113510783costards
costers94128303costers
cotans81317923co_tans
cottar84613813cottar_
cottas84615573cotta_s
cotters94323433cotters
couchers153513843couchers
couches144020463couches
cough115819643coug__h
coughed143310903coughed
cougher133711733cougher
coulees9315503coulees
coulis84018753cou_lis
couloirs1045983couloirs
coulters103614303coulters
coumaric1446163coumaric
coumarin1247313coumarin
coumarins1347023coumarins
coumarou12104363coumarou
coumarous1385763coumarous
counters103320183counters
country12388033country
counts84618273cou_nts
coupes105022523cou_pes
couplers123311313couplers
couples115317053couples
coupons112710563coupons
coups95522473cou__ps
courage10310993courage
courages11311393courages
courant9317973courant
courants10310803courants
couriers103213163couriers
courlans10117613courlans
course85117773cou__rse
coursers104412293coursers
courses94218893courses
court75532763cou__rt
courters103015363courters
courts84216163cou_rts
cousins9516003cousins
couter84930203couter_
couths115715393cou_ths
couture9310613couture
coutures10311973coutures
couvade1335063couvade
couvades1435603couvades
covary1438743co_vary
covers114627963co_vers
cowages13310933cowages
coward12411673co_ward
cowards1339613co_wards
cowers114625533co_wers
cowgirl1353273cowgirl
cowgirls1442493cowgirls
cowpats1437713cowpats
crowbars1544423crowbars
cruors838623cru_ors
cubers105318343c_ubers
curara83712203c_urara
curaras93911943c_uraras
curare84916953c_urare
curares94916853c_urares
curari84414403c_urari
curaris94114773c_uraris
curers84923183c_urers
currs75624393c_u_rrs
curs65645543c_u__rs
cymars13599143c_ymars
czars164812913c__zars
desugars1043373desugars
dodgers105213823dodgers
dogears937513dogears
doggers104413433doggers
dollars83311023dollars
dongas84914613donga_s
doughs115912933doug_hs
doulas75114993doula_s
doumas95314813douma_s
dourahs11487253dourahs
douras75016723doura_s
dousers84817273dousers
eggars8398973_eggars
feuars938653feu_ars
foggers124112013foggers
forgers115218183forgers
foulard11257283foulard
foulards12266463foulards
fours85521493fou__rs
gars55750743___gars
gaugers94211703gaugers
gorgers94813643gorgers
gouger86014363gouger_
gouges86318693goug_es
guars65021043_gu_ars
hangars114313483hangars
hoars85925543ho__ars
hogans105914313ho_gans
hoggers124512483hoggers
houdahs1434243houdahs
hours85422383hou__rs
housers104717813housers
jaguars1535223jaguars
joggers164110693joggers
jouals1338923jou_als
jowars16369653jo_wars
lodgers95113833lodgers
logans76319063lo_gans
loggats9286453loggats
loggers94616133loggers
longans84510813longans
longers84819543longers
loughs105014773loug_hs
loumas84812333louma_s
loungers9449003loungers
lours55125293lou__rs
louvers10359103louvers
lugers74617023_lugers
lunars65012813_lunars
modulars1165833modulars
molars85517323mo_lars
mongers104217273mongers
morgans10310123morgans
mortars93411523mortars
mousers95216443mousers
muggars11316643muggars
nongays11176533nongays
nonsugars1043703nonsugars
nonwars10109003nonwars
nougat74712653nouga_t
noughts11478083noughts
oars46846033_o__ars
ocular8610133ocular_
ogams84112683_o_gams
organs7912913_organs
ottars64112223_ottars
oughts104710183_oughts
ourari63413543_ourari
ouraris73512933_ouraris
ours47237563_ou__rs
outers64230163_outers
outgas7313203_outga_s
outwars10912793_outwars
polars84419353po_lars
poplars113910333poplars
poulard10299733poulard
poulards11288233poulards
pourers93513673pourers
pours74623183pou__rs
pouters94221863pouters
roars55622233ro__ars
rogers74517913ro_gers
rouges76022383roug_es
roughers12329173roughers
roughs105416213roug_hs
rousers75220133rousers
routers74822853routers
saggars93610683saggars
sangars83116253sangars
saugers83914053saugers
scourers10348533scourers
scourgers1234383scourgers
scours84913583scou__rs
scouters103411303scouters
seggars9377783seggars
soars54732513so__ars
sofars94712783so_fars
sonars64818973so_nars
souari6311373sou_ari
souaris7312323sou_aris
soucar839323soucar_
soudans8309353soudans
soughs105115623soug_hs
sours55230503sou__rs
souters74422583souters
sowars94318003so_wars
sowcars1236003sowcars
sugar6312913_sugar_
sugary1039013_sugary
togas67823003to_ga_s
tolars64817923to_lars
tongas74315513tonga_s
tongers84116013tongers
toucans937573toucans
toughs105414983toug_hs
tourers73512733tourers
tours55325863tou__rs
touters74018333touters
uvulars1044413uvulars
voguers11356683voguers
vulgars11306533vulgars
yogas96615603yo_ga_s
youngers12336933youngers
yours85217873you__rs
yugas95012063_yuga_s

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.1701051123.5
2DLD Change Limit1340273586.45320769.7
3Display Results3583580.1262841.3
 (SQL Overall)1786913586.74926476.7
 
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.