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

82 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
reaffirming205192(None) 
affirming1843102__affirming
reaffixing2442322reaffi_xing
disaffirming2252073disaffirming
reaffirm1642483reaffirm___
reaffirmed1951503reaffirm_ed
reaffirms1741943reaffirm__s
rearming111413613rea___rming
reconfirming2053083reconfirming
refilming15256463re__filming
refiring123513923re__fir_ing
reforming1538563re__forming
reinforming1784043reinforming
reoffering1744093reoffer_ing
affirmant1753814__affirmant
affixing2264334__affi_xing
affording1744024__affording
chaffering22104644chaffer_ing
confirming1845904_confirming
deairing10311894dea__ir_ing
deforming1636704de__forming
firming132811224____firming
graffitiing1951494graffitiing
graffiting1842924graffi_ting
infirming1545164__infirming
mafficking2542644_mafficking
performing1844944pe_rforming
prearming14139224prea___rming
prefiring1559074pre__fir_ing
preforming1846234pre__forming
preinforming2072694preinforming
raffling1567064r_aff__ling
reabsorbing1642764reabsorbing
reacquiring2352654reacquir_ing
readdicting1643814readdicting
readmitting1544054readmitting
readorning1245724rea_dorning
reaffirmation2152064reaffirmation
reaffirmations2251974reaffirmations
reafforesting2051394reafforesting
realigning1245934rea_ligning
realising10313174rea_li_sing
realizing19313814rea_li_zing
realtering1139474realter_ing
reaming103924014rea____ming
reanointing1244994reanointing
rearing83128784rea___r_ing
reasserting1246154reasserting
reassigning1343644reassigning
reassorting1245024reassorting
reassuming1343704rea_ssuming
reassuring1155944reassur_ing
reavailing1444874reavai_ling
reclaiming1546584reclai_ming
redefining1545424redefi_ning
redshirting1643264redshirting
reenforcing1742774reenforcing
referring1338034re__ferring
reffing143712174re_ff___ing
refiling123116534re__fi_ling
refilling13299334re__filling
refinding14259944re__finding
refining122416864re__fi_ning
refitting132811124re__fitting
refixing19329794re__fi_xing
reforging1437664re__forging
reframing1538624re__framing
refrying15278904re__f_rying
rehiring122911884re__hir_ing
reinflaming1743164reinflaming
reinforcing1743714reinforcing
repairing12310014re_pair_ing
requiring1937044re_quir_ing
respiring12159904re_spir_ing
retiming113014194re__ti_ming
retiring92717414re__tir_ing
retrimming1544264re_trimming
retrofiring1544184retrofir_ing
rewarming15147384re__warming
rewiring122911224re__wir_ing
seafaring1345964sea_far_ing
trafficking2451784trafficking

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 Filter1786911488190.470380193.6
2DLD Change Limit148819828.47017570.1
3Display Results82820.0302733.3
 (SQL Overall)178691828.97019921.0
 
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.