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

98 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
becurst114785(None) 
becrust1137981becrust
becurse1136181becurse
accurst1146242accurst
becrusts1244842becrusts
becursed1335582becursed
becurses1236722becurses
bequest1837822bequest
burst75332242b__urst
curst74931022__curst
recurs83315802recurs_
securest1058582securest
backrest1639393backrest
bears75739043be_ars_
beast76338643be__ast
beauish12268513beauish
beaus75127113beau_s_
beaut75135213beau__t
beauts86015283beauts_
becaps123811403becaps_
becarpet1447533becarpet
because1136233because
becket144619883bec_ket
beckets15399823beckets
becks135522013bec_ks_
beclasp1335263beclasp
becrusted1443943becrusted
becursing1435453becursing
bedfast1346413bedfast
bedpost1247243bedpost
beers75628393be_ers_
befret11315963be_fret
begirt9412683begir_t
begums11429493begums_
behest11314613be_hest
bemist105216953be_mist
bemuse1038943bemu_se
bequests1944113bequests
beret74946363be__ret
bescours1245093bescours_
best66355323be___st
bevors111610343bevors_
bluest84016483b_luest
blurs74619083b_lurs_
blurt77625623b_lur_t
blurts84412643b_lurts
bourse84414333b_ourse
buret77444013b__uret
burnt75230333b__urnt
burs65847423b__urs_
bursa74921523b__ursa
burse75527253b__urse
bursts85116243b__ursts
bust65947783b__u_st
crust75827663__crust
curet75447643__curet
curs65645543__curs_
curse75829143__curse
curt67051713__cur_t
decors94017773decors_
decurve1335583decurve
decury1277963decur_y
degust8310253degu_st
demurest1137453demurest
demurs939773demurs_
durst66125173__durst
ecrus75113863_ecrus_
ecus65421463_ecu_s_
encrust947873encrust
erst47436433_e__rst
femurs1136713femurs_
hurst85527193__hurst
inburst937163inburst
incrust949203incrust
incurs83012283incurs_
lemurs837253lemurs_
locust85312343locu_st
obscurest1343413obscurest
occurs10136553occurs_
piecrust1244633piecrust
recast83422773rec_ast
recourse1038383recourse
recruit939773recruit
recur74116843recur__
recurve1237403recurve
recuse85519163recu_se
recut74729243recu__t
recuts83817373recuts_
request16311023request
revuist1038473revuist
secret8325063sec_ret
secure8513533secur_e
secured1059723secured
securer958253securer
secures9613163secures
security1346693security
verst84429373ve__rst
wurst85122993__wurst

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.406440125.6
2DLD Change Limit134027986.59320328.7
3Display Results98980.0303266.7
 (SQL Overall)178691987.02925422.0
 
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.