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

200 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
begirds113488(None) 
begird1036821begird_
beards94116672be_ards
begins94415302begi_ns
begirded1334172begirded
begirdle1253202begirdle
begirdles1342492begirdles
begirt9412682begir_t
beglads11127262beglads
begrims1276762begrims
behinds1335282behinds
bemires113212832bemires
birds85421332b__irds
engirds995052engirds
girds74816992__girds
hegiras1136102hegiras
regards94112562regards
regilds996672regilds
ungirds9105302ungirds
upgirds11103072upgirds
weirds10478052we_irds
aegis6316783aegi__s
aegises8311373aegises
bairns86710873b_airns
bards87139643b__ards
batgirls1142403batgirls
bayards13379683bayards
beads85429503be__ads
beard86024963be_ard_
bears75739043be_ar_s
bedims1149593bedi_ms
bedirty1344183bedirty
bedrid1039943bedrid_
beds75937783be___ds
bedwards1596393bedwards
beers75628393be_er_s
beeyards1444593beeyards
befits114711503befi_ts
begalls10319163begalls
begazes1937963begazes
begets96215523beg_ets
beggars11378223beggars
begged115013803begged_
begin85117353begi__n
begirding1434333begirding
begirdled1442403begirdled
beglad10138463beglad_
begorah1355593begorah
begorra1043543begorra
begrim11118333beg_rim
begrime1276553begrime
begrimes1376513begrimes
begs75733833beg___s
beguiles1146103beguiles
beguines11127213beguines
begulfs1333753begulfs
begums11429493beg_ums
beheads1338523beheads
behind1238063behind_
beholds1336423beholds
beiges91014403be_iges
beignes10149243beignes
beings94613033be_ings
bekiss1236373beki_ss
belauds1036643belauds
belied95022163belied_
beliefs12448583beliefs
beliers94617383beliers
belies84631053beli_es
bellbirds1443163bellbirds
bemire103312803bemir_e
bemired123410633bemired
bemists113410703bemists
bemixes18338653bemixes
bends85628973be__nds
bergeres1189103bergeres
bergs84718043be__rgs
berimes115216643berimes
berks115423123be__rks
berms95323663be__rms
berries94423553berries
beside95114613besi_de
besides104814533besides
bestirs9311133bestir_s
bestuds10326753bestuds
betide95115973beti_de
betides104915263betides
betimes115114413betimes
betises94816123betises
bevies114017303bevi_es
bevors111610343bevor_s
bewares12313373bewares
bewigs1246533bewi_gs
beworms1437913beworms
beyonds1335063beyonds
bezils1711310603bezi_ls
bids75838433b__i_ds
binds86627473b__inds
bird76128323b__ird_
birks114920303b__irks
birls74023163b__irls
biros75325133b__iros
birrs74917103b__irrs
blinds95111613b_linds
bluebirds1442963bluebirds
boards94616933b_oards
bogarts1047743bogarts
bogies94724313bogi_es
boobirds1344183boobirds
bovids1287973bovi_ds
boyards13399323boyards
braids95015683brai_ds
briards10398553briards
builds9378493b_uilds
burds84626063b__urds
busgirls1142653busgirls
bywords1634283bywords
cairds96411513_cairds
cebids11439173cebi_ds
deairs74013783deair_s
degerms1135623degerms
desires81316133desires
egads74610923_eg_ads
egers65120373_eger_s
egis56520653_egi__s
egises7312493_egises
emirs76116163_emir_s
engilds974863engilds
engird8126973engird_
felids103111623feli_ds
geoids8369843geoi_ds
gids65933733__gi_ds
gilds75417523__gilds
gird65424993__gird_
girls64518393__girls
girns64516803__girns
giros65722653__giros
girts65423623__girts
grids75321393__grids
hegaris11310423hegaris
hegira1036523hegir_a
heirs85618563he_ir_s
hejiras1744233hejiras
herds96424683he__rds
jerids142810943jeri_ds
jerrids15277743jerrids
kefirs13396653kefir_s
keirs95313673ke_ir_s
lairds74711613_lairds
legends936073legends
legers74518313leger_s
legions84611783legions
legists899593legists
legits71313003legi_ts
megilps1233563megilps
megrims1276103megrims
nerds65719253ne__rds
overgirds1445163overgirds
periods10312243periods
petards104311153petards
rebids94015533rebi_ds
rebinds104511873rebinds
records105213923records
redbirds1283873redbirds
refinds114512123refinds
refires104820313refires
regard85215773regard_
regild8149773regild_
regimes104514743regimes
reginas85614063reginas
regions83613473regions
regius7311923regi_us
regives115014213regives
regrinds1035533regrinds
rehires105016113rehires
reminds104614793reminds
resids74219153resi_ds
retards85015003retards
retires74726213retires
rewards114813993rewards
rewinds114810483rewinds
rewires104717113rewires
rewords115413973rewords
seabirds1164403seabirds
shairds11216263shairds
teiids736693te_iids
teinds738263te_inds
thirds10438603_thirds
ungird887973ungird_
upgird10103933upgird_
vegies104314273vegi_es
venires103012453venires
weird95111283we_ird_
weirdo10405883we_irdo
weirdos11355123we_irdos
weirdy13395463we_irdy
weirs84316493we_ir_s
wergilds1342653wergilds
yairds10448023_yairds
yirds96612513__yirds

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 Limit1340272007.17318684.9
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.40524131.1
 
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.