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

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
reemergences175304(None) 
reemergence1653161reemergence_
emergences15105952__emergences
preemergence1962292preemergence_
emergence14136613__emergence_
emergencies16124513__emergencies
mergences14137553___mergences
reemerges1255173reemerg___es
reexperiences2472293reexperiences
references1589353r_efer_ences
resurgences1445003r_esurgences
reverences1579173r_ever_ences
submergences1952993submergences
convergences20146254convergences
deferences1677874_defer_ences
detergencies1654354_detergencies
deterrences1455184_deterrences
divergences1874494_divergences
emergency17154554__emergenc_y
emergents1245974__emergen_ts
experiences22106054_experiences
irreverences1752924irrever_ences
mergence13137944___mergence_
nonemergencies1961644nonemergencies
preemergent1652524preemergen__t
preeminences1883524preem_inences
preferences1876184prefer_ences
recurrences1544864r_ecurrences
reembraces1643894reembr__aces
reemerge1154794reemerg___e_
reemerged1354404reemerg___ed
reemerging1474584reemergin__g
reenergizes2152804reenerg_izes
reentrances1345174reentr_ances
reexperience2372424reexperience_
reexperienced2571794reexperienced
reference14810094r_efer_ence_
referenced1676864r_efer_enced
refulgences1753354r_efulgences
remanences1446624r_em_anences
remembrances20152894remembr_ances
remerges111110204r_emerg___es
resentences1347424r_esentences
resurgence1345494r_esurgence_
reverence14710164r_ever_ence_
reverenced1676314r_ever_enced
reverencer1575724r_ever_encer
reverencers1673324r_ever_encers
submergence1853394submergence_
vergences15128064___vergences

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 Filter1786911247900.390458182.1
2DLD Change Limit124790507.03017751.1
3Display Results50500.0331515.2
 (SQL Overall)178691507.45323975.7
 
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.