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

111 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
broodless123503(None) 
bloodless1234511bloodless
bloomless1342962bloomless
bondless1148812b_ondless
boodlers113710742b_oodlers
boodles103416042b_oodle_s
boonless10328352b_oonless
bootless103410982b_ootless
brandless1236122brandless
breadless1235942breadless
broadness1256662broadness
brooders112610242brood_ers
broodiest1237822broodiest
broodiness1344652broodiness
brooklets1543682brooklets
browless1346652br_owless
foodless12338382_foodless
hoodless12289732_hoodless
roadless937702_roadless
rodless8310072_r_odless
roofless11316732_roofless
rootless83910442_rootless
woodless12278452_woodless
armorless1143483armorless
arrowless1242813arrowless
beardless1234913beardless
bedless1039703b__edless
blondness1234963blondness
bloodies11310163bloodie_s
bloodiest1236663bloodiest
bloodiness1344353bloodiness
bloodlessly1752163bloodlessly
bloodlust1243333bloodlust
bloodlusts1352343bloodlusts
blotless10347153b_lotless
bodiless1135913b_odiless
boldness1136973b_oldness
boltless10338283b_oltless
boneless10310213b_oneless
boodies103721443b_oodie_s
boodle93215033b_oodle__
boodled113410933b_oodle_d
boodler103312003b_oodle_r
booklets14247123b_ooklets
boomlets12246673b_oomlets
bootlegs11325873b_ootlegs
boundless1235183boundless
bowless123310313b__owless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
braless92910563br__aless
bridlers11359183br_idlers
bridles104114473br_idle_s
briefless1443613briefless
brimless1235273br_imless
brindles113710223brindle_s
brineless1136253brineless
broadens11267243broad_ens
broadest1138573broad_est
broadleaf1542603broadleaf
broiders114211193broid_ers
broilers103210093br_oilers
brooches15288193brooche_s
brooded113510933brood_e_d
brooder103811623brood_e_r
broodier1157433broodie_r
broods95416383brood___s
brookies1459143brookie_s
brooklet1456403brookle_t
broomiest1356913broomiest
brownness1444343brownness
brushless1444003brushless
budless1038873b__udless
cloudless1243153cloudless
cookless14258633_cookless
cordless11299963_cordless
cropless1237793cr_opless
crownless1443423crownless
doodlers10338843_doodlers
doodles93614163_doodle_s
doorless936713_doorless
errorless942813errorless
floorless1243793floorless
footless113710803_footless
fordless12289003_fordless
frockless1843453frockless
frontless1235403frontless
frostless1235743frostless
godless938403__godless
goodness1036253_goodness
greedless1144893greedless
groundless1243473groundless
groveless13235363groveless
hoofless14258013_hoofless
hookless151238363_hookless
hoopless13279263_hoopless
lordless9277483_lordless
moonless10278043_moonless
noodles83513193_noodle_s
oodles73517183__oodle_s
poodles103013513_poodle_s
proudness1246693proudness
rindless92510193_rindless
rockless14297293_rockless
rootles73215633_rootle_s
rootlets8308653_rootlets
toadless936313_toadless
toolless836343_toolless
treadless1036003treadless
wordless12258843_wordless

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411116.95321378.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.41924085.6
 
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.