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

239 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
shales9473125(None) 
hales85449841_hales
sales56055591s_ales
scales84529311scales
shades105924531shades
shakes135024591shakes
shale85332831shale_
shaled105023951shaled
shaley123714991shaley
shames114726221shames
shapes115124941shapes
shares95236411shares
shaves125224931shaves
spales84728101spales
stales65538291stales
swales93920761swales
whales124716941whales
ales47067102__ales
bales76250082_bales
chafes145017912chafes
chaleh143711992chaleh
chalehs15268802chalehs
chalet113825992chalet
chalets122813472chalets
chalks155412142chalks
chapes135421872chapes
chares115631802chares
chases115128232chases
chiles115425302chiles
chyles144813282chyles
dales66439742_dales
dhals95415442dhal_s
dholes104914792dholes
exhales1737142exhales
gales65442482_gales
hades96035112_hades
haes77651022_ha_es
hajes155420942_hajes
hakes126034302_hakes
hale76052832_hale_
haled95335822_haled
haler85033522_haler
halers94926912_halers
halest94823272_halest
halls85633782_halls
halms105225212_halms
haloes94623862_haloes
halos85230252_halos
halts85230102_halts
halves124717092_halves
hames106138702_hames
haoles94919802_haoles
hares86255542_hares
hates86742572_hates
haves116034872_haves
hazes174928322_hazes
holes84748652_holes
inhales10511862inhales
kales95730982_kales
males75049792_males
pales75753802_pales
phages125213512phages
phases114618402phases
rales54947492_rales
reales64934122reales
sabes76437462s_abes
sables85026692sables
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sale44959702s_ale_
salep77022952s_alep
saleps85014902s_aleps
salps74423242s_alps
sals46851672s_al_s
salts55431882s_alts
salves94221762s_alves
sanes55649072s_anes
sates54949322s_ates
saves85838632s_aves
saxes125229342s_axes
scalds94813692scalds
scale74629142scale_
scaled94822442scaled
scaler84321602scaler
scalers93817262scalers
scalls84218202scalls
scalps104315232scalps
scapes105122262scapes
scares85033002scares
sealed74328362sealed
sealer63928962sealer
sealers74323552sealers
seals54839692seal_s
selles64426982selles
shackles173010592shackles
shacks154817562shacks
shade95125582shade_
shaded114518872shaded
shader104218762shader
shaders115915552shaders
shads95124482sha_ds
shafts125411432shafts
shags95123862sha_gs
shahs115919512sha_hs
shake124726402shake_
shaken134113612shaken
shaker134319462shaker
shakers144015562shakers
shakoes144510012shakoes
shakos134912182shakos
shalier103116422shalier
shaliest111415042shaliest
shall85024052shal_l
shalom11810912shalom
shaloms1288982shaloms
shalt85534482shal_t
shaly114322862shal_y
shamas113717932shamas
shambles15159042shambles
shame105726702shame_
shamed125120212shamed
shammes144312832shammes
shamos114216982shamos
shams105829412sha_ms
shamus114112812shamus
shanks135315582shanks
shape105125112shape_
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapers124016892shapers
shards104319172shards
share86437082share_
shared105829062shared
sharer95025482sharer
sharers104720622sharers
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shauled1148792shauled
shauls94913112shauls
shave114425892shave_
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shavers134115092shavers
shavies134213202shavies
shawed134817232shawed
shawled1437772shawled
shawls125411972shawls
shawms14579562shawms
shaws116226262sha_ws
shays116021432sha_ys
sheals94420642sheal_s
sheaves134412972sheaves
shells94319522shells
shelves134112092shelves
shes75734352sh__es
shiels95418922shiels
shies86136552sh_ies
shills94519602shills
shines95028912shines
shires95225572shires
shives124921412shives
shlep104914832sh_lep
shleps114710332sh_leps
shmoes114612092shmoes
shoaled113810962shoaled
shoaler102610072shoaler
shoalest1168912shoalest
shoals94215782shoal_s
shoes85429652sh_oes
shores94830402shores
shotes95321892shotes
shoves124919412shoves
shuls85319712shul_s
shutes93518212shutes
sials54227242sial_s
sidles74721152sidles
skalds11437832skalds
skates104219392skates
slakes104021882slakes
slates64934062slates
slaves95023022slaves
smalls84514122smalls
smalts85214892smalts
smazes174311662smazes
smiles84522292smiles
snakes103919602snakes
snares65329032snares
soaves94218672soaves
socles8418452socles
soles55547922s_oles
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spale74929212spale_
spalls84217342spalls
spares84834552spares
spates85028172spates
spiles84227912spiles
stables93219072stables
stades74626242stades
stages75629492stages
stakes103927292stakes
stale55637102stale_
staled74728102staled
staler64025822staler
stalest73720172stalest
stalks104614552stalks
stalls64019922stalls
stanes64933402stanes
stapes85028732stapes
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steles63725662steles
stiles64328762stiles
stoles63927672stoles
styles94418652styles
swages104417072swages
swale85221592swale_
tales55451372_tales
thaler94613102thaler
thalers106212262thalers
thanes94918982thanes
tholes94919782tholes
vales85434262_vales
wales86142832_wales
whale115517432whale_
whaled134612032whaled
whaler124611972whaler
whalers13529702whalers
whiles124418012whiles
wholes124616772wholes

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 Filter178691825510.1101624463.6
2DLD Change Limit825512392.68630733.8
3Display Results2392390.0932569.9
 (SQL Overall)1786912392.88961852.2
 
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.