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 “stere” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
stere5532854(None) 
sere46153471s_ere
stare54440261stare
steer55423861steer
stele55026841stele
stereo65317911stereo
steres63929531steres
stern55319121stern
store56333811store
aster55434892aster_
astern64815812astern
asters65631602asters
austere7312992austere
cere66741472_cere
dere56845902_dere
ere36352772__ere
ester54727712ester_
esters64627732esters
eterne6311722eterne
fere76342232_fere
frere85617722frere
here76447102_here
mere67244442_mere
metre74821302metre
pere66450262_pere
sabre74821502sabre
saree55044662saree
satire63218002satire
scare75334462scare
scene77220572scene
score75526742score
scree720031712scree
see35772262s_e_e
seer45547042seer_
seers55136382seers
seme65836652s_eme
sene46848052s_ene
ser36752402s_er_
sera46141392s_era
sered65737292s_ered
serer55935512s_erer
seres55448892s_eres
serf76340112s_erf
serge64727472s_erge
sers45746652s_ers
serve85425962s_erve
setae56026222setae
severe94016082severe
share86437082share
sheer84726892sheer
sherd96321152sherd
shire84727132shire
shore85432652shore
siege66718442siege
sieve84918842sieve
sire46150412s_ire
siree55238812siree
skee85431472ske_e
skene96118122skene
smerk115412722smerk
snare54429982snare
sneer54919952sneer
snore55424952snore
sore47059532s_ore
spare75135562spare
speer74623902speer
sperm93216022sperm
sphere113313662sphere
spire75828692spire
spore75428592spore
spree74830862spree
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762star_
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
state56237332state
stave85324992stave
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steered83615252steered
steerer73113632steerer
steers63820982steers
steeve93710902steeve
stein54620542stein
stela54019042stela
stelae63716482stelae
steles63725662steles
stem610628252ste_m
stems75219952stems
steno54716862steno
stent55634512stent
step67126292ste_p
steppe10319872steppe
steps76619882steps
stereos74314972stereos
steric8317062steric
sterile7316602sterile
sterlet71318472sterlet
sterna63712762sterna
sterner7411912sterner
sterns64616762sterns
sterol6613332sterol
stet45947322ste_t
stets55423912stets
stew77525462ste_w
stewed104814242stewed
stews85519142stews
stewy116112062stewy
stey76224412ste_y
stile54931572stile
stime76521802stime
stipe76523372stipe
stir45723252stir_
stirk95717412stirk
stirp76815502stirp
stirs55921622stirs
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stope74727242stope
stored75524212stored
storer64721672storer
stores65533662stores
storey95217612storey
stork96819692stork
storm76520402storm
story86723032story
stoure64814942stoure
stove85220252stove
streek104111412streek
streel64214022streel
street64125772street
strep77120852strep
strew89220662strew
stupe75217752stupe
sturt56028962sturt
stye76218972st_ye
style85519362style
sucre75019102sucre
suede64419752suede
suer45334032suer_
suers55128482suers
sure45447412s_ure
suture6313202suture
sware85828212sware
swede94413202swede
sweer84918572sweer
swerve1256292swerve
swore84920822swore
tare45957622_tare
tee38366872_te_e
tele45040872_tele
terce75721842_terce
term66233152_term
tern46134802_tern
terne56426152_terne
terse55026822_terse
there87527392there
tire46143352_tire
tore47359322_tore
tree47745812_tree
tyre75428252_tyre
uteri51012982uteri
were76238332_were
where117019422where

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001811.62333148.5
3Display Results1811810.0463934.8
 (SQL Overall)1786911811.98290156.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.