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

138 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
stead6552027(None) 
steads74116221steads
steady103510201steady
steak95219801steak
steal56125471steal
steam76322931steam
steed66024941steed
ahead96817052ahead
bead75937922_bead
bestead10389112bestead
bread85523112bread
dead65434242_dead
dread74419022dread
head87137172_head
instead836202instead
knead10429662knead
lead56038852_lead
mead75531602_mead
oread64619602oread
osteal6312962osteal
plead85818462plead
read55942532_read
sad47459202s__ad
salad65321832salad
sated66238532sate_d
scad75725772s_cad
scend85516292scend
sea36161292s_ea_
seal45654372s_eal
seam66645972s_eam
sear47353842s_ear
seas45755272s_eas
seat47575562s_eat
seed55549482s_eed
send55237292s_end
seta45637312seta_
setae56026222setae
setal56430902setal
shad86230912s_had
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
shed86536152she_d
shend94719972shend
sherd96321152sherd
sited65130742site_d
skean94415622skean
skeed105018982skeed
sled55334372sle_d
smear74416392smear
sneak96016172sneak
sneap75514822sneap
sned56026052sne_d
spaed85522272spaed
speak114618672speak
spean74620512spean
spear75821062spear
sped76031492spe_d
speed85526622speed
spend85619332spend
spread9312532spread
squad155110792squad
stab67329932st_ab
stade64825302st_ade
stag57332002st_ag
staid66722082staid
stand65923282stand
star48037762st_ar
stat47352692st_at
staw78627692st_aw
stay78333722st_ay
steaded92811672steaded
steaks104415852steaks
steals64020062steals
steamed103712142steamed
steams84916902steams
steamy115112372steamy
steeds73814882steeds
steek95418002steek
steel55721992steel
steep76020702steep
steer55423862steer
stein54620542stein
stela54019042stela
stelae63716482stelae
stelai63912562stelai
stelar64013862stelar
stele55026842stele
stem610628252ste_m
stems75219952stems
steno54716862steno
stent55634512stent
step67126292ste_p
steps76619882steps
stere55328542stere
stern55319122stern
stet45947322ste_t
stets55423912stets
stew77525462ste_w
steward1138062steward
stewed104814242stewed
stews85519142stews
stewy116112062stewy
stey76224412ste_y
stied65723032stied
stoa45425912stoa_
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stood65517712stood
strand74514822strand
strap77925262strap
straw813321292straw
stray88525572stray
streak104613622streak
stream84717292stream
stud56220092st_ud
styed95815482styed
sued56537932sue_d
swear85316852swear
sweat85628402sweat
tad47959822_t_ad
tea37353322_tea_
teak85930842_teak
teal45546502_teal
team66238652_team
tear45242882_tear
teas45851492_teas
teat45963632_teat
ted46446562_te_d
teed55439262_teed
tend56433772_tend
toad55830182_toad
trad55630912_trad
tread64821702tread

Search took 5 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.826216332.9
2DLD Change Limit538001383.15617046.9
3Display Results1381380.0334181.8
 (SQL Overall)1786911384.01544505.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.