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

117 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
decreases123722(None) 
deceases11410151dec_eases
decrease1136561decrease_
decreased1345451decreased
degreases1146151degreases
creases94020962__creases
decease1049522dec_ease_
deceased1247712dec_eased
decrees102513122decre__es
degrease1045412degrease_
degreased1244712degreased
degreaser1144332degreaser
degreasers1243142degreasers
depresses1259882depresses
increases1157382increases
precreases1445652precreases
recreates11313352recreates
acreages1138363_acreages
ancresses1138413ancresses
berceuses1344103berceuses
bereaves1338273be_reaves
boreases10310253_boreases
ceases84427073__c_eases
cereuses1049243ce_reuses
cocreates132611883cocreates
crases85532313__cr_ases
crease85519573__crease_
creased104315583__creased
creaser94415723__creaser
creasers103612823__creasers
creates95225193__creates
creeses93914623__creeses
cresses94219813__cresses
deaerates10313633deaerates
dearnesses1139583dearnesses
debases103814133de__bases
debruises1243633debruises
decades113615513dec__ades
decanes103118913dec__anes
decares102818533dec__ares
deceives1437903dec_eives
deciares11510633dec_iares
decimates14410693decimates
declares11611313dec_lares
declass1038733dec_las_s
declasse1165943dec_lasse
declasses1246443declasses
decorates12314743decorates
decreasing1446513decreasing
decree93117783decre__e_
decreed112710253decre__ed
decreer10269123decre__er
decreers11277623decre_ers
decretals1245093decretals
decrials1137133decria_ls
decries103319803decr__ies
defenses1237913de_fenses
degases93413103de__gases
degrades11269923degr_ades
degrees92810723degre__es
deleaves1248063de_leaves
depraves1436873depr_aves
deprecates1547283deprecates
depredates1445493depredates
depress10239873depre_s_s
depressed1357623depressed
derates84028893de_r_ates
dermises112512023de_rmises
derrises93012783de_rrises
dickenses1645073dickenses
diereses938693diere_ses
digresses1137863digresses
diseases92415813d_iseases
diureses936453diure_ses
dresses83716173d__resses
duchesses1544133duchesses
duresses939173d_uresses
ectases92911673_ec_tases
egresses949443_egresses
erases64425403_e_r_ases
gearcases1254693gearcases
greases84816713__greases
heiresses1236963heiresses
idocrases1273793idocr_ases
increase1066453increase_
increased1245533increased
increaser1154573increaser
increasers1243313increasers
necroses10310563necr_oses
nucleases1146493nucleases
pancreases1443763pancreases
pectases122411193pec_tases
peeresses1138463peeresses
permeases1347103permeases
precrease1345233precrease_
precreased1544413precreased
recesses10312323rec_esses
recrates102420363recr_ates
recreances1446503recreances
recreants1146623recreants
recreate10313603recreate_
recreated12412533recreated
recrosses1138373recrosses
redresses10410293redresses
regresses10310463regresses
releases8313343re_leases
represses11412143represses
secrecies1346913secrecies
secretes10410473secre_tes
seeresses939053seeresses
sucrases10310253sucr_ases
surceases1157473surceases
teargases1044803teargases
terrases82111473te_rrases
uncreates11310433uncreates
ureases74416723__ureases
whereases1545673whereases

Search took 9 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.1701051123.5
2DLD Change Limit1486411177.95318689.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.16921874.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.