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

470 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
motive11311214(None) 
emotive1239191emotive
motile83818341motile
motived13357761motived
motives123611891motives
votive12348931votive
active11313742active
amative12311732amative
costive12312842costive
dative10311812dative
mobile103613542mobile
moire71017322mo_ire
moline84422032moline
monie75631652moni_e
monitive1349992monitive
mortice11711492mortice
mortise9713532mortise
mote67048082mot__e
motif10519682moti_f
motifs1139672motifs
motiles93317432motiles
motion85217552motion
motivate1347692motivate
motivic1445162motivic
motte75526972mot_te
mottle84116052mottle
move96630722mo__ve
movie105319132movi_e
moxie144018122moxi_e
mutine84420372mutine
native9613012native
notice8313442notice
ogive9379092_ogive
olive84817152_olive
votives13337952votives
abortive1346883abortive
actives12311523actives
adoptive1445503adoptive
alive85722513_alive
amortise10428513amortise
amortize1987743amortize
amosite9313163amosite
amotion9710473amotion
amusive1246253amusive
arrive91311793arrive
attire62412383attire
azotise1637073azotise
azotize1537083azotize
belive115415303belive
betide95115973betide
betime105914833betime
betise85616273betise
biotite9311033biotite
bodice11711423bodice
bogie89524103bogi_e
boite74426323bo_ite
bolide9515563bolide
bootie85421163booti_e
boride9415903boride
bottle84916073bottle
bovine11712433bovine
captive1438973captive
chive135117623_chive
coactive1598623coactive
codrive1337653codrive
conative131214623conative
conine84528553conine
connive1238993connive
contrive13311353contrive
cootie84223093cooti_e
cosie74728263cosi_e
cosine83823513cosine
cote66648733cot__e
coting94629253coting
cottae84615703cottae
cotype1346823cotype
cove95837073co__ve
cozie163519133cozi_e
cutie76925933cuti_e
datives11310073datives
denotive1238673denotive
derive103817043derive
dive85634773__dive
dobie84920333dobi_e
docile94213123docile
dogie75222793dogi_e
domine92918253domine
donative12139873donative
dotage82711613dotage
dote55442883dot__e
dotier73917033dotier
doting84821913doting
dottle74212503dottle
dove85131563do__ve
dowie94721143dowi_e
doxie136017153doxi_e
drive95318003_drive
elative10312453elative
emetine9712943emetine
emote75421193emot__e
emoting10313563emoting
emotion9711303emotion
emotively1744403emotively
endive103310473endive
entice81316863entice
entire61617703entire
eosine64519413eosine
erosive1039193erosive
erotize16311663erotize
etoile6312263etoile
festive1339773festive
fictive1537023fictive
five107629743__five
fogie96719003fogi_e
fomite113314073fomite
footie94718143footi_e
forgive1436193forgive
furtive1337173furtive
futile93914953futile
give85829353__give
glaive10357933glaive
goitre7349003goitre
gothite1146403gothite
hive106029673__hive
hogtie102711773hogti_e
hoise85224773ho_ise
homie104622533homi_e
hostile10312553hostile
hotline10712353hotline
hottie92514383hottie
hove107132223ho__ve
immotile1245173immotile
intime81014273intime
intine61021983intine
iodide84812933iodide
iodine74618653iodine
iodise74214943iodise
iodize164112593iodize
iolite63221983iolite
ionise63516943ionise
ionize154613873ionize
jive146123593__jive
koine9516483ko_ine
live76540993__live
locative1338683locative
looie55624243looi_e
loti46431843loti__
lotic76420673loti_c
lotion65716523lotion
lotte54923853lot_te
louie55023513loui_e
love75234763lo__ve
maile75232223m_aile
maize164618563m_aize
malice104818483malice
maline84529083maline
mamie95826003mami_e
marine84230403marine
massive12289773massive
mate65154223mat__e
matier84321523matier
matin75132853mati_n
matinee92415613matinee
mating94832913mating
matins84527783matins
matte75626843mat_te
mature8313463mature
mauve104013273m_auve
mavie104722563mavi_e
maxixe1435223maxixe
mediae94217413mediae
metage93114453metage
metate82720533metate
mete64438133met__e
metier83517693metier
meting94320593meting
metis75025903meti_s
metisse936503metisse
metope10611123metope
metre74821303met_re
mettle83815723mettle
mice87442233m__ice
mike105535293m__ike
mile66352573m__ile
mime85736403m__ime
mine67256173m__ine
miniver1238393miniver
miotic103715753mioti_c
miotics112710653miotics
mire66748233m__ire
mise66043583m__ise
misgive13339033misgive
mislive122812693mislive
missive122413143missive
mistime11312613mistime
mite66249413m__ite
mitier83620673mitier
mitis75425993miti_s
mitises9315543mitises
mitre75522423mit_re
moating104218153moating
moatlike1446993moatlike
mobiles112813123mobiles
mode75840303mo__de
modi76826313modi__
modica11310063modica
modify1537173modify
modish123813543modish
modiste1039283modiste
module93011033module
moggie103210103moggie
moil65534093mo_i_l
moiled94318863mo_iled
moiler84017263mo_iler
moils76125753mo_ils
moira71012023mo_ira
moires8915633mo_ires
moist76033583mo_ist
moke106234223mo__ke
mole66251833mo__le
molies84429513molies
mollie83517103mollie
molting103517173molting
mome85239353mo__me
momi87524483momi__
momism93410353momism
monde85723143mo_nde
monetise10311473monetise
monetize1949983monetize
mongoe94214983mongoe
monied94319463monied
monies83233163monies
moniker1338673moniker
monish114217593monish
monism104016313monism
monist84324983monist
montage101211713montage
montane91313623montane
monte75829773mo_nte
mooing93718373mooing
moose76327193mo_ose
mooting103019363mooting
mope86838043mo__pe
mopier103914783mopier
moping114017103moping
mopish134311593mopish
mopoke1436633mopoke
morae75831193mo_rae
moraine9314573moraine
morale85220553morale
more67154523mo__re
morgue938113morgue
morion86217733morion
morose85116243morose
morse76032703mo_rse
morticed1377163morticed
mortices12711563mortices
mortify1536223mortify
mortised1178743mortised
mortiser1078473mortiser
mortises10713613mortises
mosque17287163mosque
moste75925083mo_ste
mot57279423mot___
motel76623243mot_el
motels83616893motels
motes75944003mot_es
motet75641193mot_et
motets84216193motets
motey105922953mot_ey
moth96731333mot__h
mother113718643mother
mothier121910213mothier
mothlike1736063mothlike
moths106021553mot_hs
mothy136214553mot_hy
motific1446323motific
motioned1137453motioned
motioner1037593motioner
motions94215003motions
motivated1545963motivated
motivates1447073motivates
motiving1437163motiving
motivity1646223motivity
motley1139383motley
motlier92010583motlier
motmot10311073motmot
motor75317293mot_or
motored1039933motored
motorise10311523motorise
motorize19410433motorize
motors84616603motors
mots66853163mot__s
mott66648443mot__t
mottes85523693mottes
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
motto76119513mot_to
mottoes93412193mottoes
mottos84615243mottos
motts76527003mot_ts
moue65835573mo__ue
mouille937843mouille
mouse77133003mo_use
mousse84813033mousse
moved114218153mo__ved
mover104220863mo__ver
moves106128423mo__ves
movies115118453movies
moving123913283moving
mowing124119093mowing
moxies154317403moxies
murine84220023murine
mutase82811983mutase
mutate83017483mutate
mutative1348283mutative
mute65136873mut__e
mutined103311353mutined
mutines93117823mutines
muting93921523muting
mutiny113612683mutiny
mutism103211463mutism
mutule8311423mutule
myotic133112313myoti_c
myotics14257603myotics
myotome1445483myotome
naive85116213_naive
natives10310823natives
noise55723733no_ise
norite63221133norite
notate63217863notate
note46239963not__e
noticed1037863noticed
noticer937273noticer
notices9312283notices
notify1236943notify
noting74120153noting
notion64516583notion
novice1138433novice
nowise9511073nowise
octave11157343octave
ogives10367913_ogives
olives94313953_olives
oolite63319603oolite
oorie53026363oori_e
ootid61416703ooti_d
ootids71110353ootids
opine77422463_opine
optime1079353optime
otic66624823_oti_c
otiose639403_otiose
outgive11199253outgive
outlive102513033outlive
outvie92412803outvie
ovine86316643_ovine
oxide131210953_oxide
oxime1498433_oxime
patine85328123patine
petite84320653petite
plosive1236673plosive
podite93315353podite
poetise9314043poetise
poetize18310773poetize
poise75127893po_ise
police102918563police
polite83625073polite
pontine92419053pontine
poove104514303po_ove
positive1349993positive
postdive1445763postdive
postie84123963posti_e
potage92715903potage
potiche1438043potiche
potion84519573potion
potlike13910123potlike
potline91015233potline
potpie103412433potpie
potsie83916033potsie
pottle84416103pottle
poutine93316823poutine
promotive1648033promotive
ratine65131823ratine
ratite65022423ratite
regive104814323regive
reive85522943_reive
relive95120783relive
restive10315933restive
retie55735303reti_e
retile65929673retile
retime85321803retime
retine66237333retine
retire64927013retire
revive124914823revive
rive75537723__rive
rotate63320343rotate
rotative11310343rotative
rotche114311983rotche
rote46249023rot__e
roti46332933roti__
rotifer1036993rotifer
rotis56327063roti_s
rotte54625933rot_te
routine72615903routine
rove75136983ro__ve
rutile65217683rutile
satire63218003satire
scrive115414943scrive
shive114423423_shive
shrive125216953shrive
skive124614113_skive
smote75820283smot__e
soave84219053so_ave
softie93312483softi_e
solve85618943so_lve
somite84519373somite
sopite84917713sopite
sorptive1346473sorptive
sortie63621993sorti_e
sozine15712353sozine
sportive1348333sportive
stative102612933stative
stave85324993_stave
stile54931573_stile
stime76521803_stime
stipe76523373_stipe
stiver93915733_stiver
stove85220253_stove
strive95020963strive
swive115316193_swive
thrive125313223thrive
tide55237373__tide
tie36557533__ti_e
tike85534483__tike
tile45451443__tile
time66235013__time
tine45855133__tine
tire46143353__tire
tivy1014516863__tivy
toile54626493to_ile
tontine72316143tontine
tortile7313193tortile
tote46643673tot__e
toting74123793toting
towie85821873towi_e
toxine133114123toxine
unitive10310563unitive
unlive92712333unlive
untie54425493unti_e
updive1234903updive
uptime1067673uptime
utile54718933_utile
vetiver1336103vetiver
visive1257873visive
vive105426623__vive
vocative1637913vocative
vogie95116663vogi_e
voice104915323vo_ice
voile84719723vo_ile
volitive1446893volitive
vomitive1645853vomitive
vote74728623vot__e
voting103916033voting
votively1744193votively
waive114214603_waive
wive105931753__wive
wove105624313wo__ve
yowie114616453yowi_e
zouave1833573zouave
zowie174313843zowi_e

Search took 6 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.1401276364.3
2DLD Change Limit1127164705.43620735.1
3Display Results4704700.2032315.3
 (SQL Overall)1786914705.77930920.7
 
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.