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

206 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
relative1131314(None) 
elative10312451_elative
relatives1239961relatives
ablative1348242ablative
creative132812802cre_ative
dilative1239522dilative
elatives1139782_elatives
ergative1238972ergative
gelatine93213312gelatine
illative1147182illative
irrelative1344782irrelative
negative1239082negative
precative16312572precative
reactive13310472reactive
regulative1446982regulative
relate64033632relat__e
relating92725442relating
relation82619772relation
relatively1646802relatively
relativize2244672relativize
relive95120782rel__ive
restive10315932re_stive
rotative11310342rotative
sedative1238852sedative
ablatives1445503ablatives
amative12311733_amative
belive115415303bel__ive
calmative1647033calmative
conative131214623conative
correlative1645543correlative
creatine103417413cre_atine
creatives14279693cre_atives
curative13310403curative
dative10311813__dative
delaine8314793dela_ine
delate73827753delat__e
delating103119603delating
delation92318083delation
delusive1245853delusive
denotive1238673denotive
depletive1545623depletive
deviative1647723deviative
dilutive1255383dilutive
donative12139873donative
durative1239073durative
elapine9310673_elapine
elate55335883_elat__e
elating83423083_elating
elation73620453_elation
elective13311003_elective
elusive1057003_elusive
emotive1239193_emotive
emulative1447453emulative
enactive1338513_enactive
erective13311833erective
ergatives1346443ergatives
eruptive1345793eruptive
evasive1344663_evasive
exaptive2045253_exaptive
festive1339773fe_stive
fixative2145083fixative
fricative1746743fricative
gelate73421263gelat__e
gelati73814533gelati__
gelatin83514733gelati_n
gelatines102910543gelatines
gelating103015733gelating
gelatins93414093gelatins
gelation93014433gelation
gelatis83313513gelati_s
genitive1247643genitive
gestative1347303gestative
glaive10357933_gla_ive
hematine131614673hematine
hematite131612153hematite
hepatize2248233hepatize
ideative1238573ideative
illatives1245523illatives
iterative12410713iterative
laxative1845093laxative
legatine91311403legatine
lenitive1148493lenitive
ligative1258803ligative
locative1338683locative
mealtime1245123mealtime
mediative1548123mediative
melamine12310303melamine
melanite10512033melanite
melanize19410303melanize
mutative1348283mutative
native9613013__native
negatived1444333negatived
negatives1346583negatives
nonrelative1456833nonrelative
operative141110553operative
optative1347653optative
orective1339353ore_ctive
palatine10316073palatine
prelate9519693prelat__e
prelatic12311293prelati_c
prelatism1347853prelatism
prelature1146273prelature
prelusive1455583prelusive
privative17188293privative
probative1649173probative
pulsative1455173pulsative
putative1348373putative
radiative1348173radiative
ratine65131823r__atine
ratite65022423r__atite
realise73021813re_alise
realize162717083re_alize
realties8514853realties
reave84528023re_a__ve
rebaptize2293373rebaptize
rebate84424113rebat__e
rebating112418343rebating
receive1239733re_ceive
receptive1648333receptive
recitative1548183recitative
reclusive1475433reclusive
recreative1549023recreative
redate74124683redat__e
redating102620173redating
redrive112410563re_drive
reductive1547793reductive
refective1749113refective
reflate103516263reflat__e
reflating132514713reflating
reflation12412333reflation
reflective1857123reflective
reflexive2243033reflexive
refractive1846693refractive
regave104713383rega__ve
regive104814323re__give
reive85522943re___ive
rejective2148253rejective
relace83122153rela__ce
relacing112516043relacing
relaid75518443rela_i_d
relapse947703rela_pse
relatable11310053relatable
related83327573relat_ed
relater73723143relat_er
relaters83218153relaters
relates73731433relat_es
relations92418333relations
relativism1554413relativism
relativist1356233relativist
relativity1645243relativity
relativized2454023relativized
relativizes2354393relativizes
relator74016373relat_or
relators83316133relators
relaxin14239183relaxi_n
relaxing162612633relaxing
relaxins15248683relaxins
relaying122515153relaying
releve95116403rel__eve
relieve105010693rel_ieve
reline65434353rel__ine
relived115114683rel__ived
relives104619443rel__ives
relumine1038933relumine
remate84428683remat__e
remating112322423remating
renature839333renature
renovative1645433renovative
reparative1548173reparative
repave114813873repa__ve
replate93420053replat__e
replating122217403replating
replicative1846083replicative
reptile93914083re_ptile
reraise7316313rera_ise
resentive12410723resentive
resistive1247583resistive
reslate73520593reslat__e
reslating102516993reslating
restrive11310923restrive
retaliative1454983retaliative
retentive1249853retentive
retie55735303re__ti_e
retile65929673re__tile
retime85321803re__time
retine66237333re__tine
retire64927013re__tire
revertive1548853revertive
revive124914823re__vive
rolamite1048743rolamite
sanative11310473sanative
sedatives1346153sedatives
selective1449523selective
stative102612933_stative
talkative1644303talkative
teatime9310083te_atime
tentative1247813tentative
treatise8311103tre_atise
urinative1247653urinative
vegetive1545543vegetive
velarize2048773velarize
velate93720143velat__e
violative1545113violative
vocative1637913vocative
volatile1146433volatile
volitive1446893volitive

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622066.94021060.8
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.43624030.5
 
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.