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

186 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
stylites1116869(None) 
stylises11188941stylises
stylite10219611stylite_
stylizes20207111stylizes
skylines1535702skylines
stellites938112stellites
stilbites1144832stilbites
stipites1039652stipites
stylate10179772stylate_
styles94418652styl__es
stylets10369212stylet_s
stylings12276232stylings
stylise10208952stylise_
stylised12215892stylised
styliser11185522styliser
stylisers12204242stylisers
stylists11207022stylists
stylitic1356342stylitic
stylitism1443742stylitism
stylize19177452stylize_
stylized21175872stylized
stylizer20185442stylizer
stylizers21194332stylizers
stylolites1343652stylolites
styluses11204772styluses
stymies1239212stymi_es
sylvites14225842s_ylvites
acylates1339743acylates
aplites9314933_aplites
athletes1157883athletes
attrites8311563attrites
blites84721213__blites
butylates1444713butylates
bylines1239243_bylines
cryolites1446953cryolites
cylices14359283_cylices
doylies114512573doyli_es
egalites9310503egalites
elites66027123__elites
ethylates1545933ethylates
fayalites1546063fayalites
flites95122443__flites
guylines12236943guylines
halites103221193_halites
haplites1339993haplites
hoplites13310543hoplites
hyalites14208833hyalites
illites72415013_illites
iolites73819483_iolites
kryolites1643993kryolites
kylikes1333583_kylikes
marlites103415263marlites
mullites10411643mullites
oolites72817843_oolites
otoliths11104513otoliths
pelites93821993_pelites
penlites10312273penlites
perlites10316353perlites
phyllites1745323phyllites
pyrites12812203_pyrites
rhyolites1545033rhyolites
salines74029413s_alines
sallies73227813salli_es
salties73725773s_alties
salutes73716253s_alutes
samites93118713s_amites
satellites1045423satellites
scolices1238733scolices
setlines8312743setlines
shelties111111373shelties
sienites8311913sienites
sillies73425083silli_es
sites56045433s___ites
skites104418033s__kites
skydives1952133skydives
skylike1336103skylike_
skyline1436793skyline_
skylit1338273skylit__
skywrites1952763skywrites
slates64934063s__lates
slices84022853s__lices
slides73922183s__lides
slimes84722043s__limes
slipes84921413s__lipes
slits56128853s__lit_s
smaltites1145743smaltites
smites83921923s__mites
sodalites10128693sodalites
solates73523853s_olates
solutes73515263s_olutes
somites94219123s_omites
sopites93817173s_opites
sorites73825243s_orites
spites84127333s__pites
splices113914383s_plices
splines94718893s_plines
splits85416413s_plit_s
spoliates1138543spoliates
sprites94220333s_prites
stabiles10311403stabiles
stactes91914633st_actes
staithes1138953st_aithes
stales65538293stal__es
stanines85115673stanines
stannites947013stannites
states64337083st__ates
statices102712343statices
statives112710793statives
statutes8368893statutes
steatites939843steatites
steelies8312553steeli_es
steles63725663stel__es
stellite839533stellite_
sternites9310073sternites
stibines1038153stibines
stibnites1144043stibnites
sties55132983st__i_es
stilbite1045423stilbite_
stiles64328773st__iles
stilted83511473stil_ted
stilts67915313stil_t_s
stimes85920573st__imes
stimies9316563stimi_es
stipes84524053st__ipes
stogies8413693stogi_es
stoles63927673stol__es
stolider936603stolider
stolidest1046113stolidest
stomates10313343stomates
stoolies8311083stooli_es
stories7324273stori_es
straiten838613straiten
straitens946233straitens
straiter8311783straiter
straitest949173straitest
straits74916323strait_s
striates83417083striates
strides84520393st_rides
strifes104716583st_rifes
strikes114719093st_rikes
stripes95320573st_ripes
strives104119373st_rives
studies82413863studi_es
styes86316523sty___es
style85519363styl__e_
styled105613103styl__ed
styleless1243413styleless
styler94013303styl__er
stylers10359353styl_ers
stylet94018573styl__et
styli83911173styli___
styling112910653styli_ng
stylish13197443styli_sh
stylist102110283styli_st
stylistic14116093stylistic
stylistics15113573stylistics
stylitisms1553183stylitisms
stylobates1542653stylobates
stylolite1244383stylolite_
stylus9397463styl__us
stymie1137623stymi_e_
stymied1335663stymi_ed
stypsises1443423stypsises
styptics1543813styptics
styraxes1833493styraxes
styrenes11116623styrenes
sublates10315003sublates
sublimes12310033sublimes
sublines10315783sublines
subsites10312783subsites
suites63727403s__uites
sulfites1139903sulfites
sullies74122223sulli_es
syenites1138943syenites
sylis84316023s_yli__s
sylvines14215903s_ylvines
sylvite13266353s_ylvite_
talipes9611603_talipes
taxites1449673_taxites
tillites8312833tillites
uralites82112723uralites
utilises848973utilises
utilities9610803utilities
utilizes1758123utilizes
velites103417303_velites
zeolites1738383zeolites

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 Filter1786911461620.186960704.3
2DLD Change Limit1461621868.22017781.3
3Display Results1861860.0762447.4
 (SQL Overall)1786911868.48221067.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.