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

130 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
beggary1431615(None) 
beggar10328221beggar_
beggarly15293391beggarly
beggars11378221beggars
beggared1334752beggared
beweary1536222beweary
buggery14367932buggery
eggar7458882_eggar_
eggars8398972_eggars
jaggary19304862jaggary
seggar8357812seggar_
seggars9377782seggars
angary10311323_angary
baggage1235633baggage
bagger104619203bagger_
baggers113915693baggers
baggily1436043baggily
baggy125615683bagg__y
beady114719923be__ady
beaky146118023be__aky
beamy126218573be__amy
beanery1237563beanery
bear66844643be__ar_
beard86024963be__ard
bears75739043be__ars
becharm1636843becharm
bedward1497473bedward
bedwarf16106463bedwarf
beery105220123be__ery
beeyard1335523beeyard
begall92610723be_gall
began86319573be_ga_n
begat86629723be_ga_t
begaze1838333be_gaze
beggardom1651263beggardom
beggaries1356233beggaries
beggaring1435183beggaring
begged115013813begg_ed
begging123012653begging
begird1036823be_gird
begirt9412683be_girt
beglad10138463begla_d
beglads11127263beglads
begorah1355593begorah
begorra1043543begorra
beigy111110583beig__y
belady12489933be_lady
belay105021523be_la_y
belfry1435073be_lfry
belga8313233belga__
belgas9311713belga_s
benday123810813benda_y
bergere1068913bergere
berry104521773be__rry
bestiary1344813bestiary
beswarm1445783beswarm
betray111511443betra_y
beware11313713be_ware
beworry1543743beworry
bewray14147733bewra_y
bezoar1736913bezoar_
bezoars1836793bezoars
bigamy1436343b_igamy
bigger104315063bigger_
biggety1434433biggety
biggity1435013biggity
biggy124413133bigg__y
bigotry1344523bigotry
biliary1238213biliary
binary11312223b_inary
bleary115112553b_leary
bogart9617193b_ogart
boggy126116073bogg__y
braggart1245613braggart
breviary1642613breviary
briary114912003b_riary
bugger104418723bugger_
buggers114315663buggers
buggy124613483bugg__y
burglary1473133burglary
bursary12397583bursary
cedary12419603ce_dary
deary95826843de__ary
denary105316863de_nary
doggery13448263doggery
egger74414413_egger_
eggers84612583_eggers
eggy96611853_egg__y
feodary1444713feodary
feudary1444273feudary
glary96018543__glary
haggard13377183haggard
hegari1039523he_gari
jaggery19336903jaggery
kegger12388083kegger_
keggers13357043keggers
laggard10347623laggard
leary85927383le__ary
legacy1256653le_gacy
leggy105210243legg__y
megara9310093me_gara
muggar10316443muggar_
muggars11316643muggars
nectary1246223nectary
niggard1044943niggard
peccary1636283peccary
pedlary13277543pedlary
pessary1246873pessary
piggery14266193piggery
puggry13374823pugg_ry
regard85215773re_gard
regear73512743regear_
regears83012463regears
reggae858953regga_e
reggaes948883reggaes
retiary1038333retiary
saggar84010853saggar_
saggard10358953saggard
saggars93610683saggars
sectary1238273sectary
senary93716073se_nary
sugary1039013_sugary
teary85124053te__ary
ternary1038343ternary
toggery12505923toggery
vagary1337333_vagary
waggery15276903waggery
weary115620613we__ary
wiggery15295873wiggery
zedoary2043213zedoary

Search took 7 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.390458182.1
2DLD Change Limit1340271305.86022871.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.29628381.7
 
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.