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

79 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
becrusts124484(None) 
becrust1137981becrust_
becrusted1443942becrusted
becurses1236722becurses
becurst1147852becurst_
crusts84916542__crusts
encrusts1045282encrusts
incrusts1036252incrusts
piecrusts1342602piecrusts
recruits1036562recruits
backrests1744983backrests
bearcats1267023bearcats
beasts84519723be__asts
beauts86015283be_au_ts
becarpets1542913becarpets
because1136233becaus_e
beckets15399823bec_kets
beclasps1444353beclasps
becrawls1543623becrawls
becrimes1467073becrimes
becrowds1683773becrowds
becrusting1544603becrusting
becurse1136183becurs_e
becursed1335583becursed
bedposts1343873bedposts
bedrugs11194283bedru_gs
befrets1237613befr_ets
behests1235953be_hests
bemists113410703be_mists
bemuses1139293be_muses
bequests1944113bequests
berceuses1344103berceuses
berets85822523be_r_ets
besmuts1134683besmu_ts
bests75932613be___sts
bruits85714453b__ruits
brunts85215453b__runts
bruts75922953b__ru_ts
bursts85116243b_ur_sts
busts75227693b___usts
ceruses93716233ce_ruses
crests85218703__crests
cruets85314953__cruets
cruses88127713__cruses
crusets93811043__crusets
crust75827663__crust_
crusty114911343__crusty
decrypts1642943decrypts
defrosts1244833defrosts
degusts936063de_gusts
ecrus75113863_ecru__s
encrust947873encrust_
entrusts847113entrusts
eructs83610793_e_ructs
erupts8348903_e_rupts
incrust949203incrust_
intrusts837723intrusts
locusts9277933loc_usts
metrists1039853metrists
necroses10310563necroses
necrosis1048883necrosis
percuss1137163percus_s
peruses94018163pe_ruses
piecrust1244633piecrust_
recasts93413533rec_asts
recluses105111733recluses
recounts1038773recounts
recross989833recros_s
recruit939773recruit_
recuses94619463rec_uses
recuts83817373rec_u_ts
rusts55026993___rusts
sacrists1039563sacrists
secrets9311773secr_ets
thrusts10226523_thrusts
trusts64714433__trusts
verists103613673ve_rists
versts93914733ve_r_sts
xeruses143010753xe_ruses

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.423422437.4
2DLD Change Limit146162797.93618417.6
3Display Results79790.0332393.9
 (SQL Overall)178691798.39221293.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.