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

163 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
barguest113716(None) 
barghest1447911barghest
barguests1243481barguests
argues74516412_argues_
baggiest123011752baggiest
baguet9316102ba_gue_t
baguets1037482ba_guets
barest85327692bar__est
bargees105415872bargees_
barges94528252barg_es_
barghests1543312barghests
barkiest144115152barkiest
barmiest125212782barmiest
barniest104815052barniest
barques18259642barques_
braggest1296532braggest
largest83715102larg_est
vaguest1137332va_guest
acquest1837173_acquest
agues64919053_a_gues_
argent74023663_arg_ent
argles75218483_argles_
argue64818443_argue__
argued84311173_argue_d
arguer74510543_argue_r
arguers8489023_arguers
argument1158903_argument
argus66716543_argu_s_
arguses84711743_arguses
aridest8316143_aridest
armrest9310163_armrest
arrest63722633_ar_rest
artiest73121993_artiest
august739203_augu_st
babiest114414753ba_biest
backrest1639393backrest
baddest112611143ba_ddest
badges103917363badg_es_
baggies113814853baggies_
baguette11105933ba_guette
baldest102313533ba_ldest
balkiest144112453balkiest
balmiest124110993balmiest
bangles103617413bangles_
banquet1839783banque_t
banquets1935433banquets
barbes104526233bar_bes_
barbet104427883bar_be_t
barbets114915843bar_bets
barbies114519593barbies_
barbless12318713barbless
barbules1238043barbules_
barbut104617003barbu__t
barbuts11439843barbuts_
bardes95026933bar_des_
bareges105212033bareges_
bareness10912813bareness
bares75457133bar__es_
barge85631023barg_e__
barged105822643barg_e_d
bargee94624443barg_e_e
barites94322333barites_
bariums1139143bariums_
barkless14318023barkless
barless94317003bar_less
baroness101210063baroness
baronet91022203barone_t
baronets101410903baronets
baroques1934863baroques_
barque17239553barque__
barquette2064903barquette
barrenest1149563barrenest
barres84427543bar_res_
barret84930483bar_re_t
barrets94917103bar_rets
baryes116218503bar_yes_
barytes124611153barytes_
basest84720493ba__sest
basques18248673basques_
battiest104115553battiest
battues94610193battues_
bawdiest14398673bawdiest
bequest1837823b_equest
biggest1138143b_iggest
bilgiest11309883bilgiest
bluest84016483b__luest
boggiest123110933boggiest
braggiest13116783braggiest
brakiest143912243brakiest
brashest133511763brashest
bravest124211753b_ravest
brawest123810483b_rawest
brogues10719823brogues_
buggiest123410363buggiest
bulgiest112910943bulgiest
burgees104915893burgees_
burgess10409343burg_ess
burgles105615963burgles_
burliest103113053burliest
burriest102911213burriest
cagiest102916433ca_giest
cangues10611823cangues_
cargoes104415223cargoes_
darkest122512623dar_kest
darndest1067223darndest
earliest82415243earliest
earnest7318733ear_nest
faggiest132910183faggiest
farthest1499863farthest
gangues9149753gangues_
garget84327273garg_e_t
gargets94614573garg_ets
gargles94214893gargles_
garigues1034953garigues_
guest65225923___guest
hangnest12311413hangnest
hardest113118413har_dest
hardiest123416333hardiest
harshest14310193harshest
harvest132112753har_vest
jaggiest17289323jaggiest
langues81211913langues_
languet8713693langue_t
languets987243languets
lardiest93813883lardiest
larges74824233larg_es_
largess8408913larg_ess
larkiest123713313larkiest
mangiest112815903mangiest
margent10316693marg_ent
marges94525713marg_es_
marliest102415183marliest
marques182610863marques_
marquess19204953marquess
morgues1038273morgues_
naggiest102610013naggiest
nonguest938563nonguest
parges94529543parg_es_
parget94529393parg_e_t
pargets105215193parg_ets
parquet18311583parque_t
parquets1936413parquets
rangiest93115983rangiest
rarest65725483rar__est
reargues936713reargues_
sagest74920263sa_g_est
saggiest102812713saggiest
sagiest82617983sa_giest
sarges75128593sarg_es_
sarkiest123615063sarkiest
tangiest92915223tangiest
tardiest93515243tardiest
targes74524593targ_es_
target75028903targ_e_t
targets84314223targ_ets
tarriest83215003tarriest
tartest72517533tar_test
tartiest82718313tartiest
truest64816193_tr_uest
wariest105122503war_iest
warmest123113033war_mest
wartiest113614643wartiest
yarest95018913yar__est

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621638.70316794.4
3Display Results1631630.0602716.7
 (SQL Overall)1786911638.91920034.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.