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

247 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
wastries11121288(None) 
pastries101517421pastries
wasteries121115341wasteries
wastrie101210291wastrie_
gantries91413782gantries
gastrins9310122gastrins
masteries111018492masteries
nasties73520492nast_ies
pantries101817392pantries
pasties94529812past_ies
vestries11314042vestries
wastages12109752wastages
wasterie111211582wasterie_
wastes96224882wast__es
wastrel1037552wastr_el
wastrels1136202wastrels
aeries64737783_a_eries
ambries111614543_ambries
antres65021003_antr_es
aperies9423203_aperies
arteries8321463_arteries
ascribes1246193_ascribes
aspires9612043_aspires
asterias8317003_asterias
astonies8815093_astonies
astrals75515243_astrals
astrict9614783_astrict
astricts1049453_astricts
astride8311973_astride
astringes1038333_astringes
attires72312953_attires
attrites8311563_attrites
attrits7310613_attrits
bakeries14312193bakeries
banties94324763bant_ies
basifies13310493basifies
basketries1645043basketries
bastardies1365133bastardies
bastes85330383bast__es
bastiles10313353bastiles
batteries11615113batteries
bawdries14136843bawdries
bawties124214313bawt_ies
beasties102514653beast_ies
bestrides1237913bestrides
bistres94017213bistr_es
blasties102113623blast_ies
calories102919543calories
canaries10318943canaries
cantrips12318923cantrips
caries85147623ca__ries
carries94328013ca_rries
casefies1339213casefies
casernes103810753casernes
castes85631863cast__es
castles94917733cast_les
castrates11312663castrates
catteries11815513catteries
catties94023053ca_tties
causeries11510633causeries
cauteries11615363cauteries
chantries14310273chantries
dairies84217733da_iries
dassies84418663das_sies
dataries9314033dataries
daubries1136743daubries
dauties83315763daut_ies
dawties113312703dawt_ies
descries11311923descries
destrier9311823destrier
destriers1038143destriers
easies64126633eas__ies
easterlies1046713easterlies
eateries8324303eateries
entries71523163_entries
estrins7315853_estrins
factories14810093factories
faeries104118993fa_eries
fairies103516043fa_iries
fakeries1559833fakeries
fatties103018203fa_tties
gasifies1238693gasifies
gastraea954383gastraea
gastraeas1063573gastraeas
gastrea847223gastr_ea
gastreas957243gastreas
gastric1038623gastri_c
gastrin839823gastri_n
gastritis1045673gastritis
gauntries1046033gauntries
gentries91315263gentries
harries103525493ha_rries
hastes95727073hast__es
hastier103916623hast_ier
hastiest112916493hast_iest
histories12412473histories
japeries17311463japeries
kauries113613193ka_uries
laetriles944663laetriles
laities7320343lait_ies
lassies74420103las_sies
latrias71913213la_trias
latrines8515003la_trines
lustres73013233lustr_es
marries93825283ma_rries
martyries1446563martyries
mashies12318253mas_hies
masonries1146853masonries
mastics112614783mast_ics
mastixes1738253mastixes
mastoids1177873mastoids
matres84522233ma_tr_es
matrices12312083ma_trices
matrixes1738063ma_trixes
miseries10320403miseries
mysteries141211193mysteries
naperies10313903naperies
nastier74115293nast_ier
nastiest83615953nast_iest
nostrils848163nostrils
oestrins8312673oestrins
paltrier1037523paltrier
paltriest1138603paltriest
panfries13149203panfries
panties94230933pant_ies
papistries1445193papistries
paries84742513pa__ries
parries93925843pa_rries
parties93230863part_ies
pastes85233913past__es
pastie85525523past_ie_
pastier94320383past_ier
pastiest103319543past_iest
pastils94416173past_ils
pastimes123611903pastimes
pastis84924323past_i_s
pastises103616053pastises
pastures10311963pastures
patsies93919483pa_tsies
patties93425143pa_tties
peltries10313023peltries
piastres10249303piastr_es
poetries10315583poetries
posties93128813post_ies
psaltries1185743psaltries
rasures7312013rasur_es
restrikes1339413restrikes
restrives12310663restrives
retries74129073_retries
rosaries8312783rosaries
roseries8317313roseries
salaries8319573salaries
salties73725773salt_ies
saltires83112423saltires
sassies74719263sas_sies
satires72617573sa_tires
sauries72821623sa_uries
savories11311273savories
scries85226823__scries
sentries81318053sentries
series64540973__series
sties55132983__st_ies
stories7324273__stories
strides84520393__strides
strifes104716583__strifes
strikes114719093__strikes
stripes95320573__stripes
strips85719653__strips
strives104119373__strives
tanistries1047053tanistries
tapestries1245403tapestries
tarries73324263ta_rries
tassies74918933tas_sies
tastes64126423tast__es
tastier711817093tast_ier
tastiest83216633tast_iest
tatties74120343ta_tties
tawdries12136083tawdries
tries55742813___tries
usuries7510633_usuries
vagaries12310293vagaries
varies94330873va__ries
vastier103613203vast_ier
vastiest112713073vast_iest
vastities1248933vastities
waddies124214753wa_ddies
wadies105121203wa__dies
waffies163611443wa_ffies
waftages15105393waftages
waftures1434853waftures
waggeries14127463waggeries
wagtails1244443wagtails
waistlines1343893waistlines
waitress1135223waitress
waitrons1136633waitrons
walies95324523wa__lies
walkyries1942673walkyries
wallies103320743wa_llies
waltzes1935953walt_zes
wantages12109023wantages
wares88250583wa__r_es
warier93722893wa__rier
wariest105122503wa__riest
warstles11368803warst_les
wartier103413913wart_ier
wartiest113614643wart_iest
wartimes1336963wartimes
wasabis1255363wasabi_s
washes124425493was__hes
washier133611153was_hier
washiest14310403was_hiest
washrags1543893washrags
waspier12259053was_pier
waspiest1338813was_piest
wassails1145953wassails
wastage11109253wastage_
waste86125053wast__e_
wasted104423023wast__ed
waster95228943wast__er
wasters104026593wast_ers
wasting114422843wast_ing
wastry12388773wastr__y
wasts87433673wast___s
watapes12228383wa_tapes
watches153017373wa_tches
waterier11312083waterier
wateriest12312233wateriest
wattages12106783wattages
wattapes1395253wattapes
wattles103814073wa_ttles
wavies125019843wa__vies
wearies103020223w_earies
westerlies1345603westerlies
wherries14179023wherries
whirries14136693whirries
whities133113253whit_ies
wineries112316533wineries
wintrier1136873wintrier
wintriest1238153wintriest
wistarias1246783wistarias
wisterias1248083wisterias
withies133913543w_ithies
worries104117133w_orries
worthies14310283worthies
wrastles11328933wrast_les
wries85827743w___ries
wussies103411083wus_sies

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.1731032896.0
2DLD Change Limit1461622477.64019131.2
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.90622601.9
 
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.