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

515 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
dilating10271490(None) 
delating103119601delating
diluting10248981diluting
ablating11311992ablating
adulating1178712adulating
dating85326482d__ating
debating123213732debating
deflating142610712deflating
delaying133210972delaying
deleting103314422deleting
depilating1439182depilating
derating103222272derating
dialing94318172di_aling
dialling10310782dialling
dictating1338882dictating
dieting93616832di_eting
dighting142510842dighting
dilatant948202dilatant
dilation92215462dilation
dilations102614452dilations
dilative1239522dilative
dinting93520552di_nting
disrating11714552disrating
doating93816862d_oating
donating10311802donating
elating83423082_elating
epilating12310962epilating
fileting1239302fileting
filiating1339242filiating
fixating1936182fixating
gelating103015732gelating
hilting113316892hil_ting
ideating10311702ideating
jilting153211742jil_ting
kilting123213852kil_ting
ligating102212282ligating
lilting83515382lil_ting
milting103619122mil_ting
nidating1039772nidating
piloting1139692piloting
pirating11314512pirating
plating103823072_plating
relating92725442relating
silting83320482sil_ting
slating83724652_slating
solating9315592solating
tilting83417102til_ting
violating1337422violating
wilting113515912wil_ting
abating10413973_abating
abdicating1686153abdicating
acylating1547553acylating
aerating92820993aerating
agitating1138853agitating
ailing74331013ail__ing
airting83616303ai_rting
aliasing9310073aliasing
allaying12339303allaying
animating12312503animating
aviating12311013aviating
bating95132253__bating
beating104326873_beating
belaying143110603belaying
belting104119133bel_ting
berating113220753berating
biasing103512453bi_asing
bighting15269453bighting
bilging114212683bil_ging
bilking144413553bil_king
billeting1236633billeting
billing103823853bil_ling
biltong1034683bil_tong
biting95321823bi__ting
bitting103717293bi_tting
blading113615363_blading
blaming123515693_blaming
blaring104317113_blaring
blasting114013423_blasting
blatting114111653_blatting
blawing134012753_blawing
blazing193612393_blazing
bleating113514503bleating
bloating113512813bloating
boating103721303_boating
bolting104416763bol_ting
borating113414503borating
cheating144014523cheating
chelating1549353chelating
citing94220183ci__ting
clawing133812673_clawing
claying133614303_claying
cleating113518133cleating
coating103525303_coating
collating12312753collating
crating103725203_crating
creating113921953creating
curating11314293curating
dallying13368493dallying
damaging1337383damaging
daring84928683d__aring
darting94020663d_arting
daunting103310403daunting
dauting93814763d_auting
dawing114819823d__awing
dawting123610673d_awting
dazing175516513d__azing
dealing94323233d_ealing
deaning94020473d_eaning
deaving123814753d_eaving
debasing12238063debasing
debiting122511203debiting
debuting12268633debuting
decanting132510633decanting
decaying15239453decaying
decimating1648743decimating
declaring1339573declaring
declawing1636213declawing
dedicating1539143dedicating
defacing15238683defacing
defaming15238463defaming
defatting1436103defatting
defeating142311973defeating
defilading1643643defilading
deglazing2135133deglazing
delaine8314783dela_ine
delation92318083delation
delations102616593delations
deleading1237773deleading
deleaving1436263deleaving
delegating1337673delegating
deleing93313953del_eing
deliming12310373deliming
delisting112710503delisting
deluding1137683deluding
deluging1137123deluging
delving123711573del_ving
demasting1338453demasting
demoting12311423demoting
denoting10311753denoting
denting94422183d_enting
departing1349513departing
deplaning1338053deplaning
depleting1378193depleting
deputing12238793deputing
deratting1139513deratting
desalting1138843desalting
desolating1239463desolating
deviating14311083deviating
devoting1338823devoting
dewaxing20215293dewaxing
dialings10329823di_alings
diallings1134993diallings
dialoging1246313dialoging
dialysing1444483dialysing
dialyzing2344043dialyzing
diamin9312513di_amin_
diamine10311973di_amine
diamins10312203di_amins
diazin1639163di_azin_
diazine1738933di_azine
diazins1739183di_azins
dibbing133110883di_bbing
dibbling14247333dibbling
dicing105718763di__cing
dicking153617613di_cking
diddling12228733diddling
dieing84018653di__eing
digesting12208673digesting
digging113513703di_gging
diking124320243di__king
dilatancy1552523dilatancy
dilatants1044513dilatants
dilatate947773dilatate
dilate73220693dilat__e
dilated93115823dilat_ed
dilater83515643dilat_er
dilaters92513053dilaters
dilates83220653dilat_es
dilator82712783dilat_or
dilators93213173dilators
dilatory12279273dilatory
dilution9239143dilution
dilutions10248583dilutions
dilutive1255373dilutive
dimming13339583di_mming
dimpling14199023dimpling
dindling112411163dindling
dinging103618613di_nging
dining84525133di__ning
dinking133618283di_nking
dinning93416553di_nning
dipping134014833di_pping
directing1338813directing
dirking133812603di_rking
dirling93316073di_rling
dirtying1336093dirtying
disabling1337753disabling
disarming1338803disarming
discanting1449453discanting
discasing1339433discasing
discing113914593di_scing
discoing12511453discoing
diseasing11310833diseasing
dishing124017103di_shing
disking134615493di_sking
disliking1537313disliking
dislocating1546733dislocating
dismasting1446383dismasting
dismaying1656823dismaying
disparting1438933disparting
displacing1646413displacing
displanting1546043displanting
displaying1746313displaying
disputing1337763disputing
dissaving1436953dissaving
disseating121111783disseating
dissing94517683di_ssing
distain8313783distain_
distains9413603distains
distasting1248023distasting
disusing1039003disusing
ditching15349943ditching
dittoing1036263dittoing
divagating1644003divagating
diverting142410333diverting
divesting14298483divesting
dividing1437183dividing
diving113717953di__ving
divining1338413divining
divulgating1742303divulgating
divvying1932773divvying
dizening19177143dizening
dizzying2133023dizzying
doling84923133dol__ing
dolling93817373dol_ling
dollying13407413dollying
dominating1449393dominating
doting84821913d__oting
dotting93314483d_otting
doubting1237373doubting
drafting13339403drafting
draping114213353d_raping
dratting10389653dratting
drawing123812053d_rawing
draying123813843d_raying
dreading113712803dreading
dreaming124011063dreaming
drifting13338733drifting
drilling103311983dril_ling
ducting113713593d_ucting
dueting93814393d_ueting
duetting1047183duetting
dulling93418273dul_ling
dunting93418383d_unting
dusting93618993d_usting
eating75134403__eating
editing9313133edi__ting
educating1337923educating
eluting84115293_eluting
emulating1239863emulating
enlacing1148773enlacing
equating18310113equating
estating92614993estating
etiolating1146963etiolating
exalting1638033exalting
fating105328673__fating
fellating1339243fellating
felting113515213fel_ting
fighting162710083fighting
filching1736113filching
filing103823763fil__ing
filleting1335843filleting
filling113520803fil_ling
filming133210353fil_ming
filtrating1445973filtrating
fisting113818123fi_sting
fitting113516563fi_tting
flaking154114493_flaking
flaming134216443_flaming
flaring114116803_flaring
flatling123410013_flatling
flatting123511253_flatting
flawing143812563_flawing
flaying143914463_flaying
flinting123412343flinting
flirting12319013flirting
fliting113514613_fliting
flitting123010883flitting
floating123111883floating
fluting113815093_fluting
flyting14378553_flyting
foliating1339253foliating
gating84826953__gating
gelatin83514733gelatin_
gelatine93213303gelatine
gelatins93414093gelatins
gifting123810893gi_fting
gilding103813003gil_ding
gilling93520383gil_ling
gillying13306813gillying
gimleting1343863gimleting
girting93113333gi_rting
gitting93215703gi_tting
glaring93714883_glaring
glazing183611003_glazing
glinting103210053glinting
gloating102611463gloating
grating93923183_grating
gyrating1337453gyrating
halting114419073hal_ting
hating104929713__hating
heating114024323_heating
highting16259723highting
hilding123713533hil_ding
hilling113821773hil_ling
hilloing12158293hilloing
hinting113919223hi_nting
histing113720373hi_sting
hitting113017273hi_tting
idling8912873idl__ing
imaging1138073_imaging
imitating1238763imitating
indicating1449693indicating
inflating13310443inflating
inlacing1158373inlacing
inlaying1247893inlaying
iodating1038823iodating
iodinating1246963iodinating
isatin6412213_isatin_
isatine7311763_isatine
isatins7310773_isatins
isolating1039743isolating
jolting153410913jol_ting
jubilating2045223jubilating
killing123118723kil_ling
kilning12289023kil_ning
kiltings13327083kil_tings
kiting114117093ki__ting
kitting123214443ki_tting
lacing94626233__lacing
lading84227123__lading
laking115027043__laking
laming94528363__laming
lasing74727983__lasing
lasting84725243__lasting
lathing114315693__lathing
latina65621143__latina
latino64120473__latino
laving104623573__laving
lawing104625283__lawing
laying104525703__laying
lazing164821473__lazing
legating102313113legating
librating1239053librating
lichting14268513lichting
lifting113313273li_fting
lighting132811833lighting
limiting1138813limiting
linting83820983li_nting
liquating1946313liquating
listing84020593li_sting
locating11311503locating
luting75221753__luting
luxating1645613luxating
malting103219083mal_ting
mating94832913__mating
mediating13311193medi_ating
medicating1648923medicating
meditating1448113meditating
melting103317753mel_ting
migrating13910523migrating
milding113615453mil_ding
militating1348823militating
milking143712763mil_king
milling103223683mil_ling
minting103020813mi_nting
minuting1139723minuting
misacting1439083misacting
misdating131010663misdating
miseating121215433miseating
mislaying1557913mislaying
mismating141211813mismating
misrating121014843misrating
misting103623383mi_sting
moating104218153_moating
modulating1446373modulating
molting103517173mol_ting
mulcting13246983mulcting
mutating112211753mutating
mutilating1349063mutilating
negating102012833negating
nictating1237573nictating
nilling83619563nil_ling
nitrating10312673nitrating
notating92513343notating
nutating92411953nutating
oiling74925313oil__ing
opiating11410093opiating
oppilating1544853oppilating
orating83520323_orating
ovulating1336953ovulating
oxalating1745803oxalating
oxidating1845053oxidating
palatine10316063palatine
palpating1438533palpating
pelting102917273pel_ting
picoting1338883picoting
piling95025593pil__ing
pillaging1345553pillaging
pillaring1237643pillaring
pilling103722563pil_ling
pilotings1234353pilotings
pitting103618873pi_tting
pivoting1436183pivoting
placing123815283_placing
plaiting113113513_plaiting
planing103418253_planing
planting113515383_planting
platina94413643_platina
platings113611363_platings
platting114813033_platting
playing133816093_playing
pleating112916053pleating
prating103424453_prating
pulsating1236343pulsating
pupating1337683pupating
quilting18218713quil_ting
radiating111112123radi_ating
radicating1459063radicating
rating74938703__rating
rebating112418343rebating
redating102620173redating
reflating132514713reflating
relacing112516043relacing
relaxing162612633relaxing
relaying122515153relaying
remating112322403remating
replating122217393replating
reslating102516993reslating
rifting113515003ri_fting
righting132610853righting
riling74227973ril__ing
rilling84023623ril_ling
rioting82716393ri_oting
rivaling1239913rivaling
riveting12139443riveting
rotating92614553rotating
ruinating1039593ruinating
salting84120793sal_ting
saluting9310553saluting
sating74735453__sating
seating84130683_seating
sedating103014113sedating
sibilating1346963sibilating
sifting113014593si_fting
sighting133110863sighting
silking123715593sil_king
siloing83215493sil_oing
simulating1347613simulating
sinuating1039683sinuating
siting74126623si__ting
sitting83519633si_tting
situating1038883situating
skating123613843_skating
slaking123717473_slaking
slanting94115093_slanting
slatings94011723_slatings
slatting94014233_slatting
slaving113514833_slaving
slaying113316843_slaying
slitting93012583slitting
solacing11310133solacing
solvating1336443solvating
splatting1235983splatting
splaying14219303splaying
stating83725163_stating
stilting93312393stil_ting
sublating12310983sublating
sulfating1338063sulfating
sweating123213023sweating
tailgating1244873tailgating
tiling73426553til__ing
tilling83522773til_ling
tincting1148883tincting
tinting84620603ti_nting
titrating10310113titrating
toileting1036263toileting
treating92519613treating
ululating1036643ululating
umlauting1243163umlauting
undulating1247143undulating
unlacing1148643unlacing
unlading1058863unlading
unlaying1258363unlaying
updating1236593updating
uprating11311113uprating
urinating10310653urinating
vacating14310343vacating
valeting1238843valeting
valuating1338633valuating
vialing113614163vi_aling
vialling1237223vialling
vibrating1537473vibrating
visaing11279333visa_ing
visiting1238393visiting
vitiating1338403vitiating
welting113615313wel_ting
wilding123814293wil_ding
wildling13248083wildling
wiling103024293wil__ing
willing113821613wil_ling
willying15306713willying
wisting113519743wi_sting
witing103522823wi__ting
witting113417063wi_tting

Search took 10 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.1561145455.1
2DLD Change Limit1461625159.06316127.3
3Display Results5155150.2162384.3
 (SQL Overall)1786915159.43518939.2
 
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.