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) 
knits93914751knits
nits45741651_nits
shits84731171shits
sits45050211s_its
skits94721871skits
slits56128851slits
snibs75613761snibs
snips75818011snips
snit46342471snit_
snots55225121snots
spits74429551spits
suits55028051suits
units54923431units
adits66523712adits
aits46355542_aits
anils56326722anils
anis45746472ani_s
antis55033312antis
ants47243472an_ts
baits76630582baits
binits85716672binits
bints76130182bints
bits66148172_bits
brits76433092brits
chits105424572chits
crits75527572crits
dints67431312dints
dits56450532_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043472_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744602_gits
gnats65217712gnats
grits65529582grits
hints87330622hints
hits75545142_hits
intis55121642intis
its35538842__its
kits86441782_kits
knit85728152knit_
knots95614722knots
lints57137192lints
lits46252502_lits
mints76834042mints
nets45941532_nets
nibs65028322_nibs
nils46132462_nils
nims66226892_nims
nips65830932_nips
nit37065952_nit_
nite45943592_nite
nites55736342_nites
nuts45032672_nuts
obits74617552obits
omits75018262omits
pints75936222pints
pits66348752_pits
quits144122352quits
saids65328862saids
sails55738102sails
sains55639972sains
saints65122422saints
saith85826552saith
salts55431882salts
sanies63031952sanies
sanity9316202sanity
satis55633682satis
scats75930602scats
scots74025912scots
scuts74522522scuts
seats54844342seats
sects75622892sects
seifs85019332seifs
seis45542392sei_s
seniti64317222seniti
sennits73811282sennits
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shies86136552shies
shifts124412942shifts
shims104422552shims
shins85131042shins
ships105123772ships
shirts94918342shirts
shist84829612shist
shists96515112shists
shit76745942shit_
shivs115018802shivs
shots84730852shots
shuts85622482shuts
sibs65933552s_ibs
sics65234102s_ics
sifts84918922sifts
silts55330822silts
sims65737182s_ims
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755282s_ins
sinus55523852sinus
sips65740112s_ips
sirs44338342s_irs
sis37360552s_i_s
sit35877762s_it_
site47052422s_ite
sites56045432s_ites
sith75435162s_ith
situs55019232s_itus
skats94621542skats
skids104615342skids
skies95026842skies
skims114517202skims
skins94723472skins
skips115616612skips
skirts104111502skirts
skis84825302ski_s
skit85437542skit_
skite95120062skite
skites104418042skites
slats55436902slats
slims75423652slims
slips76023722slips
slit46250102slit_
slots54830532slots
sluts54523982sluts
smit65138412smit_
smite75224872smite
smites83921922smites
smith107818052smith
smiths114711022smiths
smuts75415712smuts
snags64421312snags
snails64816652snails
snaps74719562snaps
snath86419802snath
snaths95112912snaths
snaws86116362snaws
sneds65715352sneds
snib66522982sni_b
snick114416012snick
snicks124312472snicks
snide64318732snide
sniff113915862sniff
sniffs12378842sniffs
snip66424652sni_p
snipe75320572snipe
snipes83917392snipes
snitch11357942snitch
snobs74716152snobs
snogs66017492snogs
snoots64216682snoots
snorts64116502snorts
snot44745452snot_
snouts64915872snouts
snows84719892snows
snubs75412552snubs
snugs64913022snugs
snyes85012752snyes
softs85019232softs
soils55327982soils
sonics84315632sonics
soots55536212soots
sorts54536662sorts
sots45552452s_ots
spaits85017472spaits
spats75031382spats
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spirts85317132spirts
spit65545082spit_
spite75430662spite
spites84127332spites
spitz166017972spitz
spivs105114242spivs
splits85416412splits
spots74424112spots
sprits85122532sprits
sris45434152sri_s
stats55933362stats
stets55423912stets
sties55132982sties
stilts67915312stilts
stints65119762stints
stirs55921622stirs
stots54828552stots
suets55126102suets
suints64617782suints
suit45649872suit_
suite54829562suite
suites63727402suites
swats85726862swats
swifts12408172swifts
swigs96213662swigs
swims105514142swims
swiss86712902swiss
swith115917402swith
swots85518432swots
tints56030922tints
tits46145052_tits
toits55327472toits
twits86015792twits
unfits93910292unfits
unit45140072unit_
unite54828382unite
unites65024852unites
unity84918492unity
unwits9389892unwits
waits88333522waits
whits115923822whits
wits76044882_wits
writs86624382writs
zits136030302_zits

Search took 3 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.296603685.8
2DLD Change Limit538002241.72031279.1
3Display Results2242240.0603733.3
 (SQL Overall)1786912242.07686074.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.