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

154 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
corbeil1185921(None) 
corbeils12358071corbeils
corbel103715971corbe_l
corbeille1344022corbeille
corbels113813592corbels
corbie103618202corb_ie
corbies113520122corbies
cormel103815602corme_l
corneal94414502corneal
cornel84020052corne_l
cowbell1445222cowbell
barbel104317073barbe_l
barbell11429963barbell
bordel94514573borde_l
boreal84817213bor_eal
borneol936823borneol
carcel105018673carce_l
carpel105418473carpe_l
carrel84718633carre_l
carrell94610473carrell
cartel85022533carte_l
carvel114817573carve_l
ceil65725063c___eil
cereal8315833cer_eal
choreal124412223chor_eal
choreic1438703chor_eic
cobber124116843cobbe_r
cobbers134114753cobbers
cobbier133410163cobbier
cobia94117513co_b_ia
codeia94112193co_deia
codein94916723co_dein
codicil1246813codicil
coheir1137583co_heir
coil66439653co___il
combe116223543combe__
combed135516543combe_d
comber125118503combe_r
combers134516623combers
combes125321733combe_s
compel124412893compe_l
conceal113313023conceal
conceit113218073conceit
congeal104011683congeal
coral76033453cor__al
corban10314693corb_an
corbans11313173corbans
corbeilles1443813corbeilles
corbeled1338373corbeled
corbeling1439033corbeling
corbelled1446613corbelled
corbina111911453corbina
corby125018533corb__y
corded105923353corde_d
cordelle1148433cordelle
corder94322883corde_r
corders104520883corders
cordial10312953cordial
core67263113cor_e__
cored85044223cor_e_d
coreign1037343cor_eign
coremia11310363coremia
corer75538873cor_e_r
corers85231073cor_ers
cores76361853cor_e_s
corgi8316083cor_gi_
corgis9314413cor_gis
coria75828323cor__ia
corked135020783corke_d
corker124720853corke_r
corkers134118853corkers
corkier133114303corkier
cormels113813373cormels
cormoid12310403cormoid
cornball1247053cornball
cornea84018933corne_a
corneas94717003corneas
corned95224523corne_d
cornels94716663cornels
corner84625623corne_r
corners94723313corners
cornet84436733corne_t
cornets94820573cornets
cornier93017093cornier
cornily12410853cor_nily
cornmeal1245853cornmeal
cornual94210173cornual
coronal94115763coronal
coronel94515223coronel
corral83616253cor_ral
correct11513983correct
corrie83621233cor_rie
corries94026803corries
corsair937633corsair
corse75036183corse__
corses84433463corse_s
corset85636223corse_t
corsets94819803corsets
cortege1098953cortege
cortex15311473corte_x
cortin82423153cor_tin
corvee114320093corve_e
corvees124613793corvees
corves115122523corve_s
corvet114626933corve_t
corvets124715023corvets
corvid12310473cor_vid
coryzal2154823coryzal
council1137473council
cowbells1544993cowbells
creel75121483c_r_eel
crocein1138073crocein
cruel74815903c_rue_l
curbed114615873curbe_d
curber104517053curbe_r
curbers115514383curbers
curtail9299663curtail
doorbell1143413doorbell
dorsel75315503dorse_l
forbear1237523forbear
forbid123312433forb_id
forfeit1339203forfeit
garboil1036513garboil
gerbil938343gerb_il
gorbelly1445473gorbelly
hordein1138753hordein
howbeit1545663howbeit
loreal63814313lor_eal
morbid112511463morb_id
morel75729093mor_e_l
morsel85815893morse_l
nombril1145103nombril
obeli73711933_o_beli
orbed85516193_orbe_d
orbier839993_orbier
orbit73622063_orb_it
orcein838183_orcein
orchil1158653_orchil
ordeal779253_ordeal
oriel54920423_orie_l
parboil1138323parboil
potboil1195463potboil
sobeit8315363so_beit
sorbed94916523sorbe_d
sorbent92915243sorbent
sorbet83924083sorbe_t
sorbets93012513sorbets
sorbic10310393sorb_ic
sorel56231443sor_e_l
sorrel6413553sorre_l
surveil1045093surveil
vermeil1285223vermeil
wormil1138043wor_mil
zoril143916693zor__il

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.406440125.6
2DLD Change Limit1340271546.48320673.6
3Display Results1541540.0632444.4
 (SQL Overall)1786911546.95225703.5
 
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.