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 “crenulate” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
crenulate116769(None) 
crenelate1176511crenelate
crenulated1356041crenulated
cannulate1148632cannulate
canulate10314552c_anulate
crenate93317112cren__ate
crenelated1375362crenelated
crenelates1266192crenelates
granulate1059182granulate
regulate9313022_regulate
annulate8310923_annulate
areolate81014453are_olate
calculate1389873calculate
cannulae1046493cannula_e
cannulated1346503cannulated
cannulates1247783cannulates
canulae9311183c_anula_e
canulated12310673c_anulated
canulates11312873c_anulates
capsulate1347563capsulate
chelate122914893che__late
cingulate12238603cingulate
circulate13810433circulate
coagulate1258083coagulate
coequate1946153coequ_ate
conflate13311173c_onflate
consulate11612233consulate
copulate122614113c_opulate
corelate10516013core__late
craniate10312563cran_iate
create85126383cre___ate
credulity15123833credulity
cremate113816183cre__mate
crenated113013913cren__ated
crenellated1452523crenellated
crenelle1046333crenel_le
crenulation1347573crenulation
crepitate1385953crepitate
crewmate15405633cre_wmate
cumulate123110223c_umulate
cupulate122810033c_upulate
cyanurate1443993cyanurate
denudate1046163_denudate
deregulate12135193deregulate
emulate9314123__emulate
frenula1045623frenula__
frenular1144633frenula_r
granulated1256943granulated
granulates1148463granulates
granulite1046923granulite
gratulate1047683gratulate
lunulate838253_lunulate
peculate122414663_peculate
phenolate1447473phenolate
pinnulate1145763pinnulate
planulate1146903planulate
prelate9519693pre__late
reflate103516263_re_flate
regelate9312083_regelate
regulated11310463_regulated
regulates101211723_regulates
reinflate12157403_reinflate
relate64033633_re__late
renovate1138553_renovate
replate93420053_re_plate
reregulate11145953reregulate
reslate73520593_re_slate
rosulate8310903_rosulate
serrulate946983serrulate
speculate13239183speculate
translate9412273translate
tribulate1148083tribulate

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.420425454.8
2DLD Change Limit148641727.16020759.9
3Display Results72720.0302400.0
 (SQL Overall)178691727.61023481.1
 
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.