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

211 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
styrax167524(None) 
storax1389781storax
hyrax1838032_hyrax
strap77925262st_rap
straw813321292st_raw
stray88525572st_ray
stylar9358112stylar
styraxes1833492styraxes
anthrax1757153anthrax
astral66919283ast_ral
astray95615543ast_ray
astylar10265063astylar
ataraxy1743983ataraxy
borax145918723_borax
butyral1245713butyral
estral64716513est_ral
estray95713333est_ray
etyma1036583etyma_
eyra76217553_eyra_
eyras84715923_eyras
gyral94412783_gyral
pyran10514473_pyran
pyrex175211213_pyrex
rax108445723___rax
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
saran53730303s_aran
satara6315533satara_
sataras7315063sataras
satrap86212553satrap
satyr848483satyr__
satyric1237493satyric
satyrid1137233satyrid
satyrs937963satyr_s
sax107447643s___ax
scarab10310063scarab
scrag85916173s_crag
scram910621623s_cram
scrap97120403s_crap
sera46141393s_era_
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
shoran94016043shoran
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
skybox2242293skybox
skycap1742913skycap
skyman1535313skyman
skyway1933343skyway
smilax1535393smilax
sora45746913s_ora_
soras55041013s_oras
sovran937153sovran
soya75724433soy_a_
soyas84520913soy_as
spiral83715343spiral
sporal82915453sporal
sprag86418693s_prag
sprat76635973s_prat
spray106720063s_pray
stab67329933st__ab
stag57332003st__ag
stalag7310023stalag
star48037763st__ar
starch113013203starch
stare54440263star_e
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623star_k
starry94911673starry
stars55836573star_s
start55642313star_t
starts65423123starts
starve94613743starve
stat47352693st__at
statal61613223statal
staw78627693st__aw
stay78333723st__ay
stead65520273st_ead
steak95219803st_eak
steal56125473st_eal
steam76322933st_eam
stela54019043stela_
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stere55328543ster_e
stereo65317913stereo
steres63929533steres
steric8317063steric
stern55319123ster_n
sterna63712763sterna
sternal73411913sternal
sterns64616763sterns
sterol6613333sterol
stir45723253stir__
stirk95717413stir_k
stirks104914243stirks
stirp76815503stir_p
stirps85011823stirps
stirs55921623stir_s
stoa45425913st_oa_
stoae55024263st_oae
stoai55417873st_oai
stoas55126023st_oas
stoat57135953st_oat
stoma75918273stoma_
stomal85213313stomal
stomas84816323stomas
storage8310473storage
storaxes1536883storaxes
store56333813stor_e
stored75524213stored
storer64721673storer
stores65533663stores
storey95217613storey
stork96819693stor_k
storks106115953storks
storm76520403stor_m
storms85814633storms
stormy115510733stormy
story86723033stor_y
strafe95215983st_rafe
strain64919573st_rain
strait64025893st_rait
strake104017393st_rake
strand74514823st_rand
strang75718313st_rang
straps87721783st_raps
strass67117223st_rass
strata63616283st_rata
strath93216373st_rath
strati63518903st_rati
straws98718673st_raws
strawy1210312823st_rawy
strays96417933st_rays
streak104613623streak
stream84717293stream
strep77120853st_rep
strew89220663st_rew
stria55723213st_ria
striae65422273striae
strip77524343st_rip
strop77422243st_rop
strow88920573st_row
stroy87720393st_roy
strum75619453st_rum
strut56030733st_rut
stupa74112313stupa_
stupas83910883stupas
sturdy1037043sturdy
sturt56028963stur_t
sturts63915143sturts
sty66227313sty___
stye76218973sty__e
styed95815483sty_ed
styes86316523sty_es
stygian1144083stygian
stying105414573stying
stylate10179773stylate
style85519363sty_le
styled105613103styled
styler94013303styler
styles94418653styles
stylet94018573stylet
styli83911173sty_li
stylus9397463stylus
stymie1137623stymie
stymy13358293sty_my
styrene10116693styrene
sunray9310123sunray
supra73614253supra_
sura45740293s_ura_
surah86823253s_urah
sural55931263s_ural
suras55336333s_uras
surra55521343surra_
surras65919533surras
surtax1337843surtax
sutra54217933sutra_
sutras64818593sutras
sutural7310223sutural
svaraj1634963svaraj
swaraj1636023swaraj
syntax1634303syntax
syren85216743s_yren
syrinx1637143s_yrinx
syrup103010963s_yrup
tax109449153_t__ax
terai53525483_terai
thorax1638253thorax
thraw1110515923_thraw
tora47545993_tora_
torah87125273_torah
toras55540373_toras
trad55630913_t_rad
tram67034553_t_ram
trap67532803_t_rap
tray77632593_t_ray
typal105311153_typal
tyrant9315333_tyrant
tyre75428253_tyr_e
tyred95816433_tyred
tyres84725233_tyres
tyro76622363_tyr_o
tyros85118593_tyros

Search took 6 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.423422437.4
2DLD Change Limit1127162115.20021676.2
3Display Results2112110.0633349.2
 (SQL Overall)1786912115.68631426.5
 
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.