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

175 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
conned9511970(None) 
canned95022061canned
coined94523601coined
coned86040051co_ned
conked135019111conked
conner84423961conner
corned95224521corned
donned85015741donned
wonned104012061wonned
acorned10238272acorned
banned94721342banned
binned94414542binned
bonded104719952bonded
boned85133242bo_ned
bonged105719602bonged
bonked135517312bonked
bonne75124712bonne_
bonnes85621452bonnes
bonnet85524632bonnet
caned85838092c_aned
cannel84216402cannel
canner84625982canner
canoed94618962canoed
canted94825782canted
censed94016322censed
chined125620062chined
chinned134810492chinned
cloned94518802cloned
clonked14429562clonked
clowned13447732clowned
coaled95022712coaled
coannex1635512coannex
coated94927042coated
coaxed165612512coaxed
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
cogged116416612cogged
coifed124113062coifed
coigned11418662coigned
coiled95123942coiled
coiner84323782coiner
coked124730692co_ked
coled85540762co_led
combed135516542combed
comped135919872comped
concede12310102concede
condoned122612022condoned
cone67256962co_ne_
cones76457422co_nes
coney105932882co_ney
confer114018682confer
confined14310402confined
congaed11399742congaed
conge85227592conge_
congee96024472congee
congeed113212312congeed
conger95024272conger
conges94928172conges
conies84338592conies
conine84528552conine_
conines93827792conines
conker124721552conker
conn66229132conn__
connect113515742connect
conners94023112conners
connived1436432connived
connoted1138862connoted
conns75024232conn_s
conoid9818882conoid
conte76633202conte_
contend103511892contend
contes84432912contes
convened143412222convened
convex18367742convex
convey144610222convey
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224592cooled
cooped114821602cooped
coped105036842co_ped
copied114618562copied
copped135221252copped
corded105923352corded
cored85044222co_red
corked135020782corked
cornea84018922cornea
cornel84020052cornel
corner84625622corner
cornet84436732cornet
cornfed1337382cornfed
coshed124217542coshed
cosied94819882cosied
costed95623112costed
coted85033852co_ted
counted103815802counted
couped115019312couped
coved115027372co_ved
cowed115637852co_wed
cowled125218392cowled
coxed154322812co_xed
coyed114623802co_yed
cozened19349182cozened
cozied184112152cozied
craned96121652craned
crooned103813342crooned
crowned133912432crowned
cunner83915002cunner
denned84215632denned
dinned84317612dinned
donne65520462donne_
donnee74317062donnee
donnerd9427812donnerd
downed115314782downed
dunned85015522dunned
fanned104117472fanned
finned104114602finned
foined105915012foined
fonded115717042fonded
funned103613952funned
ginned83813982ginned
gonged97115912gonged
gowned114410132gowned
gunned83513092gunned
honed95332262ho_ned
honied104818392honied
honked144517912honked
horned105718702horned
inned64118422_inned
joined144613072joined
kenned114411272kenned
konked104010582konked
loaned73816292loaned
longed87121372longed
manned94418642manned
moaned94514172moaned
monied94319462monied
mooned94216642mooned
owned95113232_owned
panned94123432panned
penned94217612penned
pinned94818382pinned
ponced114314812ponced
ponded105218772ponded
ponged105619352ponged
ponied94920702ponied
punned93416192punned
reconned113610652reconned
ronnel63310882ronnel
scanned104110892scanned
sconced12359172sconced
scorned10229952scorned
sinned73818412sinned
sonnet65923502sonnet
sorned74820042sorned
sunned74216322sunned
tanned75219952tanned
tinned74317532tinned
toned65435342to_ned
tonged86518902tonged
tonne54921432tonne_
tonner64819202tonner
tonnes65320852tonnes
tunned74014492tunned
vanned104614482vanned
wanned104318012wanned
winned104017012winned
wonner95114442wonner
wonted103213282wonted
yenned10409382yenned
zoned154020262zo_ned
zonked20429472zonked
zooned164011082zooned

Search took 4 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.356501941.0
2DLD Change Limit825511752.79629524.7
3Display Results1751750.0632777.8
 (SQL Overall)1786911753.21555580.4
 
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.