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 “recurrences” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
recurrences154486(None) 
recurrence1445311recurrence_
incurrences1555332incurrences
occurrences1452772occurrences
reoccurrences1661712reoccurrences
resurgences1445002resurgences
concurrences1554403concurrences
currencies1445663__currencies
deterrences1455183deterrences
esuriences12105303_esuriences
feculences1744943fecu_lences
incurrence1455743incurrence_
occurrence1353233occurrence_
recommences1954923recommences
recreances1446503rec_reances
recrudesces1651743recrudesces
recumbencies2062933recumbencies
recurrent1146713recurren__t
recurrently1652753recurrently
references1589353re_ferences
refulgences1753353refulgences
reoccurrence1561873reoccurrence_
resurgence1345493resurgence_
resurrects1242823resurre_cts
reverences1579173re_verences
securances1445743secu_rances
abhorrences1872034abhorrences
clarences1346454__clarences
concurrence1454794concurrence_
concurrencies1653164concurrencies
currency1545544__currenc_y
currents1038374__curren_ts
decadences1665144dec_adences
decurrent1256454decurren__t
deferences1677874de_ferences
deterrence1345624deterrence_
emergences15105954_emergences
esurience11126004_esurience_
esuriencies1353824_esuriencies
feculence1644824fecu_lence_
fourpences1743984_fourpences
frequences2444934frequ__ences
insurgences1454634insurgences
mergences14137554me__rgences
occurrents1453004occurren_ts
precedences1845514prec_edences
preferences1876184pre_ferences
pruriences1444704_pruriences
rearranges1145114re_arranges
recarries1147864recarr__ies
recencies13312254rec___encies
recommence1855154recommence_
recommenced2053814recommenced
recompenses17114354recompenses
recondenses1444964recondenses
reconvenes1546504reconven_es
reconvinces1844954reconvinces
recreance1346994rec_reance_
recreancies1544654rec_reancies
recreates11313364rec__reates
recrudesce1551794recrudesce_
recrudesced1751504recrudesced
rectrices1338874rec_tr_ices
recumbency2152494recumbenc_y
recuperates1545604recuperates
recurred1137094recurr___ed
recurring1237954recurrin__g
recurves1337404recu_r__ves
recusancies1553544recu_sancies
redolences1376804re_dolences
reemergences1753044reemergences
reentrances1345174reentrances
refences13311844re___fences
reference14810094re_ference_
referenced1676864re_ferenced
refluences1545514re_fluences
refulgence1653614refulgence_
reluctances15143934reluctances
remanences1446624re_manences
renascences1554864renascences
renitences1248444re_nitences
repugnances1692864repugnances
resentences1347424resentences
residences1368234re_sidences
resiliences1375244resiliences
resurfaces1543014resu_rfaces
resurrect1144884resurre_c_t
resurrected1452674resurrected
reticences1447454re_ticences
retrenches1545904re__trenches
returnees9396114retu_r_nees
reverence14710164re_verence_
reverenced1676314re_verenced
reverencer1575724re_verencer
reverencers1673324re_verencers
securance1345874secu_rance_
secureness1245054secu_reness
sequences2067014sequ__ences
terrenes82212604te__rren_es
truculences1582624trucu_lences
vergences15128064ve__rgences

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191018.75017007.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911019.21919382.9
 
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.