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

136 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
federate1231088(None) 
federated1438421federated
federates13310151federates
deaerate9314172deaerate
derate74531232__derate
federacy1744242federacy
federal1148532federa_l
federals1247302federals
federative1746162federative
federator1346262federator
ferrate103014042fe_rrate
generate9312902generate
moderate11710992moderate
underate9918602underate
venerate11312902venerate
acerate92818913_acerate
acierate10311813acierate
aerate64830553__aerate
ameerate1039633ameerate
asperate10312373asperate
bedframe1643023bedframe
bedmate1239433bed_mate
bedplate1346223bedplate
bedrape1277693bed_rape
berate84729023__berate
beverage1445143beverage
celebrate1348083celebrate
cerate84829463__cerate
cerebrate1348653cerebrate
confederate1754833confederate
deaerated11311113deaerated
deaerates10313643deaerates
debate94419193__debate
decorate11315193decorate
dedicate12312803dedicate
defecate1438793defecate
delate73827753__delate
delegate10410463delegate
denervate1346173denervate
depurate1139983depurate
derat65044083__derat_
derated93623503__derated
derates84028893__derates
derats74625063__derats
desecrate1249083desecrate
desiderate1246273desiderate
desperate12410843desperate
deuterate1049513deuterate
edemata1046003_edemata
edentate947703_edentate
educate10310213_educate
elevate101110373_elevate
emeerate10410103emeerate
emirate91015833_emirate
enervate1148463_enervate
execrate1739653_execrate
federacies1644993federacies
federalese1452313federalese
federalize2345823federalize
federally1645293federally
federating1548853federating
federation1449573federation
federators1446193federators
fedora1038593fedora__
fedoras1137923fedora_s
fellate10313433fe_llate
fenestrate1345293fenestrate
fermate122813003fe_rmate
ferrates113013423fe_rrates
ferrite103312753fe_rrite
feterita1166463feterita
figurate1237193figurate
filtrate1148223filtrate
foredate12310913foredate
foveate1338363fove_ate
fumarate1345683fumarate
generated11310203generated
generates10312713generates
hebetate1347053hebetate
hydrate14239813hyd_rate
ideate7313683_ide_ate
indurate9311873indurate
iterate71119113_iterate
lacerate102214713lacerate
leverage1285393leverage
levirate1147623levirate
liberate101113383liberate
literate81216893literate
macerate122314073macerate
mediate103415213med_iate
medicate13513243medicate
meditate11310623meditate
meterage1147933meterage
moderated1388143moderated
moderates12710753moderates
moderato1186263moderato
numerate101610393numerate
obdurate1175123obdurate
oedemata1143853oedemata
operate9615733_operate
overate10620963_overate
pedate93117763ped__ate
pederast1158593pederast
pederasts1255203pederasts
pederasty1552883pederasty
peerage1089803pe_erage
penetrate1149233penetrate
perorate10417923perorate
predebate1446163predebate
recrate92621663re_crate
recreate10313603recreate
redate74124683red__ate
redecorate1346143redecorate
regelate9312083regelate
regrate82618663re_grate
reiterate9412933reiterate
relegate9311243relegate
reoperate11410183reoperate
sedate73019813sed__ate
selenate81712533selenate
separate10310783separate
serenate81914883serenate
serrate73017543se_rrate
sewerage1245513sewerage
siderite9411363siderite
temperate1348513temperate
tolerate8312323tolerate
ulcerate1039733ulcerate
underage101012273underage
underrate10411893underrate
valerate11311473valerate
vedette1166003vede_tte
vegetate1246673vegetate
venenate1147933venenate
venerated1339953venerated
venerates12312263venerates

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621367.62619166.3
3Display Results1361360.0602266.7
 (SQL Overall)1786911368.10622044.3
 
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.