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

117 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
swath11592038(None) 
snath86419801snath
swarth126012081swarth
swash116316751swash
swat77244441swat_
swatch14549281swatch
swathe125514111swathe
swaths125312641swaths
swats85726861swats
swith115917401swith
awash116613162awash
bath95940082_bath
death94822522death
eath75735662_eath
hath105933912_hath
heath115724282heath
lath76640382_lath
loath84918602loath
math95437442_math
neath86020282neath
oath76132152_oath
path99134912_path
rath76037662_rath
saith85826552saith
sash77235302s_ash
sat36288482s_at_
sate45556102s_ate
sati45539322s_ati
scat65848372scat_
scathe114414992scathe
scats75930602scats
scatt76030092scatt
seat47575562seat_
seats54844342seats
shah105627782sha_h
shat76456592shat_
sheath12412882sheath
sith75435152s_ith
sixth155512232sixth
skat87037892skat_
skate94721542skate
skats94621532skats
slash84719682slash
slat46959022slat_
slatch114510532slatch
slate55438282slate
slats55436902slats
slaty86523152slaty
sloth85019442sloth
smash104814432smash
smith107818042smith
snash84815672snash
snatch114310602snatch
snathe94415112snathe
snaths95112912snaths
sooth85924052sooth
soth75932512s_oth
south85223572south
spat66548522spat_
spate74731582spate
spathe115115692spathe
spats75031382spats
staph104314652staph
stash84916972stash
stat47352692stat_
state56237332state
stats55933362stats
strath93216362strath
swab96825312swa_b
swabs105817272swabs
swag87526732swa_g
swage94919562swage
swags94921252swags
swail86217162swail
swain84919052swain
swale85221592swale
swam96329982swa_m
swami105614522swami
swamp125015322swamp
swamy136714402swamy
swan76631312swa_n
swang95519722swang
swank125318232swank
swans84625012swans
swap95925432swa_p
swaps104819202swaps
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218832swarm
swart86234642swart
swarths13537322swarths
swarthy16466372swarthy
swarty125812382swarty
swathed144611932swathed
swather134213592swather
swathes134115512swathes
sway107128232swa_y
sways115518462sways
sweat85628402sweat_
sweats94814612sweats
sweaty123710052sweaty
swish115114822swish
switch14458912switch
swithe124010682swithe
swot75134652swot_
swots85518422swots
synth113711822synth
twat75831512twat_
twats86616602twats
wash106033812_wash
wat67378922_wat_
watch135617062_watch
wats77555882_wats
watt75545412_watt
with105730472_with
wrath115715872wrath

Search took 5 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.0931921408.6
2DLD Change Limit538001173.84313999.5
3Display Results1171170.0631857.1
 (SQL Overall)1786911173.99944683.9
 
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.