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 “swash” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
swash11631675(None) 
awash116613161awash
sash77235301s_ash
slash84719681slash
smash104814431smash
snash84815671snash
stash84916971stash
swath115920381swath
swish115114821swish
wash106033811_wash
abash106016512abash
ash67944602__ash
bash915240162_bash
brash106221562brash
cash96636282_cash
clash106219032clash
crash109120012crash
dash87031632_dash
deash95617242deash
fash107232292_fash
flash115716212flash
gash86833022_gash
gnash9449832gnash
hash106936502_hash
lash76539652_lash
leash85519212leash
mash96039392_mash
pash95638132_pash
plash104616562plash
quash174512162quash
rash76039932_rash
rewash1237672rewash
sass45035622s_ass
saws75839482saws_
seas45755272seas_
shah105627782sha_h
shahs115919512shahs
shush113812542shush
shwas116415102shwas_
skas85325712skas_
skosh12407262skosh
slosh84514482slosh
slush85316572slush
smush104410582smush
snath86419802snath
spas67036722spas_
spasm94514172spasm
splash1168822splash
squash1846832squash
staph104314652staph
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
swarth126012082swarth
swashed144311362swashed
swasher134011512swasher
swashes134714402swashes
swat77244442swa_t
swatch14549282swatch
swathe125514112swathe
swaths125312642swaths
swats85726862swats
sway107128232swa_y
sways115518462sways
swishy15365842swishy
swiss86712902swiss
swith115917402swith
swoosh12195212swoosh
trash86119762trash
twas76824082twas_
was68767562_was_
washy145911842_washy
wasp95626852_wasp
wast75655852_wast
wish107228732_wish

Search took 4 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.1731032896.0
2DLD Change Limit53800953.32616175.6
3Display Results95950.0332878.8
 (SQL Overall)178691953.53250592.0
 
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.