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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
derate7453123(None) 
aerate64830551aerate
berate84729021berate
cerate84829461cerate
debate94419191debate
delate73827751delate
derat65044081derat_
derated93623501derated
derates84028881derates
derats74625061derats
acerate92818912acerate
aerated85322372aerated
aerates74627482aerates
aurate64426472aurate
berake124216082berake
berated104422132berated
berates94126852berates
borate85026152borate
carate84734002carate
cerated103922472cerated
cerates95428232cerates
cerite84724872cerite
crate76537402_crate
create85126372create
curate85226242curate
date56443322d__ate
deaerate9314162deaerate
dealate83617842dealate
dearie73319812dearie
dearth104212512dearth
death94822522de_ath
deave95022332de_ave
debase94014472debase
debated113916082debated
debater104114692debater
debates103718522debates
decade104216162decade
decane93818872decane
decare93919152decare
decorate11315192decorate
deface123113862deface
defame123212432defame
defat95426692defat_
defats105114552defats
deflate113613942deflate
degage92711382degage
degame102713182degame
degrade10229902degrade
dekare112811562dekare
delated93722872delated
delates83526282delates
delete73620702delete
demote94817802demote
denote74118042denote
dentate8315152dentate
deprave1337072deprave
depurate1139982depurate
depute94512302depute
derail74218812derail
derange939812derange
deratted1048402deratted
deray95024182dera_y
derays105514252derays
dere56845902der__e
deride84420032deride
derivate12311202derivate
derive103817042derive
derogate10311352derogate
deviate11312712deviate
devote104513782devote
dewater112912422dewater
dilate73220692dilate
disrate81418522disrate
donate73619502donate
drake104918302d_rake
drape85319632d_rape
drat56247832d_rat_
drats66628372d_rats
drave95219272d_rave
elate55335882_elate
enate54428142_enate
erase54925492_erase
ergate7315142_ergate
federate12310872federate
fermate122813002fermate
ferrate103014032ferrate
gelate73421252gelate
grate64932882_grate
gyrate104912522gyrate
ideate7313682ide_ate
irate55627982_irate
iterate71119102iterate
karate105320922karate
legate72917452legate
lyrate94112102lyrate
metate82720532metate
moderate11710992moderate
negate72915572negate
nervate1039522nervate
operate9615732operate
orate55133302_orate
overate10620962overate
pedate93117762pedate
pirate82322882pirate
prate75135982_prate
rate45458762__rate
rebate84424102rebate
recrate92621642recrate
redate74124682redate
regrate82618652regrate
relate64033632relate
remate84428682remate
sedate73019802sedate
senate63725142senate
serape84818412serape
seriate73722472seriate
serrate73017532serrate
terete6319332terete
ternate7415482ternate
underate9918602underate
uprate83916542uprate
urate55432162_urate
velate93720142velate
verite94323442verite
verste94515632verste

Search took 5 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 Filter178691825510.1101624463.6
2DLD Change Limit825511254.65617730.0
3Display Results1251250.0931344.1
 (SQL Overall)1786911254.85936775.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.