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

125 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
styed9581548(None) 
sayed96127141sayed
skyed13529921skyed
stayed104817271stayed
steed66024941steed
stied65723031stied
stye76218971stye_
styes86316521styes
styled105613101styled
bayed115423022bayed
coyed114623802coyed
dyed96720762_dyed
eyed86623232_eyed
fayed126422152fayed
guyed1049892guyed
hayed125822012hayed
joyed164811832joyed
keyed1369392keyed
layed95127382layed
mayed115522402mayed
payed115925932payed
rayed95127502rayed
sabed86526812sabed
saned65636272saned
sated66238532sated
saved95127112saved
sawed95628402sawed
sayeds10469252sayeds
sayer84926552sayer
sayid95516722sayid
seed55549482s_eed
sered65737292sered
sewed95325162sewed
sexed136618542sexed
shed86536152s_hed
shied96125492shied
shoed95723012shoed
shred98125612shred
shyer114714782shyer
sided74825952sided
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
skeed105018982skeed
skied104417752skied
skyey15537222skyey
slayed104716222slayed
sled55334372s_led
slued64220512slued
slyer85515122slyer
sned56026052s_ned
snye77115492snye_
snyes85012752snyes
soled65835172soled
sored66141782sored
sotted74121402sotted
sowed94933862sowed
spaed85522272spaed
spayed124213612spayed
sped76031492s_ped
speed85526622speed
spied85427712spied
spued84918472spued
stade64825302stade
staged84521562staged
staid66722082staid
staked114621942staked
staled74728102staled
stand65923282stand
staned74824642staned
stared75429872stared
stated75427832stated
staved103918052staved
stayer94516482stayer
stead65520272stead
steeds73814882steeds
steek95418002steek
steel55721992steel
steep76020702steep
steer55423862steer
stem610628252st_em
step67126292st_ep
stet45947322st_et
stew77525462st_ew
stewed104814242stewed
stey76224412st_ey
sties55132982sties
stiped94517072stiped
stoked114718292stoked
stoled74521592stoled
stoned75923142stoned
stood65517712stood
stoped94721012stoped
stored75524212stored
stowed105817202stowed
strayed114513282strayed
strep77120852strep
strew89220662strew
stroyed114110862stroyed
stud56220092st_ud
sty66227312sty__
style85519362style
styler94013302styler
styles94418652styles
stylet94018572stylet
styli83911172styli
stymied1335662stymied
stymy13358292stymy
sued56537932s_ued
swayed133510262swayed
ted46446562_t_ed
teed55439262_teed
tied55535212_tied
toed56137042_toed
toyed96019802toyed
tsked105910032tsked
tye65837442_tye_
tyee75131422_tyee
tyer75323392_tyer
tyes76433372_tyes
tyned95915012_tyned
typed115815452_typed
tyred95816432_tyred
wyted12529472wyted

Search took 2 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.296603685.8
2DLD Change Limit538001251.59333772.8
3Display Results1251250.0462717.4
 (SQL Overall)1786911251.93592346.8
 
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.