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

102 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
decrease113657(None) 
decease1049521dec_ease
decreased1345461decreased
decreases1237231decreases
degrease1045411degrease
crease85519572__crease
deceased1247722dec_eased
deceases11410152dec_eases
decree93117782decre__e
decrees102513122decrees_
degreased1244722degreased
degreaser1144332degreaser
degreases1146152degreases
increase1066452increase
precrease1345232precrease
recreate10313602recreate
acreage1037843_acreage
berceuse1243433berceuse
bereave1258353be_reave
cease75227653__c_ease
cocreate122611813cocreate
creased104315593__creased
creaser94415743__creaser
creases94020963__creases
creasy114612303__creasy
create85126383__create
creese84014333__creese
deaerate9314173deaerate
dearest83618673deare_st
debase94014473de__base
debruise1143913debruise
decade104216163dec__ade
decane93818873dec__ane
decare93919153dec__are
decares102818533decare_s_
deceive1337813dec_eive
decerns10119053decerns_
deciare10710663dec_iare
decimate13411123decimate
deckels14367363deckels_
deckers144413833deckers_
declare10411233dec_lare
declass1038733dec_lass
declasse1165943declasse
decorate11315193decorate
decreasing1446523decreasing
decreed112710263decre_ed
decreer10269123decre_er
decreers11277623decreers
decrepit1345883decrepit
decretal1146353decretal
decretals1245093decretals
decretive1547493decretive
decrial10310323decria_l
decrials1137133decrials
decriers11299733decriers_
decries103319813decries_
defense1137503de_fense
defleas1147223defleas_
degrade10229903degr_ade
degreasers1243143degreasers
degree82814853degre__e
degrees92810723degrees_
deleave1147723de_leave
deprave1337073depr_ave
deprecate1477433deprecate
depredate1345733depredate
depress10239873depre_ss
depressed1357633depressed
depresses1259883depresses
derate74531233de_r_ate
dermas94116813de_rmas_
disease83213843d_isease
erase54925493_e_r_ase
gearcase1154453gearcase
grease75416233__grease
idocrase1183603idocr_ase
increased1245543increased
increaser1154573increaser
increases1157383increases
increate10312203increate
necrose939733necr_ose
nuclease1046213nuclease
ocreae83310273_ocrea_e
ocreate93711743_ocreate
pectase112410363pec_tase
permease1246503permease
precreased1544423precreased
precreases1445653precreases
recrate92621663recr_ate
recreance1346993recreance
recreant10311283recreant
recreated12412543recreated
recreates11313363recreates
release7312763re_lease
secrete9311073secre_te
secretes10410473secretes
secrets9311773secrets_
sucrase9310343sucr_ase
surcease1086883surcease
uncreate10311353uncreate
urease64516993__urease

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.423422437.4
2DLD Change Limit1461621027.40619735.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.87522690.9
 
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.