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 “bionomies” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
bionomies139715(None) 
bionomics1574581bionomics
biologies12311182biologies
bionomic1476152bionomi_c
bionomist1347112bionomist
bionomists1444902bionomists
bonhomies1655782b_onhomies
economies1348622economies
isonomies1147452isonomies
aeronomies12118323aeronomies
agronomies13135913agronomies
anomies93316993__anomies
autonomies1247953autonomies
bigamies1337373bi_gamies
bignonias1243783bignonias
binaries10314183bi_naries
binocles1236413bi_nocles
binomial1246223bi_nomial
binomials1343903bi_nomials
biogenies1248513biogenies
biologics1446863biologics
biomes103815253bi__om_es
bionics114310873bion__ics
bionomy1444723bionom__y
biopsies1237383bio_psies
bioscopies1645383bioscopies
biosolids1242943biosolids
biotopes1246963bioto_pes
biotoxins1844183biotoxins
bloodies11310163blo_odies
bloomier1275783blo_omier
bloomiest1335853blo_omiest
bonhomie1555213b_onhomie_
boobies113718203b_o_obies
boodies103721443b_o_odies
boogies103719013b_o_ogies
bookies133819403b_o_okies
boomier113312183b_o_omier
boomiest122711843b_o_omiest
boonies93422483b_o_onies
booties94124613b_o_oties
brionies10310543brion__ies
brookies1459143bro_okies
broomier1236873bro_omier
broomiest1356913bro_omiest
economics1545903economics
economise1346053economise
economises1446563economises
economizes2345373economizes
eponymies1644653eponymies
ionomer939833_ionom_er
ionomers1038503_ionomers
ionones7313883_iono_nes
monodies11312503_monodies
roomies93017243_ro_omies
signories10107853signories
sodomies11128553_sodomies
taxonomies1953643taxonomies
theonomies1545773theonomies
zootomies2046143zootomies

Search took 7 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 Limit148641606.51622811.7
3Display Results60600.0302000.0
 (SQL Overall)178691606.96625651.9
 
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.