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

53 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
affirmer164308(None) 
affirmed1743211affirmed
affirmers1742561affirmers
affirm1435522affirm__
affirms1534382affirm_s
affixer2033912affi_xer
firmer114712442__firmer
admirer1035523admir_er
affaire1344463affair_e_
affaires1444303affair_es
affecter1644523affecter
affiche1844313affiche_
affiches1945233affiches
affine12310503affi_ne_
affined1436413affi_ned
affines1339483affi_nes
affirmant1753813affirmant
affirming1843103affirming
affixed2134123affi_xed
affixers2143293affi_xers
affixes2035503affi_xes
affixment2443883affixment
afflicter1742823afflicter
afforded1643433afforded
affrayer1742693affrayer
afire86215913a_fir_e_
aglimmer1342343aglimmer
aimer75926823a__i_mer
airer54927893a__ir_er
airier64619363a__irier
airmen82612353a__irmen
armer76924443a___rmer
aspirer967903aspir_er
confirmer1665663confirmer
daffier1457833daffi__er
deformer14247943deformer
fairer95212063_fair_er
farmer115017373__farmer
filmer114112403__filmer
firer811229253__fir_er
firmed125411883__firmed
firmers124711443__firmers
flirter10318673_flirter
former114221403__former
iffier1236763iffi__er
infirmed14205343infirmed
informer13227283informer
mafficker2342253mafficker
offerer1335543offer_er
officer1534213offi_cer
reaffirmed1951503reaffirmed
reformer13217953reformer
squirmer1934373squirmer

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 Filter1786911461620.483369960.7
2DLD Change Limit146162537.83018666.9
3Display Results53530.0134076.9
 (SQL Overall)178691538.32621461.8
 
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.