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

120 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
scants8521972(None) 
cants77036941_cants
scans74625101scan_s
scant79735071scant_
scanty114014661scanty
scarts85321491scarts
scats75930601sca_ts
scatts85914661scatts
scents85317021scents
secants93413891secants
slants64819081slants
alants67722022alants
ants47243472__ants
ascents93812552ascents
brants85723052brants
canes75350372_canes
cans65050842_can_s
canst74932212_canst
cant66362022_cant_
canto74931012_canto
cantos84826972_cantos
cantus85117762_cantus
canty105226802_canty
carts78946292_carts
casts77237792_casts
cats66356342_ca_ts
cents74730332_cents
chants115020392chants
cunts76125122_cunts
decants103514442decants
descants112910142descants
discants112912022discants
giants74713502giants
grants73722472grants
hants86335402_hants
incants92012802incants
octants9128732octants
pants76536922_pants
plants84921802plants
quants153614142quants
rants55935342_rants
recants93217092recants
saints65122422saints
salts55431882s_alts
sands65228582s_ands
sanes55649072s_anes
sans45153352s_an_s
santo56227282s_anto
santos64421832s_antos
savants1038652savants
scabs94818642sca_bs
scads85419952sca_ds
scags85520972sca_gs
scalds94813692scalds
scales84529312scales
scalls84218202scalls
scalps104315232scalps
scamps125014172scamps
scams94423972sca_ms
scan65530452scan__
scanted104114392scanted
scanter94215182scanter
scantest101710182scantest
scanties103215412scanties
scantly12419552scantly
scapes105122262scapes
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scars75433532sca_rs
scart76139772scart_
scat65848372sca_t_
scatt76030092sca_tt
scatty115310652scatty
scaups105411932scaups
scaurs85512042scaurs
scenas84114702scenas
scends95213002scends
scenes84520352scenes
scent75831622scent_
scones84521302scones
scoots85315932scoots
scots74025902sc_ots
scouts84817942scouts
scuts74522522sc_uts
seats54844342sea_ts
secant84023292secant_
shafts125411432shafts
shanks135315582shanks
shanti94014072shanti
shantis103313082shantis
shanty124715112shanty
shunts95712012shunts
skanks94710832skanks
skats94621532ska_ts
slangs75615342slangs
slant55238702slant_
slanty95114842slanty
slats55436902sla_ts
smalts85214892smalts
smarts86218002smarts
sonants7511232sonants
spaits85017472spaits
spanks124514122spanks
spans74528732span_s
spats75031382spa_ts
stands75118052stands
stanes64933402stanes
stangs75018162stangs
stanks104917702stanks
starts65423122starts
stats55933362sta_ts
stents65019452stents
stints65119762stints
stunts65615252stunts
suints64617782suints
swanks134811562swanks
swans84625012swan_s
swats85726862swa_ts
wants87932212_wants

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.233766914.2
2DLD Change Limit825511205.56314839.3
3Display Results1201200.0801500.0
 (SQL Overall)1786911205.87630410.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.