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

144 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
gadroon93817(None) 
gadroons1037011gadroons
godroon946041godroon
cardoon104813812cardoon
gaboon93211772ga_boon
gadrooned1243402gadrooned
galloon82910642galloon
garcon92912482ga_rcon
garron73113492ga_rron
godroons1045362godroons
hadron102913752hadr_on
ladron73413322ladr_on
lardoon83410372lardoon
madrono10288742madrono
madzoon1996062madzoon
maroon83118202ma_roon
patroon92811972patroon
quadroon1844472quadroon
aboon74918703_a_boon
adjoin14107293_adjoin
adnoun757033_adnoun
adorn64917093_ad_orn
adown95611663_ad_own
adroit7518793_adroit
apron7318833_apr_on
argon65520593_a_rgon
arson55118833_a_rson
aswoon947013_aswoon
baboon103613913ba_boon
balloon93711433balloon
baron78131243ba_r_on
barroom1139373barroom
baryon111211613ba_ryon
bassoon937613bassoon
bedroom1247083bedroom
bigaroon1144593biga_roon
bradoon1037353brad_oon
caldron1038153caldr_on
carbon104919043ca_rbon
cardon94120853ca_rdon
cardoons113411943cardoons
carrion9312673carrion
carryon1237033carryon
carton84522663ca_rton
cartoon94114463cartoon
croon75522783__croon
dacron94310693dacr_on
dahoon1039053da_hoon
dayroom1345233dayroom
dromon939363__dromon
drool65416103__drool
droop85814823__droop
drown95515823__drown
gabion93211033ga_bion
gaboons10289903ga_boons
gadjo1436913gad_jo_
gadoid9310463gad_oid
gadrooning1343543gadrooning
gadzooks23112933gadzooks
galleon8278713galleon
gallon73715813ga_llon
galloons9289703galloons
galloot82814223galloot
galoot72719163ga_loot
gammon1138903ga_mmon
garcons102411643ga_rcons
garden84215083ga_rden
garote7717953ga_rote
garrison943983garrison
garrons82713463garrons
garrote8510103garrote
gascon9339723ga_scon
gazoo153112873ga_zoo_
gazoos163010223ga_zoos
giron66118993g_ir_on
godhood1345143godhood
godown1136033god_own
godson857383god_son
gombroon1343753gombroon
goon57236173g___oon
gorgon8310243g_orgon
gossoon865663gossoon
groan65618423g__roan
groin65521083g__roin
groom85317983g__room
grown95317353g__rown
guardroom1352503guardroom
gudgeon10123743gudgeon
guerdon944343guerdon
gunroom1045053gunroom
gyron95314623g_yr_on
hadrons113314303hadrons
harpoon1238313harpoon
headroom1446303headroom
jargon1448823ja_rgon
jargoon1545193jargoon
karoo92519583ka_roo_
karoos102415803ka_roos
karroo10410013karroo_
karroos1139313karroos
kroon94514483__kroon
ladhood1246473ladhood
ladrone83611873ladrone
ladrons83813193ladrons
lagoon7410483la_goon
lampoon11267193lampoon
lardon74415063la_rdon
lardoons9398483lardoons
macaroon1246343macaroon
macron103615673macr_on
madrona10288703madrona
madrone102812663madrone
madronos11337543madronos
madzoons20124773madzoons
maroons92615553ma_roons
marron83717543ma_rron
matron83918313matr_on
matzoon1896473matzoon
midnoon1044683midnoon
mudroom1244953mudroom
natron64116023natr_on
padrone102512073padrone
padroni10278613padroni
pardon94618733pa_rdon
parson83817903pa_rson
parton84720993pa_rton
patron84018043patr_on
patroons102710603patroons
quadroons1944183quadroons
raccoon1176163raccoon
racoon83814473ra_coon
radon64620503rad__on
ratoon64417373ra_toon
rattoon7359243rattoon
redroot8312903redroot
rigadoon1043193rigad_oon
sadiron836043sadiron
saloon64418023sa_loon
taproom1147963taproom
taproot9412673taproot
tardyon1134673tardyon
tarpon82812803ta_rpon
varoom11411413va_room
wardroom1445043wardroom

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271446.57620381.2
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.04525364.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.