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

116 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
shend9471997(None) 
scend85516291scend
send55237291s_end
shed86536151she_d
shends105313771shends
shent85933491shent
sherd96321151sherd
spend85619331spend
ahead96817052ahead
ahed89536252ahe_d
amend85717752amend
ascend9429732ascend
ashed97829772ashe_d
ashen87818672ashen_
bend76435262_bend
blend85317452blend
emend86214892emend
end46834352__end
fend84832972_fend
fiend95312982fiend
hand86833702_hand
head87137172_head
heed86437602_heed
held85330402_held
hen67555272_hen_
hens75642572_hens
hent76656382_hent
herd84933062_herd
hind85529752_hind
lend56233672_lend
mend75334022_mend
ohed87825182ohe_d
pend75934532_pend
rend56136572_rend
sand55338462s_and
saned65636272saned
scena74815782scena
scends95213002scends
scene77220572scene
scent75831622scent
seed55549482s_eed
seen46943122seen_
sen36058522s_en_
sends65528242s_ends
sene46848052s_ene
sent46963012s_ent
shad86230912sh_ad
shandy134710032shandy
shank125422192shank
shard96125962shard
she66837692she__
shea76031572she_a
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheds96122702sheds
sheen85023312sheen
sheened113511702sheened
sheens95116992sheens
sheeny124912192sheeny
sheep105321522sheep
sheer84726892sheer
sheet84836952sheet
sheik122514652sheik
shelf115221112shelf
shell84424122shell
sheol84318362sheol
sherds105614722sherds
shes75734352she_s
shew108030762she_w
shewed134716182shewed
shewn115715702shewn
shews115924712shews
shied96125492shied
shield106212972shield
shin75634302shin_
shindy13449322shindy
shine85533092shine
shined104620782shined
shins85131042shins
shiny115122142shiny
shod86225052sh_od
shoed95723002shoed
shone83725972shone
shred98125612shred
shrewd136810772shrewd
shun75122772shun_
shuns85018142shuns
shunt85226502shunt
skeed105018982skeed
skene96118122skene
sled55334372sle_d
sned56026052sne_d
sound64420022sound
sped76031492spe_d
speed85526622speed
spends94714472spends
spendy124911142spendy
spent75532832spent
sphene113412402sphene
stand65923282stand
stead65520272stead
steed66024942steed
steno54716862steno
stent55634512stent
sued56537932sue_d
tend56433772_tend
then78429692then_
thens85921832thens
trend64817452trend
upend85011042upend
vend86626422_vend
wend85330452_wend
when105723042when_
whens114618762whens

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.0931921408.6
2DLD Change Limit538001161.82629463.3
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.95291542.5
 
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.