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

438 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
negater8371196(None) 
neater64424311ne_ater
negate72915571negate_
negated93413231negated
negaters9349781negaters
negates83215841negates
negator83010671negator
beater84729392be_ater
debater104114692debater
dewater112912422dewater
eater54639842_e_ater
elater64724202_elater
engager9278602engager
feater95224052fe_ater
gater64533652__gater
heater94828302he_ater
legate72917452legate_
legated92513982legated
legatee82814632legatee
legates82917682legates
legator83011132legator
nearer64618892ne_arer
neaten64214542ne_aten
negaton8299142negaton
negators92411172negators
nester64124182ne_ster
netter63722022ne_tter
neuter63713792ne_uter
rebater93517912rebater
regaler83814622regaler
regather1236732regather
relater73723142relater
seater64534152se_ater
sedater83713622sedater
abater85518123_abater
abnegate1144863abnegate_
abnegated1344163abnegated
abnegates1244943abnegates
abnegator1243593abnegator
aerate64830553aerate_
aerated85322373aerated
aerates74627493aerates
aerator7314843aerator
agate66525153_agate_
agates76121343_agates
animater101512393animater
anteater8311603anteater
beader94623793be_ader
beaker125520693be_aker
bearer85323913be_arer
beaten84617063be_aten
beaters94925043be_aters
beaver114819253be_aver
begat86629723begat__
begaze1838333begaze_
begazed2036203begazed
begazes1937963begazes
begetter11136313begetter
behaver15206723behaver
belated103520013belated
belayer12339503belayer
belter84720963be_lter
berate84729023berate_
berated104422133berated
berates94126873berates
betatter1035453betatter
better84723703be_tter
bleater94515303bleater
bloater94013423bloater
boater84622093_boater
cater74840723__cater
center84421413ce_nter
cerate84829463cerate_
cerated103922473cerated
cerates95428253cerates
cheater124816963cheater
coater84329573_coater
crater85026643_crater
dater65332313__dater
deader84220473de_ader
deafer104114813de_afer
dealer74122143de_aler
dearer74822803de_arer
debaser103510413debaser
debate94419193debate_
debated113916083debated
debaters113511923debaters
debates103718533debates
decanter112510793decanter
decayer13339353decayer
defacer132810363defacer
defamer132710323defamer
defeater122611663defeater
deflater123211603deflater
defter104215923de_fter
degage92711383degage_
degame102713183degame_
degames113312623degames
degases93413103degases
degasser10325813degasser
degrader11247913degrader
delate73827753delate_
delated93722873delated
delates83526283delates
delator83015023delator
delayer113010533delayer
derate74531233derate_
derated93623503derated
derates84028893derates
desalter938363desalter
deter65028043de__ter
dewaters122910723dewaters
dexter143810893de_xter
dilater83515653dilater
eager65526963_e_ager
easter65027983_easter
eaten55323053_e_aten
eaters65535953_e_aters
eatery95316353_e_atery
eger55923563_eg__er
egger74414403_eg_ger
eglatere945153_eglatere
elate55335883_elate_
elated74725823_elated
elaters74420193_elaters
elates65032363_elates
emoter85415193_emoter
enate54428143_enate_
enates64026423_enates
engage82812103engage_
engaged10379833engaged
engagers10246553engagers
engages92912493engages
engraver1245333engraver
enter54726383_e_nter
eraser64216333_eraser
ergate7315143ergate_
ergates8314493ergates
ester54727713_e_ster
evader1036813_evader
exacter1637403_exacter
exalter1437563_exalter
eyewater1444243eyewater
fagoter1135883fagoter
fearer94820183fe_arer
feaster10812983feaster
feather133613503fe_ather
fester94723513fe_ster
fetter94120383fe_tter
figeater1236953figeater
fighter143010773fighter
floater104413353floater
frater94520593_frater
gager74726293__gager
gagster9317633gagster
gaiter73819503__gaiter
gamer84928943__gamer
gaper86125123__gaper
garter74420513__garter
gaster75027353__gaster
gate55746573__gate_
gated75329773__gated
gaters74728643__gaters
gates65939513__gates
gather104115853__gather
gator64416033__gator
gayer94519193__gayer
gazer155720073__gazer
gelate73421253gelate_
gelated93615633gelated
gelates83219583gelates
getter74117613ge_tter
gloater83711013gloater
grater74625443_grater
greater84416493greater
hater85034753__hater
header104422543he_ader
healer94221803he_aler
heaper114119523he_aper
hearer94323643he_arer
heated104525593he_ated
heaters104225223he_aters
heather133914853he_ather
heaver124819673he_aver
hefter124313923he_fter
heister103613623heister
inflater1149893inflater
ingate73018243ingate_
ingates82716913ingates
ingather1244783ingather
irater65218353_irater
jester134319153je_ster
jugate14379463jugate_
keester11319913keester
kegeler1245493kegeler
kegger12388063keg_ger
kegler11398233keg_ler
keister113011573keister
kelter103214373ke_lter
keyster14256153keyster
kneader1275893kne_ader
krater104014313_krater
later54843923__later
leader74824653le_ader
leaguer835793leaguer
leaker104620073le_aker
leaner64022193le_aner
leaper88118943le_aper
leaser65322673le_aser
leather103815783le_ather
leaver94321513le_aver
lefter93613433le_fter
legatees9258433legatees
legato72810953legat_o
legators92811033legators
legatos82711183legatos
leger65721503leg__er
leggier9368233leggier
leister73212753leister
letter63722583le_tter
levanter1145303levanter
levator10298963levator
ligate72519253ligate_
ligated92414143ligated
ligates82318383ligates
lighter113113443lighter
locater93113603locater
mater74438863__mater
meager94515193me_ager
meaner84617843me_aner
meated94222403me_ated
meatier93214613me_atier
meeter83616503me_eter
megabar1244503megabar
megastar1143533megastar
megathere1544733megathere
megaton10269853megaton
meister93114163meister
melter83520113me_lter
menacer112610883menacer
metamer1139613metamer
metate82720533metate_
metates92720013metates
meter75130323me__ter
nagger84016123nag_ger
naggier9309153naggier
namer75622103n__amer
narrater838723narrater
nates55238333n__ates
natter64420743n_atter
near45236503ne_a__r
neared75119803ne_ared
neat46356783ne_at__
neatens73310403ne_atens
neatest72516003ne_atest
neath86020283ne_at_h
neatherd12107193ne_atherd
neatly93812483ne_atly
neats55931903ne_at_s
necker124012793ne_cker
nectar838853ne_ctar
needer73614953ne_eder
needier84010623needier
needler8388893needler
negating102012833negating
negation92913023negation
negative1239083negative
negatived1444333negatived
negatives1346583negatives
negatons9299273negatons
negatron9335993negatron
neglecter1263633neglecter
neguses837933neguses
neither1037573neither
nematic111713993nematic
neonate7311333neonate_
neonates8310063neonates
nerdier83110353nerdier
nervate1039523nervate_
nervier10298833nervier
nested74720063ne_sted
nesters74422793ne_sters
nestler73510443nestler
nestor63713423ne_stor
nether94014163ne_ther
netted74118713ne_tted
netters73618583ne_tters
nettier74211813nettier
nettler7349503nettler
neuters74212273ne_uters
never86218643ne__ver
newer85717463ne__wer
newsier10147223newsier
newwaver1741963newwaver
nidate7313783nidate_
nidated939863nidated
nidates8311893nidates
nigger89713573nig_ger
niggler93610293niggler
nigher103612753nig_her
niter55028973n__iter
notate63217863notate_
notated82713663notated
notates72817483notates
noter55025643n__oter
nugatory1245273nugatory
nutate63017373nutate_
nutated83113423nutated
nutates73214973nutates
nutter63918053n_utter
oater55433733__oater
pater74740723__pater
pearter9412743pearter
peatier94017233pe_atier
pedaler103410693pedaler
pedate93117763pedate_
pelter83321623pe_lter
penates93321593penates
penster92811953penster
perter84422283pe_rter
pester84827593pe_ster
peter74427593pe__ter
petter83924773pe_tter
pewter114013673pe_wter
plater84427693_plater
pleater93916333pleater
prater84825353_prater
rater54943283__rater
reader73628293re_ader
realer63528593re_aler
realter73716313realter
reamer84325213re_amer
reaper84223143re_aper
rearer64928913re_arer
reaver94524733re_aver
rebate84424113rebate_
rebated103619703rebated
rebaters103413943rebaters
rebates95123183rebates
recanter101913153recanter
reciter94117263reciter
redate74124683redate_
redated93120923redated
redates83423873redates
reenter73217793reenter
refuter104312193refuter
regainer9249353regainer
regale74821453regale_
regaled93615963regaled
regalers94311133regalers
regales83520793regales
regathers1336353regathers
regatta835963regatta
regave104713383regave_
register939553register
regrate82618663regrate_
regrated102816333regrated
regrates92618403regrates
reheater113413033reheater
reinter73116843reinter
relate64033633relate_
related83327573related
relaters83218153relaters
relates73731433relates
relator74016363relator
relaxer143410223relaxer
remaker133813173remaker
remaster10311473remaster
remate84428683remate_
remated103522473remated
remates93827113remates
remoter94815973remoter
renter64527413re_nter
repaper11310023repaper
repeater102615443repeater
rester63832433re_ster
retaker113714313retaker
reutter71010093reutter
righter113212383righter
rugate75813813rugate_
sealer63928963se_aler
seamer84223613se_amer
searer65432023se_arer
seated75131053se_ated
seaters74028943se_aters
seawater1136603seawater
secateur1042923secateur
sedate73019803sedate_
sedated93714343sedated
sedates83418033sedates
senate63725143senate_
senates73322583senates
senator7313063senator
setter64023723se_tter
sighter113412113sighter
skater105015493_skater
slater64429183_slater
sneaker112910453sne_aker
stater64427563_stater
sugarer837323sugarer
sweater103712723sweater
tater54138613__tater
tearer64822903te_arer
teaser65421523te_aser
teated74924023te_ated
teeter65420313te_eter
tempter11358213tempter
tenter64623933te_nter
tester64227153te_ster
tetter64322453te_tter
theater104014253theater
tighter112910693tighter
togate74515683togate_
togated94410663togated
treater74219833treater
uneager839753une_ager
uneaten7412543une_aten
ungated92717213ungated
updater10347253updater
upgather14152753upgather
vealer94016543ve_aler
vegete1039483vegete_
velate93720143velate_
venter94218723ve_nter
vetter93417643ve_tter
water84733313__water
weaker134015443we_aker
weaner93816773we_aner
wearer94319403we_arer
weather133513223we_ather
weaver123916613we_aver
webster1236093webster
weighter1535603weighter
welter93417383we_lter
wester94222893we_ster
wetter93919443we_tter
yester93417983ye_ster
zester153617793ze_ster

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.1401276364.3
2DLD Change Limit1340274387.12618808.2
3Display Results4384380.1562807.7
 (SQL Overall)1786914387.42224075.9
 
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.