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

159 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
snips7581801(None) 
nips65830931_nips
ships105123771ships
sips65740111s_ips
skips115616611skips
slips76023721slips
snaps74719561snaps
snibs75613761snibs
snip66424651snip_
snipe75320571snipe
snipes83917391snipes
snits54124831snits
anils56326722anils
anis45746472ani_s
blips95615782blips
chips125721252chips
clips96018302clips
dips75536922_dips
drips85417232drips
flips105117742flips
genips9469942genips
gips75632932_gips
grips85520132grips
hips96433712_hips
kips106430532_kips
knaps115511172knaps
knits93914752knits
knops115911812knops
lips67141452_lips
mips85534092_mips
naps66238582_naps
nibs65028322_nibs
nils46132462_nils
nims66226892_nims
nip56945992_nip_
nipa69421642_nipa
nipas77116672_nipas
nits45741652_nits
pips85837142_pips
quips164713372quips
rips66237442_rips
saids65328862saids
sails55738102sails
sains55639972sains
salps74423242salps
samps96124672samps
sanies63031952sanies
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422552shims
shins85131042shins
ship95228242ship_
shits84731172shits
shivs115018802shivs
shnaps1148082shnaps
shops104222902shops
sibs65933552s_ibs
sics65234102s_ics
simps94719762simps
sims65737182s_ims
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755282s_ins
sinus55523852sinus
sip57656022s_ip_
sipe67341052s_ipe
sipes76036952s_ipes
sirs44338342s_irs
sis37360552s_i_s
sits45050212s_its
skeps115614252skeps
skids104615342skids
skies95026842skies
skimps14488042skimps
skims114517202skims
skins94723472skins
skip105421762skip_
skis84825302ski_s
skits94721872skits
slaps76025712slaps
slims75423652slims
slip67031732slip_
slipe75626132slipe
slipes84921412slipes
slipt76627482slipt
slits56128852slits
slops75026012slops
snags64421312snags
snails64816652snails
snap65727032snap_
snaws86116362snaws
sneaps84510862sneaps
sneds65715352sneds
snib66522982sni_b
snick114416012snick
snicks124312472snicks
snide64318732snide
sniff113915862sniff
sniffs12378842sniffs
sniped94913482sniped
sniper84413642sniper
snipers93311772snipers
snippy1374842snippy
snit46342472sni_t
snobs74716152snobs
snogs66017492snogs
snoops84314172snoops
snots55225122snots
snows84719892snows
snubs75412552snubs
snugs64913022snugs
snyes85012752snyes
soaps75120712soaps
soils55327982soils
sonics84315632sonics
sops65244562s_ops
soups75322942soups
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spits74429552spits
spivs105114242spivs
sris45434152sri_s
steps76619882steps
sties55132982sties
stipe76523372stipe
stipes84524052stipes
stirps85011822stirps
stirs55921622stirs
stops74827282stops
strips85719652strips
suits55028052suits
sumps95023432sumps
sunups837262sunups
sups64834432s_ups
swaps104819202swaps
swigs96213662swigs
swims105514142swims
swipe105217082swipe
swipes114114332swipes
swiss86712902swiss
swops105913972swops
tips66436772_tips
trips74923362trips
units54923432units
unrips8199452unrips
unzips17175272unzips
whips134917082whips
yips95226712_yips
zips155723802_zips

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.303589739.3
2DLD Change Limit538001591.47036598.6
3Display Results1591590.0305300.0
 (SQL Overall)1786911591.80399107.6
 
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.