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

224 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
snits5412483(None) 
knits93914741knits
nits45741641_nits
shits84731161shits
sits45050201s_its
skits94721851skits
slits56128851slits
snibs75613761snibs
snips75818011snips
snit46342471snit_
snots55225101snots
spits74429551spits
suits55028051suits
units54923431units
adits66523712adits
aits46355532_aits
anils56326722anils
anis45746462ani_s
antis55033312antis
ants47243472an_ts
baits76630582baits
binits85716672binits
bints76130182bints
bits66148162_bits
brits76433082brits
chits105424572chits
crits75527572crits
dints67431312dints
dits56450522_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744592_gits
gnats65217712gnats
grits65529582grits
hints87330622hints
hits75545132_hits
intis55121642intis
its35538832__its
kits86441762_kits
knit85728142knit_
knots95614722knots
lints57137192lints
lits46252492_lits
mints76834042mints
nets45941532_nets
nibs65028312_nibs
nils46132452_nils
nims66226882_nims
nips65830922_nips
nit37065942_nit_
nite45943582_nite
nites55736342_nites
nuts45032672_nuts
obits74617552obits
omits75018262omits
pints75936222pints
pits66348742_pits
quits144122352quits
saids65328852saids
sails55738102sails
sains55639972sains
saints65122422saints
saith85826552saith
salts55431882salts
sanies63031952sanies
sanity9316202sanity
satis55633672satis
scats75930602scats
scots74025902scots
scuts74522522scuts
seats54844342seats
sects75622892sects
seifs85019332seifs
seis45542392sei_s
seniti64317212seniti
sennits73811282sennits
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shies86136552shies
shifts124412932shifts
shims104422542shims
shins85131042shins
ships105123772ships
shirts94918332shirts
shist84829602shist
shists96515102shists
shit76745932shit_
shivs115018802shivs
shots84730832shots
shuts85622472shuts
sibs65933542s_ibs
sics65234092s_ics
sifts84918922sifts
silts55330822silts
sims65737172s_ims
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272s_ins
sinus55523852sinus
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sit35877752s_it_
site47052412s_ite
sites56045432s_ites
sith75435152s_ith
situs55019232s_itus
skats94621532skats
skids104615322skids
skies95026832skies
skims114517182skims
skins94723462skins
skips115616602skips
skirts104111502skirts
skis84825282ski_s
skit85437522skit_
skite95120042skite
skites104418032skites
slats55436902slats
slims75423652slims
slips76023722slips
slit46250102slit_
slots54830522slots
sluts54523982sluts
smit65138412smit_
smite75224872smite
smites83921922smites
smith107818052smith
smiths114711022smiths
smuts75415712smuts
snags64421312snags
snails64816652snails
snaps74719562snaps
snath86419802snath
snaths95112912snaths
snaws86116362snaws
sneds65715352sneds
snib66522982sni_b
snick114416012snick
snicks124312472snicks
snide64318722snide
sniff113915862sniff
sniffs12378842sniffs
snip66424652sni_p
snipe75320572snipe
snipes83917392snipes
snitch11357942snitch
snobs74716152snobs
snogs66017492snogs
snoots64216662snoots
snorts64116492snorts
snot44745442snot_
snouts64915862snouts
snows84719882snows
snubs75412552snubs
snugs64913022snugs
snyes85012752snyes
softs85019232softs
soils55327982soils
sonics84315632sonics
soots55536202soots
sorts54536662sorts
sots45552442s_ots
spaits85017472spaits
spats75031382spats
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spirts85317132spirts
spit65545082spit_
spite75430662spite
spites84127332spites
spitz166017962spitz
spivs105114242spivs
splits85416412splits
spots74424102spots
sprits85122532sprits
sris45434152sri_s
stats55933362stats
stets55423912stets
sties55132982sties
stilts67915302stilts
stints65119762stints
stirs55921612stirs
stots54828542stots
suets55126102suets
suints64617782suints
suit45649872suit_
suite54829562suite
suites63727402suites
swats85726862swats
swifts12408172swifts
swigs96213662swigs
swims105514142swims
swiss86712902swiss
swith115917402swith
swots85518422swots
tints56030922tints
tits46145032_tits
toits55327472toits
twits86015792twits
unfits93910292unfits
unit45140072unit_
unite54828382unite
unites65024852unites
unity84918492unity
unwits9389892unwits
waits88333522waits
whits115923822whits
wits76044872_wits
writs86624382writs
zits136030292_zits

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.0931921408.6
2DLD Change Limit538002241.48636204.6
3Display Results2242240.0603733.3
 (SQL Overall)1786912241.639109024.4
 
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.