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

143 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
swigs9621366(None) 
swags94921251swags
swig85818021swig_
swims105514141swims
swings104714451swings
swiss86712901swiss
twigs96911171twigs
wigs84931251_wigs
bewigs1246532bewigs
bigs76235022_bigs
brigs85823222brigs
cigs75625102_cigs
digs66036052_digs
figs85332642_figs
frigs96019272frigs
gigs66631182_gigs
grigs75318192grigs
iwis77117012iwi_s
jigs126524762_jigs
migs76935322_migs
pigs76634222_pigs
prigs85219702prigs
rigs55137592_rigs
sags55948402s_ags
saids65328852saids
saiga64717932saiga
saigas74114292saigas
sails55738102sails
sains55639972sains
scags85520972scags
segs54933882s_egs
seifs85019332seifs
seis45542392sei_s
sewings11369172sewings
shags95123862shags
shies86136552shies
shims104422552shims
shins85131042shins
ships105123772ships
shits84731172shits
shivs115018802shivs
shogs95319712shogs
sibs65933542s_ibs
sics65234092s_ics
sigh85625892s_igh
sighs95416742s_ighs
sign55523052s_ign
signs65516322s_igns
sims65737172s_ims
sings65532702sings
sins46755272s_ins
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skags104316072skags
skegs105011232skegs
skids104615332skids
skies95026832skies
skims114517192skims
skins94723462skins
skips115616602skips
skis84825292ski_s
skits94721862skits
slags66525902slags
slims75423652slims
slings74618012slings
slips76023722slips
slits56128852slits
slogs64521842slogs
slugs64618562slugs
smogs85112162smogs
snags64421312snags
snibs75613762snibs
snips75818012snips
snits54124832snits
snogs66017492snogs
snugs64913022snugs
soils55327982soils
songs67725552songs
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spits74429552spits
spivs105114242spivs
sprigs94814772sprigs
sris45434152sri_s
stags66226742stags
staigs75414812staigs
sties55132982sties
stings76220182stings
stirs55921622stirs
suits55028052suits
swabs105817272swabs
swag87526732swag_
swage94919562swage
swages104417072swages
swails94913122swails
swains94513952swains
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
swift116818052swift
swifts12408172swifts
swill83417372swill
swills94213362swills
swim96221402swi_m
swine85625302swine
swing96124842swing
swinge105614382swinge
swinges113413422swinges
swingy13489872swingy
swink125116352swink
swinks134610652swinks
swipe105217082swipe
swipes114114332swipes
swirl84514142swirl
swirls94010132swirls
swish115114822swish
swith115917402swith
swive115316192swive
swives123915182swives
swobs104910892swobs
swops105913972swops
swots85518432swots
trigs65423062trigs
twig87615772twig_
twins85118982twins
twits86015792twits
vigs85427272_vigs
wags86140552_wags
whigs125612642whigs
wig76740382_wig_
wings95727242_wings
wins75949172_wins
wis66552332_wi_s
wiss75630542_wiss
wits76044872_wits
wogs86531402_wogs
ywis105313102ywi_s
zigs145422792_zigs

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.310576422.6
2DLD Change Limit538001431.44037361.1
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.780100388.2
 
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.