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

117 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
separates1131074(None) 
separate10310781separate_
separated1237711separated
depurates1239822depurates
separately1553432separately
separatism1455602separatism
separatist1247182separatist
separator1146262separator
separators1246502separators
serrates82617022se_rrates
stearates939452stearates
aerates74627493ae__rates
apparats1287093apparat_s
apparatus1353863apparatus
aspartates1244673aspartates
asperates11312553asperates
aspirates1139613aspirates
berates94126873be__rates
carates95630613__carates
cerates95428253ce__rates
deaerates10313643deaerates
dealates92716683de_alates
decorates12314743decorates
demarcates1545973demarcates
departed1238823depar_ted
departee1139723depar_tee
departees1265723departees
departs104310683depar_t_s
depilates12310923depilates
depraves1436873dep_raves
depurate1139983depurate_
depurated1338183depurated
derates84028893de__rates
ecartes94212563_ecar_tes
emanates10311333_emanates
emirates101214853_emirates
epazotes1943773_epazotes
ephorates1459163_ephorates
epilates10313503_epilates
escalates1148823escalates
espartos1044333espar_tos
federates13310153federates
ferrates113013423fe_rrates
fumarates1445393fumarates
generates10312713generates
karates115617473__karates
levirates1247493levirates
nephrites1446503nephrites
operates10515413_operates
palates93624933__palates
parades104121463__parades
perorates11417023perorates
pirates93020333__pirates
prates84633163__p_rates
recrates102420373re_crates
regrates92618403re_grates
reoperates1249663reoperates
repartee10312753repar_tee
repartees1147253repartees
repatriates1385323repatriates
rephrases1447413rephrases
replates102919273rep_lates
retardates1146433retardates
sarapes94617743s__arapes
saturates9811603saturates
savates10312953s__avates
seaplanes1148713seaplanes
searches132112903se_arches
seatmates1157823seatmates
seawares1139333se_awares
seawater1136603se_awater
seawaters1235713se_awaters
secretes10410473se_cretes
sedates83418043se__dates
selenates91611353selenates
senates73322613se__nates
sensates8511143se_nsates
separable1348673separable
separably1655773separably
separateness1455503separateness
separating1348643separating
separation12510433separation
separations1369273separations
separatisms1554653separatisms
separatists1354503separatists
separative1546973separative
septages1168263sep_tages
septate9511873sep_tate_
septettes1144923septettes
serapes95218103se__rapes
seriates82620673se_riates
serrate73017543se_rrate_
serrated92513433se_rrated
sewerages1345363sewerages
sororates9410473sororates
sparables13167163s_parables
spares84834553s_par__es
sparges104016343s_par_ges
sparkles143210493s_parkles
spates85028173s_p__ates
speciates13229233speciates
spectates13228813spectates
sprats85819933s_p_rat_s
sprites94220333s_p_rites
squamates2045593squamates
stearate839723stearate_
supernates12413263supernates
supinates1139553supinates
suppurates1445043suppurates
svarajes1843513s_varajes
swarajes1843743s_warajes
sybarites1465933sybarites
tephrites1446313tephrites
unseparated1443513unseparated
uprates93814863_up_rates
venerates12312263venerates
vicarates1487623vicarates

Search took 9 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.423422437.4
2DLD Change Limit1486411177.96618659.4
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.43521184.5
 
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.