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

517 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
datives1131007(None) 
dative10311811dative_
natives10310821natives
actives12311522actives
captives1538622captives
dacites101114592dacites
daises74318982da_ises
dates65639152dat__es
datival1135582datival
datively1545672datively
dauties83315762dauti_es
davies105020512davi_es
dawties113312702dawti_es
daytimes1434482daytimes
derives114017812derives
dives95832402d__ives
donatives13146902donatives
drives105117112d_rives
duratives1346222duratives
duties74921902duti_es
elatives1139782elatives
latices9313762latices
motives123611892motives
naives94914222na_ives
native9613012native_
patines95225762patines
ratines75328582ratines
ratites74920682ratites
satires72617572satires
sedatives1346152sedatives
statives112710792statives
votives13337952votives
waives123714182wa_ives
abatises10311013abatises
abides94719893_abides
ablatives1445503ablatives
aboves114512843_aboves
active11313743active_
adaptive1445133adaptive_
additives1444443additives
admires1038663admires
admixes1765963admixes
advices13136933advices
advises11138973advises
agatizes1838863agatizes
agaves104611513_agaves
aides65336603_a_ides
aiver85725163_a_iver
aivers94822323_a_ivers
ajivas1655133_ajivas
alines65735223_alines
alive85722513_alive_
amative12311733amative_
amices105018013_amices
amides95722663_amides
amies76837693_ami_es
amines84727983_amines
animes84719593_animes
anises64826693_anises
apatites10311293apatites
apices104916263_apices
arises65233803_arises
arrives101311513arrives
asides75118873_asides
ates45047923_at__es
atones65225773_atones
attires72312953attires
auditives1345723auditives
aves76142603_a__ves
axises134413993_axises
axites134913833_axites
azides165113803_azides
azines155517073_azines
babies106123653babi_es
baizes174315053ba_izes
banties94324763banti_es
baptises1238923baptises
baptizes2136843baptizes
barites94322333barites
bastiles10313353bastiles
batches144019613batches
bates75846343bat__es
bathes116524833bat_hes
batiked1435963batiked
batiks1239373bati_ks
batistes1039713batistes
battles94517683battles
battues94610193battues
bawties124214313bawti_es
betides104915263betides
betimes115114413betimes
betises94816123betises
calices114321693calices
calves115119283ca_lves
camises114218463camises
canines93724033canines
capizes20410373capizes
captive1438973captive_
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carves115128453ca_rves
catches144320773catches
cates75951893cat__es
cations94524143cations
catties94023053catties
caves105639703ca__ves
cavies114525003cavi_es
chives144317593_chives
cities84524853citi_es
creatives14279693creatives
curatives1437823curatives
cuties84927363cuti_es
cutises94414913cutises
dabbles124514773dabbles
daces85030683da__ces
dacite91115883dacite_
daddies103414943daddies
daddles104213803daddles
dadoes85616533da_does
daggles103611913daggles
dagoes85714603da_goes
daiker115113033da_iker
daikers124010313da_ikers
dailies84219263dailies
daimen92210573da_imen
dainties9312403dainti_es
dairies84217733dairies
dais57040703da_i__s
daisies84217093daisies
dales66439743da__les
dalles74222063da_lles
dallies84023193dallies
damages11511273damages
dames85435853da__mes
dances95120653da_nces
dandies94121443dandies
dandles94218533dandles
dangles93618423dangles
danios7314603dani_os
danishes121710493danishes
daphnes13327683daphnes
dapples1238993dapples
darbies104216983darbies
dares66146703da__res
darics94314113dari_cs
darings93713653darings
darioles9710693darioles
darkies124015753darkies
darkles124011933darkles
dartles84014133dartles
dashes106124983da_shes
dassies84418663dassies
dataries9314033dataries
datchas1347423datchas
date56443323dat__e_
dated75530993dat__ed
dateless9259963dateless
datelines1088853datelines
dater65332313dat__er
daters74827373dat_ers
dating85326483dati_ng
datos65222783dat__os
dattos74311903dat_tos
datums936353dat_ums
daturas838773daturas
daubes94913703da_ubes
dautie72914703dauti_e_
daven94916473da__ven
davens104612913da__vens
davits104012363davi_ts
dawdles12379163dawdles
dawtie103011093dawti_e_
daysides1335963daysides
daytime1344783daytime_
dazes155024143da__zes
dazzles1636413dazzles
dearies83526273deari_es
deaves105319533d_eaves
deceives1437903deceives
decides114217653decides
deciles104417723deciles
defies104624053defi_es
defiles114016843defiles
defines114118683defines
deices94119373d_eices
deities82621923deities
delimes10314193delimes
deliver113312243deliver
delivers123310753delivers
delves104917083d_elves
demies94825803demi_es
demises103719563demises
denies74729643deni_es
dentines93418403dentines
deprives1438393deprives
derides93420853derides
derive103817043derive_
derived123912763derived
deriver114213913deriver
derivers123811363derivers
desires81316133desires
destines93619663destines
deticks1437353deticks
detinues9569823detinues
detoxes1538803detoxes
devices133212583devices
devises114116763devises
dexies145018343dexi_es
diamides1238823diamides
diamines11311643diamines
diaries83321953diari_es
diatribes1245533diatribes
diazines1838713diazines
dices86434243d__ices
didies84621833didi_es
dies55653523d__i_es
dikes105831333d__ikes
dilative1239523dilative_
dimes85833043d__imes
dines66449153d__ines
dirties83119383dirti_es
distaves12311403distaves
ditches133215713ditches
dites66339153d__ites
ditties83116983ditties
ditzes163212423dit_zes
divas95418583d__ivas
dive85634773d__ive_
dived106321373d__ived
diver94827803d__iver
divers105024963d__ivers
divest106820073d__ivest
divides123211453divides
divines113514723divines
divvies1457663divvies
dobies94422093dobi_es
dogies85022253dogi_es
domines102918973domines
donative12139873donative_
dories75232363dori_es
dotages92311793dotages
dotes65836693dot__es
dotier73917033doti_er
dotiest83717453doti_est
dottles83912283dottles
doves94728153d__oves
doxies143917853doxi_es
dries64733673d_ri_es
drive95318003d_rive_
drivel105110383d_rivel
drivels11397923d_rivels
driven105210143d_riven
driver104714493d_river
drivers114412793d_rivers
droves105116673d_roves
dualizes1838823dualizes
dunites8313593dunites
durative1239073durative_
dwarves1434463dwarves
dwines105013103d_wines
easies64126633easi_es
eatings84616443eatings
eaves85231993ea__ves
elative10312453elative_
endives113710693endives
entices91616333entices
entires71517783entires
ergatives1346443ergatives
facies113921593faci_es
famines123216263famines
fates85139233fat__es
fatigues1244193fatigues
fatsoes10379423fatsoes
fatties103018203fatties
fauves125610423fa_uves
faves115331423fa__ves
fives116027363__fives
fixatives2243353fixatives
gabies93820733gabi_es
gamines103618463gamines
gates65939513gat__es
gatings95212823gatings
gives95324873__gives
glaives11347833glaives
hafizes2235983hafizes
halides113416663halides
halites103221193halites
halves124717093ha_lves
hatches153420273hatches
hates86742573hat__es
haves116034873ha__ves
hives116925513__hives
ideative1238573ideative_
illatives1245523illatives
intines7921113intines
isatines8310663isatines
jives154820813__jives
kations114013663kations
knives13458553_knives
ladies75124883ladi_es
laities7320343laities
lapides103012043lapides
lapises93513463lapises
latches123320123latches
latexes1438313latexes
lathes95127493lat_hes
latigoes9306163latigoes
latigos8277243latigos
latinas74416463latinas
latinos73613803latinos
latkes104715873lat_kes
latrines8515003latrines
lattes65324203lat_tes
lattices1038383lattices
laves86039153la__ves
lawines103313563lawines
laxatives1943353laxatives
lazies154418783lazi_es
lives86133193__lives
locatives1446563locatives
mailes84329113ma_iles
maizes175115733ma_izes
malices114316623malices
malines93625603malines
mamies104626243mami_es
mantises10317923mantises
marines93928013marines
mastixes1738253mastixes
matches143219783matches
mates75251363mat__es
matier84321523mati_er
matiest92522453mati_est
matinee92415613matinee
matinees102110423matinees
matiness102114753matiness
matings104516213matings
matins84527783mati_ns
matres84522233mat_res
matrices12312083matrices
matrixes1738063matrixes
mattes85624533mat_tes
matures9314303matures
mauves113811553ma_uves
mavies114923193mavi_es
mavises122812993mavises
maxixes1535253maxixes
mitises9315543mitises
motiles93317433motiles
motive113112143motive_
motived13357763motived
mutines93117823mutines
naive85116213na_ive_
naiver94311353na_iver
naivest10309473na_ivest
nasties73520493nasti_es
nates55238333nat__es
nations74720563nations
natively1446413natively
nativism13116613nativism
nativist11118683nativist
natures7311963natures
naves87030383na__ves
navies95218623navi_es
navvies1335323navvies
negatives1346583negatives
notices9312283notices
oaves84925613oa__ves
octaves12316963octaves
ogives10367913_ogives
olives94313953_olives
optatives1445203optatives
optimes1148473optimes
outgives12218623outgives
outlives112511763outlives
outvies102214243outvies
panties94230933panti_es
pantiles103617153pantiles
paries84742513pari_es
parises94827183parises
parties93230863parti_es
passives13228823passives
pasties94529813pasti_es
pastimes123611903pastimes
pastises103616053pastises
patches143320383patches
pates76047893pat__es
patinas96318523patinas
patine85328123patine_
patined105114783patined
patins87528783pati_ns
patios85221783pati_os
patsies93919483patsies
patties93425143patties
paves104833923pa__ves
pavises125315493pavises
petites93820203petites
pities83828083piti_es
platies93722543plati_es
rabies85226023rabi_es
radices102314263radices
radixes15259343radixes
ragtimes1135823ragtimes
raises64826543ra_ises
ramies84630463rami_es
rapines95120863rapines
ratches123620463ratches
rates55352013rat__es
ratifies11313513ratifies
ratine65131823ratine_
ratings84217413ratings
rations74123433rations
ratios64922673rati_os
ratite65022423ratite_
ratlines83815293ratlines
rattles73217303rattles
raves85441973ra__ves
ravines104220233ravines
regives115014213regives
reives95723043_reives
relatives1239963relatives
relives104619443relives
reties65436193reti_es
retiles74426993retiles
retimes95020173retimes
retines75134673retines
retires74726213retires
revives134715543revives
rives85336003__rives
rutiles74315843rutiles
sabines94318483sabines
saices84221803sa_ices
salines74029413salines
salivas10309603salivas
salties73725773salti_es
saltines82917793saltines
saltires83112423saltires
salves94221763sa_lves
samites93118713samites
sanies63031953sani_es
sates54949323sat__es
satiates8314633satiates
satinet7325283satinet
satinets8311733satinets
satins64930483sati_ns
satire63218003satire_
satis55633683sati__s
saves85838633sa__ves
savines104417633savines
savvies1337603savvies
scrives124414273scrives
sedative1238853sedative_
shives124921413_shives
shrives134416173shrives
skives134113943_skives
starves104614553starves
statices102712343statices
stative102612933stative_
staves94525193_staves
sties55132983_sti_es
stiles64328773_stiles
stimes85920573_stimes
stipes84524053_stipes
stiver93915733_stiver
stivers103613543_stivers
stoves93818923_stoves
strives104119373strives
swives123915183_swives
talipes9611603talipes
tamises92715973tamises
tantivies1247103tantivies
tapises92914013tapises
tates55444983tat__es
tatties74120343tatties
tattles73616283tattles
taxies135817333taxi_es
taxites1449673taxites
teatimes1039443teatimes
thrives134611713thrives
tides64830153__tides
ties45248313__ti_es
tikes95628903__tikes
tiles55542103__tiles
times75630823__times
tines54848423__tines
tires55437493__tires
unlives102010953unlives
unties64326923unti_es
updives1334713updives
uptimes1177553uptimes
vahines133410523vahines
valines104520213valines
valises103516263valises
valves124113783va_lves
varices123313573varices
varies94330873vari_es
varves124414783va_rves
vetiver1336103vetiver
vetivers1435163vetivers
vocatives1745883vocatives
votive12348933votive_
wadies105121203wadi_es
wahines133111173wahines
waive114214603wa_ive_
waived134511283wa_ived
waiver124212713wa_iver
waivers133410053wa_ivers
walies95324523wali_es
wartimes1336963wartimes
watapes12228383watapes
watches153017373watches
wattles103814073wattles
waves115633923wa__ves
wavies125019843wavi_es
wives115328923__wives
zaires1539703za_ires
zanies153219673zani_es

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.390458182.1
2DLD Change Limit1340275176.82619634.8
3Display Results5175170.1902721.1
 (SQL Overall)1786915177.40624127.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.