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 “popgun” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
popgun114573(None) 
popguns1234021popguns
oppugn1142792oppugn
poplin10413482poplin
progun968782progun
begun85113443_begun
blowgun1342653blowgun
bogan87519003bo_gan
bogus85616473bo_gus
bosun75113593bo_sun
cogon89120903co_gon
coign85013913coig_n
copen94826433cop_en
copout10418783copout
gorgon8310243gorgon
gun47240803___gun
hogan97817703ho_gan
impugn1143163impugn
korun9411923ko_run
logan68123283lo_gan
login66025003lo_gin
logon615922313lo_gon
longan75612363longan
mogul8310213mo_gul
morgan9311373morgan
morgen9312203morgen
morgue938113morgue
noggin8288883noggin
noun45724183no__un
open66427003_op_en
opium92812093_opium
oppugns1241933oppugns
opsin7613473_opsin
opus66420593_op_us
organ6915393_organ
outgun7349643outgun
pagan86121163p_agan
pangen94115913pangen
papain10313793papain
pappus9408373pappus
penguin1045873penguin
peplum12156823peplum
peplus10138343peplus
pepsin10310853pepsin
pidgin10259813pidgin
piggin103111093piggin
pigpen1136583pigpen
pipkin14248603pipkin
pippin92810303pippin
plague93610853plague
plaguy12386413plaguy
podgy125610773podg_y
podium112911913podium
pogey116017893po_gey
pogy105623553po_g_y
poilu72316003poilu_
poilus82210573poilus
poison8312223poison
poleyn1157323poleyn
pollen83416453pollen
polygon1346933polygon
pompon1238943pompon
pompous1338063pompous
pong76231143pong__
ponged105619353ponged
pongee94920193pongee
pongid104111583pongid
ponging113416153ponging
pongs85526343pong_s
ponton83217643ponton
poon67341263po__on
pop76252253pop___
popcorn1344903popcorn
pope85535613pop__e
popery134511703popery
popes95933813pop_es
popish133812113popish
poplar103611113poplar
poplins11313153poplins
poppa8409893pop_pa
poppas93710713poppas
popped104117813popped
popper93615963popper
poppet92717323poppet
popping113715413popping
popple92710983popple
poppy114813193pop_py
pops86340953pop__s
popsie103013053popsie
popsy125713403pop_sy
porgy116916123porg_y
porn65636023po__rn
porous84419483porous
poseur8419403poseur
possum1057953possum
postin83521033postin
poteen83514263poteen
potful1138083potful
potion84519573potion
potman102813573potman
potmen102713093potmen
pouf95732643po__uf
pound84417863po__und
pour611527473po__ur
pout65752553po__ut
poyou102611523poyou_
poyous112911623poyous
pronoun939033pronoun
propman1339063propman
propmen1338763propmen
propound1346393propound
pun58846513__p_un
pupu87620713pup_u_
pupus94614043pup_us
repugn946493repugn
rogue66417533ro_gue
rotgut738793rotgut
shogun1045713shogun
shotgun1143003shotgun
spongin1036373spongin
spun66221463_sp_un
togue64816303to_gue
tongue7410093tongue
topful1136543topful
tophus115210363tophus
vodoun1036233vodoun
vodun937223vo_dun
vogue95613043vo_gue
wangun1037103wangun
yogin98317743yo_gin

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161305.70319764.3
3Display Results1301300.0304333.3
 (SQL Overall)1786911306.12329183.6
 
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.