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

171 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
patroons10271060(None) 
patrons93818101patr_ons
patroon92811971patroon_
cartoons104012802cartoons
gadroons1037012gadroons
maroons92615552ma_roons
matrons93517632matr_ons
matzoons19105082matzoons
natrons73215662natr_ons
pardons103817622pa_rdons
parsons93516872pa_rsons
partons94620512pa_rtons
patriots1038052patriots
patrols93513512patr_ols
patron84018042patr_on_
platoons1038682plat_oons
poltroons1145392poltroons
ratoons73815472rat_oons
rattoons8327512rattoons
aprons8316993_apr_ons
argons75018203_a_rgons
arsons63917213_a_rsons
atropins10410493_atropins
attorns738443_attorns
baboons113211083ba_boons
balloons103110523balloons
barons85025383ba_r_ons
barrooms1237893barrooms
baryons121010473ba_ryons
bassoons1036553bassoons
bathrooms1644773bathrooms
batons85519423bat__ons
carbons115418943ca_rbons
cardons104519943ca_rdons
cardoons113411943cardoons
carrions10312453carrions
carryons1337103carryons
cartons94122473ca_rtons
cartoon94114463cartoon_
cartoony13377403cartoony
cations94524143cat_ions
chatrooms1685103chatrooms
citrons92913223citr_ons
coatrooms1385413coatrooms
copatrons1346333copatr_ons
croons85418423__croons
dacrons103211033dacr_ons
dahoons1137753da_hoons
dayrooms1444343dayrooms
diatrons939613diatr_ons
eftsoons1142613eftsoons
fatwoods1585953fatwoods
gaboons10289903ga_boons
gadroon938173gadroon_
galloons9289703galloons
garcons102411643ga_rcons
garrons82713463ga_rrons
godroons1045363godroons
hadrons113314303hadr_ons
harpoons1337483harpoons
introns73515023intr_ons
jargons1558203ja_rgons
jargoons1644663jargoons
karoos102415803ka_roo_s
karroos1139313karroo_s
kations114013663kat_ions
kroons103711243__kroons
ladrons83813193ladr_ons
lagoons839253la_goons
lampoons12266873lampoons
lardons83914493la_rdons
lardoons9398483lardoons
macaroons1345563macaroons
macrons113514893macr_ons
madronos11337543madronos
madzoons20124773madzoons
maroon83118203ma_roon_
marrons93216973ma_rrons
matron83918313matr_on_
matzoon1896473matzoon_
nations74720563nat_ions
natron64116023natr_on_
octoroons1143423octoroons
outroots839873outroots
pactions122613503pactions
padrone102512073padr_one
padrones112711043padrones
padroni10278613padr_oni
paeons83915523pa__eons
pandoors11258983pandoors
pantaloons1243613pantaloons
pantheons1446513pantheons
paragons11311503paragons
paratroops1452623paratroops
pardon94618733pa_rdon_
pareos87023773pa_reo_s
pargos95719043pa_rgo_s
parians93519733pa_rians
parlors9312913pa_rlors
parlous9414293pa_rlous
parodos103011753pa_rodos
paroles95025883pa_roles
parols84722613pa_r_ols
parous84024163pa_r_ous
parrots9312743pa_rrots
parson83817903pa_rson_
partans94418283pa_rtans
parton84720993pa_rton_
partook1337313partoo_k
parvos116614753pa_rvo_s
passions10310583passions
pastromis1346583pastromis
patens84820863pat__ens
pathogens1545713pathogens
pathos115516693pat_ho_s
pathoses13412773pathoses
patins87528783pat__ins
patios85221783pat_io_s
patois84319363pat__ois
patrimony1642673patrimony
patriot9314533patrio_t
patrol83213023patr_o_l
patronal1048653patronal
patroness1137483patroness
patronise1198443patronise
patronly1344883patronly
pattens95414923pat_tens
patterns10439943patterns
patulous10116363patulous
payrolls1344753payrolls
pereons92815003p_ereons
perrons93115483p_errons
persons93717013p_ersons
petrols92913083petr_ols
petrous92714423petr_ous
picaroons1344673picaroons
pitons85319043pit__ons
plastrons1147133plastr_ons
platoon938953plat_oon_
playrooms1644223playrooms
poltroon1046503poltroon_
pontoons10279313pontoons
poons75430973p___oons
portions10514413portions
pothooks1746053pothooks
potions93417423pot_ions
prions84317783p__rions
proofs114511683p__roofs
protons93118003p__rotons
puccoons1443403puccoons
putdowns1443523putdowns
putons83515153put__ons
pythons1537363pyt_hons
quadroons1944183quadroons
raccoons1265453raccoons
racoons93912433ra_coons
rations74123433rat_ions
ratoon64417373rat_oon_
rattons73815323rat_tons
rattoon7359243rattoon_
saloons74415323sa_loons
spittoons1142383spittoons
taprooms1246663taprooms
taproots1047253taproots
tarpons92612213ta_rpons
tattoos738643tattoo_s
toons55027533__t_oons
trogons83410723__trogons
troops85712783__troops
varooms1248883va_rooms
waitrons1136633waitr_ons

Search took 10 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621718.62616944.4
3Display Results1711710.0632714.3
 (SQL Overall)1786911719.09519647.2
 
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.