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

180 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
coined9452360(None) 
chined125620061chined
coifed124113061coifed
coigned11418661coigned
coiled95123931coiled
coiner84323781coiner
coned86040051co_ned
conned95119701conned
corned95224521corned
foined105915011foined
joined144613071joined
acorned10238262acorned
alined75221402alined
boiled95020952boiled
boinked14457042boinked
boned85133242bo_ned
brined95118412brined
cabined1239992cabined
cairned1037642cairned
caned85838092c_aned
canned95022062canned
ceiled94114952ceiled
chained133812692chained
chided135113962chided
chimed145814832chimed
chine105231722chine_
chines115029172chines
chinked174011022chinked
chinned134810492chinned
choired13349342choired
cine66242942c_ine_
cines75239682c_ines
cited84421952c_ited
cline76428532cline_
clines84926042clines
clinged113310092clinged
clinked144011642clinked
cloned94518802cloned
clowned13447722clowned
coaled95022702coaled
coated94927032coated
coaxed165612512coaxed
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
coffined1735992coffined
cogged116416612cogged
coiffed1635412coiffed
coigne94612192coigne_
coignes103912152coignes
coiler84421592coiler
coin66645352coin__
coiners93620752coiners
coinfer12419392coinfer
coins75834552coin_s
cointer93616722cointer
cojoined1856292cojoined
coked124730692co_ked
coled85540752co_led
combed135516542combed
combined15269182combined
comped135919872comped
cone67256962co_ne_
cones76457422co_nes
coney105932882co_ney
confined14310402confined
conies84338592conies
conine84528552conine_
conines93827792conines
conked135019112conked
conner84423962conner
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224582cooled
cooped114821602cooped
coped105036842co_ped
copied114618562copied
copped135221252copped
corded105923352corded
cored85044222co_red
corked135020782corked
cornea84018922cornea
cornel84020052cornel
corner84625622corner
cornet84436732cornet
cornfed1337382cornfed
coshed124217542coshed
cosied94819882cosied
cosigned1235722cosigned
cosine83823512cosine_
cosines94122672cosines
costed95623112costed
coted85033852co_ted
counted103815802counted
couped115019312couped
coved115027372co_ved
cowed115637842co_wed
cowled125218382cowled
coxed154322812co_xed
coyed114623802co_yed
cozened19349182cozened
cozied184112152cozied
craned96121652craned
cried84624282cri_ed
cringed113312402cringed
crooned103813342crooned
crowned133912422crowned
dined76431992_dined
doiled84817292doiled
doited85016632doited
donned85015742donned
downed115314782downed
dwined114610212dwined
eloined8149812eloined
fined94930502_fined
foiled104618402foiled
gained84617462gained
gowned114410132gowned
groined92710812groined
hoised105117432hoised
honed95332262ho_ned
honied104818392honied
horned105718702horned
joiner134114132joiner
jointed15378502jointed
koine9516482koine_
koines10415732koines
lined64934642_lined
loaned73816292loaned
loided83414022loided
mined85333352_mined
moaned94514172moaned
moiled94318862moiled
monied94319462monied
mooned94216642mooned
noised75416232noised
oiled64429472_oiled
oinked114213282_oinked
opined95113852opined
owned95113232_owned
pained95622852pained
peined94918842peined
pined85935322_pined
poind84217912poin_d
poinded11358972poinded
pointed103813982pointed
poised94918472poised
ponied94920702ponied
quoined1735782quoined
rained75024602rained
recoined113614422recoined
reined74425522reined
roiled74320052roiled
rosined84911902rosined
ruined74813322ruined
sained75424242sained
scorned10229952scorned
seined74023062seined
shined104620782shined
soiled73822472soiled
sorned74820042sorned
spined95423942spined
tined65434532_tined
toiled74420322toiled
toited74016752toited
toned65435342to_ned
trined74920712trined
twined104413122twined
uncoined111813022uncoined
veined104413912veined
vined95626152_vined
voiced123910112voiced
voided114011132voided
whined134715202whined
wined94434182_wined
wonned104012062wonned
zoned154020262zo_ned
zooned164011082zooned

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.1261418182.5
2DLD Change Limit825511802.75030018.5
3Display Results1801800.0632857.1
 (SQL Overall)1786911802.93960799.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.