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

122 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
stern5531912(None) 
astern64815811astern
stein54620541stein
stere55328541stere
sterna63712761sterna
sterns64616761sterns
tern46134801_tern
aster55434892aster_
asters65631602asters
cistern93310702cistern
eastern74412532eastern
ern35738362__ern
ester54727712ester_
esters64627732esters
eterne6311722eterne
extern1348472extern
fern76129322_fern
hern76134892_hern
intern64016542intern
kern85326212_kern
pastern94415062pastern
postern93615612postern
pterin81014152pterin
quern143610402quern
saltern74010652saltern
sateen63815012sateen
scorn75817452scorn
secern81010222secern
seen46943122s_een
seer45547042seer_
seers55136382seers
sen36058522s_e_n
ser36752402s_er_
sera46141392s_era
sere46153472s_ere
serf76340112s_erf
serin55434442s_erin
sers45746652s_ers
seton55223542seton
sewn76124332s_ewn
sharn84823702sharn
sheen85023312sheen
sherd96321152sherd
shewn115715702shewn
shorn85722182shorn
siren54525822siren
skean94415622skean
skeen94817402skeen
skein94814412skein
smerk115412722smerk
sorn46641062s_orn
spean74620512spean
sperm93216022sperm
spurn74815452spurn
stain55727942stain
star48037762star_
stare54440262stare
stark95425622stark
stars55836572stars
start55642312start
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
stearin7312002stearin
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steer55423862steer
steers63820982steers
steins64818342steins
stela54019042stela
stele55026842stele
stem610628252ste_m
stems75219952stems
steno54716862steno
stent55634512stent
step67126292ste_p
steps76619882steps
stereo65317912stereo
steres63929532steres
steric8317062steric
sternal73411912sternal
sterner7411912sterner
sternly1037852sternly
sternum947732sternum
sterol6613332sterol
stet45947322ste_t
stets55423912stets
stew77525462ste_w
stews85519142stews
stewy116112062stewy
stey76224412ste_y
stir45723252stir_
stirk95717412stirk
stirp76815502stirp
stirs55921622stirs
store56333812store
stork96819692stork
storm76520402storm
story86723032story
strep77120852strep
strew89220662strew
strewn96710012strewn
stun45623452st_un
sturt56028962sturt
suer45334032suer_
suers55128482suers
sworn86115312sworn
syren85216742syren
tarn46842722_tarn
teen45938202_teen
ten35856112_te_n
term66233152_term
terne56426152_terne
terns55226872_terns
torn46044252_torn
turn46330392_turn
uteri51012982uteri
western102911102western
yestern10338642yestern

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.330541487.9
2DLD Change Limit538001222.04626295.2
3Display Results1221220.0304066.7
 (SQL Overall)1786911222.40674268.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.