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

510 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
native961301(None) 
dative10311811dative
naive85116211na_ive
natives10310821natives
active11313742active
alive85722512_alive
amative12311732amative
captive1438972captive
conative131214622conative
datives11310072datives
donative12139872donative
elative10312452elative
enactive1338512enactive
inactive1348202inactive
motive113112142motive
naiver94311352na_iver
naives94914222na_ives
narine63422552narine
nation64322802nation
natively1446412natively
nature6311262nature
nave75732312na__ve
negative1239082negative
notice8313442notice
patine85328122patine
ratine65131822ratine
ratite65022422ratite
sanative11310472sanative
satire63218002satire
stative102612932stative
unitive10310562unitive
votive12348932votive
waive114214602wa_ive
abide86223713_abide
ablative1348243ablative
above105414323_above
actives12311523actives
adaptive1445133adaptive
afire86215913_afire
agatize1739833agatize
agave95314033_agave
agile65122263_agile
aide56045003_a_ide
aiver85725163_a_iver
ajiva1586803_ajiva
alike95523963_alike
aline57243153_aline
amice96122873_amice
amide86128483_amide
amie66339853_ami_e
amine75835383_amine
anatase738943anatase
anile54634463_anile
anime75423203_anime
anise55129703_anise
antae56828293ant_ae
ante46538903ant__e
anti45536363anti__
antiar6317173antiar
antic75728863anti_c
antick124814583antick
antics84621453antics
antigen8311123antigen
anting75827023anting
antique1638883antique
antired82316193antired
antis55033313anti_s
antisex1439693antisex
antlike11312073antlike
antre55224523ant_re
anytime1246043anytime
apatite9312963apatite
arise56436433_arise
arrive91311793arrive
aside65122083_aside
ate37059243_at__e
atilt54828473_atilt
atone56527983_atone
attire62412383attire
ave67748703_a__ve
axile126020513_axile
axite125218253_axite
azide155617163_azide
azine146721413_azine
baize164717393ba_ize
baptise1139553baptise
baptize2036983baptize
barite84224813barite
bastile9313913bastile
bate66552423bat__e
bathe105822883bat_he
batik11614733bati_k
batiked1435963batiked
batiks1239373batiks
bating95132253bating
batiste939743batiste
batlike133311883batlike
battle85217863battle
battue84311003battue
bawtie113812143bawti_e
belive115415303belive
betide95115973betide
betime105914833betime
betise85616273betise
calve105919923ca_lve
camise103319633camise
canine83826703canine
captives1538623captives
caribe103416753caribe
carve106227753ca_rve
cate66254603cat__e
cation83925503cation
catlike132712933catlike
cattie85221023cattie
cattle85118903cattle
cave95941263ca__ve
cavie104621593cavi_e
chive135117623_chive
coactive1598623coactive
costive12312843costive
creative132812803creative
curative13310403curative
cutie76925933cuti_e
dacite91115883dacite
date56443323dat__e
dating85326483dating
datival1135583datival
datively1545673datively
dautie72914703dauti_e
dawtie103011093dawti_e
daytime1344783daytime
denotive1238673denotive
derive103817043derive
dilative1239523dilative
dive85634773__dive
donatives13146903donatives
drive95318003_drive
durative1239073durative
eating75134403eating
eave75733583ea__ve
elatives1139783elatives
emanative1447313emanative
emotive1239193emotive
enamine91214313enamine
enate54428153enat__e
enatic8317563enati_c
enation73419233enation
endive103310473endive
entice81316863entice
entire61617703entire
ergative1238973ergative
evasive1344663evasive
exaptive2045253exaptive
faciae112913413faciae
facile112514883facile
famine114318193famine
fate75444283fat__e
fatigue1144393fatigue
fating105328673fating
fatlike142911193fatlike
fauve114712073fa_uve
fave105532963fa__ve
festive1339773festive
fictive1537023fictive
five107629743__five
fixative2145083fixative
furtive1337173furtive
futile93914953futile
gamine94620153gamine
gate55746573gat__e
gating84826953gating
gave84634053ga__ve
genitive1247643genitive
give85829353__give
glaive10357933glaive
gnathite1244483gnathite
gnatlike1334743gnatlike
gratine84719193gratine
habile11515213habile
halide103417993halide
halite93624233halite
halve114818923ha_lve
hate78450173hat__e
hating104929713hating
hatlike143311713hatlike
have106137073ha__ve
hive106029673__hive
ideative1238573ideative
illative1147183illative
intime81014273intime
intine61021983intine
inutile739883inutile
invasive1444833invasive
isatine7311763isatine
jive146123593__jive
kation104315683kation
knave12389463kna__ve
labile8315223labile
lamiae84817453lamiae
larine63927043larine
late47560483lat__e
lathe85626723lat_he
lati46438273lati__
latices9313763latices
latigo73410013latigo
latina65621143latina
latino64120473latino
latish92416173latish
latke94817093lat_ke
latrine7715133latrine
latte55426303lat_te
lattice938433lattice
lave75642143la__ve
lawine93316463lawine
laxative1845093laxative
lenitive1148493lenitive
ligative1258803ligative
live76540993__live
locative1338683locative
maile75232223ma_ile
maize164618563ma_ize
malice104818483malice
maline84529083maline
mamie95826003mami_e
marine84230403marine
massive12289773massive
mate65154223mat__e
matier84321523matier
matin75132853mati_n
matinee92415613matinee
mating94832913mating
matins84527783matins
matte75626843mat_te
mature8313473mature
mauve104013273ma_uve
mavie104722563mavi_e
maxixe1435223maxixe
monitive1349993monitive
motile83818343motile
motived13357763motived
motives123611893motives
mutative1348283mutative
mutine84420373mutine
nabe66029493na__be
nabis76020583nabi_s
nacre75715363na_cre
nadir61012973nadi_r
nadirs7109003nadirs
nae35952743na___e
naevi867873na_evi
naiad6313403na_iad
naif76839023na_i_f
naifs87617423na_ifs
nail45838653na_i_l
nailed74021493na_iled
nailer64119363na_iler
nails55730403na_ils
naira5314743na_ira
nairu5413813na_iru
naively1335903na_ively
naivest10309473na_ivest
naivete1055663na_ivete
naivety1344283na_ivety
name65637413na__me
naming93917893naming
nance74721843na_nce
nanism8311203nanism
nannie63713223nannie
naoi46024633naoi__
nape65230803na__pe
nappe96114993na_ppe
nappie104112263nappie
nardine82712573nardine
nargile847653nargile
narial6317953narial
naric76824173nari_c
naris55735293nari_s
narrative1247373narrative
nasial6413283nasial
nasion63914083nasion
nastic82915973nasti_c
nastier74115293nastier
nasties73520493nasties
nastily103011033nastily
natal53921493nat_al
natant6318733natant
natch105018223nat_ch
nates55238333nat_es
nations74720563nations
nativism13116613nativism
nativist11118683nativist
nativity1446633nativity
natrium948983natrium
natron64116023natron
natter64420743natter
nattier73614623nattier
nattily103610323nattily
natty85719143nat_ty
natured838963natured
natures7311963natures
nautili746113nautili
navel87016573na__vel
naves87030383na__ves
navies95218623navies
navvies1335323navvies
navvy14696683na_vvy
navy107518633na__vy
nazi136219873nazi__
nazify2134233nazify
nazis145216083nazi_s
negatived1444333negatived
negatives1346583negatives
nerve86617373n_erve
netizen1635883netizen
netlike11308913netlike
nettle64514583nettle
neve76224833n__eve
newie81813483newi_e
nice65534713n__ice
nide55535793n__ide
nieve85613183n_ieve
nine45842173n__ine
nite45943583n__ite
nitid61817833niti_d
nitre57519683nit_re
nitride82811243nitride
nitrile73011373nitrile
nitrite72314463nitrite
nixe115722023n__ixe
nixie125114943nixi_e
noise55723733n_oise
nonactive1448973nonactive
nonnative1248343nonnative
norite63221133norite
normative1448893normative
notate63217863notate
note46239963not__e
noticed1037863noticed
noticer937273noticer
notices9312283notices
notify1236943notify
noting74120153noting
notion64516583notion
novice1138433novice
nowise9511073nowise
nubile83212713nubile
nudie65118673nudi_e
nutate63017373nutate
nutlike113110113nutlike
oatlike113412403oatlike
octave11157343octave
ogive9379093_ogive
olive84817153_olive
onetime937623onetime
optative1347653optative
optime1079353optime
outgive11199253outgive
outlive102513033outlive
outvie92412803outvie
paise75028333pa_ise
pantie84326473panti_e
pantile93918483pantile
pareve114613013pareve
partite9317133partite
parve109824853pa_rve
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
pate65350463pat__e
patin76832853pati_n
patina86022193patina
patinae95414403patinae
patined105114783patined
patines95225763patines
patins87528783patins
patio74426353pati_o
patios85221783patios
pattee84323383pattee
pattie84020963pattie
pave96133893pa__ve
pavise114714803pavise
petite84320653petite
punitive1346833punitive
putative1348373putative
ragtime1036163ragtime
raise54828053ra_ise
ramie75027823rami_e
rapine85023083rapine
rate45458763rat__e
rathe85821923rat_he
ratify122610043ratify
ratines75328583ratines
rating74938703rating
ratio55227583rati_o
ration64226013ration
ratios64922673ratios
ratites74920683ratites
ratlike113912353ratlike
ratline74517803ratline
rattle64717613rattle
rave75542093ra__ve
ravine95522223ravine
reactive13310473reactive
regive104814323regive
reive85522943_reive
relative11313143relative
relive95120783relive
restive10315933restive
retie55735303reti_e
retile65929673retile
retime85321803retime
retine66237333retine
retire64927013retire
revive124914823revive
rive75537723__rive
rotative11310343rotative
rutile65217683rutile
sabine84020393sabine
saice75424053sa_ice
saithe94713913saithe
saline65132703saline
saliva93110743saliva
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
salve85022133sa_lve
samite83020603samite
sate45556103sat__e
sati45539333sati__
satiate7315403satiate
satin55935223sati_n
satinet7325283satinet
sating74735453sating
satins64930483satins
satiny93817983satiny
satires72617573satires
satis55633683sati_s
save75741363sa__ve
savine94220283savine
scrive115414943scrive
sedative1238853sedative
shive114423423_shive
shrive125216953shrive
skive124614113_skive
snathe94415113snat_he
sonatine8313323sonatine
starve94613743starve
statice92614033statice
statives112710793statives
stave85324993_stave
stile54931573_stile
stime76521803_stime
stipe76523373_stipe
stiver93915733_stiver
stove85220253_stove
strive95020963strive
suasive1037853suasive
swive115316193_swive
tactile9310613tactile
tantivy1335563tantivy
tardive1136893tardive
tate44748603tat__e
tattie64817513tattie
tattle64115653tattle
tawie84819813tawi_e
taxite13511303taxite
teatime9310083teatime
tentative1247813tentative
thrive125313223thrive
tide55237383__tide
tie36557533__ti_e
tike85534483__tike
tile45451443__tile
time66235013__time
tine45855133__tine
tire46143353__tire
tivy1014516863__tivy
tractive13310043tractive
unagile838283unagile
unakite1138743unakite
unalike11311533unalike
unitize16310033unitize
unlive92712333unlive
untie54425493unti_e
updive1234903updive
uptime1067673uptime
urinative1247653urinative
utile54718933_utile
vagile10310543vagile
vahine123612113vahine
valine94623093valine
valise92917643valise
valve114515933va_lve
varve115716853va_rve
vatic10316423vati_c
vetiver1336103vetiver
visive1257873visive
vive105426623__vive
vocative1637913vocative
votives13337953votives
wahine123813013wahine
waived134511283wa_ived
waiver124212713wa_iver
waives123714183wa_ives
wartime1237743wartime
watape11208483watape
wattle94314213wattle
wave105234733wa__ve
wive105931753__wive
zaire14311993za_ire

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.390458182.1
2DLD Change Limit1127165105.81319390.3
3Display Results5105100.1732948.0
 (SQL Overall)1786915106.37628025.6
 
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.