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

178 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
steres6392953(None) 
seres55448891s_eres
stares66038751stares
steers63820981steers
steles63725661steles
stere55328541stere_
stereo65317911stereo
stereos74314971stereos
sterns64616751sterns
stores65533641stores
asters65631602aster_s
ceres75540012_ceres
esters64627732ester_s
feres86038182_feres
freres94716172freres
haeres94017032haeres
heres86245902_heres
meres75143572_meres
metres85121562metres
peres76246642_peres
sabres85520862sabres
sarees65329942sarees
satires72617572satires
scares85033002scares
scenes84520352scenes
scores84725922scores
screes85023962screes
seeress7311572seeress
seers55136382seer_s
sees45361052s_e_es
semes75731582s_emes
sere46153472s_ere_
sered65737292s_ered
serer55935502s_erer
serest64831612s_erest
serfs84922012s_erfs
serges74225962s_erges
series64540972s_eries
sers45746652s_er_s
serves94423652s_erves
sexes126126222s_exes
shares95236412shares
sheers94322402sheers
sherds105614722sherds
shires95225572shires
shores94830402shores
sieges73816832sieges
sieves93216002sieves
sirees64624582sirees
sires55945372s_ires
skees95023122ske_es
skenes104616632skenes
smerks12449712smerks
snares65329032snares
sneers64016172sneers
snores64324312snores
sores55454282s_ores
spares84834552spares
speers85019952speers
sperms102512602sperms
spheres123114352spheres
spires84628112spires
spores84726612spores
sprees85620642sprees
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stare54440262stare_
stared75429872stared
starer64027362starer
starers74522312starers
starets73515922starets
stars55836572star_s
starts65423122starts
starves104614552starves
stases64225562stases
states64337082states
staves94525192staves
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
steed66024942ste_ed
steeds73814882steeds
steek95418002ste_ek
steeks103613702steeks
steel55721992ste_el
steels64117982steels
steep76020702ste_ep
steeps85215192steeps
steer55423862ste_er
steered83615252steered
steerer73113632steerer
steerers82511352steerers
steeves103410902steeves
steins64818342steins
stele55026842stele_
stems75219952ste_ms
stenos63915772stenos
stents65019452stents
steppes113110692steppes
steps76619882ste_ps
steric8317062steric
sterlet71318472sterlet
sterlets8169272sterlets
stern55319122ster_n
sterna63712762sterna
sterner7411912sterner
sternest8314432sternest
sterol6613322sterol
sterols7313442sterols
stets55423912ste_ts
stewed104814242stewed
stews85519142ste_ws
sties55132982st_ies
stiles64328762stiles
stimes85920572stimes
stipes84524052stipes
stirks104914232stirks
stirpes95011292stirpes
stirps85011812stirps
stirs55921612stir_s
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stopes84525892stopes
store56333812store_
stored75524212stored
storer64721672storer
storers75018682storers
storey95217612storey
storeys10559652storeys
stories7324272stories
storks106115932storks
storms85814602storms
stoures74614162stoures
stoves93818922stoves
streek104111412streek
streeks11378712streeks
streel64214022streel
streels73811342streels
street64125772street
streets73312612streets
strep77120852st_rep
streps86218062streps
stress66616672stress
strew89220652st_rew
strews96817092strews
stupes84116952stupes
sturts63915142sturts
styes86316522st_yes
styles94418652styles
sucres84218892sucres
suedes73918112suedes
suers55128482suer_s
sutures7314222sutures
swedes102711892swedes
swerves1377532swerves
tares57456562_tares
tees45353582_te_es
teles54536002_teles
terces83921412_terces
terms75523472_terms
ternes65422902_ternes
terns55226872_terns
terse55026822_terse
theres96525472theres
tires55437492_tires
tores55352672_tores
trees55835762_trees
tres46542902_t_res
tsores65113662tsores
tyres84725232_tyres
uterus639192uterus
wheres125917432wheres

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 Filter178691825510.1101624463.6
2DLD Change Limit825511782.53332590.2
3Display Results1781780.0463869.6
 (SQL Overall)1786911782.68966452.6
 
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.