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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

50 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
reoccurrences166171(None) 
reoccurrence1561871reoccurrence_
occurrences1452772__occurrences
recurrences1544862re__currences
concurrences1554403_concurrences
nonoccurrences1771923nonoccurrences
occurrence1353233__occurrence_
recurrence1445313re__currence_
concurrence1454794_concurrence_
concurrencies1653164_concurrencies
incurrences1555334__incurrences
nonoccurrence1672184nonoccurrence_
occurrents1453004__occurren_ts
reoccurred1551864reoccurr___ed
reoccurring1652264reoccurrin__g
resurgences1445004re__surgences
concurrency1753425_concurrenc_y
concurrents1554565_concurren_ts
conferrences19106075_conferrences
currencies1445665____currencies
deterrences1455185de__terrences
esuriences12105305_e__suriences
feculences1744945fe__cu_lences
fourpences1743975_fo__urpences
geosciences1652955geosc__iences
incurrence1455735__incurrence_
nonconcurrences1872145nonconcurrences
occurrent1344275__occurren__t
preoccupancies217855preoccu_pancies
reassurances14112605reassu_rances
recommences1954915re__commences
recreances1446505re__c_reances
recrudesces1651745re_cru_desces
recumbencies2062935re__cumbencies
recurrent1146715re__curren__t
recurrently1652755re__currently
reemergences1753045re_emergences
reexperiences2472295reexperiences
references1589355re___ferences
refluences1545515re_flu__ences
refulgences1753355re__fulgences
reinsurances1452815reinsu_rances
reoccupies1652495reoccu___pies
reoccurs1242965reoccu_r____s
resurgence1345495re__surgence_
resurrects1242825re__surre_cts
reticences1447455retic___ences
reverences1579175re___verences
securances1445745se__cu_rances
succulences1452535_succu_lences

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790509.33013375.1
3Display Results50500.0301666.7
 (SQL Overall)178691509.51618778.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.