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

176 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
deaerate931417(None) 
deaerated11311111deaerated
deaerates10313641deaerates
aerate64830552__aerate
deaerator10128112deaerator
dealate83617842dea_late
decorate11315192decorate
defecate1438792defecate
delegate10410462delegate
denervate1346172denervate
depurate1139982depurate
derate74531232d__erate
desecrate1249082desecrate
desperate12410842desperate
deuterate1049512deuterate
federate12310882federate
generate9312902generate
venerate11312902venerate
acerate92818913_acerate
acierate10311813acierate
aerated85322373__aerated
aerates74627493__aerates
ameerate1039633ameerate
asperate10312373asperate
aurate64426473__aurate
berate84729023__berate
beverage1445143beverage
carate84734003_ca_rate
celebrate1348093celebrate
cerate84829463__cerate
cerebrate1348653cerebrate
deaerating12311563deaerating
deaeration11313013deaeration
deaerators11107713deaerators
dealated103213603dea_lated
dealates92716683dea_lates
deaminate12410173deaminate
dearest83618673dearest_
dearie73319813dea_r_ie
dearth104212513dea_r_th
debate94419193d__ebate
decease1049523dece_ase
decelerate1347513decelerate
decimate13411123decimate
decorated13312213decorated
decorates12314743decorates
decrease1136573decrease
dedicate12312803dedicate
defalcate1544923defalcate
defeat103817163defe_at_
defeated132812163defe_ated
defeater122611663defe_ater
defeats113511233defe_ats
defecated1637493defecated
defecates1538593defecates
deflagrate15143403deflagrate
deflate113613943de_flate
degenerate1246833degenerate
degrade10229903de_grade
degrease1045413degrease
dehydrate1744863dehydrate
delate73827753d__elate
deleave1147723dele_ave
delectate1248743delectate
delegated1238373delegated
delegatee1148813delegatee
delegates1139843delegates
delete73620703dele__te
deliberate1347123deliberate
delicate11315493delicate
demarcate1446613demarcate
demerara1144853demerara
demerge11168023demer_ge
demerit10314993demerit_
demerited1339073demerited
demerits11310763demerits
dendrite1048783dendrite
denervated1545113denervated
denervates1445933denervates
denigrate1168693denigrate
denitrate10810533denitrate
dentate8315153de_ntate
denudate1046163denudate
depauperate1652063depauperate
depilate11311703depilate
deprave1337073de_prave
deprecate1477433deprecate
depredate1345733depredate
depurated1338183depurated
depurates1239823depurates
derat65044083d__erat_
derated93623503d__erated
derates84028893d__erates
derats74625063d__erats
derivate12311203derivate
derogate10311353derogate
desecrated1447953desecrated
desecrater1346983desecrater
desecrates1348843desecrates
desert72725493deser_t_
deserted101012203deser_ted
deserter91211603deser_ter
deserts82513053deser_ts
deserve11108703deser_ve
desiderate1246273desiderate
desolate9411993desolate
detente83313603dete_nte
deterge9118463deter_ge
detonate9311193detonate
deuterated1247533deuterated
deuterates1149083deuterates
devaluate13226363devaluate
devastate1344953devastate
deviate11312713de_viate
digerati1047403digerati
disrate81418523d_israte
dolabrate1244493dolabrate
dolerite9611773dolerite
elevate101110373_elevate
emeerate10410103emeerate
emirate91015833_emirate
enervate1148463_enervate
execrate1739653_execrate
federated1438423federated
federates13310153federates
ferrate103014043fe_rrate
generated11310203generated
generates10312713generates
glabrate1146043glabrate
headgate1346483headgate
headrace1446673headrace
hebetate1347053hebetate
hetaerae1145543hetaera_e
iterate71119113_iterate
karate105320923_ka_rate
lacerate102214713lacerate
leachate1347443leachate
leverage1285393leverage
levirate1147623levirate
liberate101113383liberate
literate81216893literate
macerate122314073macerate
meterage1147933meterage
moderate11710993moderate
narrate7313493_narrate
numerate101610393numerate
operate9615733_operate
overate10620963_overate
peerage1089803pe_erage
penetrate1149233penetrate
perorate10417923perorate
quadrate1888043quadrate
recrate92621663re_crate
recreate10313603recreate
regelate9312083regelate
regrate82618663re_grate
reiterate9412933reiterate
relegate9311243relegate
reoperate11410183reoperate
seatmate1048573seatmate
selenate81712533selenate
separate10310783separate
serenate81914883serenate
serrate73017543se_rrate
sewerage1245513sewerage
stearate839723stea_rate
teammate1245613teammate
temperate1348513temperate
tolerate8312323tolerate
ulcerate1039733ulcerate
underate9918603underate
valerate11311473valerate
vegetate1246673vegetate
venenate1147933venenate
venerated1339953venerated
venerates12312263venerates

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.406440125.6
2DLD Change Limit1461621766.67021913.3
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.15624970.8
 
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.