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

132 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
sherd9632115(None) 
herd84933061_herd
shard96125961shard
shed86536151she_d
shend94719971shend
sherds105614721sherds
shred98125611shred
ahead96817052ahead
ahed89536252ahe_d
ashed97829772ashe_d
chard116124742chard
chert105232102chert
chord115917262chord
hard85443502_hard
head87137172_head
heard95222752_heard
heed86437602_heed
held85330402_held
her66547812_her_
herb94730962_herb
herds96424682_herds
here76447102_here
herl75834552_herl
herm95636152_herm
hern76134892_hern
hero74635782_hero
hers75844872_hers
nerd56624942_nerd
ohed87825182ohe_d
sard55344242s_ard
scend85516292scend
seed55549482s_eed
seer45547042seer_
seers55136382seers
send55237292s_end
ser36752402s_er_
sera46141392s_era
sere46153472s_ere
sered65737292s_ered
serf76340112s_erf
sers45746652s_ers
shad86230912sh_ad
shaird10288702shaird
shards104319172shards
share86437082share
shared105829062shared
shark126225022shark
sharn84823702sharn
sharp104922532sharp
she66837692she__
shea76031572she_a
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheared114516002sheared
shears93820902shears
sheas86331792sheas
sheds96122702sheds
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheered113515452sheered
sheers94322402sheers
sheet84836962sheet
sheik122514662sheik
shelf115221112shelf
shell84424122shell
shends105313772shends
shent85933502shent
sheol84318372sheol
sherif122915242sherif
sherpa1138092sherpa
sherry124510412sherry
shes75734352she_s
shew108030762she_w
shewed134716182shewed
shewn115715702shewn
shews115924712shews
shied96125492shied
shield106212972shield
shier85428942shier_
shiers94921752shiers
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shod86225062sh_od
shoed95723012shoed
shoer84722162shoer_
shoers94518332shoers
shore85432652shore
shored105723652shored
shorl84720252shorl
shorn85722182shorn
short85040532short
shreds105613052shreds
shrew119720172shrew
shrewd136810782shrewd
shri76021702sh_ri
shyer114714782shyer_
shyers124712202shyers
sired66134282sired
skeed105018982skeed
sled55334372sle_d
smerk115412722smerk
sned56026052sne_d
sord56237202s_ord
sored66141782sored
sped76031492spe_d
speed85526622speed
spend85619332spend
sperm93216022sperm
sphere113313662sphere
sphered133512312sphered
sphery14318882sphery
stead65520272stead
steed66024942steed
stere55328542stere
stern55319122stern
sued56537932sue_d
suer45334032suer_
suers55128482suers
surd56433812s_urd
sward94221462sward
sword95214122sword
there87527392there
therm106018022therm
third95912492third
usher84517762usher_
ushered1139152ushered
ushers94415532ushers
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.296603685.8
2DLD Change Limit538001321.68631909.8
3Display Results1321320.0304400.0
 (SQL Overall)1786911322.01288812.6
 
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.