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

90 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
becrawl144458(None) 
becrawls1543621becrawls
becrawled1743122becrawled
becrowd1555172becrowd
bedrail1037252bedrail
brawl106217962b__rawl
crawl104916712__crawl
scrawl11208082_scrawl
aecial84817313aecia_l
bawl95326063b___awl
bearable121512363bearable
bearably15177933bearably
becalm1239203bec_alm
became123213163bec_ame
becap114315053bec_a_p
becaps123811403bec_aps
bechalk1845803bechalk
bechamel1754283bechamel
becharm1636843becharm
beclasp1335263beclasp
beclown1435423beclown
becrawling1843613becrawling
becrime1387053becrime
becrowds1683773becrowds
becrust1137983becrust
bedrails1136293bedrails
bedrape1277693bedrape
bedroll1055553bedroll
befall114410643be_fall
begall92610723be_gall
behowl1445533be_howl
benzal1739643benza_l
berake124216083be_rake
berate84729023be_rate
beryl101211673be_r_yl
betray111511443betra_y
betrayal1343593betrayal
betrays12127823betrays
bewail1189583be_wail
bewrap13157053bewra_p
bewraps14135403bewraps
bewrapt14147133bewrapt
bewray14147733bewra_y
bewrays15145113bewrays
bharal1138893bhara_l
boral75831703b_ora_l
bradawl1344363bradawl
brail75525553b__rail
braw94829563b__raw_
brawls115214333b__rawls
brawly144312353b__rawly
brawn106018563b__rawn
braws106425193b__raws
buccal1248243bucca_l
cecal94619113cec_a_l
cercal10314123cerca_l
craal74117753__craal
craw97725263__craw_
crawls114712083__crawls
crawly144610763__crawly
craws105723123__craws
decal85523233dec_a_l
declaw1266703declaw_
declaws1336253declaws
decrial10310323decrial
decrown13206053decrown
derail74218813de_rail
drawl95516013__drawl
fecal105119213fec_a_l
fecial114714623fecia_l
feral85424653fe_ra_l
neural6311993neura_l
outcrawl1344583outcrawl
recall83815723rec_all
recoal84117973recoa_l
recrate92621663recrate
recrown12257573recrown
rectal84418133recta_l
redraw10269853redraw_
redrawn11245953redrawn
redraws11218473redraws
retral64419743retra_l
sacral83414413sacra_l
scrawls12177273_scrawls
scrawly15197183_scrawly
serail64222673se_rail
seral56336383se_ra_l
sprawl11188063_sprawl
tectal83713253tecta_l
trawl84915873__trawl

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.1431249587.4
2DLD Change Limit134027907.25018486.5
3Display Results90900.0303000.0
 (SQL Overall)178691907.42324072.6
 
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.