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

116 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
beignets1115537(None) 
beignes10149241beigne_s
beignet101510961beignet_
begets96215522be_g_ets
beiges91014402beig_e_s
beigne9148612beigne__
bennets94712162be_nnets
bigness1038192b_igness
feigners1235482feigners
signets83311502_signets
aiglets84012913_aiglets
aigrets82810533_aigrets
aligners9117573aligners
baguets1037483b_aguets
bannets94013843b_annets
baronets101410903baronets
basinets1039063basinets
bayonets13135583bayonets
beagles103212123beagle_s
beckets15399823be_ckets
bedights1544743bedig_hts
beets76131443be___ets
befingers1544103befingers
befrets1237613be_frets
beget85632553be_g_et_
beginners1283613beginners
begins94415303begin__s
beige81515373beig_e__
beings94613033bei_n_gs
beknots1335083be_knots
benes75536233be__ne_s
benignity1542813benignity
bennes86019013be_nne_s
bennet84823363be_nnet_
bents76033693be__n_ts
berets85822523be__rets
besets85718803be__sets
bezants1877343bezan_ts
bidets95215533b_i_dets
biggest1138143b_iggest
biggety1434433b_iggety
bights124417963b_ig_hts
bigots95015133b_ig_ots
billets94516153b_illets
biners85023633b_i_ners
bines76946793b_i_ne_s
bingers104519993b_ingers
binges93923123b_inge_s
binits85716673b_i_nits
bints76130183b_i_n_ts
bionts8612393b_ion_ts
blights133110213blig_hts
bonnets94812803b_onnets
brights133710233brig_hts
briners94315633bri_ners
brines85028853bri_ne_s
bringers112811073bringers
briquets1934853briquets
briskets14346563briskets
brunets9419553b_runets
budgets11489863budg_ets
burgonets1243513burgonets
burnets93813263b_urnets
coignes103912153coigne_s
cygnets1333813_cygnets
deigned1037503deigne_d
deigns8389983deign__s
designees1145003designees
designers1136003designers
dipnets10109033_dipnets
dragnets10136563dragnets
eaglets84111663_eaglets
egrets72712243_e_grets
eights103618983_eig_hts
feigned1245353feigne_d
feigner1135593feigne_r
feigns10407753feign__s
feints94813873fei_n_ts
genets75716663ge__nets
giglets93211553_giglets
hairnets1195633hairnets
heights14399443heig_hts
jennets14517633je_nnets
linnets739833_linnets
magnets10311143_magnets
piglets103311793_piglets
pignuts1035613_pignuts
reagents959623reagents
regents83416543re_gents
reglets83512983re_glets
regrets83212923re_grets
reigned949213reigne_d
reignite947233reignite
reignites1046933reignites
reigns74811753reign__s
rennets75212633re_nnets
resigners1036863resigners
seigneur942933seigneur
seigneurs1042493seigneurs
seiners74219273sei_ners
seines65029903sei_ne_s
sennets73712583se_nnets
signees83510803_signees
signers84714443_signers
signet73621153_signet_
sniglets9276813sniglets
spinets94714813spi_nets
telnets738373te_lnets
tenets65518953te__nets
trigness968403trigness
veiners104112523vei_ners
veinlets11144833veinlets
weighers15135673weighers
weights14409553weig_hts
weiners103913063wei_ners
wiglets113411423_wiglets

Search took 9 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.1561145455.1
2DLD Change Limit1461621168.04618165.8
3Display Results1161160.0502320.0
 (SQL Overall)1786911168.25221654.3
 
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.