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

476 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
delaine831479(None) 
delaines9312961delaines
betaine9413782betaine
dealing94323232dealing
decane93818872deca_ne
decline103716612decline
define104718142de_fine
delate73827752dela_te
delating103119602delating
delaying133210972delaying
deleing93313952deleing
delime9314042del_ime
delving123711572delving
dentine83320242dentine
depaint10314592depaint
deplane10311412depla_ne
destine83719952destine
detain74617382detain_
detained103111642detained
detainee92511722detainee
detainer92910792detainer
detains83716092detains
domaine10610502domaine
elain55324702_elain_
elains64919852_elains
elapine9310672_elapine
feline94820142fel_ine
gelatine93213302gelatine
melamine12310302melamine
reline65434352rel_ine
adenine8311213ade_nine
aedine73218393ae_dine
alane56135613_ala_ne
alanine7316863_alanine
alexine142410543alexine
aline57243153_al_ine
alkine104916803_alkine
alpine84417373_alpine
alvine94614583_alvine
beanie83618593be_anie
beeline93314723beeline
beguine1068503beguine
belaying143110603belaying
belie75630383bel_i_e
belike124616283bel_ike
belive115415303bel_ive
belling103825073belling
belting104119133belting
beltline1036943beltline
belying133612443belying
benzine1839343benzine
bepaint11312183bepaint
berline93716853berline
betaines10313293betaines
blain75421793_blain_
blains84516373_blains
byline11311643byl_ine
calamine12314033calamine
calcine11315273calcine
celandine1245623celandine
celling103921263celling
cervine122610803cervine
cetane8315283ceta_ne
chaine115119223_chaine
cline76428533_cl_ine
cocaine111315173cocaine
dateline9810353datel_ine
deaden83714323de_aden
deadline10139053deadline
deafen10389673de_afen
deair65817193de_ai_r
deaired9411533de_aired
deairs74013783de_airs
dealate83617843dealate
dealings103510703dealings
dean56039483de_a_n_
deaned84620453de_a_ned
deaning94020473deaning
deans66131393de_a_ns
dearie73319813de_arie
deave95022333de_a_ve
deaving123814753deaving
debacle1237443debacle
debase94014473deba_se
debasing12238063debasing
debate94419193deba_te
debating123213733debating
debone93714783de_bone
debride1138593debride
decade104216163deca_de
decanes103118913deca_nes
decant93524223deca_nt
decare93919153deca_re
decaying15239453decaying
deceive1337813deceive
deciare10710663deciare
decide104116873de_cide
decile94619213de_cile
decking153915593decking
declaim1247363declai_m
declaimed1544383declaimed
declaimer1444233declaimer
declaims1345823declaims
declare10411223decla_re
declaring1339573declaring
declasse1165943declasse
declawing1636213declawing
declined123910883declined
decliner113710843decliner
declines113315803declines
dedans85915073deda_ns
deeding103315123deeding
deeming113913123deeming
deface123113863defa_ce
defacing15238683defacing
defame123212433defa_me
defaming15238463defaming
defang1137753defa_ng
defiance1477633defiance
defiant11311923defiant
defile105216663de_file
defined123813823de_fined
definer114413773de_finer
defines114118683de_fines
deflate113613943defla_te
deflating142610713deflating
defleaing1444743defleaing
defying15328823defying
degage92711383dega_ge
degame102713183dega_me
deglaze1835583degla_ze
deglazing2135133deglazing
deice84320033de__ice
deicide1149403deicide
deicing11312193deicing
dekare112811563deka_re
dekeing13358353dekeing
deking125614553de_king
delaminate1347373delaminate
delated93722873delated
delates83526283delates
delation92318083delation
delations102616593delations
delator83015023delator
delay94820633dela__y
delayed123310763delayed
delayer113010533delayer
delays104014053dela_ys
dele56843083del___e
deleading1237773deleading
deleave1147723deleave
deleaving1436263deleaving
delete73620703del_ete
deleting103314423deleting
deli55631293del_i__
delict94320333del_ict
delimed11310723del_imed
delimes10314193del_imes
deliming12310373deliming
delis64928543del_i_s
delish105215613del_ish
delist74625053del_ist
deliver113312243del_iver
dellies83622213dellies
delouse839833delouse
deltaic1037023deltai_c
deltic9312503delti_c
delude81910673del_ude
deluding1137683deluding
deluge8189403del_uge
deluging1137123deluging
delusive1245843delusive
deluxe14197303del_uxe
delve96018263del__ve
demand104314253dema_nd
demesne1035573demesne
demise94618323de_mise
demoing11311753demoing
dene56643413de___ne
denning93515173denning
dentin73919573dentin_
dentines93418403dentines
denting94422183denting
dentins83419223dentins
denying123711293denying
depainted1375843depainted
depaints1136643depaints
deplaned1238653depla_ned
deplanes11311213depla_nes
deplaning1338053deplaning
depone93616553de_pone
deprive1338303deprive
depside1138403depside
deraign936573deraign
deraigned1244093deraigned
deraigns1034883deraigns
derail74218813derai_l
derailed102410403derailed
derails84216393derails
derange939813derange
derate74531233dera_te
derating103222283derating
deride84420033de_ride
derive103817043de_rive
desand84812633desa_nd
desire7415303de_sire
despise1038683despise
despite10410123despite
destain8412083destain_
destained1158253destained
destains9311813destains
destined103312453destined
destines93619663destines
destiny113111463destiny
detail74516433detai_l
detailed10319873detailed
detailer9268673detailer
details84214043details
detainees10267153detainees
detainers10269103detainers
detinue85010033de_tinue
detrain8412253detrain_
detrained1158913detrained
detrains9411763detrains
deucing1139393deucing
devalue1136013devalue
devein1039143devein_
deveined1336673deveined
deveins1138803deveins
deviance1477083deviance
deviant11311313deviant
deviate11312713deviate
device124512163de_vice
devise104215753de_vise
devoice13347343devoice
dewan95718043dewa_n_
dewans105215143dewa_ns
dewaxing20215293dewaxing
dewing114115703de_wing
dexie134716893de_xi_e
dextrine1688253dextrine
dezinc1836053de_zinc
dialing94318173dialing
diamine10311983diamine
diazine1738933diazine
dilate73220693dila_te
dilating102714903dilating
dilative1239523dilative
dine55555333d___ine
divine103514463d_ivine
doling84923133dol_ing
dolling93817373dolling
domain9511323domain_
domaines11611063domaines
domains10510873domains
domine92918253d_omine
dopamine1346173dopamine
dourine8311453dourine
drain65222893d_rain_
drained93713253d_rained
drainer83012843d_rainer
drains73719403d_rains
dualize1759763dualize
dueling93614543duel_ing
duelling103410733duelling
dulcinea1143263dulcinea
dulling93418273dulling
dwelling13368413dwelling
dwine95616143d__wine
eellike1138233eellike
elan46734243_ela_n_
eland65820393_ela_nd
elans55527753_ela_ns
elaphine1346113_elaphine
elapse857523_elapse
elate55335883_ela_te
elating83423083_elating
elative10312453_elative
elfin84312463_elfin_
elfins94810943_elfins
elide64922643_el_ide
elint55436473_el_int
elite56230183_el_ite
eloin55923203_eloin_
eloined8149813_eloined
eloiner7149183_eloiner
eloins65419383_eloins
enamine91214313_enamine
engine71114863_engine
eosine64519413_eosine
equine151711573_equine
ermine8416923_ermine
etamine91313073_etamine
eucaine939243eucaine
examine161510033_examine
exine125518493_e_xine
felines104718073fel_ines
felling113321133felling
felsite1039083felsite
felting113515213felting
ferine96422583fe_rine
flavine1338453_flavine
fulmine1257963fulmine
gelable101710733gelable
gelant72821673gela_nt
gelate73421253gela_te
gelatin83514733gelatin_
gelatines102910533gelatines
gelating103015733gelating
gelatins93414093gelatins
gelding103911793gelding
gelling93219763gelling
genuine838373genuine
glaire74411293_glaire
glaive10357933_glaive
healing113922963healing
helling114623223helling
helming133712003helming
helping133512223helping
helving144011133helving
hematine131614673hematine
hemline12311073hemline
heroine103517483heroine
hexamine2046873hexamine
hexane16379533hexa_ne
hyaline132310723hyaline
idealise938053idealise
idealize1847873idealize
jelling153516613jelling
kelpie12308613kelpi_e
kelping14319193kelping
kelvin13117323kelvin_
kelvins14106563kelvins
ketamine14157053ketamine
lain46146283__lain_
lane45153333__la_ne
larine63927043__larine
lawine93316463__lawine
legatine91311403legatine
leonine7311233leonine
leucine938073leucine
liane54720663__liane
line46965573__l_ine
madeleine1244133madeleine
malaise9312673malaise
maline84529083mal_ine
mealie82519813meali_e
meanie83718393me_anie
melamines1339763melamines
melange1038363melange
melanic11310403melanic
melanin9310893melanin
melanins10310383melanins
melanite10512023melanite
melanize19410303melanize
melding113414273melding
melling102822623melling
melting103317753melting
milline92519113milline
moline84422033mol_ine
moraine9314573moraine
myeline1238253myel_ine
nellie63614813nelli_e
nervine102510623nervine
neurine7311683neurine
olefine1038023olefine
oleine6313793_oleine
online6315843onl_ine
opaline9412483opaline
palatine10316063palatine
pealike131211273pealike
pealing104123203pealing
pelage9515363pela_ge
pelerine10313013pelerine
pelite84323003pel_ite
pelting102917273pelting
pennine93712953pennine
pepsine11310603pepsine
petaline10314883petaline
plaice10311553_plaice
plain74823303_plain_
plained103812233_plained
plainer93811983_plainer
plains85019593_plains
plaint85323203_plaint
plane74929143_pla_ne
praline93019743praline
ralline73518413ralline
realise73021813realise
realize162717083realize
recane83022873reca_ne
recline94020493recline
redline84218833redline
refine95225693re_fine
regain74517763regain_
regained102111243regained
regainer9249353regainer
regains84316583regains
relace83122153rela_ce
relacing112516043relacing
relaid75518443relai_d
reland75920433rela_nd
relapse947703relapse
relate64033633rela_te
relating92725443relating
relative11313143relative
relaxin14239183relaxin_
relaxing162612633relaxing
relaxins15248683relaxins
relaying122515153relaying
reliance10310473reliance
reliant7319243reliant
relined85321933rel_ined
relines75331323rel_ines
relink104415923rel_ink
relive95120783rel_ive
relumine1038933relumine
relying112914613relying
remain85919863remain_
remained112412893remained
remains94117903remains
repaint9318363repaint
repine85627813re_pine
reraise7316313reraise
reshine102816943reshine
retain64523283retain_
retained93016093retained
retainer82913813retainer
retains74522253retains
retine66237333re_tine
rexine134719443re_xine
romaine9512123romaine
saline65132703sal_ine
saltine75018563saltine
sealing83528563sealing
seine55732873se__ine
selfing112911623selfing
selkie102811693selki_e
selling83225833selling
sepaline10311343sepaline
serine65432673se_rine
sestine73017923sestine
setline7313923setline
sideline91011093sidel_ine
silane62718053sila_ne
slain54923573_slain_
slainte738543_slainte
solanine8311533solanine
spline86020533spl_ine
sylvine13216543sylvine
tealike111111083tealike
telae54323293tela__e
telling83321083telling
terrine72517573terrine
thebaine1355423thebaine
tolane64316583tola_ne
valine94623093val_ine
vealing114217423vealing
velamen1237123velamen
velamina1345663velamina
velarize2048763velarize
velate93720143vela_te
venine93718433ve_nine
versine102515173versine
vespine1237903vespine
vulpine1235903vulpine
welding123213253welding
welkin1337313welkin_
welkins1437173welkins
wellie92814913welli_e
welling112920313welling
welting113615313welting
yealing112716383yealing
yelling113516703yelling
yelping13317873yelping
zebrine1836463zebrine

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340274766.76619808.9
3Display Results4764760.1732751.4
 (SQL Overall)1786914767.09225196.1
 
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.