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

150 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
snogs6601749(None) 
nogs56534611_nogs
shogs95319711shogs
slogs64521841slogs
smogs85112161smogs
snags64421311snags
snobs74716151snobs
snog55623631snog_
snots55225121snots
snows84719891snows
snugs64913021snugs
songs67725551songs
anoas57226492anoas
biogs85016112biogs
blogs85319232blogs
bogs75742752_bogs
bongs87828422bongs
clogs85519552clogs
cogs77340032_cogs
dogs66440152_dogs
dongs76525812dongs
engs56121392en_gs
enols54718402enols
enows85115492enows
flogs95919962flogs
fogs87035002_fogs
frogs96220772frogs
gongs74921612gongs
grogs76319412grogs
hogs87139662_hogs
hongs95126202hongs
incogs937902incogs
jogs127129332_jogs
knobs11519712knobs
knops115911812knops
knots95614722knots
knows124912412knows
logs57343112_logs
longs65527062longs
mogs75439332_mogs
nags55436022_nags
negs55727362_negs
nobs66436902_nobs
nods55838222_nods
noes45845392_noes
nog46847312_nog_
nogg65115942_nogg
noggs75811182_noggs
noms65636402_noms
nos38859322_no_s
nous46136982_nous
nows75738232_nows
onos46229002ono_s
pongs85526342pongs
progs86624152progs
sagos66123872sagos
sags55948402s_ags
scags85520972scags
scops95820192scops
scots74025912scots
scows106617802scows
segos64919482segos
segs54933882s_egs
senors63620792senors
shags95123862shags
shoes85429662shoes
shog86025142shog_
shogi95014012shogi
shogis103810942shogis
shoos84226362shoos
shops104222902shops
shots84730852shots
shows115324582shows
sings65532702sings
skags104316072skags
skegs105011232skegs
slags66525902slags
slobs74419872slobs
sloes54728872sloes
slog56728272slog_
slops75026012slops
slots54830532slots
slows85323462slows
slugs64618562slugs
smog76317412smog_
snag55827872snag_
snaps74719562snaps
snaws86116362snaws
sneds65715352sneds
snibs75613762snibs
snips75818012snips
snits54124832snits
snob65825592sno_b
snood64616162snood
snoods74312452snoods
snook95115572snook
snooks104412832snooks
snool55118642snool
snools65715882snools
snoop75317172snoop
snoops84314172snoops
snoot55030142snoot
snoots64216682snoots
snore55424952snore
snores64324322snores
snort54833752snort
snorts64116502snorts
snot44745452sno_t
snout54530632snout
snouts64915872snouts
snow76324792sno_w
snowy115011562snowy
snubs75412552snubs
snug55218692snug_
snyes85012752snyes
sobs64941752s_obs
sods54940212s_ods
sols45448162s_ols
soms66239372s_oms
sones55444142sones
song55133672song_
sons46049552s_ons
sooks94425452sooks
soots55536212soots
sops65244562s_ops
sos37761602s_o_s
sots45552452s_ots
sous46947212s_ous
sows75342492s_ows
soys75233932s_oys
spots74424112spots
stags66226742stags
stoas55126022stoas
stobs75718232stobs
stogy95414082stogy
stops74827282stops
stoss54316342stoss
stots54828552stots
stows86622702stows
sundogs947102sundogs
swags94921252swags
swigs96213662swigs
swobs104910892swobs
swops105913972swops
swots85518432swots
synods1077952synods
togs57242432_togs
tongs65928462tongs
trogs67022602trogs
wogs86531402_wogs

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 Limit538001501.75030742.9
3Display Results1501500.0334545.5
 (SQL Overall)1786911502.07985950.5
 
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.