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

115 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
corbeils1235807(None) 
corbeil11859211corbeil_
corbels113813591corbe_ls
corbeille1344022corbeille
corbeilles1443812corbeilles
corbel103715972corbe_l_
corbies113520122corb_ies
cormels113813372corme_ls
cornels94716662corne_ls
cowbells1544992cowbells
barbells12368823barbells
barbels114514433barbe_ls
bordels103911973borde_ls
borneols1046343borneols
carcels114516063carce_ls
carpels115315463carpe_ls
carrells10359273carrells
carrels95117303carre_ls
cartels94618123carte_ls
carvels124914593carve_ls
ceils75019403c___eils
cereals9313173cer_eals
cobbers134114753cobbe_rs
cobias104014993co_b_ias
codeias103911223co_deias
codeins103715483co_deins
codicils1346043codicils
coheirs1236753co_heirs
coils75030083co___ils
combers134516623combe_rs
combes125321733combe__s
compels133210883compe_ls
conceals123111013conceals
conceits122813613conceits
congeals11309853congeals
coralbells1451823coralbells
corals85325143cor__als
corbans11313173corb_ans
corbeled1338373corbeled
corbeling1439033corbeling
corbelings1544073corbelings
corbelled1446613corbelled
corbie103618203corb_i_e
corbina111911453corb_ina
corbinas12229393corbinas
cordelle1148433cordelle
cordelles1248233cordelles
corders104520883corde_rs
cordials1139623cordials
coreign1037343cor_eign
coreigns1136323cor_eigns
corers85231073cor_e_rs
cores76361853cor_e__s
corgis9314413cor_gi_s
corkers134118853corke_rs
cormel103815603corme_l_
cornballs1346313cornballs
corneal94414503corneal_
corneas94717003corne_as
corneitis1146493corneitis
cornel84020053corne_l_
corneous10310033corneous
corners94723313corne_rs
cornets94820573corne_ts
cornily12410853cor_nily
cornmeals1344573cornmeals
corodies11313693corodies
coronals103312893coronals
coronels104012143coronels
corrals93713853cor_rals
corrects1259573corrects
corries94026793cor_ries
corsairs1046873corsairs
corses84433463corse__s
corsets94819803corse_ts
corteges1198823corteges
cortexes1797613cortexes
cortins92421333cor_tins
corvees124613793corve_es
corves115122523corve__s
corvets124715023corve_ts
corvids1337683cor_vids
councils1246973councils
cowbell1445223cowbe_ll
creels84416943c_r_eels
croceins1238103croceins
curbers115514383curbe_rs
curtails10318243curtails
doorbells1243303doorbells
dorsels84412573dorse_ls
forbears1337073forbears
forbids13268263forb_ids
forfeits1445803forfeits
garboils1145663garboils
gerbils1037303gerb_ils
gorbelly1445473gorbelly
hordeins1238323hordeins
morels84820013mor_e_ls
morsels94112653morse_ls
nombrils1244513nombrils
orbits84211443_orb_its
orceins937743_orceins
orchils1277703_orchils
ordeals877993_ordeals
oriels64914623_orie_ls
parboils1237433parboils
potboils1284633potboils
sorbents10279133sorbents
sorbets93012513sorbe_ts
sorels63921163sor_e_ls
sorrels7310723sorre_ls
surveils1144523surveils
vermeils1374813vermeils
wormils1236733wor_mils
zorils153810883zor__ils

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621156.76321612.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.