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

485 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
legating10231311(None) 
legatine91311401legatine
ligating102212281ligating
negating102012831negating
aerating92821002aerating
beating104326872be_ating
begazing2136632begazing
berating113220762berating
bleating113514502ble_ating
cleating113518132cle_ating
debating123213732debating
delating103119602delating
delegating1337672delegating
derating103222282derating
eating75134402_e_ating
elating83423082_elating
elevating1338202elevating
gating84826952__gating
gelating103015732gelating
heating114024322he_ating
leading93419552le_ading
leafing113313582le_afing
leaguing1035342leaguing
leaking123616972le_aking
leaning83721202le_aning
leaping103215992le_aping
leasing83920162le_asing
leaving114216852le_aving
legation92412932legation
legations102711922legations
legging103912642leg_ging
leniting9312352leniting
letting83218532le_tting
levanting1345522levanting
levigating1545692levigating
lighting132811832lighting
locating11311502locating
luxating1645612luxating
pleating112916052ple_ating
rebating112418342rebating
redating102620172redating
regaling10315362regaling
regrating111316212regrating
relating92725442relating
relegating1239482relegating
remating112322412remating
seating84130682se_ating
sedating103014112sedating
abating10413973_abating
ablating11311993ablating
abnegating1444463abnegating
agenting1039383agenting
alerting91312383ale_rting
alienating1147223alienating
alighting1446413alighting
aviating12311013aviating
bating95132253__bating
beading113221863be_ading
beaming123618803be_aming
beaning103820683be_aning
bearing103624773be_aring
beatings114113233be_atings
begalling13216493begalling
begetting13186583begetting
beggaring1435183beggaring
begging123012653beg_ging
behaving1735453behaving
belaying143110603belaying
belting104119133be_lting
benaming1339693benaming
beraking153612973beraking
besting104923923be_sting
betaking153010153betaking
betting103921403be_tting
bewaring14279493bewaring
bighting15269453bighting
blearing113111943ble_aring
blighting1635733blighting
bloating113512813bloating
boating103721303_boating
bogarting1334653bogarting
borating113414503borating
ceasing104118263ce_asing
ceratin93020163ceratin_
ceratins102818733ceratins
cheating144014523cheating
chelating1549353chelating
cleaning113112383cle_aning
clearing113014883cle_aring
cleaving141389683cle_aving
clefting14347583cle_fting
coating103525313_coating
crating103725203_crating
creating113921953creating
cremating14312193cremating
curating11314293curating
dating85326483__dating
dealing94323233de_aling
deaning94020473de_aning
deaving123814753de_aving
debasing12238063debasing
debiting122511203debiting
debuting12268633debuting
decanting132510633decanting
decaying15239453decaying
defacing15238683defacing
defaming15238463defaming
defatting1436103defatting
defeating142311973defeating
deflating142610713deflating
degassing1234823degassing
deglazing2135133deglazing
degrading13137373degrading
degusting1236163degusting
delaying133210973delaying
deleting103314423deleting
demasting1338453demasting
demoting12311423demoting
denoting10311753denoting
denting94422183de_nting
departing1349513departing
deputing12238793deputing
deratting1139513deratting
derogating1348633derogating
desalting1138843desalting
deviating14311083deviating
devoting1338823devoting
dewaxing20215293dewaxing
dighting142510843dighting
dilating102714903dilating
doating93816863_doating
donating10311803donating
eagling91113603_eagling
earing75235483_e_aring
easing74926463_e_asing
easting84924303_easting
eatings84616443_e_atings
editing9313133_editing
egesting1039013_egesting
egging93210983_eg_ging
electing112113783electing
elegising1145423elegising
elegizing2045613elegizing
elongating1244523elongating
eluting84115293_eluting
emoting10313563_emoting
enacting11311363_enacting
engaging1147373engaging
equating18310113equating
erasing8317963_erasing
estating92614993estating
evading1237283_evading
eviting11511373_eviting
exacting1838523_exacting
exalting1638033_exalting
exiting15311393_exiting
fagoting1336283fagoting
fating105328673__fating
fearing113520033fe_aring
feasing113916653fe_asing
feasting122011323feasting
feazing205411443fe_azing
feinting123410833feinting
fellating1339243fellating
felting113515213fe_lting
feting104417793fe__ting
fetting113517873fe_tting
fighting162710083fighting
fixating1936183fixating
fleeting122910323fle_eting
flighting1736103flighting
floating123111883floating
gaeing84617223__gaeing
gaging94718403__gaging
gaiting93716583__gaiting
gaming104622043__gaming
gaping105618923__gaping
gasting95022763__gasting
gatings95212823__gatings
gazing174717173__gazing
gearing92818843ge_aring
gelatin83514733gelatin_
gelatine93213303gelatine
gelatins93414093gelatins
gemmating1576443gemmating
gestating11229983gestating
getting93316563ge_tting
gleaming12277933gle_aming
gleaning10269323gle_aning
gleeting10279173gle_eting
gloating102611463gloating
grating93923183_grating
gyrating1337453gyrating
hating104929713__hating
heading122919113he_ading
healing113922963he_aling
heaping133015853he_aping
hearing113324163he_aring
hearting12513123hearting
heaving144114763he_aving
hefting144510913he_fting
heisting123411043heisting
hematin121516023hematin_
hematine131614673hematine
hematins131714683hematins
henting113719653he_nting
highting16259723highting
ideating10311703ideating
ingoting1039863ingoting
iodating1038823iodating
iterating10314253iterating
jesting154317713je_sting
jetting153815343je_tting
kegging14328293keg_ging
kegling13309363keg_ling
keratin113314153keratin_
keratins122313483keratins
lacerating1349443lacerating
lacing94626233l__acing
lactating1239183lactating
lading84227123l__ading
lagering102212313lagering
lagging103316733lag_ging
laking115027043l__aking
laming94528363l__aming
lariating10311783lariating
lasing74727983l__asing
lasting84725243l_asting
lathing114315693l__athing
latina65621143l__atina
latino64120473l__atino
laving104623573l__aving
lawing104625283l__awing
laying104525703l__aying
lazing164821473l__azing
leaching143012833leaching
leadings103511243le_adings
leanings94010183le_anings
learning978553learning
leashing123310313leashing
leasings9379843le_asings
leavings12407493le_avings
leching134613653le_ching
lectin82515013le_ctin_
lectins92515003le_ctins
leeching14318373leeching
leering83417643le_ering
leftwing1532973leftwing
legacies1139043legacies
legalise949493legalise
legalising1245743legalising
legalism1148583legalism
legalist9512393legalist
legality1237623legality
legalize1839103legalize
legalizing2147543legalizing
legate72917453legat__e
legated92513983legat_ed
legatee82814633legat_ee
legatees9258433legatees
legates82917683legat_es
legato72810953legat__o
legator83011133legat_or
legators92811033legators
legatos82711183legat_os
leggin8268593leg_gin_
leggings11316193leg_gings
leggins9259473leg_gins
legislating1343403legislating
legong836963leg__ong
legumin1045073legumin_
legumins1144993legumins
lekking11306503le_kking
lemming12269393le_mming
lending94118533le_nding
lensing84015103le_nsing
leptin82512333le_ptin_
leptins92412693le_ptins
letching143810263letching
levantine1264793levantine
leveeing12265963leveeing
leveling122910433leveling
levering122212503levering
levitating1446653levitating
levying1435873le_vying
liberating1349253liberating
librating1239053librating
lichting14268513lichting
lifting113313273l_ifting
ligation92313093ligation
ligations102111993ligations
ligative1258803ligative
ligaturing1293063ligaturing
lightings14277723lightings
lightning14286023lightning
lilting83515383l_ilting
limiting1138813limiting
linting83820983l_inting
liquating1946313liquating
listing84020593l_isting
litigating1246743litigating
loading94114613l_oading
loafing11319793l_oafing
loaming103613733l_oaming
loaning83614833l_oaning
loathing1247673l_oathing
lofting113311313l_ofting
logging103316803log_ging
looting83019643l_ooting
lotting82917753l_otting
louting83719383l_outing
lugeing9359113lug_eing
lugging104114353lug_ging
luging83915293lug__ing
lunting83817743l_unting
lusting83619323l_usting
luting75221753l__uting
mating94832913__mating
meaning103918703me_aning
medaling121912263medaling
mediating13311203mediating
meeting103314963me_eting
megaton10269853megaton_
megatons11279703megatons
melting103317753me_lting
menacing1339783menacing
meriting11314683meriting
metaling111613723metaling
meting94320593me__ting
migrating13910533migrating
moating104218153_moating
mutating112211753mutating
nearing83020333ne_aring
negation92913023negation
negations102811963negations
negative1239083negative
negativing1543613negativing
negaton8299143negaton_
negatons9299273negatons
nesting84320443ne_sting
netting84018763ne_tting
nidating1039783nidating
notating92513343notating
nutating92411953nutating
obligating1445803obligating
operating12313723operating
opiating11410093opiating
orating83520323_orating
oughting1335953oughting
peacing124117073pe_acing
peaking144317693pe_aking
pealing104123203pe_aling
pedaling122412133pedaling
pegging122811133peg_ging
pelting102917273pe_lting
petting103720953pe_tting
pirating11314513pirating
placating1438513placating
plating103823073_plating
pleading123011443ple_ading
pleasing112611593ple_asing
plighting1635563plighting
prating103424453_prating
predating13514653predating
pupating1337683pupating
rating74938703__rating
reacting113317893reacting
reading93327213re_ading
reaming103924013re_aming
reaping103621213re_aping
rearing83128783re_aring
reaving113820533re_aving
rebaiting12311643rebaiting
recaning111416693recaning
recanting122414823recanting
recasting122414233recasting
reciting113118073reciting
recoating121317463recoating
recrating121318793recrating
redacting13612303redacting
reesting93118273reesting
refacing142512813refacing
reflating132514713reflating
refuting121911903refuting
regain74517763rega_in_
regaining112411083regaining
regains84316583rega_ins
regarding12149153regarding
regauging1235543regauging
regearing112211413regearing
regelating1239953regelating
regiving13269713regiving
reglazing2046553reglazing
regluing1077033regluing
regrading121210203regrading
regrafting1545993regrafting
regranting1238323regranting
regulating12310063regulating
reheating132314913reheating
relacing112516043relacing
relaxing162612633relaxing
relaying122515153relaying
remaking152613303remaking
renaming11313693renaming
renting84026853re_nting
repasting122312843repasting
repaving142810743repaving
repaying142712393repaying
repeating122618983repeating
replating122217403replating
reputing112412603reputing
resawing122311433resawing
resaying122512453resaying
reseating102421533reseating
resiting93521123resiting
reslating102516993reslating
restating102319413restating
resting85031183re_sting
retaking133114283retaking
retaping113012553retaping
retasting102513413retasting
retaxing162311333retaxing
retting83425883re_tting
revoting12312033revoting
rewaking162310983rewaking
rewaxing19248563rewaxing
righting132610853righting
rotating92614553rotating
sating74735453__sating
seagoing1038193seagoing
sealing83528563se_aling
seaming103222113se_aming
searing83330923se_aring
seatings93614303se_atings
segueing1034983segueing
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
setting83621393se_tting
sighting133110863sighting
skating123613853_skating
slating83724653_slating
sleaving123310983sle_aving
sleeting93114163sle_eting
slighting1436373slighting
solating9315593solating
stating83725163_stating
sugaring1039053sugaring
sweating123213023sweating
teaming103917593te_aming
tearing84021493te_aring
teasing83918513te_asing
tempting1357343tempting
tenanting1036213tenanting
tenting84621153te_nting
testing86021053te_sting
tolerating1148593tolerating
treating92519613treating
ulcerating1346983ulcerating
ululating1036643ululating
ungazing1936033ungazing
updating1236593updating
upgazing2133313upgazing
uprating11311113uprating
vacating14310353vacating
vealing114217423ve_aling
vegetating1545703vegetating
vegging13308873veg_ging
venting114218093ve_nting
vesting114618683ve_sting
vetting114216563ve_tting
weaning114117193we_aning
wearing113318863we_aring
weaving143211623we_aving
weeting113816053we_eting
weighting1744783weighting
welting113615313we_lting
westing115020273we_sting
wetting114117383we_tting
yealing112716383ye_aling
yeaning113814633ye_aning
yeasting12188923yeasting
zeatin15412823ze_atin_
zeatins16311733ze_atins
zesting174515333ze_sting

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.440406115.9
2DLD Change Limit1461624856.92021121.7
3Display Results4854850.2032389.2
 (SQL Overall)1786914857.56323627.0
 
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.