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

149 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
affirm143552(None) 
affirms1534381affirms
affair1234352affair_
affaire1344462affaire
affairs1334162affairs
affine12310502affine
affirmed1743212affirmed
affirmer1643082affirmer
affix1836002affi_x
afford1346492afford
afire86215912a_fire
firm96026452__firm
infirm1137042infirm
kaffir16345302kaffir_
kaffirs17325552kaffirs
reaffirm1642482reaffirm
zaffir21395512zaffir_
zaffirs22375662zaffirs
aciform1446003aciform
admire949933admire
aecium10410423aecium
afar76720783a_far_
afars85716513a_fars
afeard1058263afeard
aff95537613aff___
affaires1444303affaires
affect1448903affect
affiant1348433affiant
affiche1844313affiche
affinal1336443affinal
affined1436413affined
affines1339483affines
affirmant1753813affirmant
affirmers1742563affirmers
affirming1843103affirming
affixal2043763affixal
affixed2134123affixed
affixer2033913affixer
affixers2143293affixers
affixes2035503affixes
afflict1547043afflict
afflux1942793afflux
affords1435023affords
affray1534973affray
afore85818603a_fore
afrit8323173afri_t
afrits9311903afrits
after85719793after_
afters94717073afters
ageism968803ageism
agism84614063a_gism
aim57858213a__i_m
air38058393a__ir_
airn46433833a__irn
airs46447423a__irs
airt45757783a__irt
airy75734153a__iry
alarm76621423a_larm
aliform1247033aliform
allium8311243allium
amir65129753a_mir_
amirs75924923a_mirs
arm58449623a___rm
aspire8612123aspire
astir55517093astir_
aswarm11107913aswarm
aswirl935093aswirl
atrium8411823atrium
attire62412383attire
ausform1245233ausform
autism83815333autism
awhirl1264673awhirl
axiom143913593a_xiom
baffies153612943baffies
baffing164011603baffing
biform1368123biform
chirm125317063_chirm
confirm1437363confirm
daffier1457833daffier
daffily1735133daffily
daffing15369733daffing
deform1259613deform
disaffirm1851833disaffirm
effigy1642213effigy
effort1238623effort
fair76332523_fair_
fairs85825443_fairs
fairy115318283_fairy
fakir125111493fakir_
fakirs13468083fakirs
faqir17548643faqir_
faqirs18456033faqirs
farm95934533__farm
favism1437913favism
film94828173__film
fir66744893__fir_
fire76245593__fire
firms105217423__firms
firn76927503__firn
firs76637713__firs
flir76422203_flir_
flirs85518933_flirs
flirt87424753_flirt
form95836873__form
gaffer134310133gaffer_
gaffers14428713gaffers
gaffing15379733gaffing
haffit1538533haffi_t
haffits1636193haffits
hafnium1544243hafnium
iffier1236763iffier
infirms1245563infirms
inform11310153inform
kafir12488903kafir_
kafirs13306983kafirs
kefir12457913kefir_
kefirs13396653kefirs
maffia14327203maffi_a
maffias15327283maffias
maffick2143523maffick
maftir1136493maftir_
maftirs1236043maftirs
naffing14359033naffing
offer114311383offer_
offers12349963offers
office1435693office
offing13368643offing
offish15137273offish
raffia12287703raffi_a
raffias13237713raffias
raffish1658843raffish
reaffirms1741943reaffirms
refilm114311403refilm
refire95419473refire
reform11312703reform
squirm17387673squirm
taffia12286903taffi_a
taffias13377413taffias
taffies133012693taffies
thairm1156963thairm
waffie15338563waffi_e
waffies163611443waffies
waffing173710243waffing
yaffing17337823yaffing
zaffar21385043zaffar_
zaffars22325233zaffars
zaffer21397153zaffer_
zaffers22386773zaffers
zaffre21354663zaff_re

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161497.59614838.9
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.78222962.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.