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

70 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
becrawls154362(None) 
becrawl1444581becrawl_
becrawled1743122becrawled
becrowds1683772becrowds
bedrails1136292bedrails
brawls115214332b__rawls
crawls114712082__crawls
scrawls12177272_scrawls
bawls105719323b___awls
bearable121512363bearable
bearably15177933bearably
becalm1239203bec_a_lm
becalms1335743bec_alms
becaps123811403bec_a_ps
bechalk1845803becha_lk
bechalks1944793bechalks
bechamels1853033bechamels
becharms1745343becharms
beclasps1444353beclasps
beclowns1544683beclowns
becrawling1843613becrawling
becrimes1467073becrimes
becrowd1555173becrow_d
becrusts1244843becrusts
bedrail1037253bedrail_
bedrapes1386963bedrapes
bedrolls1144673bedrolls
befalls12349123be_falls
begalls10319163be_galls
behowls1534443be_howls
berakes134815773be_rakes
berates94126873be_rates
beryls11107883be_r_yls
betrayals1442963betrayals
betrays12127823betra_ys
bewails1277553be_wails
bewraps14135403bewra_ps
bewrays15145113bewra_ys
bharals1236733bhara_ls
borals86721913b_ora_ls
bradawls1443673bradawls
brails84621293b__rails
brawl106217963b__rawl_
brawly144312353b__rawly
brawns115614083b__rawns
braws106425193b__raw_s
craals84113303__craals
crawl104916713__crawl_
crawly144610763__crawly
craws105723123__craw_s
decals93717713dec_a_ls
declaws1336253declaw_s
decrials1137133decrials
decrowns14265063decrowns
derails84216393de_rails
drawls105511393__drawls
fecials123510333fecia_ls
ferals94216643fe_ra_ls
outcrawls1443513outcrawls
recalls92613623rec_alls
recoals94214623recoa_ls
recrates102420373recrates
recrowns13246143recrowns
redraws11218473redraw_s
sacrals93311793sacra_ls
scrawl11208083_scrawl_
scrawly15197183_scrawly
serails73318363se_rails
sprawls12176373_sprawls
trawls94412393__trawls

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 Filter1786911461620.283631417.0
2DLD Change Limit146162709.07616104.2
3Display Results70700.0164375.0
 (SQL Overall)178691709.37519060.4
 
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.