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

166 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
dinged9522178(None) 
binged105920821binged
danged94819481danged
digged104314651digged
dined76431991din_ed
dinge75627301dinge_
dinger85323671dinger
dinges83825421dinges
dingey114914051dingey
dinked124818351dinked
dinned84317611dinned
dinted84419841dinted
dunged95414691dunged
hinged114618921hinged
kinged124215291kinged
pinged104321381pinged
ringed84623841ringed
singed85422291singed
tinged84220801tinged
winged114620831winged
zinged174414621zinged
banged104923722banged
bilged105513182bilged
binge85125512binge_
binger94923452binger
binges93923122binges
binned94414542binned
bonged105719602bonged
bunged105218792bunged
clinged113310092clinged
cringed113312402cringed
danced105315252danced
danger83722822danger
dangled104013152dangled
deigned1037502deigned
denied84318632denied
denned84215632denned
dented84120512dented
dialed84716452dialed
dibbed124713472dibbed
diced95824682di_ced
dicked144920862dicked
died66137852di__ed
dieted83115492dieted
digger94616082digger
diked115024682di_ked
dilled84122222dilled
dimmed124110322dimmed
dindled104412722dindled
dine55555332din_e_
diner65632902din_er
dines66449152din_es
ding66940952ding__
dingers94321382dingers
dingeys12458402dingeys
dinghy14476962dinghy
dingier93513672dingier
dingies93618242dingies
dingle84317072dingle
dingles93818322dingles
dingo74720792ding_o
dingoes94114832dingoes
dings76331402ding_s
dingus83611842dingus
dingy105721262ding_y
dinkey144812762dinkey
dinner74217162dinner
dipped123517492dipped
dirge75117072dirge_
dirges84915102dirges
dirked124912272dirked
dirled84514902dirled
disced104914652disced
dished114318712dished
disked125015762disked
dissed85220182dissed
dived106321372di_ved
dodged107514692dodged
dogged106017702dogged
donned85015742donned
dunked124315282dunked
dunned85015522dunned
dunted84718502dunted
dwined114610212dwin_ed
fanged114318222fanged
fidged124610932fidged
figged124013892figged
fined94930502fin_ed
finger104920332finger
finked144214622finked
finned104114602finned
fringed123611522fringed
ganged94619192ganged
gigged104112292gigged
ginger84920032ginger
ginned83813982ginned
gonged97115912gonged
hanged114222392hanged
hinge95323452hinge_
hinger104723332hinger
hinges105121032hinges
hinted104318322hinted
igged86012762_igged
inked104218522_inked
inned64118422_inned
jigged164412772jigged
jingled164111062jingled
jinked184013142jinked
jinxed21346082jinxed
kinked104014752kinked
lined64934642lin_ed
linger75226002linger
linked114518212linked
linted74021822linted
longed87121372longed
lunged85418272lunged
minced114114912minced
minded103817832minded
mined85333352min_ed
mingled113612732mingled
minted94220582minted
oinked114213282oinked
panged104722332panged
pigged114214152pigged
pined85935322pin_ed
pinger94324092pinger
pinked134819882pinked
pinned94818382pinned
ponged105619352ponged
ranged84824312ranged
ridged94014222ridged
rigged94517402rigged
rinded84418982rinded
ringer74526062ringer
rinsed75016352rinsed
sieged85212712sieged
signed83413752signed
singe65731132singe_
singer74227312singer
singes74326852singes
singled93914682singled
sinned73818412sinned
swinged123810792swinged
tanged84622492tanged
tined65434532tin_ed
tinge64626622tinge_
tinges74722332tinges
tingled93712802tingled
tinned74317532tinned
tinted74419532tinted
tonged86518902tonged
twinged12398362twinged
venged114011992venged
vined95626152vin_ed
whinged15409152whinged
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.343520965.0
2DLD Change Limit825511662.17337989.4
3Display Results1661660.0463608.7
 (SQL Overall)1786911662.56269746.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.