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

77 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
accurst114624(None) 
accost101112262acc_ost
accurate12410662accurate
accursed1354642accursed
accuse103411032accu_se
acquest1837172acquest
becurst1147852becurst
curst74931022__curst
occurs10136552occurs_
acarus8312193acarus_
accent105116273acc_ent
accents113511243accents
accept123210643acc_ept
accepts13356373accepts
access1037683acc_ess
accord1178843accor_d
accords1247243accords
accosts11107993acc_osts
account11109043account
accounts1285843accounts
accrete1137853acc_rete
accrual1144553accrual
accrue1035823acc_rue
accrued1233833accrued
accrues1135323accrues
accuracy1443603accuracy
accusal11136003accusal
accusant1246863accusant
accused12368433accused
accuser11347933accuser
accusers12285903accusers_
accuses114112193accuses
accustom1443663accu_stom
achiest12315193achiest
acquests1944643acquests
acquit17610323acqu_it
acquits1857293acquits
actors81016773actors_
acutest94410603acutest
adjust1447183adju_st
adust64117453a_du_st
airburst1044233airburst
amours83512663amours_
arcus76918863arcu_s_
ascus75013583ascu_s_
athirst1037873athirst
augurs7399963augurs_
august739203augu_st
aurist65027253a__urist
baccarat1447933baccarat
becrust1137983becrust
becurse1136183becurse
burst75332243__burst
casuist9411303casuist
course85117783_course
court75532773_cour_t
courts84216173_courts
crust75827663_cru_st
curet75447643__curet
curs65645543__curs_
curse75829143__curse
curt67051713__cur_t
durst66125173__durst
encrust947873encrust
hurst85527193__hurst
inburst937163inburst
incrust949203incrust
incurs83012283incurs_
locust85312343locu_st
occult1038433occu_lt
occults1135123occults
occur9137323occur__
recurs83315803recurs_
scaurs85512053scaurs_
scours84913593scours_
securest1058583securest
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.436409841.7
2DLD Change Limit134027777.25318478.8
3Display Results77770.0302566.7
 (SQL Overall)178691777.71923149.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.