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

97 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
braunites114670(None) 
braunite1047251braunite_
bauxites1735152b_auxites
granites92116362gra_nites
preunites1138932preunites
reunites8312472_reunites
uranites82514642ura_nites
alunites8310703_alunites
aragonites1145803aragonites
arenites8917103ar_enites
arsenites9149163arsenites
augites8312183__augites
aunties73920073__aunties
autunites946193autunites
banties94324763b_a_nties
barites94322333b_a_rites
baronies10315023baroni_es
bauxite1635573b_auxite_
beanies93821093bea_ni_es
beauties10229523beauti_es
boracites1347943bora_cites
bornites10310973b_ornites
bounties10311393b_ounties
brachiates1746343brachiates
brainiacs1343773brainiacs
brainier102510223braini_er
brainiest11209723braini_est
braininess1246123braininess
brainstem1352993brainstem
brainstems1441933brainstems
braises93818873bra__ises
braizes183112453bra__izes
branches153613803bra_nches
brandies11714563bra_ndies
brannier10218933branni_er
branniest11199383branni_est
brants85723053bra_n_t_s
brassies103613533brassi_es
brattices1345553brattices
brawnier13216723brawni_er
brawniest14197103brawni_est
brawniness1544033brawniness
braxies16711463bra_xi_es
brinies93317913br_ini_es
brionies10310543brioni_es
brookites1545033brookites
brownies13189613browni_es
brucines1237763br_ucines
bruises93212913br_u_ises
bruited104110353br_u_ited
bruiter93710633br_u_iter
bruiters10329133br_u_iters
bruits85714453br_u_it_s
brunches153710453br_unches
brunets9419553br_unet_s
brunettes1144583br_unettes
brunizem2162363br_unizem
brunizems2241153br_unizems
brunts85215453br_un_t_s
brutes86118683br_u__tes
bryonies1336843bryoni_es
craniates11310653cra_niates
crannies10313013cranni_es
craunches1655723craunches
crinites10612753cr_inites
crudites1137763cr_udites
cyanites132610153cya_nites
disunites1088663disunites
dunites8313593__dunites
gahnites1235703_gahnites
granitas92610223gra_nitas
granite82017083gra_nite_
grannies9312613granni_es
granulites1146623granulites
graphites1546823graphites
gunites8313123__gunites
kainites1238793_kainites
kyanites15216683kya_nites
mannites10312613_mannites
preunite1039573preunite_
preunited1246803preunited
ratites74920683_ra_tites
raucities1148163_raucities
raunches1368053_raunches
reunite7312713_reunite_
reunited939713_reunited
reuniter838323_reuniter
reuniters936423_reuniters
stannites947013stannites
trannies8415013tranni_es
triunities1046093triunities
unites65024853___unites
uralites82112723ura_lites
uranides92211283ura_nides
uraninites1045613uraninites
uranite72515693ura_nite_
urbanites11105913urbanites

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641978.90616690.0
3Display Results97970.0462108.7
 (SQL Overall)178691979.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.