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 “encrusts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
encrusts104528(None) 
encrust947871encrust_
entrusts847111entrusts
incrusts1036251incrusts
becrusts1244842becrusts
crusts84916542__crusts
encrusted12125002encrusted
encrypts1542982encrypts
encysts1244312enc_ysts
entrust7410882entrust_
incrust949202incrust_
intrusts837722intrusts
anacruses1145523anacruses
anacrusis1143893anacrusis
anchusas1344763anchusas
ancress978613ancres_s
antirusts948143antirusts
becrust1137983becrust_
centrists11410233centrists
crests85218703__crests
cruets85314953__cruets
cruses88127713__cruses
crusets93811043__crusets
crust75827663__crust_
crusty114911343__crusty
ecrus75113863e_cru__s
encases93116053enc_ases
encaustic1343393encaustic
encaustics1452373encaustics
enchants1347833enchants
enchases13310273enchases
enclasps1245133enclasps
encloses10911053encloses
encrusting13125293encrusting
encrypt1445323encrypt_
encyst1136203enc_yst_
engluts834533englu_ts
engrafts1294703engrafts
engross837123engros_s
enlists749393en_lists
enroots738713en_roots
enthuses1138253enthuses
entrants8311753entrants
entreats839773entreats
entrusted1065943entrusted
entwists1156143entwists
enureses838113enureses
enuresis845493enuresis
eructs83610793e__ructs
erupts8348903e__rupts
estruses838483estruses
excursus1742593excursus
excuses1638903exc_uses
exhausts1842963exhausts
inbursts1044323inbursts
incests92711383inc_ests
incross937663incros_s
incrusted12125843incrusted
incuses93514853inc_uses
intrust7311493intrust_
locusts9277933loc_usts
necroses10310563necroses
necrosis1048883necrosis
piecrusts1342603piecrusts
recruits1036563recruits
rusts55026993___rusts
sacrists1039563sacrists
tenorists948193tenorists
thrusts10226523_thrusts
trusts64714433__trusts
uncross938193uncros_s
unitrusts943323unitrusts
unrests7229463un_rests
untruss736553untrus_s
untrusty1144223untrusty
xenocrysts2251593xenocrysts

Search took 7 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 Limit146162766.42022766.7
3Display Results76760.0332303.0
 (SQL Overall)178691766.85926052.0
 
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.