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

158 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
beignet10151096(None) 
beigne9148611beigne_
beignes10149241beignes
beignets11155371beignets
beget85632552be_g_et
beige81515372beig_e_
beiges91014402beig_es
bennet84823362be_nnet
deigned1037502deigned
feigned1245352feigned
feigner1135592feigner
reigned949212reigned
signet73621152_signet
aiglet74224193_aiglet
aigret73720023_aigret
aligned9128553aligned
aligner8108313aligner
baguet9316103b_aguet
bannet84925333b_annet
baronet91022203baronet
basinet9318933basinet
bayonet121212213bayonet
beagle93612593beagle_
beagles103212123beagles
beaned95621473be_aned
becket144619883be_cket
bedight1437483bedig_ht
beet66457543be___et
befinger1434643befinger
befret11315963be_fret
begat86629723be_g_at
begets96215523be_g_ets
begged115013803be_gged
begin85117353begin__
beginner1173953beginner
begins94415303begin_s
begirt9412683be_girt
begone9512133begone_
begot84625953be_g_ot
beigy111110583beig__y
being84920503bei_n_g
beings94613033bei_ngs
beknot1239763be_knot
bene66439493be__ne_
benes75536233be__nes
benign938313benign__
benignant1243983benignant
benignity1542813benignity
benignly1443213benignly
benne76521123be_nne_
bennes86019013be_nnes
bennets94712163be_nnets
bent67759913be__n_t
beret74946363be__ret
beringed1298173beringed
beset76739133be__set
bewigged1643383bewigged
bewinged1584473bewinged
bezant17814543bezan_t
bidet84935623b_i_det
bigfeet1376153b_igfeet
bigger104315063b_igger
biggest1138143b_iggest
biggety1434433b_iggety
bight118728843b_ig_ht
bigness1038193b_igness
bigot84828323b_ig_ot
billet86029723b_illet
bine66650863b_i_ne_
biner75930693b_i_ner
bines76946793b_i_nes
binge85125513b_inge_
binged105920823b_inged
binger94923453b_inger
binges93923123b_inges
binit76431583b_i_nit
binned94414543b_inned
bint67355043b_i_n_t
biont7727163b_ion_t
blight124114623blig_ht
bonnet85524633b_onnet
bright124215923brig_ht
brine75132273bri_ne_
brined95118413bri_ned
briner84519043bri_ner
brines85028853bri_nes
bringer104213353bringer
briquet1838833briquet
brisket134413403brisket
brunet84419293b_runet
budget104618113budg_et
burgonet1148103burgonet
burnet84326173b_urnet
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
cygnet1237893_cygnet
deign74312803deign__
deigns8389983deign_s
designed1136943designed
designee1087753designee
designer1036543designer
dipnet91317473_dipnet
dragnet91211433dragnet
eaglet73722583_eaglet
egret63327313_e_gret
eight94928053_eig_ht
exigent1539513exigent
feign94210713feign__
feigners1235483feigners
feigns10407753feign_s
feint84732253fei_n_t
genet66038683ge__net
giglet83920273_giglet
hairnet10911703hairnet
height134713433heig_ht
jennet134714953je_nnet
linnet6419423_linnet
magnet9320663_magnet
neighed12135893neighed
peined94918843pei_ned
piglet93420923_piglet
pignut9311573_pignut
reagent8716603reagent
regent74127673re_gent
reglet73724233re_glet
regret73723533re_gret
reign65015193reign__
reignite947233reignite
reigns74811753reign_s
reined74425523rei_ned
rennet64624853re_nnet
resigned1038863resigned
resigner937793resigner
seigneur942933seigneur
seine55732873sei_ne_
seined74023063sei_ned
seiner64622483sei_ner
seines65029903sei_nes
sennet64224143se_nnet
signed83413753_signed
signee73617233_signee
signer74015633_signer
signets83311503_signets
sniglet83612413sniglet
soigne74310033soigne_
soignee8279133soignee
spinet85629753spi_net
telnet6518833te_lnet
tenet55542213te__net
veined104413913vei_ned
veiner94514753vei_ner
veinlet101310573veinlet
weighed15135933weighed
weigher14136343weigher
weight133914183weig_ht
weiner94214133wei_ner
wiglet105519153_wiglet

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271586.78019768.0
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.99925530.9
 
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.