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

145 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
scant7973507(None) 
cant66362031_cant
scan65530451scan_
scans74625101scans
scants85219721scants
scanty114014661scanty
scart76139771scart
scat65848371sca_t
scatt76030091scatt
scent75831621scent
secant84023291secant
slant55238701slant
alant55742292alant
ant37270792__ant
ascent84519652ascent
askant10412712askant
aslant6317752aslant
avant86224662avant
brant74742172brant
can57760142_can_
cane66653122_cane
cans65050852_cans
canst74932212_canst
canto74931012_canto
cants77036942_cants
canty105226802_canty
cart66570342_cart
cast67159902_cast
cat58282342_ca_t
cent67451012_cent
chant105932692chant
cunt66243672_cunt
decant93524222decant
descant104315592descant
discant103017262discant
giant65430592giant
grant64840022grant
hant75461592_hant
incant82418512incant
leant56737782leant
meant76537212meant
octant81216552octant
pant66061262_pant
plant75437112plant
quant143624812quant
rant45864682_rant
recant83228682recant
riant55833152riant
saint55147072saint
salt45758522s_alt
sand55338472s_and
sane45954342s_ane
sang55441232s_ang
sank85236832s_ank
sans45153362s_ans
santo56227282s_anto
sat36288482s_a_t
savant9416042savant
scab85926712sca_b
scabs94818642scabs
scad75725772sca_d
scads85419962scads
scag76626892sca_g
scags85520972scags
scald84818122scald
scale74629142scale
scall74420372scall
scalp95217982scalp
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scams94423972scams
scanted104114392scanted
scanter94215182scanter
scantly12419552scantly
scape96921842scape
scar66434202sca_r
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scarts85321492scarts
scary105222592scary
scats75930602scats
scatts85914662scatts
scatty115310652scatty
scaup95515992scaup
scaur75814902scaur
scena74815782scena
scend85516292scend
scene77220572scene
scents85317022scents
scone74621832scone
scoot75729152scoot
scot66242612sc_ot
scout75031452scout
scut65835542sc_ut
seat47575562sea_t
secants93413892secants
sejant133114482sejant
sent46963012s_ent
shaft115725272shaft
shalt85534492shalt
shank125422192shank
shanti94014092shanti
shanty124715122shanty
shat76456602sha_t
shent85933502shent
shunt85226512shunt
skank84415582skank
skat87037902ska_t
skint95629222skint
slang66324022slang
slank95822772slank
slants64819082slants
slanty95114842slanty
slat46959022sla_t
smalt74729332smalt
smart75834092smart
sonant6621952sonant
spait75631602spait
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spat66548522spa_t
spent75532832spent
stand65923282stand
stane55933002stane
stang66424682stang
stank95823302stank
start55642312start
stat47352692sta_t
stent55634512stent
stint57037662stint
stunt55328172stunt
suint55638182suint
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
swart86234642swart
swat77244442swa_t
vacant11415132vacant
want76156172_want

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.296603685.8
2DLD Change Limit538001451.62633087.3
3Display Results1451450.0304833.3
 (SQL Overall)1786911451.95291542.5
 
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.