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

132 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
swang9551972(None) 
sang55441231s_ang
slang66324021slang
spang84919731spang
stang66424681stang
swag87526731swa_g
swan76631311swan_
swank125318231swank
swans84625011swans
swing96124841swing
swung95610561swung
twang94511851twang
alang66023512alang
awing96827322awing
bang74837002_bang
bhang115512922bhang
bwana10310242bwana
chang115418562chang
clang86019312clang
dang65131542_dang
fang85432552_fang
gang66031972_gang
hang85535552_hang
hwan105716892hwan_
kiang104811352kiang
lang56637382_lang
liang64914412liang
orang65119942orang
owing96222722owing
pang75336292_pang
prang84820322prang
rang56939162_rang
sag46163402s_a_g
sand55338472s_and
sane45954342s_ane
sanga66023792s_anga
sangh95517452s_angh
sank85236832s_ank
sans45153362s_ans
satang75711562satang
sawing104323812sawing
sawn75428162sawn_
scag76626892sca_g
scan65530452scan_
scans74625102scans
scant79735072scant
sewan85921292sewan_
sewans95215902sewans
sewing103819622sewing
shag86430562sha_g
shank125422192shank
sing57544172s_ing
skag96321512ska_g
skank84415582skank
slag55934352sla_g
slangs75615342slangs
slangy105411392slangy
slank95822772slank
slant55238702slant
sling66028802sling
slung65117832slung
snag55827872sna_g
song55133672s_ong
sowans94215892sowans
sowing104222912sowing
span65234662span_
spank115919572spank
spans74528732spans
sprang95713522sprang
stag57332002sta_g
staig65519642staig
stand65923282stand
stane55933002stane
stangs75018162stangs
stank95823302stank
sting65330242sting
strang75718312strang
stung65417152stung
suing65026362suing
sung55832172s_ung
swab96825312swa_b
swabs105817272swabs
swage94919562swage
swaging124210632swaging
swags94921252swags
swail86217162swail
swain84919052swain
swains94513952swains
swale85221592swale
swam96329982swa_m
swami105614522swami
swamp125015322swamp
swamy136714402swamy
swanks134811562swanks
swanky16447972swanky
swanny12336822swanny
swap95925432swa_p
swaps104819202swaps
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swats85726862swats
sway107128232swa_y
swaying143610642swaying
sways115518462sways
swig85818022sw_ig
swine85625302swine
swinge105614382swinge
swings104714452swings
swingy13489872swingy
swink125116352swink
tang56138672_tang
twangs10358092twangs
twangy13386982twangy
vang84926042_vang
wag76451752_wa_g
wan66761942_wan_
wand85833882_wand
wane76344722_wane
wank115632512_wank
wans76452272_wans
want76156172_want
wany106432362_wany
whang124813382whang
wing86339222_wing
wrang94716112wrang
yang85626072_yang

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.313570897.8
2DLD Change Limit538001321.53035163.4
3Display Results1321320.0462869.6
 (SQL Overall)1786911321.88994595.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.