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

143 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
enchased143738(None) 
encased103512311enc_ased
enchase1239451enchase_
enchaser1346691enchaser
enchases13310271enchases
chased125019292__chased
encaged113211082enc_aged
encase83714362enc_ase_
encases93116052enc_ases
encashed14246472enc_ashed
enchained1545492enchained
enchanted1546552enchanted
enchasers1445092enchasers
enclasped1454212enclasped
enclaved1456342enclaved
enclosed1198252enclosed
enthused1245082enthused
incased103612392inc_ased
uncased104216952unc_ased
anchored1438593anchored
archaised1545483archaised
benched154713943bench__ed
cased86032413__c_ased
ceased94920783__ceased
chafed154813913__chafed
chared125423693__chared
chase105127123__chase_
chaser114918383__chaser
chases115128233__chases
chasmed154710173__chasmed
chassed134712133__chassed
chawed155214603__chawed
deceased1247713deceased
eased65430403e___ased
echard1249223e_cha_rd
eched116919223e_ch__ed
echoed125211153e_ch_oed
ectases92911673e_ctases
emphases1568353emphases
encage93713503enc_age_
encages103313783enc_ages
encamped1535023encamped
encash11276943enc_as_h
encashes13227673enc_ashes
enchain1248853encha_in
enchains1348523enchains
enchant12313103encha_nt
enchanter1446193enchanter
enchants1347823enchants
enchasing1567733enchasing
enclasp1145843enclas_p
enclasps1245133enclasps
enclave1257533enclave_
enclaves1357703enclaves
enclose999993enclose_
encloser10107183encloser
encloses10911053encloses
encoded1139033enc_oded
encored10412103enc_ored
encrusted12125003encrusted
encysted1444293encysted
endeared1038053endeared
endorsed1057193endorsed
enfaced13218913en_faced
enflamed1455723enflamed
enframed1466263enframed
engaged10379833en_gaged
engraved1335813engraved
enhaloed12125923en_haloed
enhanced1436623en_hanced
enlaced102410523en_laced
enolase7310193enolase_
enolases8411003enolases
enplaned1137473enplaned
enraged93511783en_raged
enslaved1245063enslaved
ensnared965293ensnared
entases72816273en_tases
enthuse1046963enthuse_
enthuses1138253enthuses
erased74816753e__rased
escaped12388853esc_aped
escheated1546273escheated
eschewed1743443eschewed
etched123613703etch__ed
euchred13106163euch_red
euclase938933euclase_
euclases1039223euclases
excessed1844943excessed
exchanged23113673exchanged
excised1736673exc_ised
excused1736293exc_used
exhaled1835283e_xhaled
incaged114010443inc_aged
incase83615283inc_ase_
incases93615973inc_ases
incensed11277953incensed
inched124514483inch__ed
incised102911583inc_ised
inclasped1463553inclasped
inclosed1197613inclosed
increased1245533increased
incused102911173inc_used
inhaled1169333in_haled
inphase1245383inphase_
necrosed1137213necrosed
phased124011973__phased
purchased1743593purchased
unbased103513483un_based
unbiased1147143unbiased
uncaged113314123unc_aged
uncaked143514353unc_aked
uncase83817433unc_ase_
uncases93516553unc_ases
uncashed14299763unc_ashed
uncasked15278453unc_asked
uncaused1138443uncaused
unchained1537273unchained
unchaired1536203unchaired
unchanged1636283unchanged
uncharged1636613uncharged
uncharred1536103uncharred
uncharted1538083uncharted
unchaste1346923unchaste
unchaster1445393unchaster
unchewed1735803unchewed
unchoked18257623unchoked
unchosen1356283unchosen
unclasped1465503unclasped
unclawed1457983unclawed
unclosed111010503unclosed
uncoated11314963uncoated
uncrated11416313uncrated
uncursed1148963uncursed
unerased9312773unerased
unleased9310713unleased
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unthawed1535583unthawed
wenched163910913wench__ed

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621438.01618233.8
3Display Results1431430.0463108.7
 (SQL Overall)1786911438.23221706.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.