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

493 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
diesel7441040(None) 
diesels8429141diesels
dieses75218691dieses
damsel9148032damsel
desex13311982d_esex
devel94217122d_evel
diel59034602di__el
diene65720132diene_
dienes75719902dienes
dies55653522dies__
dieseled1035522dieseled
diesis74013492diesis
diester83013682diester
dieted83115492dieted
dieter73516772dieter
dispel9310322dispel
dissed85220172dissed
disses75225962disses
djebel1643452djebel
dorsel75315502dorsel
dossel74813642dossel
hirsel9138682hirsel
missel85216522missel
tinsel639442tinsel
ainsell796393ainsell
aisle55223193ai_sle
bedel84219393_bedel
beses75830723_beses
beset76739133_beset
betel74419903_betel
bevel104517043_bevel
bezel165215173_bezel
biased94012223biased
biases84618433biases
bilevel1244393bilevel
birse74517403birse_
birses84717733birses
bise66437093bi_se_
bises75435623bi_ses
chisel112111943chisel
creel75121483cre_el
crenel84213063crenel
cresol8310203cresol
cresyl1135133cresyl
crewel114310473crewel
cyeses11510123cyeses
daedal849083daedal
daises74318983daises
damosel10126693damosel
damsels10126703damsels
darnel74312183darnel
deal56347413d_e_al
deasil71110983deasil
decal85523233d_ecal
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
deice84320033deice_
deiced104214483deiced
deicer94114413deicer
deices94119373deices
deil56231623d_e_il
deism84116033deis_m
deisms94411043deisms
deist64633593deis_t
deists74916433deists
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
dense65923503dense_
densely1146713densely
denser74115193denser
dere56845903d_ere_
desalt7518313d_esalt
desert72725493d_esert
desk95618903d_es_k
desks105913073d_esks
deter65028043d_eter
devels104313903d_evels
devil94714733d_evil
dewed105020303d_ewed
dexes135224513d_exes
diadem1037583diadem
dial55935063di__al
dialed84716453dialed
dialer74315433dialer
diallel845683diallel
diaper94513113diaper
diastem10318043diastem
diaster82813313diaster
dibbed124713473dibbed
dibber114614713dibber
dibble114013843dibble
dibs76233673dibs__
dice75841893di_ce_
diced95824683di_ced
dicer85426423di_cer
dices86434243di_ces
dicey114819333di_cey
dicier94416233dicier
dicked144920863dicked
dicker134521403dicker
dickey165913523dickey
diddle94915213diddle
didie74120563didie_
didies84621833didies
didoes85716963didoes
didst74619613dids_t
die46759653di__e_
died66137853di__ed
dieing84018653dieing
dieoff1335503dieoff
diereses938693diereses
dieseling1146143dieseling
dieselize1943973dieselize
diesters92513593diesters
diet57357533di__et
dieters83216423dieters
diether1147443diether
diets66026643die_ts
differ133910843differ
difs86027323difs__
digest84019623diges_t
digested11208163digested
digester10258423digester
digests93610613digests
digged104314653digged
digger94616083digger
digs66036053digs__
dike95935763di_ke_
diked115024683di_ked
diker105524553di_ker
dikes105831333di_kes
dikey135116423di_key
dill55239973di__ll
dilled84122223dilled
dime76237643di_me_
dimer85625603di_mer
dimes85833043di_mes
dimeter10411893dimeter
dimmed124110323dimmed
dimmer114112613dimmer
dimple113512793dimple
dims75435023dims__
dindle84417223dindle
dine55555333di_ne_
dined76431993di_ned
diner65632903di_ner
dines66449153di_nes
dinge75627303dinge_
dinged95221783dinged
dinger85323663dinger
dinges83825423dinges
dingey114914043dingey
dingle84317073dingle
dinked124818353dinked
dinkey144812763dinkey
dinned84317613dinned
dinner74217153dinner
dins56652043dins__
dinted84419843dinted
diobol936883diobol
diocese1036853diocese_
dioceses1137113dioceses
diode74716113diode_
diodes83915783diodes
diol57329133di__ol
diplex16408053diplex
dipnet91317473dipnet
dipole91112853dipole
dipped123517493dipped
dipper114017783dipper
dips75536913dips__
dipsas9359893dipsas
dipso85111553dips_o
dipsos95310053dipsos
dire56644143di_re_
direful1156613direful
direly10311553di_rely
direr64927073di_rer
direst75024243dires_t
dirge75117073dirge_
dirges84915103dirges
dirked124912273dirked
dirl57430023di__rl
dirled84514903dirled
dirndl834253dirndl
dis46459893di_s__
disc76123233di_s_c
disced104914653disced
disci85815023di_sci
disco85616073di_sco
discs85316263di_scs
disease83213843disease_
diseased103011703diseased
diseases92415813diseases
diseur738843diseur
diseuse83110713diseuse_
diseuses93112753diseuses
dish86328333di_s_h
dished114318713dished
dishelm1335833dishelm
dishes104622653dishes
dishevel1564703dishevel
dishy125712353di_shy
disk96625833di_s_k
disked125015763disked
disks105417473di_sks
dismal92412243dismal
disme85716243di_sme
dismes95617673dismes
dispels10310503dispels
diss56434483di_s_s
disseat83816923disseat
dissect103614133dissect
dissent84018683dissent
dissert83720693dissert
distal73615763distal
distil73616433distil
disuse74012833disuse_
disused93211013disused
disuses84015403disuses
dite55547553di_te_
dites66339153di_tes
dither104417683dither
dits56450523dits__
ditsier83010293ditsier
ditsy95612563dits_y
ditzes163212423ditzes
diureses936453diureses
dive85634773di_ve_
dived106321373di_ved
diver94827803di_ver
diverse11429993diverse_
diversely1643963diversely
dives95832403di_ves
divest106820073dives_t
divested13268213divested
divests114510933divests
dizen155214933di_zen
dizened18267333dizened
djebels1753293djebels
does56554473does__
doest65829523does_t
donzel1636313donzel
dorsal74613943dorsal
dorsels84412573dorsels
dorser74819173dorser
dose56442433d_ose_
dosed76626913d_osed
doser66228563d_oser
doses65938503d_oses
dossal75510303dossal
dossed84516633dossed
dossels85511603dossels
dosser74417973dosser
dosses76126273dosses
dossil75110903dossil
dottel73610893dottel
douse66329723douse_
doused84821163doused
douser75621633douser
douses74928933douses
dowel95618193d_owel
dowse96020813dowse_
dowsed115015013dowsed
dowser104716083dowser
dowses105718303dowses
dree56638323dre_e_
dreed75222843dre_ed
drees65628523dre_es
dreidel934473dreidel
dreidl835233dreidl
dress65319833dres_s
dressed93511873dressed
dresser83611953dresser
dresses83716173dresses
dressy10518143dressy
drest65530343dres_t
dries64733673dries__
driest74722753dries_t
drivel105110383drivel
druse64817663druse_
druses75517253druses
duel56729703d__uel
dueled84813663dueled
dueler74213683dueler
dues56045503dues__
dueted84113593dueted
duffel13407753duffel
dulse65415043dulse_
dulses73913653dulses
dweeb1137743dwe_eb
dwell9519853dwe_ll
dyes85331893dyes__
dynel9569853d_ynel
easel54521113_easel
eel37946843__e_el
emeses86114963emeses
eses45336103__eses
feel75233843_fe_el
fiesta938123fiesta
fresnel1035893fresnel
fusel85218493_fusel
geese64316003geese_
gies55641423gies__
gimel8313353gi_mel
gunsel7339853gunsel
hansel95214373hansel
hassel95614213hassel
heel75034223_he_el
hiemal11339493hiemal
hies74842833hies__
himself1544273himself
hirsels10128343hirsels
hirsle9159573hirsle
hissed104114453hissed
hisself1335913hisself
hisser94713793hisser
hisses94719353hisses
hosel86024813_hosel
housel95217043housel
ideal65716393ide_al
ides57734233ides__
impel95711763_impel
inset54430863_inset
isle45121703_i_sle
issei568573_issei
itself946253_itself
jebel145612143_jebel
jewel156711703_jewel
keel85729463_ke_el
kevel124213093_kevel
kiester11329973kiester
kineses113111253kineses
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
kittel10368863kittel
kneel95012033kne_el
leses54930813_leses
level84116553_level
libel74116103li_bel
lieder74912323lieder
liefer9529573liefer
liege65314433liege_
lieges74113443lieges
lienal63912783lienal
lies46454193lies__
lieve86315473lieve_
liever94611863liever
linsey938983linsey
lintel64013993lintel
lisle53916723li_sle
listel64214733listel
losel54419423_losel
mimeses1139073mimeses
mioses84318853mioses
mise66043573mi_se_
miser75430403mi_ser
mises74740563mi_ses
missal84314903missal
missed94423603missed
missels94614813missels
misses85130873misses
misset85028153misset
morsel85815893morsel
mussel83412903mussel
newel86114133_newel
nickel123811343nickel
niece74814503niece_
nieces84112713nieces
nieve85613183nieve_
nieves94311293nieves
nisei54214353ni_sei
obese75212423obese_
obesely1245113obesely
oneself1046073oneself
ousel55222403_ousel
passel85117003passel
peel65535613_pe_el
peise75825773peise_
peised94817683peised
peises84125043peises
piece96717993piece_
pieced113912103pieced
piecer105213083piecer
pieces104217273pieces
pies66949603pies__
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
pixel143911903pi_xel
prese75228383prese_
presell939293presell
preset84430983preset
rebel73421293_rebel
reel45240533_re_el
refel84920813_refel
repel74921403_repel
reseal64819643_reseal
resee54336333_resee
resell64215203_resell
reset55051863_reset
resew84519503_resew
revel84423163_revel
ridgel8399963ridgel
riel46432383ri__el
riever94811653riever
rinse54820973rinse_
rinsed75016353rinsed
rinser64317213rinser
rinses64720383rinses
rise45945233ri_se_
risen54621883ri_sen
riser55431053ri_ser
rises55244043ri_ses
seel45042983_se_el
seidel7311083seidel
seise54727853seise_
seised74218123seised
seiser65318343seiser
seises64026713seises
sel38253323___sel
shekel1338383shekel
sheqel1846523sheqel
siege66718443siege_
sieged85212713sieged
sieges73816833sieges
siesta639503siesta
sieve84918843sieve_
sieved104611443sieved
sieves93216003sieves
simnel857023simnel
sisal54217733si_sal
sises55233833si_ses
sisses64520603sisses
speel74420763spe_el
spiegel1034553spiegel
steel55721993ste_el
tassel66014773tassel
teasel63914983teasel
teel46335803_te_el
these86519013these_
theses96517973theses
tiercel9316203tiercel
tiered73613973tiered
ties45248313ties__
tinsels738373tinsels
tmeses85712243tmeses
tressel73010893tressel
vessel937953vessel
vies75238623vies__
viewed1345993viewed
viewer1237213viewer
vise75632673vi_se_
vised95518763vi_sed
viseed105310983viseed
vises84427773vi_ses
weasel93410523weasel
wedel94513953_wedel
weel75834083_we_el
wheel115515333whe_el
wiener94513543wiener
wise75737343wi_se_
wised95123343wi_sed
wisely122711713wi_sely
wiser85522803wi_ser
wises85633193wi_ses
wissed104114643wissed
wisses94619603wisses
yeses85119323_yeses

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.1561145455.1
2DLD Change Limit1127164936.55017208.5
3Display Results4934930.1533222.2
 (SQL Overall)1786914936.85926052.0
 
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.