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

269 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
bergere106891(None) 
bergeres1189111bergeres
bargee94624442barge_e
berserk1334912berserk
burgee97120592burge_e
burger94020792burger_
burgers103918572burgers
mergee94018142merge_e
merger95016482merger_
mergers103813422mergers
serger73819742serger_
sergers83815632sergers
verger104315702verger_
vergers114412632vergers
aerier64823153aerier_
badger105415083badger_
badgered1336213badgered
badgers114812653badgers
bagger104619203bagger_
baggers113915693baggers
banger94423633banger_
bangers104020353bangers
barber104419323barber_
barbered13259543barbered
barbers114317503barbers
barege94713543bar_ege
barer74535803bar_er_
barge85631023barg__e
barged105822643barge_d
bargees105415873bargees
bargemen1346403bargemen
barges94528253barge_s
barker124822863barker_
barkers134318513barkers
barre75929543bar__re
barter85525373barter_
bartered113113013bartered
barterer102711633barterer
barters94223033barters
barware12610703barware
beader94623793beader_
beaders104120183beaders
beagle93612593beag_le
beaker125520693beaker_
beakers134216873beakers
beanery1237563beanery
bearer85323913bearer_
bearers94619593bearers
beater84729393beater_
beaters94925043beaters
beaver114819253beaver_
beavered1437503beavered
beavers124417323beavers
bebeeru1144263bebeeru
bedder104215793bedder_
bedders113513383bedders
bedsore1057803bedsore
beebee10313063beebe_e
beeper103714093beeper_
beepers113612383beepers
beer65635993be__er_
beerier93613023beerier_
beers75628393be__ers
beery105220123be__ery
beezer174010523beezer_
beezers18349243beezers
before11410153be_fore
begaze1838333be_gaze
beget85632563be_ge_t
begets96215523be_gets
beggar10328223beggar_
beggared1334753beggared
beggars11378223beggars
beggary14316153beggary
begged115013813begge_d
begird1036823be_gird
begirt9412683be_girt
begone9512133be_gone
begrime1276553begrime
beige81515383beig__e
beiges91014413beige_s
beigne9148613beig_ne
belier84423563belier_
beliers94617383beliers
believe12519773believe
belter84720963belter_
belters93819413belters
bemire103312803be_mire
bendee94121023bende_e
bender95223303bender_
benders104021063benders
benzene1836343benzene
berake124216083ber_ake
berate84729023ber_ate
berberin1246563berberin
berberine1346523berberine
berberis1246603berberis
berceuse1243433berceuse
bereave1258353bereave
bereft114317303ber_eft
beret74946363ber_e_t
berets85822523ber_ets
berg75425543berg___
bergs84718043berg__s
berhyme1743813berhyme
beriberi1243453beriberi
berime105317333ber_ime
berline93716853berline
berme96022943ber__me
bermed115217723berme_d
bermes106023003berme_s
berry104521773ber__ry
berseem1166463berseem
berserker1543233berserker
berserks1433993berserks
besiege1035413besiege
better84723703better_
bettered113011843bettered
betters94422093betters
beware11313713be_ware
bigeye1236643b_igeye
bigger104315063bigger_
binger94923453binger_
bingers104519993bingers
birder94915493birder_
birders103913263birders
bireme10310143bir_eme
birler85715083birler_
birlers93813003birlers
booger94816553booger_
boogers104514633boogers
border94419973border_
bordered1248933bordered
borderer1168103borderer
borders104317533borders
bordure1035783bordure
borer75131273bor_er_
borers85122683bor_ers
brede85520503b_r_ede
bree67241263b_r_e_e
breeze17298963b_reeze
breve105317053b_r_eve
brewer114812553brewer_
brewers123811063brewers
brewery15376963brewery
brier74527403b_rier_
briers85319733b_riers
briery114510773b_riery
budger104617713budger_
budgers114314923budgers
bugeye1236533b_ugeye
bugger104418723bugger_
buggered1335623buggered
buggers114315663buggers
buggery14367933buggery
bulger94917353bulger_
bulgers105215143bulgers
bungee96319773bunge_e
burgage1136633burgage
burgees104915893burgees
burgeon1036433burgeon
burgess10409343burgess
burgher1337003burgher_
burghers1435633burghers
burgle94815863burg_le
burier84324653burier_
buriers94017193buriers
burker125221173burker_
burkers133716623burkers
burler84723833burler_
burlers94120273burlers
burner83819203burner_
burners94115673burners
burrer83718473burrer_
burrers93814493burrers
bursera936763bursera
degerm1037893de_germ
degree82814853degre_e
derriere936043derriere
eager65526973_eager_
eagerer8248823_eagerer
eagers74523683_eagers
eagre64315323_eag_re
edger75215953_edger_
edgers84413923_edgers
eerier64320023eerier_
eger55923573_e_ger_
egers65120373_e_gers
egger74414413_egger_
eggers84612583_eggers
ergate7315143_ergate
etagere836533etagere
fernery1335813fernery
forger104820773forger_
forgers115218183forgers
forgery14419303forgery
frere85617723_fr_ere
gerbera1034773gerbera
gorger86116983gorger_
gorgers94813643gorgers
hedger114912653hedger_
hedgers124310263hedgers
herder104516463herder_
herders113914123herders
jerker17369043jerker_
jerkers18287083jerkers
kedgeree1444383kedgeree
kegger12388083kegger_
keggers13357043keggers
larger74417513larger_
ledger85914393ledger_
ledgers94912183ledgers
leger65721513le_ger_
legers74518313le_gers
meager94515203meager_
meagre9349323meag_re
mercer105214203mercer_
mercers114412773mercers
mercery14397623mercery
merer75126233mer_er_
merge84523693merg__e
merged104214953merge_d
mergees104411233mergees
mergence13137943mergence
merges94122493merge_s
neogene847553neogene
nervure1034973nervure
perdure10379623perdure
perigee101113393perige_e
perjure16327963perjure
perter84422283perter_
perverse1336103perverse
pervert12315583pervert
purger94717233purger_
purgers104714003purgers
revere94621253re_vere
serene63522353ser_ene
serer55935513ser_er_
serge64727473serg__e
serged84118773serge_d
serges74225973serge_s
server94917713server_
servers103214833servers
severe94016083se_vere
surger74320093surger_
surgers83517483surgers
surgery11319213surgery
terete6319333ter_ete
tergite8311003tergite
termer85717253termer_
termers95414503termers
terpene92310863terpene
terrene72411033terrene
terser67317823terser_
urger64116473_urger_
urgers73313623_urgers
vegete1039483ve_gete
verderer1245373verderer
verdure11287773verdure
verge93419843verg__e
verged114815163verge_d
vergence14128273vergence
verges104320183verge_s
verier94620963verier_
verser94516963verser_
versers103813523versers
wergeld1233183wergeld
wergelt1138583wergelt
xerosere1544733xerosere

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.406440125.6
2DLD Change Limit1340272696.56320421.6
3Display Results2692690.1102445.5
 (SQL Overall)1786912697.07925242.4
 
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.