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) 
nips65830921_nips
ships105123771ships
sips65740101s_ips
skips115616601skips
slips76023721slips
snaps74719561snaps
snibs75613761snibs
snip66424651snip_
snipe75320571snipe
snipes83917391snipes
snits54124831snits
anils56326722anils
anis45746462ani_s
blips95615782blips
chips125721252chips
clips96018302clips
dips75536912_dips
drips85417232drips
flips105117742flips
genips9469942genips
gips75632922_gips
grips85520132grips
hips96433702_hips
kips106430522_kips
knaps115511172knaps
knits93914742knits
knops115911812knops
lips67141442_lips
mips85534082_mips
naps66238582_naps
nibs65028312_nibs
nils46132452_nils
nims66226882_nims
nip56945982_nip_
nipa69421632_nipa
nipas77116672_nipas
nits45741642_nits
pips85837132_pips
quips164713372quips
rips66237432_rips
saids65328852saids
sails55738102sails
sains55639972sains
salps74423242salps
samps96124672samps
sanies63031952sanies
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422552shims
shins85131042shins
ship95228242ship_
shits84731172shits
shivs115018802shivs
shnaps1148082shnaps
shops104222902shops
sibs65933542s_ibs
sics65234092s_ics
simps94719762simps
sims65737172s_ims
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272s_ins
sinus55523852sinus
sip57656012s_ip_
sipe67341042s_ipe
sipes76036952s_ipes
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skeps115614252skeps
skids104615332skids
skies95026832skies
skimps14488042skimps
skims114517192skims
skins94723462skins
skip105421752skip_
skis84825292ski_s
skits94721862skits
slaps76025712slaps
slims75423652slims
slip67031732slip_
slipe75626132slipe
slipes84921412slipes
slipt76627482slipt
slits56128852slits
slops75026012slops
snags64421312snags
snails64816652snails
snap65727032snap_
snaws86116362snaws
sneaps84510862sneaps
sneds65715352sneds
snib66522982sni_b
snick114416012snick
snicks124312472snicks
snide64318722snide
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
tips66436762_tips
trips74923362trips
units54923432units
unrips8199452unrips
unzips17175272unzips
whips134917082whips
yips95226702_yips
zips155723792_zips

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.313570897.8
2DLD Change Limit538001591.62633087.3
3Display Results1591590.0463456.5
 (SQL Overall)1786911591.98590020.7
 
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.