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

125 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
encyst113620(None) 
encysts1244311encysts
cyst96322812__cyst
encase83714362encase
encash11276942encash
encrust947872encrust
encrypt1445322encrypt
encysted1444292encysted
enlist6417042enlist
incest82918742incest
oocyst1136132oocyst
uncast84215712uncast
accost101112263accost
analyst10189323analyst
anenst63514983anenst
angst6415493an_gst
bendys12518383bendys_
cast67159903__cast
cist67244963__cist
cost68057943__cost
cysts105912773__cysts
densest83112473densest
dentist8316743dentist
dicast9315573dicast
east46659103e__ast
echt95722903e_c_ht
eclat7523603e_clat
ecus65421463e_cus_
egest65222343e_gest
egoist7612283egoist
eldest72912683eldest
emmys12446023emmys_
enact73525363en_act
enacts84012973enacts_
encage93713503encage
encamp1235943encamp
encased103512313encased
encases93116053encases
enchant12313113enchant
enchase1239453enchase
encina8310443encina
enclasp1145843enclasp
enclose999993enclose
encode9310443encode
encore8314773encore
encrusts1045283encrusts
encrypts1542983encrypts
encysting1544613encysting
endash10297123endash
endmost1056763endmost
endocast1146683endocast
ends56528523en_ds_
engirt71112613engirt
englut738453englut
engs56121393en_gs_
enjoys1644603enjoys_
enlists749393enlists
enmesh1134893enmesh
enols54718403enols_
enows85115493enows_
enrapt8313013enrapt
enroot6615993enroot
ens37245923en__s_
entrust7410883entrust
entwist1048803entwist
envoys1255133envoys_
envy10411253envy__
enzym1964393enzy_m
enzyme2054343enzyme
enzyms2063433enzyms
erst47436433e__rst
escort84616483escort
escot75320083esc_ot
escots84211743escots
except1797653except
excess1546053excess
excise1538553excise
excuse1537423excuse
exist124618943e_xist
fences114617113fences_
henrys12366103henrys_
incant82418503incant
incase83615283incase
incent83320723incent
incept102712753incept
incests92711383incests
incise83515333incise
incrust949203incrust
incult82414773incult
incus73315053incus_
incuse83513573incuse
infest93315433infest
ingest73119003ingest
inmost8411363inmost
insist6314513insist
invest93014843invest
locust85312343locust
mayst106622673_mayst
nays75931593_nays_
necks115119333necks_
neist54628443_neist
nest45548733_n_est
newest9314213newest
nicest82315663nicest
oncet74626543onc_et
oocysts1243923oocysts
opencast1244863opencast
otocyst1244833otocyst
racist82822793racist
recast83422773recast
renest64529713ren_est
sayst85322003_sayst
tennist72813113tennist
tensest72713313tensest
tryst84716223_tryst
uncase83817433uncase
uncos74117033uncos_
uncus74014983uncus_
uncut73219173unc_ut
unjust1337873unjust
unrest62918853unrest
upcast102710093upcast
webcast1445553webcast
xenocryst2152023xenocryst
xyst144714073__xyst

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161256.18618221.1
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.35828104.9
 
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.