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

149 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
relatives123996(None) 
elatives1139781_elatives
relative11313141relative_
ablatives1445502ablatives
creatives14279692cre_atives
elative10312452_elative_
ergatives1346442ergatives
gelatines102910532gelatines
illatives1245522illatives
negatives1346582negatives
realties8514852realti_es
relates73731432relat__es
relations92418332relations
relatively1646802relatively
relativism1554412relativism
relativist1356232relativist
relativizes2354392relativizes
relives104619442rel__ives
sedatives1346152sedatives
ablative1348243ablative_
beladies11310423beladi_es
calmatives1744733calmatives
correlatives1753903correlatives
creatines112814433cre_atines
creative132812803cre_ative_
curatives1437823curatives
datives11310073__datives
delaines9312963dela_ines
delates83526283delat__es
delations102616593delations
dilative1239523dilative_
donatives13146903donatives
duratives1346223duratives
elates65032363_elat__es
elations83719123_elations
electives1448933_electives
ergative1238973ergative_
eruptives1443853eruptives
fealties1139993fealti_es
fixatives2243353fixatives
fricatives1844683fricatives
gelates83219583gelat__es
gelatine93213303gelatine_
gelatins93414093gelati_ns
gelations102513093gelations
gelatis83313513gelati__s
genitives1346663genitives
glaives11347833_gla_ives
hematines141312203hematines
hematites141510793hematites
hepatizes2347823hepatizes
illative1147183illative_
irrelative1344783irrelative_
latices9313763__latices
laxatives1943353laxatives
lealties8310793lealti_es
lenitives1247503lenitives
locatives1446563locatives
mealtimes1345243mealtimes
melamines1339763melamines
melanites11410723melanites
melanizes20410383melanizes
natives10310823__natives
negative1239083negative_
negatived1444333negatived
nonrelatives1564203nonrelatives
operatives15117883operatives
optatives1445203optatives
palatines11313033palatines
platies93722543_plati_es
precative16312573precative_
prelacies13310053prelaci_es
prelates10418573prelat__es
prelatisms1445703prelatisms
prelatures1245723prelatures
prelives13310383prel__ives
privatives18186473privatives
ratines75328583r__atines
ratites74920683r__atites
reactive13310473reactive_
readies83324713re_adi_es
realises82420183re_alises
realities9316313realities
realizes173116843re_alizes
reaves94127573re_a__ves
rebaptizes2393223rebaptizes
rebates95123183rebat__es
receives1339743re_ceives
recitatives1645193recitatives
redates83423873redat__es
redrives122610393re_drives
reflates113115663reflat__es
reflations13311233reflations
reflexives2342363reflexives
regives115014213re__gives
regulative1446983regulative_
reives95723043re___ives
relaces93420883rela__ces
relapses1038033rela_pses
relate64033633relat__e_
related83327573relat__ed
relater73723143relat__er
relaters83218153relat_ers
relating92725443relati_ng
relation82619773relati_on
relativisms1653913relativisms
relativists1464553relativists
relativities1555773relativities
relativity1645233relativity
relativize2244673relativize
relativized2454023relativized
relators83316123relat_ors
relaxes143215323rela__xes
relaxins15248683relaxi_ns
releves103914973rel__eves
relies65036423rel__i_es
relieves114210393rel_ieves
relines75331323rel__ines
relive95120783rel__ive_
relived115114683rel__ived
relumines1147413relumines
rematches1636653rematches
remates93827113remat__es
renatures939443renatures
repatches1636713repatches
repaves123513653repa__ves
replates102919273replat__es
reptiles103913063re_ptiles
reraises8415643rera_ises
reslates83619503reslat__es
restive10315933re_stive_
restrives12310663restrives
reties65436193re__ti_es
retiles74426993re__tiles
retimes95020173re__times
retines75134673re__tines
retires74726213re__tires
revives134715543re__vives
rolamites1148243rolamites
rotative11310343rotative_
sedative1238853sedative_
statives112710793_statives
teatimes1039443te_atimes
tentatives1345483tentatives
treaties8316983tre_ati_es
treatises9310373tre_atises
velarizes2148643velarizes
vocatives1745883vocatives
volatiles1246133volatiles

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 Filter1786911486410.873204686.1
2DLD Change Limit1486411496.75022020.9
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.68623248.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.