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 “shadow” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

288 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
shadow133725(None) 
shadows1437191shadows
shadowy1744721shadowy
beshadow1742302beshadow
chador1238672chador
meadow1237402meadow
seadog838742seadog
shad86230912shad__
shadblow1742312shadblow
shade95125582shad_e
shaded114518872shaded
shader104218762shader
shades105924532shades
shadoof1446132shadoof
shadowed1644482shadowed
shadower1544872shadower
shads95124482shad_s
shaduf1337062shaduf
shady125416512shad_y
shahdom1643972shahdom
shako125516092shako_
shakos134912192shakos
shallow13388872shallow
shalom11810922shalom
shamos114216982shamos
shamoy14379912shamoy
shaw108132552sha__w
show106229192sh__ow
spado83713702spado_
ado49146883__ado_
ados57633513__ados
adown95611663__adown
alow75328593__alow
amadou977613amadou
avow107816463__avow
beshadows1842513beshadows
cahow135110943_cahow
chad105525503chad__
chadar1239353chadar
chadors1338753chadors
chadri1238143chadri
chads116122233chad_s
chalot113020133chalot
chao95727313cha_o_
chaos105622863cha_os
chaw126224633cha__w
chow125820993ch__ow
dado67126343_dado_
dados75522433_dados
dhow116614003dh__ow
dow76749973___dow
endow94510983_endow
fado87226473_fado_
fados95620733_fados
had77658773_had__
hadal95518123_hadal
hade85440203_had_e
haded105227623_haded
hades96035113_hades
hadj155818683_had_j
hadji16839893_hadji
hadron102913753_hadron
hadst93220223_hadst
hagdon1188283_hagdon
hallow124818323_hallow
halo76437323_halo_
halon86124863_halon
halos85230253_halos
hao67251123_ha_o_
harrow122610783_harrow
havoc1337183_havoc
haw97153273_ha__w
haymow1773683_haymow
how97252433_h__ow
indow95011663_indow
khadi1367613khad_i
khadis1446913khadis
meadows1337333meadows
meadowy1644043meadowy
miaow1058353mia_ow
pashadom1643843pashadom
pharos11312063pharos
pshaw13447513psha__w
radon64620503_radon
reavow1235723reavow
rhabdom1543383rhabdom
sabot7931783s_abot
sad47459213s_ad__
sade55544483s_ad_e
sades65239893s_ades
sadhe94815133s_adhe
sadhu9459963s_adhu
sadi55834653s_ad_i
sadis64930853s_adis
sadly94519123s_adly
sago56332673s_ago_
sagos66123873s_agos
sajou12311693s_ajou
sallow94315753sallow
salol55222143s_alol
salon55228553s_alon
sapor75119253s_apor
sarod65325873s_arod
saros55238063s_aros
savor85417943s_avor
savoy114713883s_avoy
saw68255353s_a__w
scad75725773scad__
scads85419963scad_s
scow96021423s__cow
scudo85412213scudo_
seadogs958643seadogs
seafowl1343913seafowl
season62714903season
seldom939413seldom
serow86720443s_erow
sha69837783sha___
shabby1635803shabby
shack145321753sha_ck
shacko153810113shacko
shackos16429023shackos
shacks154817563shacks
shadblows1842473shadblows
shaddock1943273shaddock
shaders115915553shaders
shadfly1733783shadfly
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shadoofs1554233shadoofs
shadowbox2551363shadowbox
shadowers1644303shadowers
shadowier1642893shadowier
shadowily1982023shadowily
shadowing1744263shadowing
shadufs1433673shadufs
shaft115725273sha_ft
shafts125411443shafts
shag86430563sha__g
shaggy14478043shaggy
shags95123863sha_gs
shah105627783sha__h
shahdoms1743773shahdoms
shahs115919513sha_hs
shaird10288703shaird
shairn9269063shairn
shake124726403sha_ke
shakedown2052573shakedown
shaken134113613shaken
shaker134319463shaker
shakes135024593shakes
shakoes144510023shakoes
shaky154616843sha_ky
shale85332833sha_le
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053sha_ll
shallop12348453shallop
shallot103614133shallot
shallows14388863shallows
shaloms1288983shaloms
shalt85534493sha_lt
shaly114322863sha_ly
sham96436363sha__m
shaman113314283shaman
shamas113717943shamas
shame105726703sha_me
shamed125120213shamed
shames114726223shames
shammos14307203shammos
shammy16388503shammy
shamois123210423shamois
shamoys15367283shamoys
shampoo1435373shampoo
shams105829413sha_ms
shamus114112813shamus
shandy134710033shandy
shank125422193sha_nk
shanks135315583shanks
shanny124110093shanny
shanti94014093shanti
shanty124715123shanty
shape105125113sha_pe
shaped125020103shaped
shapen114414653shapen
shaper114119933shaper
shapes115124953shapes
shard96125963sha_rd
shards104319173shards
share86437083sha_re
shared105829063shared
sharer95025483sharer
shares95236413shares
sharia93116733sharia
sharif122917123sharif
shark126225023sha_rk
sharks135019723sharks
sharn84823703sha_rn
sharns95516983sharns
sharny124711833sharny
sharp104922533sha_rp
sharps115516083sharps
sharpy145211033sharpy
shat76456603sha__t
shaugh13287433shaugh
shaul85418103sha_ul
shauls94913113shauls
shave114425893sha_ve
shaved135118383shaved
shaven124213303shaven
shaver123718913shaver
shaves125224933shaves
shavie124312423shavie
shawed134817233shawed
shawl116217573sha_wl
shawls125411973shawls
shawm135316153sha_wm
shawms14579563shawms
shawn116417613sha_wn
shaws116226263sha_ws
shay107133343sha__y
shays116021433sha_ys
shazam2046623shazam
shed86536153shed__
sheds96122703shed_s
sheol84318373sh_eol
shew108030763sh__ew
shmo95318103sh_mo_
shnook1366343shnook
shod86225063sh__od
shoddy1434543shoddy
shoe75933443sh__oe
shog86025143sh__og
sholom11910113sholom
shoo75929893sh__oo
shook124920163sh_ook
shool84523153sh_ool
shoon84022013sh_oon
shoos84226363sh_oos
shoot84235913sh_oot
shop95629843sh__op
shot76150263sh__ot
showdown1843573showdown
shown115216483sh__own
shows115324583sh__ows
showy145714013sh__owy
shrew119720173sh_rew
shutdown1542703shutdown
skatol1035723skatol
skidoo1136103skidoo
slalom888173slalom
slaw77930713sla__w
slow77729493s__low
snaw78923073sna__w
snow76324793s__now
sodom8814913s_odom
soldo67116563soldo_
sordor7310223sordor
sorrow9339443sorrow
sow66554763s___ow
spade84423323spad_e
spaded103816753spaded
spader94317133spader
spades94222583spades
spadix1636113spadix
sparrow1234273sparrow
sradha1085333sradha
stade64825303stad_e
stades74626243stades
stadia7312143stadia
stanol6310723stanol
stardom1037763stardom
stator64015483stator
staw78627693sta__w
stow77325743s__tow
strow88920573s_trow
sudor6312623s_udor
sunbow1145823sunbow
sundew10369693sundew
sundog837613sundog
sundown1186313sundown
swallow13355753swallow
thaw107521313tha__w
throw118719733th_row
whamo135511263whamo_
widow1278943_widow
window1347363window

Search took 10 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 Filter1786911127160.533335255.2
2DLD Change Limit1127162889.22012225.2
3Display Results2882880.0763789.5
 (SQL Overall)1786912889.82918180.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.