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

123 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
enframed146626(None) 
enflamed1455721enflamed
enframe1247361enframe_
enframes1357451enframes
unframed1478241unframed
enfaced13218912enf_aced
enflame1236572enflame_
enflames1357042enflames
engraved1335812engraved
enraged93511782en_raged
framed125116522__framed
inflamed1446032inflamed
infrared1236192infrared
reframed1437852reframed
affrayed1842843affrayed
bedframe1643023bedframe_
bedframes1743013bedframes
benamed122911093ben__amed
defamed14309833def_amed
defoamed15356243defoamed
defrayed1635403defrayed
effaced16225573e_ffaced
embraced15106673embraced
enamel81210113en__amel
encaged113211083en_caged
encamped1535023en_camped
encased103512313en_cased
enchased1437383enchased
enclaved1456343enclaved
endeared1038053endeared
endgame1145233endgame_
endgames1245423endgames
enervated1347313enervated
enface112510353enf_ace_
enfaces122110913enf_aces
enfiladed1442993enfiladed
enfolded1345433enfolded
enforced14216743enforced
enframing1546113enframing
engaged10379833en_gaged
engrafted1443733engrafted
engrailed1144323engrailed
engrained1145493engrained
engram9310653engram__
engramme1344053engramme
engrammes1444513engrammes
engrams1038073engram_s
engrave1137133engrave_
engraver1245333engraver
engraves1237233engraves
enjambed2042823en_jambed
enlaced102410523en_laced
enlarged1035413enlarged
enplaned1137483enplaned
enrage72715073en_rage_
enrages83114853en_rages
enrobed10279253en_robed
enslaved1245063enslaved
ensnared965293ensnared
entrained1089413entrained
entranced1247393entranced
entrapped1484873entrapped
entreated10310973entreated
enured73315333enur__ed
enwrapped1742793enwrapped
erased74816753e__rased
estrayed1236393estrayed
famed115928343__f_amed
farmed125117653__farmed
flamed124618973__flamed
foamed126014403__foamed
frame105821803__frame_
framer114817443__framer
frames115119863__frames
frayed135012163__frayed
generated11310203generated
inarmed10268673inar_med
infirmed14205343infirmed
inflame1256963inflame_
inflamer1356123inflamer
inflames1377323inflames
inflated12410863inflated
informed14197673informed
infracted1546363infracted
infrareds1342583infrareds
misframed1745623misframed
named85223063_n__amed
normed95014543_nor_med
reframe1239393reframe_
reframes1338993reframes
reinflamed16133423reinflamed
renamed103114523ren__amed
unarmed101811923unar_med
unblamed1337193unblamed
unbraced132310433unbraced
unbraked15289413unbraked
uncrated11416313uncrated
undraped1239393undraped
undreamed1336973undreamed
unerased9312773unerased
unfaded123111733unf_aded
unfaked153211173unf_aked
unfazed20299053unf_azed
unfeared121511013unfeared
unfilmed1495803unfilmed
unflawed1536123unflawed
unformed14239573unformed
unfreed11510123unfr_eed
ungraced12239143ungraced
ungraded11209923ungraded
unharmed1438093unharmed
unnamed102410273un_named
unprimed1337203unprimed
unraked122914013un_raked
unrated82621553un_rated
unrazed172511453un_razed
unrimed102211633un_rimed
unseamed111210663unseamed
unshamed14148053unshamed
untamed102913223un_tamed
untraced112413243untraced
unwarmed1437303unwarmed
venerated1339953venerated

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.406440125.6
2DLD Change Limit1461621237.28320068.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.73523101.6
 
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.