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

166 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
stylist10211028(None) 
stylise10208951stylise
stylish13197441stylish
stylists11207021stylists
idylist1146652idylist
skylit1338282skyli_t
stalest73720172stalest
statist7317722statist
styles94418652styles_
stylet94018572styl_et
stylets10369212stylets
styli83911172styli__
styling112910652styling
stylised12215892stylised
styliser11185522styliser
stylises11188942stylises
stylistic14116092stylistic
stylite10219612stylite
stylize19177452stylize
stylus9397462stylus_
sylis84316022s_ylis_
typist1139822_typist
alist56136783__alist
atavist10311093atavist
atheist10314063atheist
atomist92915763atomist
biblist11310833biblist
cellist9314423cellist
chymist17268173chymist
cyclist1438853cyclist
daylit10512493dayli_t
delist74625053_delist
dialist8517763dialist
dualist8614053dualist
duelist8511413duelist
enlist6417043_enlist
etatist7415033etatist
fatalist11314973fatalist
holist94723213_holist
idylists1244123idylists
idyllist1243963idyllist
list47055343___list
loyalist111511133loyalist
lyrist9312293_lyrist
metalist10519353metalist
midlist10312513midlist
oculist9310883oculist
oralist7619633oralist
pastelist1149623pastelist
playlist1347573playlist
pollist9816603pollist
ptyalism15115793ptyalism
realist73225383realist
relist64628413_relist
royalist111311983royalist
sacrist9315423sacrist
sadist74221353s_adist
satanist8313363satanist
satirist8313503satirist
sayest94217743say_est
sayst85322003say__st
scaliest101714393scaliest
schist11312653s_chist
sciolist10410233sciolist
sealift10312793sealift
sexist133013483s_exist
shaliest111415053shaliest
shist84829613s__hist
shitlist1148723shitlist
shyest125511833shy_est
silliest84017103silliest
simplist12249683simplist
sitarist8315283sitarist
skylight1943993skylight
skylike1336103skylike
skyline1436793skyline
sliest66621953s__liest
slipt76627483s__lipt
slit46250103s__li_t
slits56128853s__lits
slyest93811363sly_est
sodalist9311883sodalist
soloist7915893soloist
sophist12311563sophist
splint85223283s_plint
split75729013s_pli_t
splits85416413s_plits
stablest103312943stablest
stablish1348343stablish
stagiest91613403stagiest
stales65538293stales_
staling83925423staling
stalkiest1347903stalkiest
stalks104614553stalks_
stalls64019933stalls_
starlit71512913starli_t
stasis63116873stasis_
statism9412283statism
statists8310163statists
steeliest939643steeliest
steles63725663steles_
stelic8313083steli_c
stiles64328773stiles_
stillest8311073stillest
stilliest939223stilliest
stills64118573stills_
stilt54831983st__ilt
stilts67915313stilts_
stint57037663st__int
stockist14197713stockist
stoles63927673stoles_
stolid74213183stoli_d
stolidest1046113stolidest
stoniest8413543stoniest
stonish10410653stonish
strait64025893strai_t
straits74916323straits
strict84821043st_rict
stript85222193st_ript
studliest1036573studliest
stulls63912983stulls_
styes86316523sty_es_
stygian1144083stygian
stying105414573sty_ing
stylar9358113styl_ar
stylate10179773stylate
style85519363styl__e
styled105613103styl_ed
styler94013303styl_er
stylers10359353stylers
stylings12276233stylings
stylisers12204243stylisers
stylishly1843513stylishly
stylising1345593stylising
stylistics15113573stylistics
stylites11168693stylites
stylitic1356343stylitic
stylitism1443743stylitism
stylized21175873stylized
stylizer20185443stylizer
stylizes20207113stylizes
styloid1137553styloid
styluses11204773styluses
stymie1137623stymi_e
stymied1335663stymied
stymies1239213stymies
stypsis1245243stypsis
subsist9311573subsist
sumoist9311613sumoist
sunlit61516103sunli_t
surliest82416913surliest
syli74318983s_yli__
tanist6324593_tanist
theist9314763_theist
titlist7312923titlist
totalist8315583totalist
tsarist7712253tsarist
tubist83013163_tubist
twist86820983_t_wist
typiest1238203_typiest
typists1236173_typists
unstylish1582593unstylish
utilise749063utilise
utopist938693utopist
violist10312143violist
vitalist11313393vitalist

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271666.06322105.7
3Display Results1661660.0602766.7
 (SQL Overall)1786911666.52927368.8
 
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.