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

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

103 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
reafforesting205139(None) 
afforesting1852852__afforesting
reforesting1546192re__foresting
deforesting1654793de__foresting
reafforest1652833reafforest___
reafforested1951213reafforest_ed
reafforests1751433reafforest__s
rearresting1245963rea__rresting
efflorescing2161214_efflorescing
foresting13311364____foresting
readdressing1552794rea_ddressing
reaffirming2051924reaffir__ming
reafforestation21101474reafforestation
reassorting1245024reassor__ting
refreshing1746064re__f_reshing
affecting1845235__aff__ecting
affording1744025__affor__ding
afforest1446345__afforest___
afforested1752655__afforest_ed
afforests1543735__afforest__s
affronting1742605__aff_ronting
arresting1038635__a__rresting
befretting1644795be__f_retting
breakfasting2251565breakf__asting
defrosting1544495de__f_rosting
effecting1845585_e_ff__ecting
effervescing2491175_e_ffervescing
leafleting1442895lea_f_le_ting
leafletting1541985lea_f_letting
perforating1747025pe_rfor_ating
reabsorbing1642765reabsor__bing
reaccenting1665015rea__ccenting
reaccepting1863895rea__ccepting
reaccrediting1961485rea_ccrediting
readjusting2042905rea__djusting
readopting1465515rea_do__pting
readorning1245725rea_dor__ning
reaffirmation2152065reaffirmation
reaffirmations2251975reaffirmations
reaffixing2442325reaff___ixing
reaggregating1552565rea_ggregating
reallocating1573665reallo_cating
reallotting1243675reallo__tting
reanointing1244995rea_no_inting
reappointing17122935reappo_inting
rearousing1156455rea_ro_us_ing
reasserting1246155rea__sserting
reassessing1243995rea__ssessing
recreating131214585re___creating
redecorating16115055redecor_ating
redefeating1645335redef__eating
redefecting1844375redef__ecting
redigesting1444575re__digesting
redigressing1552925re_digressing
redirecting1545615re__directing
redressing1247825re___dressing
reenforcing1742775reenfor__cing
reerecting1339975re___erecting
reesting93118275re_____esting
reexporting2143425reexpor__ting
reexpressing2263085re_expressing
refecting152413355re__f__ecting
refereeing1444675re__fere_eing
referencing1744495re__ferencing
reflecting1638825re__f_lecting
refloating14198325re_flo__ating
reflowering1843175re_flowe_ring
refocusing1653855re__focus_ing
refocussing1752645re__focussing
reforest1139965re__forest___
reforested1445385re__forest_ed
reforests1245535re__forest__s
reforging1437665re__for__ging
reformatting1852705re__formatting
reforming1538565re__for__ming
refracting1638735re__f_racting
refreezing2344415re__f_reezing
refronting1437275re__f_ronting
regreeting1237345re___greeting
regressing1248145re___gressing
regretting1237785re___gretting
reimporting1644095reimpor__ting
reinfecting1745155reinf__ecting
reinforcing1743715reinfor__cing
reinforming1784045reinfor__ming
reinvesting1545325re__investing
renesting102514705re____nesting
reoffering1744095reoff__e_ring
reorienting1246355re___orienting
reporting12513905re__por__ting
repressing13310395re___pressing
reprocessing1754695re_processing
requesting2046315re___questing
rerenting102617665re____renting
resorting10614615re__sor__ting
restressing1266045re__stressing
resurrecting1553125re_surrecting
retesting102614605re____testing
retorting10613275re__tor__ting
retreating111414775re___treating
retrogressing1553165retrogressing
revesting132814125re____vesting
unaffecting2052165unaff__ecting

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 Filter1786911247900.403443402.0
2DLD Change Limit1247901037.94015716.6
3Display Results1031030.0631634.9
 (SQL Overall)1786911038.40621257.6
 
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.