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

127 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
decimates1441069(None) 
decimate13411121decimate_
decimated1548951decimated
deciares11510632deci_ares
decimals1345862decima_ls
decimator1447732decimator
decimators1547502decimators
decimeter14147412decimeter
decimeters15156682decimeters
decimetres15135042decimetres
decorates12314742decorates
dedicates13311692dedicates
delicates12314312delicates
depilates12310922depilates
derivates13310092derivates
deviates12312732devi_ates
acclimates1645913acclimates
animates101316423_animates
bedmates1349183be_dmates
celibates1358633celibates
cellmates1347513cellmates
checkmates2343383checkmates
climates12311973_climates
comates114123643__comates
dacites101114593daci__tes
deactivates1744393deactivates
deaerates10313643deaerates
dealates92716683de_alates
deaminates1349383deaminates
debates103718533de__bates
decades113615513dec__ades
decameter14137363decameter
decameters15156593decameters
decanes103118913dec__anes
decapitates1655643decapitates
decares102818533dec__ares
deceases11410153dec_eases
deciare10710663deci_are_
decides114217653deci__des
deciduate1345063deciduate_
deciles104417723deci__les
deciliter1247033deciliter
deciliters1345173deciliters
decilitres1344993decilitres
decimal1238083decima__l
decimalizes2546293decimalizes
decimally1745613decimally
decimating1648753decimating
decimation15411623decimation
decimations16410163decimations
decimetre14125303decimetre
declares11611313dec_lares
decollates13137153decollates
decorate11315193decorate_
decorated13312203decorated
decreases1237223decreases
decussates1343243decussates
dedicate12312803dedicate_
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicatees1445313dedicatees
defecates1538593defecates
defilades14134073defilades
deflates123013943de_flates
delates83526283de__lates
delegates1139843delegates
delicate11315493delicate_
delimes10314193delim__es
delimited1346593delimited
delimiter1246243delimiter
delimiters1345103delimiters
delimits1137573delimit_s
delineates1147123delineates
demotes104717673de__motes
denigrates1298113denigrates
denitrates1169513denitrates
denudates1145583denudates
depilate11311703depilate_
depilated1339653depilated
depurates1239823depurates
deracinates1445863deracinates
derates84028893de__rates
derivate12311203derivate_
derogates11310973derogates
desiccates1545383desiccates
designates1246363designates
desolates10311793desolates
despumates1543543despumates
detonates10310433detonates
deviate11312713devi_ate_
deviated13311043devi_ated
dictates11311383dic_tates
dilates83220663d__ilates
dominates12311743dominates
emirates101214853_emirates
epilates10313503_epilates
estimates11911363estimates
geminates12310033geminates
gemmates13307673ge_mmates
helpmates1645513helpmates
hesitates1269793hesitates
intimates111013313intimates
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
messmates1346233messmates
pectates122213953pec_tates
peculates132112543peculates
primates121515933_primates
racemates1348853racemates
reanimates1247853reanimates
recites93524583reci__tes
recrates102420373rec_rates
recreates11313363recreates
reimages1138373re_images
remates93827113re__mates
resinates9314763resinates
seatmates1157823seatmates
seriates82620673seri_ates
speciates13229233speci_ates
teammates1345673teammates
ultimates1148433ultimates
veritates12310973veritates
vesicates14119033vesicates

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.440406115.9
2DLD Change Limit1486411276.98321286.1
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.48623870.0
 
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.