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

106 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
bradoons113676(None) 
bradoon1037351bradoon_
bridoons1145421bridoons
baboons113211082b_aboons
bridoon1046202bridoon_
cardoons113411942cardoons
dragoons1045012dragoons
lardoons9398482lardoons
racoons93912432_racoons
radons74118532_rad_ons
ratoons73815472_ratoons
abrasions1145813abrasions
adorns74212613__adorns
babools11319453b_abools
baboon103613913b_aboon_
baboos103517013b_aboo_s
bacons104917583b_a_cons
ballons93916963b_allons
balloons103110523balloons
barons85025383b_a_rons
barracoons1442983barracoons
barrooms1237893barrooms
baryons121010473b_aryons
barytons1345573barytons
basions94213953b_asions
bassoons1036553bassoons
batons85519423b_a_tons
baudrons1135763baudrons
bazooms20285383b_azooms
bazoos173212623b_azoo_s
beacons11410733bea_cons
bigaroons1243943bigaroons
blazons1836163bla_zons
boons75031913b___oons
brackens16327923brackens
bradawls1443673bradawls
bradding13268933bradding
brads85528293brad___s
brains85125473bra__ins
brans75437433bra___ns
bravoes12418533bra_voes
bravoing1445993bravoing
bravos114711393bra_vo_s
brawns115614083bra__wns
brazens18418713bra_zens
breadroots1343773breadroots
breakdowns2051863breakdowns
broadens11267243broad_ens
broadlooms1552273broadlooms
broods95416383br__oods
brooks125813883br__ooks
brooms104915873br__ooms
broos75126413br__oo_s
browns116415633br__owns
buffoons1643093buffoons
cardons104519933card_ons
cardoon104813813cardoon_
cartoons104012803cartoons
crampons1436643crampons
crampoons1544063crampoons
cratons94316033cra_tons
crayons12439233cra_yons
croons85418423cr__oons
dahoons1137753_dahoons
dragons938383dra_gons
dragoon935283dragoon_
drawdowns1741933drawdowns
erasions8310983erasions
gaboons10289903_gaboons
gadroons1037013_gadroons
gradins93416233grad_ins
grandsons1145123grandsons
hadrons113314303_hadrons
harpoons1337483harpoons
jargoons1644663jargoons
kroons103711243kr__oons
ladrons83813193_ladrons
lagoons839253_lagoons
lardons83914493lard_ons
lardoon83410373lardoon_
madzoons20124773_madzoons
maroons92615553_maroons
orations81515803orations
pardons103817623pard_ons
platoons1038683platoons
quadroons1944183quadroons
raccoons1265453_raccoons
racons84319343_ra_cons
racoon83814473_racoon_
radians83013823_radians
radios74018673_radio_s
radomes10311053_radomes
radon64620503_rad_on_
ramsons939563_ramsons
rations74123433_rations
ratoon64417373_ratoon_
rattons73815323_rattons
rattoons8327513_rattoons
rayons94113343_ra_yons
readorns938283readorns
redons75222183_red_ons
rigadoons1142633rigadoons
saloons74415323_saloons
shadoofs1554233shadoofs
tardyons1244613tardyons
trapdoors1243153trapdoors

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621067.51619446.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.98222386.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.