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

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

63 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
affirmed174321(None) 
affirmer1643081affirmer
affined1436412affi_ned
affirm1435522affirm__
affirmers1742562affirmers
affirms1534382affirm_s
affixed2134122affi_xed
afforded1643432afforded
firmed125411882__firmed
infirmed14205342infirmed
reaffirmed1951502reaffirmed
admired1135703admir_ed
afeared1176833afear_ed
affaire1344463affair_e_
affaires1444303affair_es
affected1744793affected
affianced1843033affianced
affiche1844313affiche_
affiches1945233affiches
affine12310503affi_ne_
affines1339483affi_nes
affirmant1753813affirmant
affirming1843103affirming
affixer2033913affi_xer
affixes2035503affi_xes
affixment2443883affixment
afflicted1843433afflicted
afford1346493affor__d
affrayed1842843affrayed
afire86215913a_fir_e_
aimed85626053a__i_med
aired66032923a__ir_ed
airmen82612353a__irmen
airted74214503a__irted
alarmed1037733a_larmed
antired82316193antir_ed
armed86324433a___rmed
aspired1068173aspir_ed
attired8238913attir_ed
ausformed1542323ausformed
biformed1643693biformed
chirmed15379733_chirmed
confirmed1745563confirmed
deformed15248263deformed
disaffirmed2151553disaffirmed
faired105915773_fair_ed
farmed125117653__farmed
filmed124610363__filmed
fired94829743__fir_ed
firmer114712443__firmer
flirted11428673_flirted
formed125021173__formed
informed14197673informed
mafficked2442243mafficked
malformed1742373malformed
offered1436143offer_ed
refilmed14235813refilmed
refired115116993refir_ed
reformed14249603reformed
squirmed2034173squirmed
unfilmed1495803unfilmed
unfired112212453unfir_ed
unformed14239573unformed

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 Filter1786911461620.403443402.0
2DLD Change Limit146162637.47019566.5
3Display Results63630.0163937.5
 (SQL Overall)178691637.88922650.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.