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

175 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
corymb153522(None) 
corymbs1633451corymbs
comb106632112co__mb
coomb115615702co_omb
corm85735382cor_m_
corms95626222cor_ms
cory96941512cory__
corymbed1842612corymbed
coryza2074582coryza
crumb114313592c_rumb
bomb106927423bo__mb
caramba1336893caramba
carb85143163car__b
carob95325223car_ob
carom95025563carom_
caroms105619573caroms
chimb144813563c_himb
choriamb1744163choriamb
chroma132912473chroma
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
chyme156512503c_hyme
climb115413593c_limb
clomb115714703c_lomb
cob710258753co___b
cobb106422003co__bb
cobweb1533243cobweb
coky137526823coky__
column1038103column
coly96940533coly__
coma87134853co__ma
combe116223543co__mbe
combo114519433co__mbo
combs116122963co__mbs
come87547703co__me
comma114514793co_mma
commy144712643co_mmy
comp106731253co__mp
comsymp1841153comsymp
confab1347063confab
cony96537833cony__
coombe124110093co_ombe
coombs124210193co_ombs
copy116229803copy__
cor59960943cor___
coral76033453cor_al
corals85325143corals
corban10314693corban
corbel103715973corbel
corbie103618203corbie
corby125018533cor_by
cord76740923cor__d
corded105923353corded
corder94322883corder
cordoba1255743cordoba
cordon95017293cordon
cords86030623cor_ds
core67263113cor__e
cored85044223cor_ed
coremia11310363coremia
corer75538873cor_er
corers85231073corers
cores76361853cor_es
corf95941483cor__f
corgi8316083cor_gi
corgis9314413corgis
coria75828323cor_ia
coring94433963coring
corium10315723corium
cork106635693cor__k
corked135020783corked
corker124720853corker
corks116028273cor_ks
corky145221153cor_ky
cormel103815603cormel
corn69945813cor__n
corncob1345663corncob
cornea84018933cornea
corned95224523corned
cornel84020053cornel
corner84625623corner
cornet84436733cornet
corns76034763cor_ns
cornu75921323cor_nu
cornua85411903cornua
cornus84816563cornus
corny106023273cor_ny
corody12149703corody
corona83817403corona
corps95927043cor_ps
corpse104013413corpse
corpus106015293corpus
corral83616253corral
corrie83621233corrie
cors66656443cor__s
corsac10410173corsac
corse75036183cor_se
corses84433463corses
corset85636223corset
cortex15311473cortex
cortin82423153cortin
corvee114320093corvee
corves115122523corves
corvet114626933corvet
corvid12310473corvid
corymbose1842303corymbose
corymbous1842733corymbous
coryzal2154823coryzal
coryzas2134803coryzas
cosy97232703cosy__
cotype1346823cotype
coulomb1344553coulomb
cowry135512483cowry__
cowy126427363cowy__
coxcomb2243293coxcomb
coy810557553co_y__
coyed114623803co_yed
coyer105222843co_yer
coyly135614893co_yly
coypu12349873co_ypu
coys97537243co_y_s
cozy185823803cozy__
crab85727673c_r_ab
cram85635493c_ram_
crambe1239073c_rambe
crambo1238043c_rambo
cramp115120693c_ramp
crams96229153c_rams
creme94319323c_reme
crib86323583c_r_ib
crime94822693c_rime
crimp115615803c_rimp
crumbs12409233c_rumbs
crumby15408113c_rumby
crump115616423c_rump
cry89726243c_ry__
crypt123715233c_rypt
curb86732223cur__b
cyma116715843c__yma
cyme119420373c__yme
dorm76834633dor_m_
dorms85723843dor_ms
dormy115817473dor_my
dory85836233dory__
foram105124933foram_
forams115115913forams
forb97131333for__b
form95836873for_m_
forme105225993for_me
forms105327053for_ms
formyl14276443formyl
forum108318763forum_
forums114611843forums
gorm75529393gor_m_
gorms85619593gor_ms
gory86129663gory__
joram145816983joram_
jorams154810533jorams
jorum145513743jorum_
jorums15408093jorums
korma115913093kor_ma
lory75931713lory__
norm66429813nor_m_
norms76019313nor_ms
orb55736863_or__b
oryx14510213_ory_x
sorb68333043sor__b
tomb89029653to__mb
tory75840543tory__
tryma1037223_tryma
womb117022233wo__mb
worm96129493wor_m_
worms105320763wor_ms
wormy137514253wor_my

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.373479064.3
2DLD Change Limit1127161755.64319974.5
3Display Results1751750.0602916.7
 (SQL Overall)1786911756.07629409.3
 
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.