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

245 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
shale8533283(None) 
hale76052831_hale
sale44959701s_ale
scale74629141scale
shade95125581shade
shake124726401shake
shaled105023951shaled
shales94731251shales
shaley123714991shaley
shall85024051shall
shalt85534481shalt
shaly114322861shaly
shame105726701shame
shape105125111shape
share86437081share
shave114425891shave
spale74929211spale
stale55637101stale
swale85221591swale
whale115517431whale
ale36572342__ale
bale66353842_bale
chafe135117352chafe
chaleh143711992chaleh
chalet113825992chalet
chalk144814602chalk
chape125221142chape
chare105231982chare
chase105127122chase
chile105626892chile
chyle134913482chyle
dale55643982_dale
dhal86719282dhal_
dhals95415442dhals
dhole95215362dhole
exhale1636872exhale
gale56347322_gale
hade85440192_hade
hae67364002_ha_e
hake115637842_hake
haled95335822_haled
haler85033522_haler
hales85449842_hales
half106238452_half
hall75741162_hall
halm95834972_halm
halo76437322_halo
halt76056302_halt
halve114818922_halve
hame97043132_hame
haole84820082_haole
hare76255732_hare
hate78450172_hate
have106137072_have
haze164833392_haze
hole77553392_hole
inhale9411512inhale
kale86533752_kale
male66052292_male
pale66055012_pale
phage115113672phage
phase104617212phase
phyle134111152phyle
quale143617852quale
rale45050562_rale
sabe66140572s_abe
sable74732162sable
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sal36462882s_al_
salep77022952s_alep
sales56055592s_ales
sall44544682s_all
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
salve85022132s_alve
same65245642s_ame
sane45954332s_ane
sate45556102s_ate
save75741362s_ave
scald84818122scald
scaled94822442scaled
scaler84321602scaler
scales84529312scales
scall74420372scall
scalp95217982scalp
scaly104718722scaly
scape96921842scape
scare75334462scare
seal45654372seal_
sealed74328362sealed
sealer63928962sealer
seals54839692seals
selle54428312selle
sha69837782sha__
shack145321752shack
shackle16409542shackle
shad86230912sha_d
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shaft115725252shaft
shag86430562sha_g
shags95123862shags
shah105627782sha_h
shahs115919512shahs
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516082shako
shaky154616842shaky
shalier103116422shalier
shalom11810912shalom
sham96436352sha_m
shamble14149262shamble
shamed125120212shamed
shames114726222shames
shams105829412shams
shank125422192shank
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapes115124942shapes
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456592sha_t
shaul85418102shaul
shauled1148792shauled
shauls94913112shauls
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shaves125224932shaves
shavie124312412shavie
shaw108132552sha_w
shawed134817232shawed
shawl116217572shawl
shawled1437772shawled
shawls125411972shawls
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shay107133342sha_y
shays116021432shays
she66837692sh__e
sheal84927702sheal_
sheals94420642sheals
sheave124514002sheave
shelf115221112shelf
shell84424122shell
shelve124012762shelve
shiel811023772shiel
shill85325332shill
shily115222012shily
shine85533092shine
shire84727132shire
shive114423422shive
shlep104914832sh_lep
shoal83920262shoal_
shoaled113810962shoaled
shoaler102610072shoaler
shoals94215782shoals
shoaly124010762shoaly
shoe75933432sh_oe
shone83725972shone
shore85432642shore
shote85526082shote
shove114421032shove
shul75823152shul_
shuln84713112shuln
shuls85319712shuls
shute84520342shute
shyly144811572shyly
sial45938832sial_
sials54227242sials
sidle65124032sidle
skald104210172skald
skate94721542skate
slake93724052slake
slate55438282slate
slave84224032slave
small74016262small
smalt74729332smalt
smaze165012932smaze
smile74823912smile
snake94821112snake
snare54429982snare
soave84219052soave
socle7419572socle
sole46053672s_ole
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spales84728102spales
spall74919302spall
spare75135562spare
spate74731582spate
spile75230082spile
stable83921642stable
stade64825302stade
stage65330192stage
stake95927532stake
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stane55933002stane
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
stele55026842stele
stile54931572stile
stole54928812stole
style85519362style
suable83920552suable
suave83519872suave
swage94919562swage
swales93920762swales
sware85828212sware
tale46154162_tale
thae76825562tha_e
thaler94613102thaler
thane86122532thane
thole85620842thole
vale74937342_vale
wale74546432_wale
whaled134612032whaled
whaler124611972whaler
whales124716942whales
while115418692while
whole114418092whole

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 Limit538002451.76330516.2
3Display Results2452450.0633888.9
 (SQL Overall)1786912451.91993116.7
 
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.