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

215 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
spales8472810(None) 
pales75753801_pales
sales56055591s_ales
scales84529311scales
shales94731251shales
spaces104722631spaces
spades94222581spades
spaes76029971spa_es
spale74929211spale_
spalls84217341spalls
spares84834551spares
spates85028171spates
spiles84227911spiles
stales65538291stales
swales93920761swales
ales47067102__ales
apples104315762apples
bales76250082_bales
dales66439742_dales
empales112411432empales
gales65442482_gales
hales85449842_hales
impales113311762impales
kales95730982_kales
males75049792_males
maples104819422maples
nopales93812522nopales
opals75718352opal_s
paces96741112_paces
padles95221112_padles
pages85235072_pages
pale66055012_pale_
palea75028662_palea
paled85538722_paled
paler75436932_paler
palest83926222_palest
palet74650802_palet
palets85122312_palets
palls74332562_palls
palms94921752_palms
palps94719562_palps
pals66951352_pal_s
panes76148692_panes
pares77164482_pares
parles86334392_parles
pases75346502_pases
pates76047892_pates
paves104833922_paves
paxes144928422_paxes
peles75738082_peles
piles74742612_piles
poles75351002_poles
psalms1045672psalms
pules74538812_pules
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
sapless93313442sapless
sates54949322s_ates
saves85838632s_aves
saxes125229342s_axes
scalds94813692scalds
scale74629142scale_
scaled94822442scaled
scaler84321602scaler
scalers93817262scalers
scalls84218202scalls
scalps104315232scalps
scapes105122262scapes
scares85033002scares
sealed74328362sealed
sealer63928962sealer
sealers74323552sealers
seals54839692seal_s
selles64426982selles
sepaled10510592sepaled
sepals85217372sepal_s
shades105924532shades
shakes135024592shakes
shale85332832shale_
shaled105023952shaled
shaley123714992shaley
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
sials54227242sial_s
sidles74721152sidles
skalds11437832skalds
skates104219392skates
slakes104021882slakes
slates64934062slates
slaves95023022slaves
smalls84514122smalls
smalts85214892smalts
smazes174311662smazes
smiles84522292smiles
snakes103919602snakes
snares65329032snares
soaves94218672soaves
socles8418452socles
soles55547922s_oles
space95325672space_
spaced114517252spaced
spacer104917792spacer
spacers113813872spacers
spacey136212532spacey
spackles16319942spackles
spade84423322spade_
spaded103816752spaded
spader94317132spader
spaders104214472spaders
spae65034322spa_e_
spaed85522272spa_ed
spahee11313442spahee
spahees1238262spahees
spahis11310382spahis
spails84817822spails
spaits85017472spaits
spake114322742spake_
spall74919302spal_l
spalled103113122spalled
spaller92713472spaller
spallers102910722spallers
spams94922192spa_ms
spangles1138892spangles
spanks124514122spanks
spanless10247362spanless
spans74528732spa_ns
spare75135562spare_
spared95427482spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparges104016332sparges
sparkles143210482sparkles
sparks124616362sparks
spars75431542spa_rs
sparse84516342sparse
spas67036722spa__s
spasms10418972spasms
spate74731582spate_
spathes125116532spathes
spats75031382spa_ts
spatzles1935302spatzles
spavies123012942spavies
spawns11577922spawns
spayed124213612spayed
spays105520512spa_ys
spazzes1735262spazzes
speels85116392speels
spells84617682spells
spelts84614642spelts
spices104326032spices
spiels85317952spiels
spies76037622sp_ies
spikes124520712spikes
spile75230082spile_
spiled94621992spiled
spills84717452spills
spines85132032spines
spires84628112spires
spites84127332spites
splakes1349672splakes
splats84817302splats
splays114910872splays
spodes94817432spodes
spokes124417212spokes
spores84726612spores
sprees85620642sprees
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
stables93219072stables
stades74626242stades
stages75629492stages
stakes103927292stakes
stale55637102stale_
staled74728102staled
staler64025822staler
stalest73720172stalest
stalks104614552stalks
stalls64019922stalls
stanes64933402stanes
stapes85028732stapes
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steles63725662steles
stiles64328762stiles
stoles63927672stoles
styles94418652styles
supples11511282supples
swages104417072swages
swale85221592swale_
tales55451372_tales
upases84112902upases
vales85434262_vales
wales86142832_wales
whales124716942whales

Search took 7 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.283631417.0
2DLD Change Limit825512155.73314399.3
3Display Results2152150.1261706.3
 (SQL Overall)1786912156.14229093.3
 
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.