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

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

106 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
affirms153438(None) 
affirm1435521affirm_
affaires1444302affaires
affairs1334162affair_s
affines1339482affines
affirmed1743212affirmed
affirmer1643082affirmer
affirmers1742562affirmers
affixes2035502affixes
affords1435022affords
firms105217422__firms
infirms1245562infirms
kaffirs17325552kaffir_s
reaffirms1741942reaffirms
zaffirs22375662zaffir_s
admires1038663admires
afars85716513a_far_s
affair1234353affair__
affaire1344463affair_e
affects1535393affects
affiant1348433affiant
affiants1445233affiants
affiche1844313affiche
affiches1945233affiches
affinal1336443affinal
affine12310503affi_ne
affined1436413affined
affirmant1753813affirmant
affirmants1852763affirmants
affirming1843103affirming
affix1836003affi__x
affixal2043763affixal
affixed2134123affixed
affixer2033913affixer
affixers2143293affixers
afflicts1644003afflicts
afford1346493affor_d
afforest1446343afforest
affray1534973aff_ray
affrays1644063affrays
afire86215913a_fir_e
afrits9311903afri_ts
afters94717073after_s
ageisms1056603ageisms
agisms9399393a_gisms
aims67738183a__i_ms
airns55521033a__irns
airs46447423a__ir_s
airts55626343a__irts
alarms85913053a_larms
alliums957973alliums
amirs75924923a_mir_s
arms66137493a___rms
aspires9612043aspires
atriums939043atriums
attires72312953attires
ausforms1343933ausforms
autisms94311553autisms
axioms15408053a_xioms
baffies153612943baffi_es
chirms135113983_chirms
confirms1536303confirms
deforms1337803deforms
disaffirms1951513disaffirms
efforts1334703efforts
fairs85825443_fair_s
fakirs13468083fakir_s
faqirs18456033faqir_s
farms106324953__farms
favisms1535443favisms
films105617963__films
fires85740753__fires
firm96026453__firm_
firns86018543__firns
firs76637713__fir_s
flirs85518933_flir_s
flirts95411483_flirts
forms105327053__forms
gaffers14428713gaffer_s
haffits1636193haffi_ts
hafniums1643103hafniums
infirm1137043infirm_
informs1248073informs
kaffir16345303kaffir__
kafirs13306983kafir_s
kefirs13396653kefir_s
maffias15327283maffi_as
mafficks2243173mafficks
maftirs1236043maftir_s
offers12349963offer_s
offices1536243offices
offings14285833offings
raffias13237713raffi_as
reaffirm1642483reaffirm_
refilms12347503refilms
refires104820313refires
reforms1239823reforms
squirms18376343squirms
taffias13377413taffi_as
taffies133012693taffi_es
thairms1244453thairms
waffies163611443waffi_es
zaffars22325233zaffar_s
zaffers22386773zaffer_s
zaffir21395513zaffir__
zaffres22324993zaff_res

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271066.65620136.3
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.09225196.1
 
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.