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

192 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
djebel164345(None) 
djebels1753291djebels
jebel145612141_jebel
devel94217122d_evel
diesel74410402diesel
jebels15418912_jebels
jewel156711702_jewel
rebel73421292_rebel
ajee115928233aje_e_
babel95821693_babel
barbel104317073barbel
bedel84219403_bedel
beebee10313063beebee
bejewel1953043bejewel
bel57148463___bel
betel74419903_betel
bevel104517043_bevel
bezel165215173_bezel
bulbel104510683bulbel
chebec1536963chebec
corbel103715973corbel
creel75121483cre_el
crenel84213063crenel
crewel114310483crewel
dabbed124416143dabbed
dabber114816963dabber
dabble114515193dabble
daedal849083daedal
damsel9148033damsel
darnel74312183darnel
daube85015303daube_
daubed104611783daubed
dauber94112013dauber
daubes94913703daubes
daybed13438673daybed
deal56347413d_e_al
deb66342693d_eb__
debag94212303d_ebag
debar85517863d_ebar
debeak1336763d_ebeak
debit85727853d_ebit
debs76530243d_eb_s
debt77139023d_eb_t
debts86418373d_ebts
debug94210063d_ebug
debut86024143d_ebut
debye1138903d_ebye
debyes1238103d_ebyes
decal85523233d_ecal
decibel1235993decibel
deckel134911043deckel
dedal75719023d_edal
dee47665823d_e_e_
deed65340903d_e_ed
deeded94615543deeded
deem75432893d_e_em
deemed104713063deemed
deep76031883d_e_ep
deepen9339193deepen
deeper93613503deeper
deer56739023d_e_er
dees56356633d_e_es
deet57356583d_e_et
defer94619753d_efer
defuel10348933defuel
deil56231623d_e_il
deke95228763d_eke_
deked115718533d_eked
dekes105224453d_ekes
del46752753d___el
dele56843083d_ele_
deled75326543d_eled
deles65139253d_eles
dell56938203d_e_ll
deme76536283d_eme_
demes86032693d_emes
dene56643413d_ene_
denes65639723d_enes
dere56845903d_ere_
desex13311983d_esex
deter65028043d_eter
devels104313903d_evels
devil94714733d_evil
dewed105020303d_ewed
dexes135224513d_exes
dibbed124713473dibbed
dibber114614713dibber
dibble114013843dibble
diel59034603d__iel
diene65720133diene_
dienes75719903dienes
diesels8429143diesels
dieses75218693dieses
dieted83115493dieted
dieter73516773dieter
diobol936883diobol
dispel9310323dispel
doable93115243doable
dobber114015423dobber
donzel1636313donzel
dorsel75315503dorsel
dossel74813643dossel
dottel73610893dottel
double94013993double
dowel95618193d_owel
dree56638323dre_e_
dreed75222843dre_ed
drees65628523dre_es
dreidel934473dreidel
dreidl835233dreidl
drivel105110383drivel
dubbed124113213dubbed
dubber113814553dubber
duel56729703d__uel
dueled84813663dueled
dueler74213683dueler
dueted84113593dueted
duffel13407753duffel
dumbed124012083dumbed
dumber114414173dumber
dweeb1137743dwe_eb
dweebs1233653dweebs
dweeby1542993dweeby
dwell9519853dwe_ll
dyable12308983dyable
dyeable1337303dyeable
dynel9569853d_ynel
eel37946843__e_el
feeble1138253feeble
feel75233843_fe_el
glebe85016443glebe_
glebes95512243glebes
grebe85114943grebe_
grebes93813613grebes
hebe96424703_hebe_
hebes105521673_hebes
heel75034223_he_el
jee106648643_je_e_
jeed125428503_je_ed
jeep135624843_je_ep
jeer115426463_je_er
jees115938543_je_es
jeez205622033_je_ez
jefe146516883_jefe_
jefes155613673_jefes
jell117125873_je_ll
jete115927253_jete_
jetes124922843_jetes
jewed165114833_jewed
jewels16508613_jewels
jezebel2541923jezebel
jibe136323393_jibe_
jibed155114163_jibed
jiber145115703_jiber
jibes145520323_jibes
jube136322783_jube_
jubes145420743_jubes
jurel124516333_jurel
keel85729473_ke_el
kevel124213103_kevel
kneel95012033kne_el
label75019383_label
leben7314853_leben
level84116553_level
libel74116103_libel
newel86114133_newel
peel65535613_pe_el
plebe95014873plebe_
plebes104313623plebes
rebec94416543_rebec
rebels84518133_rebels
reel45240533_re_el
refel84920813_refel
repel74921403_repel
revel84423163_revel
rubel75416833_rubel
seel45042983_se_el
shekel1338383shekel
sheqel1846523sheqel
speel74420763spe_el
steel55721993ste_el
teel46335803_te_el
thebe107515433thebe_
thebes115914493thebes
treble8311663treble
umbel93612843_umbel
weber10313523_weber
wedel94513963_wedel
weel75834083_we_el
wheel115515333whe_el
xebec16378293_xebec
zebec18419263_zebec

Search took 6 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 Limit1127161925.26621404.5
3Display Results1921920.0633047.6
 (SQL Overall)1786911925.70231338.3
 
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.