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

124 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
smogs8511216(None) 
mogs75439331_mogs
shogs95319711shogs
slogs64521841slogs
smog76317411smog_
snogs66017491snogs
amoks11413552amoks
biogs85016112biogs
blogs85319232blogs
bogs75742752_bogs
clogs85519552clogs
cogs77340032_cogs
dogs66440152_dogs
flogs95919962flogs
fogs87035002_fogs
frogs96220772frogs
grogs76319412grogs
hogs87139662_hogs
jogs127129332_jogs
logs57343112_logs
mags75444532_mags
megs75530632_megs
migs76935322_migs
moas65545342_moas
mobs85737372_mobs
mocs85834902_mocs
mods77945052_mods
mog66949672_mog_
mols65948572_mols
moms86539482_moms
mons68152262_mons
moos66051302_moos
mops85940132_mops
mors65950062_mors
mos57067122_mo_s
moss67641032_moss
mots66853162_mots
mows96340832_mows
mugs76232042_mugs
nogs56534612_nogs
osmols8137312osmols
osmous8138182osmous
progs86624152progs
sagos66123872sagos
sags55948402s_ags
scags85520972scags
scops95820192scops
scots74025912scots
scows106617802scows
segos64919482segos
segs54933882s_egs
shags95123862shags
shmoes114612102shmoes
shoes85429662shoes
shog86025142shog_
shogi95014012shogi
shogis103810942shogis
shoos84226362shoos
shops104222902shops
shots84730852shots
shows115324582shows
sings65532702sings
skags104316072skags
skegs105011232skegs
slags66525902slags
slobs74419872slobs
sloes54728872sloes
slog56728272slog_
slops75026012slops
slots54830532slots
slows85323462slows
slugs64618562slugs
smews104612292smews
smock135311672smock
smocks145710012smocks
smoggy1354282smoggy
smoke115015822smoke
smokes124814342smokes
smoky14388682smoky
smolt74824162smolt
smolts84411882smolts
smoosh11236732smoosh
smote75820282smote
smug75815262smug_
smuts75415712smuts
snags64421312snags
snobs74716152snobs
snog55623632snog_
snots55225122snots
snows84719892snows
snugs64913022snugs
sobs64941752s_obs
sods54940212s_ods
sols45448162s_ols
somas76030372somas
soms66239372s_oms
songs67725552songs
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
sumos75720092sumo_s
swags94921252swags
swigs96213662swigs
swobs104910892swobs
swops105913972swops
swots85518432swots
togs57242432_togs
trogs67022602trogs
wogs86531402_wogs

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.296603685.8
2DLD Change Limit538001241.57634137.1
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.90293949.0
 
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.