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

207 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
scales8452931(None) 
sales56055591s_ales
scalds94813691scalds
scale74629141scale_
scaled94822441scaled
scaler84321601scaler
scalers93817261scalers
scalls84218201scalls
scalps104315231scalps
scapes105122261scapes
scares85033001scares
shales94731251shales
spales84728101spales
stales65538291stales
swales93920761swales
ales47067102__ales
bales76250082_bales
cables104527552_cables
cades85440732_cades
cafes106426922_cafes
cages85936012_cages
cakes116037672_cakes
calces104420052_calces
calesa8412472_calesa
calfs104919382_calfs
calks115421602_calks
calls75634732_calls
calms95222352_calms
calos74431902_calos
calves115119282_calves
calxes154113032_calxes
cames97047312_cames
canes75350372_canes
capes95441922_capes
cares77369182_cares
carles85435082_carles
cases75048382_cases
cates75951892_cates
caules85927252_caules
caves105639702_caves
coles76055062_coles
dales66439742_dales
escapes113811672escapes
gales65442482_gales
hales85449842_hales
jacales16310322jacales
kales95730982_kales
locales93715092locales
macles107023222macles
males75049792_males
oscules938122oscules
pales75753802_pales
rales54947492_rales
reales64934122reales
rescales103414572rescales
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
scabbles14167982scabbles
scabies11613332scabies
scabs94818642sca_bs
scads85419962sca_ds
scags85520972sca_gs
scalades11258802scalades
scalages113010252scalages
scalar83612432scalar
scalares103210982scalares
scalars93711902scalars
scald84818122scal_d
scalded11409762scalded
scalene9310772scalene
scaleni936882scaleni
scalenus1045542scalenus
scaleup1134482scaleup
scaleups1243392scaleups
scalier94316912scalier
scaliest101714392scaliest
scall74420372scal_l
scalp95217982scal_p
scalped124411992scalped
scalpel11377712scalpel
scalpels12345882scalpels
scalper113912922scalper
scalpers123710862scalpers
scaly104718722scal_y
scamps125014172scamps
scams94423972sca_ms
scans74625102sca_ns
scants85219722scants
scape96921842scape_
scaped115519552scaped
scare75334462scare_
scared95227292scared
scarer84524612scarer
scarers94618512scarers
scarey115016982scarey
scarfs114714682scarfs
scarless10189052scarless
scarlet91516942scarlet
scarlets10178572scarlets
scarps104718602scarps
scars75433532sca_rs
scarts85321492scarts
scarves124511622scarves
scathes124515712scathes
scats75930602sca_ts
scatts85914662scatts
scaups105411932scaups
scaurs85512052scaurs
scenes84520352scenes
schlep1347092schlep
schleps1445482schleps
scolds95011232scolds
scolex1538242scolex
scones84521302scones
scopes104719592scopes
scores84725922scores
scrapes116217662scrapes
screes85023972screes
scries85226822scries
sculks123610262sculks
sculls84613882sculls
sculps104611752sculps
scutes85219192scutes
sealed74328362sealed
sealer63928962sealer
sealers74323552sealers
seals54839692seal_s
selles64426982selles
shades105924532shades
shakes135024592shakes
shale85332832shale_
shaled105023952shaled
shaley123714992shaley
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
sials54227242sial_s
sickles133417542sickles
sidles74721152sidles
skalds11437832skalds
skates104219402skates
slakes104021882slakes
slates64934062slates
slaves95023022slaves
smalls84514122smalls
smalts85214892smalts
smazes174311662smazes
smiles84522292smiles
snakes103919602snakes
snares65329032snares
soaves94218672soaves
socages101012052socages
socles8418452socles
soles55547922s_oles
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spale74929212spale_
spalls84217342spalls
spares84834552spares
spates85028172spates
spiles84227912spiles
stables93219072stables
stades74626242stades
stages75629492stages
stakes103927292stakes
stale55637102stale_
staled74728102staled
staler64025822staler
stalest73720172stalest
stalks104614552stalks
stalls64019932stalls
stanes64933402stanes
stapes85028732stapes
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steles63725662steles
stiles64328772stiles
stoles63927672stoles
styles94418652styles
suckles134516742suckles
swages104417072swages
swale85221592swale_
tales55451372_tales
upscales12155992upscales
vales85434262_vales
wales86142832_wales
whales124716942whales

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.343520965.0
2DLD Change Limit825512072.56332208.7
3Display Results2072070.0633285.7
 (SQL Overall)1786912072.96960185.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.