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

296 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
stylar935811(None) 
astylar10265061astylar
stelar64013861stelar
styler94013301styler
mylar105311532_mylar
phylar14437372phylar
scalar83612432scalar
skylark1343272skylark
solar55927342s_olar
stalag7310022stalag
staler64025822staler
star48037762st__ar
stela54019042stela_
stelae63716482stelae
stelai63912562stelai
stellar72610422stellar
stylate10179772stylate
style85519362styl_e
styled105613102styled
stylers10359352stylers
styles94418652styles
stylet94018572stylet
styli83911172styl_i
stylus9397462stylus
styrax1675242styrax
talar56225382_talar
tolar55524112_tolar
alar46340073__alar
alular6311353alular
ashlar9338193ashlar
asyla839333asyla_
atlas55821583at_las
attar56516693at_tar
bolar75123473_bolar
boyar106013763boy_ar
boyla102912363boyla_
boylas113011723boylas
bylaw13408603_bylaw
cellar84514983cellar
collar83816173collar
cymar125711263_cymar
dollar74110983dollar
escolar946053escolar
etyma1036583etyma_
filar84819293_filar
fistular1144253fistular
gaydar1135503gaydar
gular6314833_gular
hilar85418143_hilar
hyla106716513_hyla_
hylas114815903_hylas
kyar116916843_ky_ar
lar37967533___lar
malar76424443_malar
medlar93010463medlar
molar75223093_molar
mutular936643mutular
mylars114310443_mylars
ocular8610133ocular
oscular937933oscular
osmolar944483osmolar
ostiolar844583ostiolar
ostler63312193ost_ler
ottar54313993ot_tar
ovular946833ovular
pedlar93311273pedlar
phyla13469183phyla_
phylae14458733phylae
pilar75221503_pilar
pillar8314023pillar
polar75623453_polar
poplar103611113poplar
psywar1443323psywar
pustular1045153pustular
saggar84010853saggar
sailer63526103sailer
sailor63113753sailor
salad65321833s_alad
salal55425703s_alal
salary9515213s_alary
sambar103914163sambar
sangar73617683sangar
sansar63613393sansar
sardar73013173sardar
sarsar63011843sarsar
satyr848483saty__r
sayer84926553say_er
scalare93311833scalare
scalars93711903scalars
scaler84321603scaler
scar66434203s__car
scholar1236953scholar
sealer63928963sealer
sear47353843s__ear
secpar1037923secpar
secular92211533secular
seggar8357813seggar
selah8319613s_elah
seller63824593seller
settler73410653settler
settlor7314733settlor
sewar85421103s_ewar
shear85424833s_hear
shikar1336803shikar
shmear1176933shmear
shofar1236313shofar
shyer114714783shy_er
shyly144811573shyl_y
sidler74716963sidler
sigla64515203sigla_
siller64026063siller
simar74920813s_imar
similar937853similar
simular938673simular
sirdar7269103sirdar
sitar54820543s_itar
sizar145214993s_izar
skycap1742913skycap
skylarks1442503skylarks
skylit1338283skylit
skyman1535313skyman
skyward1843863skyward
skyway1933343skyway
slab67133763s__lab
slag55934353s__lag
slam67737973s__lam
slap66434043s__lap
slat46959023s__lat
slaw77930713s__law
slay76436383s__lay
slur45525153s__lur
slyer85515123sly_er
slyly11489533slyl_y
smear74416393s_mear
smilax1535393smilax
smiler83916683smiler
soar46838673s__oar
sofar86115493s_ofar
sola45541863s_ola_
solan55328153s_olan
sonar56523423s_onar
soucar839323soucar
sowar85821343s_owar
sowcar1135863sowcar
soya75724433soy_a_
soyas84520913soy_as
spar65433303s__par
spatular1044653spatular
spear75821063s_pear
splat76129343s_plat
splay105816043s_play
stab67329933st__ab
stabler94014933stabler
stag57332003st__ag
stager74821343stager
stair54719943st_air
stalags838643stalags
stale55637103stal_e
staled74728103staled
stales65538293stales
stalk94518003stal_k
stalker113912253stalker
stalks104614553stalks
stalky13499303stalky
stall54722353stal_l
stalls64019933stalls
stalwart1147193stalwart
stapler93913633stapler
stare54440263st__are
starer64027363starer
stark95425623st__ark
stars55836573st__ars
start55642313st__art
stat47352693st__at
statal61613223statal
stater64427563stater
stator64015483stator
staw78627693st__aw
stay78333723st__ay
stayer94516483stayer
stead65520273st_ead
steak95219803st_eak
steal56125473st_eal
stealer72913973stealer
steals64020063steals
steam76322933st_eam
steer55423863st_eer
stele55026843stel_e
steles63725663steles
stelic8313083stelic
stella63612973stella
stellas72813043stellas
steward1138063steward
stifler102911473stifler
stile54931573stil_e
stiles64328773stiles
still54922083stil_l
stiller73414293stiller
stills64118573stills
stilly93714093stilly
stilt54831983stil_t
stilts67915313stilts
stipular1045843stipular
stir45723253st__ir
stiver93915733stiver
stoa45425913st_oa_
stoae55024263st_oae
stoai55417873st_oai
stoas55126023st_oas
stoat57135953st_oat
stoker104417623stoker
stole54928813stol_e
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stolid74213183stolid
stolon64112073stolon
stoma75918273stoma_
stomal85213313stomal
stomas84816323stomas
stoner65823203stoner
stoper84320103stoper
storax1389783storax
storer64721673storer
stour54916743st_our
stover94115643stover
strap77925263st_rap
straw813321293st_raw
stray88525573st_ray
streak104613623streak
stream84717293stream
stria55723213stria_
striae65422273striae
stull54916273stul_l
stulls63912983stulls
stupa74112313stupa_
stupas83910883stupas
stupor836013stupor
sty66227313sty___
stye76218973sty__e
styed95815483sty_ed
styes86316523sty_es
stygian1144083stygian
stying105414573stying
stylets10369213stylets
styling112910653styling
stylise10208953stylise
styliser11185523styliser
stylish13197443stylish
stylist102110283stylist
stylite10219613stylite
stylize19177453stylize
stylizer20185443stylizer
styloid1137553styloid
stymie1137623stymie
stymy13358293sty_my
subalar9118073subalar
subpar1048663subpar
sugar6312913s_ugar
sutler63718393sutler
swear85316853s_wear
syli74318983s_yl_i
sylis84316023s_ylis
sylph1347793s_ylph
sylva11268443s_ylva
sylvae12236863s_ylvae
sylvan12257363s_ylvan
sylvas12288173s_ylvas
tala45938053_tala_
talars66021683_talars
talas55935893_talas
taler56034863_taler
tar37570693_t__ar
tatar56122063_tatar
tear45242883_t_ear
tela45532973_tela_
telae54323293_telae
tilak91011553_tilak
tiler56131023_tiler
titular737523titular
tola45236333_tola_
tolan55124013_tolan
tolars64817943_tolars
tolas54532773_tolas
tsar47819803_t_sar
tutelar735373tutelar
tyer75323393_ty_er
typal105311153_typal
tzar136315373_t_zar
uvular955563uvular
velar85817633_velar
volar86917413_volar
waylay1535453waylay
xylan1537463_xylan
yar67253833__y_ar
year76534253__year

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.376475242.0
2DLD Change Limit1127162965.78019501.0
3Display Results2962960.1102690.9
 (SQL Overall)1786912966.26628517.6
 
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.