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

184 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
pinged10432138(None) 
binged105920821binged
dinged95221781dinged
hinged114618911hinged
kinged124215281kinged
panged104722331panged
pigged114214151pigged
pined85935321pin_ed
pinger94324091pinger
pinked134819881pinked
pinned94818381pinned
ponged105619351ponged
ringed84623841ringed
singed85422291singed
tinged84220791tinged
winged114620831winged
zinged174414621zinged
banged104923722banged
bilged105513182bilged
binge85125512binge_
binger94923452binger
binges93923122binges
binned94414542binned
bonged105719602bonged
bunged105218792bunged
clinged113310092clinged
cringed113312402cringed
danged94819482danged
digged104314652digged
dined76431992din_ed
dinge75627302dinge_
dinger85323672dinger
dinges83825422dinges
dingey114914052dingey
dinked124818352dinked
dinned84317612dinned
dinted84419842dinted
dunged95414692dunged
fanged114318222fanged
fidged124610922fidged
figged124013892figged
fined94930502fin_ed
finger104920332finger
finked144214622finked
finned104114602finned
fringed123611522fringed
ganged94619192ganged
gigged104112292gigged
ginger84920032ginger
ginned83813982ginned
gonged97115912gonged
hanged114222392hanged
hinge95323442hinge_
hinger104723322hinger
hinges105121022hinges
hinted104318322hinted
igged86012762_igged
impinged14275122impinged
inked104218522_inked
inned64118422_inned
jigged164412772jigged
jingled164111062jingled
jinked184013142jinked
jinxed21346082jinxed
kinked104014752kinked
lined64934642lin_ed
linger75226002linger
linked114518212linked
linted74021822linted
longed87121372longed
lunged85418272lunged
minced114114912minced
minded103817832minded
mined85333352min_ed
mingled113612732mingled
minted94220582minted
oinked114213282oinked
opined95113852opin_ed
paged95926782p_aged
pained95622852pain_ed
painted104214632painted
paned85437182pan_ed
pangen94115912pangen
panned94123432panned
panted95024822panted
parged104922032parged
pegged114811902pegged
peined94918842pein_ed
pended103819012pended
penned94217612penned
picked154421312picked
pieced113912102pieced
pied75035362pi__ed
piked125623312pi_ked
piled85232992pi_led
pilled94222752pilled
pimped134913482pimped
pincer104019172pincer
pinched153812452pinched
pinder94523452pinder
pine67755712pin_e_
pines76048862pin_es
piney105727502pin_ey
ping75943592ping__
pingers104020742pingers
pingo87122712ping_o
pingoes105116522pingoes
pingos95317672pingos
pings85830882ping_s
pinguid1146232pinguid
pinhead13347072pinhead
pinier84024692pinier
pinken124513282pinken
pinker125322442pinker
pinkey154314672pinkey
pinner84521502pinner
pinweed1346932pinweed
piped105123162pi_ped
pipped104516542pipped
piqued1836212piqued
pished124817062pished
pissed94816932pissed
pithed124615612pithed
pitied94017252pitied
pitted94319592pitted
plinked143910892plinked
plunged11439512plunged
poinded11358972poinded
pointed103813982pointed
ponced114314812ponced
ponded105218772ponded
pongee94920192pongee
pongid104111582pongid
ponied94920702ponied
pranged114512552pranged
prigged12398922prigged
prinked143412162prinked
printed104016372printed
pronged113912392pronged
pugged114314522pugged
pungled114210082pungled
punned93416192punned
punted94618712punted
purged104918262purged
ranged84824312ranged
ridged94014212ridged
rigged94517402rigged
rinded84418982rinded
ringer74526062ringer
rinsed75016352rinsed
sieged85212712sieged
signed83413752signed
singe65731132singe_
singer74227312singer
singes74326852singes
singled93914682singled
sinned73818412sinned
spined95423942spin_ed
sponged1137952sponged
springed123911312springed
swinged123810792swinged
tanged84622492tanged
tined65434532tin_ed
tinge64626612tinge_
tinges74722322tinges
tingled93712792tingled
tinned74317532tinned
tinted74419532tinted
tonged86518902tonged
twinged12398352twinged
venged114011982venged
vined95626152vin_ed
whinged15409142whinged
wigged124413582wigged
winced124415342winced
winded114918212winded
wined94434182win_ed
winger104125442winger
winked144018602winked
winned104017012winned
wringed123710192wringed
zigged184110192zigged
zinced18419412zinced
zinger163816702zinger

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 Filter178691825510.1101624463.6
2DLD Change Limit825511842.23336968.7
3Display Results1841840.0632920.6
 (SQL Overall)1786911842.40674268.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.