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

89 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
encysts124431(None) 
encyst1136201encyst_
cysts105912772__cysts
encases93116052encases
encrusts1045282encrusts
encrypts1542982encrypts
encysted1444302encysted
enlists749392enlists
incests92711382incests
oocysts1243922oocysts
accosts11107993accosts
analysts11167443analysts
angsts738863an_gsts
casts77237793__casts
cists76624533__cists
costs77231143__costs
cyst96322813__cyst_
dentists939263dentists
dicasts1078703dicasts
easts57530323e__asts
ecdyses1333413ecdyses
ecdysis1343223ecdysis
ecesis84611203e_cesis
eclats8313033e_clats
egests74411253e_gests
egoists887073egoists
enacts84012973en_acts
encages103313783encages
encamps1335423encamps
encase83714363encas_e
encased103512323encased
encash11276943encas_h
encashes13227673encashes
enchants1347833enchants
enchases13310273enchases
encinas938723encinas
enclasps1245133enclasps
encloses10911063encloses
encodes10310643encodes
encores9315213encores
encrust947873encrust_
encrypt1445323encrypt_
encysting1544613encysting
endocasts1244763endocasts
engluts834533engluts
enlist6417043enlist_
enosis63816423en_osis
enroots738713enroots
entases72816273entases
entasis73012573entasis
entrusts847113entrusts
entwists1156143entwists
enzymes2164413enzymes
enzyms2063433enzy_ms
escorts9418403escorts
escots84211743esc_ots
excepts1885203excepts
excess1546053exces_s
excises1638933excises
excuses1638903excuses
exists134710913e_xists
incants92012803incants
incases93615973incases
incents92414533incents
incepts11238293incepts
incest82918743incest_
incises93414893incises
incrusts1036253incrusts
incuses93514853incuses
infests10279793infests
ingests83210983ingests
insists739083insists
invests10319683invests
locusts9277933locusts
nests55728003_n_ests
oocyst1136133oocyst_
otocysts1343503otocysts
racists92613323racists
recasts93413533recasts
renests74014213ren_ests
tennists8297793tennists
trysts9448793_trysts
uncases93516553uncases
uncast84215713uncast_
unrests7229463unrests
upcasts11185643upcasts
webcasts1543313webcasts
xenocrysts2251593xenocrysts
xysts15558123__xysts

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 Filter1786911340270.406440125.6
2DLD Change Limit134027898.45315855.6
3Display Results89890.0302966.7
 (SQL Overall)178691898.88920102.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.