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 “beginner” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
beginner117395(None) 
beginners1283611beginners
aginner844662_aginner
befinger1434642befinger
ginner73915822__ginner
aginners954623_aginners
banner84421503b__anner
beckoner1654963beckoner
bediaper1344933bediaper
befingers1544103befingers
begetter11136313begetter
begin85117353begi_n__
beginning1344613beginning
begins94415303begi_n_s
begirded1334173begirded
begone9512133beg_one_
beguiler1154063beguiler
beguine1068503beguine_
beguines11127213beguines
beigne9148613be_igne_
beignes10149243be_ignes
beignet101510963be_ignet
belier84423563beli__er
believer13448423believer
bender95223303be__nder
benne76521123be__nne_
bennes86019013be__nnes
bennet84823363be__nnet
beringed1298173beringed
besieger1144683besieger
bewilder1434133bewilder
bewinged1584473bewinged
binder94422873b__inder
biner75930693b__i_ner
binger94923453b__inger
binned94414543b__inned
blinder103912983b_linder
blinker134110213b_linker
brainier102510233brainier
branner94212373b_ranner
briner84519043b_ri_ner
bringer104213353b_ringer
brinier93613473b_rinier
byliner1235723byli_ner
cowinner1334753cowinner
definer114413773defi_ner
degender1136893degender
deringer1038143deringer
designer1036543designer
dinner74217163__dinner
engineer945493engineer
feigner1135593fe_igner
ginger84920033__ginger
ginned83813983__ginned
ginners84314223__ginners
ginnier8298983__ginnier
grinner8329233_grinner
gunner73813983__gunner
inner54920633___inner
penner84616663pe__nner
pinner84521503__pinner
predinner1245133predinner
refiner105316913refi_ner
regainer9249353regainer
reginae84713453reginae_
register939553register
reinter73116843re_inter
reminder113110513reminder
repiner94816903repi_ner
repinned1157473repinned
resigner937793resigner
rewinder12317663rewinder
seiner64622483se_i_ner
sinner64320603__sinner
skinner11348093_skinner
spinner93912263_spinner
tenner64117103te__nner
thinner10358983_thinner
tinner64119963__tinner
veiner94514753ve_i_ner
veinier10269583ve_inier
weiner94214133we_i_ner
winner94219933__winner

Search took 10 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 Filter1786911461621.140156746.5
2DLD Change Limit146162838.61016975.8
3Display Results83830.0332515.2
 (SQL Overall)178691839.78318265.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.