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

246 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
elative1031245(None) 
elatives1139781elatives
relative11313141relative
ablative1348242ablative
amative12311732amative
dative10311812_dative
dilative1239522dilative
elapine9310672elapine
elate55335882elat__e
elating83423082elating
elation73620452elation
elective13311002elective
elusive1057002elusive
emotive1239192emotive
emulative1447452emulative
enactive1338512enactive
ergative1238972ergative
evasive1344662evasive
exaptive2045252exaptive
gelatine93213312gelatine
glaive10357932gla_ive
illative1147182illative
native9613012_native
negative1239082negative
relatives1239962relatives
sedative1238852sedative
stative102612932stative
ablatives1445503ablatives
active11313743_active
adaptive1445133adaptive
agatize1739833agatize
alanine7316863alanine
alate55340333alat__e
alation72920553alation
alive85722513__alive
apatite9312963apatite
belive115415303bel__ive
blastie92411393blasti_e
blate75933783blat__e
calmative1647033calmative
captive1438973captive
clave105420153cla__ve
coactive1598623coactive
conative131214623conative
costive12312843costive
creative132812803creative
curative13310403curative
datives11310073_datives
delaine8314793dela_ine
delate73827753delat__e
delating103119603delating
delation92318083delation
delusive1245853delusive
denotive1238673denotive
depletive1545623depletive
deviative1647723deviative
dilutive1255383dilutive
donative12139873donative
durative1239073durative
eating75134403e_ating
eave75733583e_a__ve
educative15136553educative
eductive1476863eductive
egalite8311563egalite
egestive1246833egestive
eglantine1044973eglantine
eglatere945163eglatere
ejective2037153ejective
elain55324703ela_i_n
elains64919853ela_ins
elaphine1346113elaphine
elapid939543elapi_d
elapids1036503elapids
elapse857523ela_pse
elastase845643elastase
elastic93013393elasti_c
elastics102710883elastics
elastin72611843elasti_n
elastins82111743elastins
elated74725823elat_ed
elater64724203elat_er
elaterite949733elaterite
elaters74420193elaters
elates65032363elat_es
elations83719123elations
electives1448933electives
elegise8139393elegise
elegize17127383elegize
elflike1435133elflike
elide64922653el__ide
elite56230183el__ite
elitism939763elitism
elitist7414913elitist
eluate62315433eluat__e
elute54822573elut__e
eluting84115293eluting
elution72913823elution
emanative1447313emanative
emetine9712943emetine
enamine91214313enamine
enate54428153enat__e
enatic8317563enati_c
enation73419233enation
endive103310473e_ndive
entice81316863e_ntice
entire61617703e_ntire
erective13311833erective
ergatives1346443ergatives
erosive1039203erosive
erotize16311663erotize
eruptive1345793eruptive
etamine91313073etamine
etatism9610293etatism
etatist7415033etatist
evaluative1644233evaluative
evocative1746293evocative
examine161510033examine
exertive1839083exertive
expletive2144443expletive
exudative2044893exudative
festive1339773festive
fictive1537023fictive
fixative2145083fixative
flatline11298923flatline
flatwise1443973flatwise
flavine1338453flavine
furtive1337173furtive
gelate73421263gelat__e
gelati73814533gelati__
gelatin83514733gelati_n
gelatines102910543gelatines
gelating103015733gelating
gelatins93414093gelatins
gelation93014433gelation
gelatis83313513gelati_s
genitive1247643genitive
gestative1347303gestative
glaire74411303gla_ire
glaived12375973gla_ived
glaives11347833gla_ives
gratine84719193gratine
hematine131614673hematine
hematite131612153hematite
hepatize2248233hepatize
ideative1238573ideative
illatives1245523illatives
inactive1348203inactive
irrelative1344783irrelative
isatine7311763isatine
iterative12410713iterative
labile8315223_labile
lamiae84817453_lamiae
larine63927043_larine
late47560483_lat__e
lathe85626723_lat_he
lati46438273_lati__
latices9313763_latices
latigo73410013_latigo
latina65621143_latina
latino64120473_latino
latish92416183_latish
latke94817093_lat_ke
latrine7715133_latrine
latte55426303_lat_te
lattice938433_lattice
lave75642143_la__ve
lawine93316463_lawine
laxative1845093laxative
leave84723723lea__ve
legatine91311403legatine
lenitive1148493lenitive
ligative1258803ligative
live76541003_l__ive
locative1338683locative
mealtime1245123mealtime
mediative1548123mediative
melamine12310303melamine
melanite10512033melanite
melanize19410303melanize
motive113112143_motive
mutative1348283mutative
naive85116213_na_ive
natives10310823_natives
negatived1444333negatived
negatives1346583negatives
olfactive1743463olfactive
olive84817153ol__ive
operative141110553operative
optative1347653optative
palatine10316073palatine
patine85328123_patine
placative1646223placative
plaice10311553pla_ice
plaintive1444623plaintive
platane93112303platane
plate74635113plat__e
platier93716293platier
platies93722543platies
platina94413643platina
plating103823073plating
plausive1344583plausive
playtime1544793playtime
plosive1236673plosive
precative16312573precative
pulsative1455173pulsative
putative1348373putative
ratine65131823_ratine
ratite65022423_ratite
reactive13310473reactive
regulative1446983regulative
relate64033633relat__e
relating92725443relating
relation82619773relation
relatively1646803relatively
relativize2244673relativize
relive95120783rel__ive
restive10315933restive
rotative11310343rotative
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
sanative11310473sanative
satire63218003_satire
sedatives1346153sedatives
selective1449523selective
slate55438283slat__e
slatier74016813slatier
slating83724653slating
slave84224033sla__ve
statice92614033statice
statives112710793statives
suasive1037853suasive
talkative1644303talkative
teatime9310083teatime
tentative1247813tentative
tractive13310043tractive
unitive10310563unitive
vegetive1545543vegetive
velarize2048773velarize
velate93720143velat__e
violative1545113violative
vocative1637913vocative
volatile1146433volatile
volitive1446893volitive
votive12348933_votive
waive114214603_wa_ive

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.453394461.4
2DLD Change Limit1340272467.06318975.9
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.