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

443 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
beigne914861(None) 
beige81515371beig_e
beignes10149241beignes
beignet101510961beignet
beagle93612592beagle
begin85117352begin_
begins94415302begins
begone9512132begone
beiges91014402beiges
beignets11155372beignets
beigy111110582beig_y
being84920502bei_ng
beings94613032beings
bene66439492be__ne
benign938312benign_
benne76521122be_nne
bine66650862b_i_ne
binge85125512b_inge
brine75132272bri_ne
coigne94612192coigne
deign74312802deign_
deigned1037502deigned
deigns8389982deigns
feign94210712feign_
feigned1245352feigned
feigner1135592feigner
feigns10407752feigns
reign65015192reign_
reigned949212reigned
reigns74811752reigns
seine55732872sei_ne
soigne74310032soigne
aedine73218393aedine
align65016503align_
aligned9128553aligned
aligner8108313aligner
aligns75312953aligns
aline57243153ali_ne
amine75835383ami_ne
azine146721413azi_ne
badge94819683badg_e
baggie102912193baggie
bailee84526013bailee
bailie83818363bailie
bairn77515533bairn_
bairns86710873bairns
baize164717393bai_ze
bane65250423b__ane
bangle94018953bangle
barge85631023barg_e
bargee94624443bargee
beadle93314683beadle
beagles103212123beagles
bean66443863be_an_
beaned95621473be_aned
beanie83618593beanie
beano75421553be_ano
beans75734693be_ans
beaten84617063beaten
became123213163became
become123312593become
bedight1437483bedight
bedizen1935943bedizen
bedunce1235683bedunce
bee56262403be___e
beebee10313063beebee
beeline93314723beeline
been65335783be_en_
beetle8311673beetle
befinger1434643befinger
before11410153before
befringe1484513befringe
beg65944133be_g__
began86319573be_gan
begat86629723be_gat
begaze1838333begaze
beget85632553be_get
beggar10328223beggar
begged115013803begged
begging123012653begging
beginner1173953beginner
begird1036823begird
begirt9412683begirt
begot84625953be_got
begs75733833be_g_s
beguine1068503beguine
begum105213923be_gum
begun85113443be_gun
behave14209013behave
behind1238063behind
behove14207203behove
belga8313233belg_a
belgas9311713belgas
belie75630383be_lie
believe12519773believe
belike124616283belike
belive115415303belive
belle75827833be_lle
belon73924113belon_
belong93411043belong
belons84119413belons
bemingle1346103bemingle
bemire103312803bemire
bemuse1038943bemuse
ben56554923be__n_
bename103316073bename
bend76435263be__nd
bendee94121023bendee
benes75536233be__nes
benignly1443213benignly
bennes86019013be_nnes
bennet84823363be_nnet
benni74715363be_nni
benny105217363be_nny
bens65945703be__ns
bent67759913be__nt
benzene1836343benzene
benzine1839343benzine
berake124216083berake
berate84729023berate
berg75425543berg__
bergere1068913bergere
bergs84718043berg_s
berime105317333berime
beringed1298173beringed
berline93716853berline
berme96022943be_rme
beside95114613beside
besiege1035413besiege
betaine9413783betaine
betake124512703betake
betide95115973betide
betime105914833betime
betise85616273betise
beton76022063beton_
betons84919553betons
betony114211583betony
beware11313713beware
bewig1138903bewig__
bewigged1643383bewigged
bewigs1246533bewig_s
bewinged1584473bewinged
beyond1237073beyond
bezant17814543bezant
bezique2743173bezique
bible95119423b_ible
bice86235563b_i_ce
bide76041483b_i_de
big67345723b_ig__
bigeye1236643b_igeye
bigger104315063b_igger
biggie103810933biggie
biggy124413133b_iggy
bight118728843b_ight
bigly114814753b_igly
bigness1038193b_igness
bigos85020013b_igos
bigot84828323b_igot
bigs76235023b_ig_s
bike106532603b_i_ke
bikie113915883b_ikie
bile66147183b_i_le
bilge87618913b_ilge
bin56658643b_i_n_
bind76234513b_i_nd
biner75930693b_i_ner
bines76946793b_i_nes
binged105920823b_inged
binger94923453b_inger
binges93923123b_inges
bingo86020093b_ingo
binned94414543b_inned
bins66548253b_i_ns
bint67355043b_i_nt
biogen9310253biogen
biome94916993b_iome
biont7727163b_iont
birle75023633b_irle
birse74517403b_irse
bise66437103b_i_se
bite66547003b_i_te
bize155926293b_i_ze
bizone1738603bizone
blight124114623blight
blin67228173bli_n_
blind86319323bli_nd
blini75519273bli_ni
blink115720143bli_nk
blite76225353bli_te
blithe115810863blithe
blunge94311483blunge
boggle104511943boggle
bogie89524103b_ogie
bogle85821683b_ogle
boing84725553boi_ng
boings96416873boings
boink115516333boi_nk
boite74426323boi_te
bone65949323b__one
bonne75124713b_onne
boogie93515993boogie
borane84620213borane
borne77926793b_orne
bougie93613273bougie
bourne83714093bourne
bovine11712433bovine
bribe94820783bri_be
bribee104316363bribee
bride86425533bri_de
bridge103711883bridge
bridle94115463bridle
brie65837903bri__e
brig76528033brig__
brigade1136493brigade
brigand1136643brigand
bright124215923bright
brigs85823223brig_s
brin67038193bri_n_
brined95118413bri_ned
briner84519043bri_ner
brines85028853bri_nes
bring85528503bri_ng
bringer104213353bringer
brings94618433brings
brink116122003bri_nk
brins75533973bri_ns
briny104719663bri_ny
briony1149043briony
brogue94211033brogue
budge94619873budg_e
budgie104310343budgie
bugle84721943b_ugle
bulge86419873bulg_e
bungee96319773bungee
bungle97116113bungle
burgee97120593burgee
burgle94815863burgle
butane8313653butane
butene8312623butene
bygone1256173bygone
byline11311643byline
cetane8315283cetane
chigoe1237533chigoe
chine105231723chi_ne
cine66242943_ci_ne
cline76428533cli_ne
coign85013913coign_
coigned11418663coigned
coignes103912153coignes
coigns94410063coigns
cringe93515483cringe
debone93714783debone
decane93818873decane
define104718143define
deice84320033dei_ce
dene56643413de__ne
dengue838253dengue
depone93616553depone
design8408933design_
designed1136943designed
designee1087753designee
designer1036543designer
designs9328313designs
diene65720133_diene
dine55555333_di_ne
dinge75627303_dinge
dwine95616143dwi_ne
eagle64219483_eagle
eagre64315323_eagre
edge65719663_edg_e
eide55832233_ei_de
eight94928053_eight
emigre937053emigre
engine71114863_engine
epergne1046143epergne
epigene1037893epigene
epigone1057843epigone
erne46727423_e_rne
esne47018793_e_sne
exine125518493_exine
eyne76322463_e_yne
feigners1235483feigners
feint84732253fei_nt
feirie939553feirie
feline94820143feline
ferine96422583ferine
fine75147953_fi_ne
fringe104013953fringe
gene56237223ge__ne
gighe10139733_gighe
gigue71210673_gigue
greige847203greig_e
gwine95513663gwi_ne
hedge105317333hedg_e
heigh124812543heig_h
height134713433height
heinie92512663heinie
henge94819823heng_e
hexane16379533hexane
hexone16289233hexone
hinge95323443_hinge
imine75821063imi_ne
insigne837673insigne
jejune1233763jejune
kedge115513693kedg_e
kerne94718213ke_rne
ketene106613003ketene
ketone105014533ketone
kine85643423_ki_ne
koine9516483koi_ne
league758743league
ledge76519463ledg_e
leone55018823le_one
liane54720663_liane
liege65314433lieg_e
lierne638023lierne
line46965573_li_ne
maigre9309163maigre
meagre9349323meagre
meikle1236653meikle
meinie82614523meinie
meiny104015413mei_ny
merge84523683merg_e
mergee94018133mergee
mesne75116293me_sne
mine67256163_mi_ne
neigh94912383neig_h
neighed12135893neighed
neighs10387733neighs
nene45932063ne__ne
neogene847553neogene
nine45842173_ni_ne
oblige937653oblig_e
obligee1046853obligee
oleine6313793olei_ne
opine77422463opi_ne
ovine86316643ovi_ne
peage84723563peag_e
pein65834943pei_n_
peined94918843pei_ned
peins76128063pei_ns
peise75825773pei_se
penne75423853pe_nne
perigee101113383perigee
pine67755713_pi_ne
puisne856353puisne
recane83022873recane
redone74820053redone
refine95225693refine
reggae858953reggae
regime95313943regime
regina75317143regina
reginae84713453reginae
regive104814323regive
regna64614813re_gna
rehinge1148503rehinge
reignite947233reignite
rein46040893rei_n_
reined74425523rei_ned
reink95518093rei_nk
reins56234563rei_ns
reive85522943rei_ve
reline65434353reline
repine85627813repine
resign74212583resign_
resigned1038863resigned
resigner937793resigner
resigns83910963resigns
retene69224273retene
retine66237333retine
retune69121953retune
rexine134719443rexine
rezone153814783rezone
sedge75019953sedg_e
segni63712483se_gni
segno64814743se_gno
segue6314413se_gue
seiche11811833seiche
seigneur942933seigneur
seined74023063sei_ned
seiner64622483sei_ner
seines65029903sei_nes
seise54727853sei_se
seize143819503sei_ze
sene46848053se__ne
serene63522353serene
serge64727463serg_e
serine65432673serine
shine85533093shi_ne
siege66718443sieg_e
sign55523053_sign_
signa66114703_signa
signed83413753_signed
signee73617233_signee
signer74015633_signer
signet73621153_signet
signs65516323_signs
sine46560623_si_ne
singe65731133_singe
soignee8279133soignee
spine76534423spi_ne
swine85625303swi_ne
swinge105614383swinge
teind6213613tei_nd
tenge65720433teng_e
terne56426153te_rne
theine94814923thei_ne
thine85026853thi_ne
tine45855133_ti_ne
tinge64626613_tinge
triene64316383triene
trine54734603tri_ne
triune64210183triune
twine85822363twi_ne
twinge104210393twinge
tzigane1742933tzigane
urine55026593uri_ne
veggie1136303veggie
vegie94614513ve_gie
vein75625753vei_n_
veined104413913vei_ned
veiner94514753vei_ner
veins84620493vei_ns
veiny115414363vei_ny
venene92912523venene
venge95117983veng_e
venine93718433venine
verge93419833verg_e
vine75643683_vi_ne
wedge105215633wedg_e
wedgie11428353wedgie
weigh125412513weig_h
weighed15135933weighed
weigher14136343weigher
weighs13338873weighs
weight133914183weight
weiner94214133wei_ner
whine116022813whi_ne
whinge134311533whinge
wine74953423_wi_ne
zein135620603zei_n_
zeins144715393zei_ns
zine137036153_zi_ne

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164437.98614114.2
3Display Results4434430.1403164.3
 (SQL Overall)1786914438.26621617.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.