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

170 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
afford134649(None) 
affords1435021affords
accord1178842accord
afeard1058262afeard
affirm1435522affirm
afforded1643432afforded
afore85818602a_fore
effort1238622effort
fiord94313342_fiord
fjord16477022_fjord
ford86835492__ford
oxford1763662oxford
abfarad1344223abfarad
abhor10411063abhor_
abhors11410623abhors
aboard9312613aboard
abort76133583a_bort
abroad9310943abroad
absorb1038013absorb
absurd935903absurd
accords1247243accords
aciform1446013aciform
acold86214933a_cold
acorn75616623a_corn
actor71116083actor_
actors81016773actors
adore65723673a_dore
adored84714243a_dored
adorn64917093a_dorn
adsorb946953adsorb
afar76720783a_far_
afars85716513a_fars
afeared1176833afeared
aff95537613aff___
affair1234353affair
affaire1344463affaire
affairs1334163affairs
affect1448903affect
affine12310503affine
affined1436413affined
affirmed1743213affirmed
affirms1534383affirms
affix1836003aff_ix
affixed2134123affixed
afflux1942793afflux
affording1744023affording
afforest1446343afforest
affray1534973affray
affront1357963affront
afield1035953afield
afire86215913a_fire
afloat9315153afloat
afoot8420113a_foot
afoul8510193a_foul
afraid1049723afraid
after85719793after_
afters94717073afters
aftosa996573aftosa
agora6914333a_gora
ahold94714253a_hold
alforja1782313alforja
algoid83011473algoid
algor6513053algor_
algors7312553algors
aliform1247033aliform
allod64418383allo_d
almond91410433almond
aloud65018073a_loud
amort75832203a_mort
angora71111573angora
apod78123183a_po_d
aport75432173a_port
arbor74818113arbor_
arbored103811603arbored
arbors84717883arbors
ardor64617863ardor_
ardors74416873ardors
armor75118053armor_
armored102610473armored
armors85017813armors
armory114211473armory
aroid65428343a_roid
ashore9414613ashore
assort64916383assort
attorn6310793attorn
aurora6411763aurora
ausform1245233ausform
autoed7712823autoed
avoid95516683a_void
award97118043a_ward
baffed154812173baff_ed
baffled16418063baffled
before11410153before
bifold1237223bifold
biform1368123biform
byword1535053byword
chord115917263_chord
cord76740923__cord
daffed14429493daff_ed
deform1259623deform
efforts1334703efforts
enfold10137613enfold
fanfold1485373fanfold
fard85639063__fard
favor114712453favor_
favored1455983favored
favors124211403favors
feod815523003_feo_d
fiords10498623_fiords
fjords17405353_fjords
flood95215603_flood
flora85317103_flora
florid10311453_florid
fold86528943__fold
fond86330953__fond
food86830573__food
for66952073__for_
fora75937393__fora
forb97131333__forb
fordo97218653__fordo
fords95328183__fords
fore78351473__fore
fork115930943__fork
form95836873__form
fort76456443__fort
frond95316343_frond
frore86218803_frore
gaffed144210203gaff_ed
gaffer134310133gaffer_
gaffers14428713gaffers
hayfork2043763hayfork
infold10128163infold
inform11310153inform
kaffir16345303kaffir_
kaffirs17325553kaffirs
lord55032083__lord
milord999573milord
naffed13408333naff_ed
offed12359163off_ed
offend13365663offend
offer114311383offer_
offered1436143offered
offers12349963offers
offload1443203offload
oxfords1842893oxfords
raffled14429083raffled
record96117433record
refold103812113refold
reform11312713reform
reword106321413reword
saffron1344173saffron
scaffold1742233scaffold
sord56237203__sord
sword95214123_sword
telford1145153telford
unfold10179703unfold
unfond10149113unfond
upfold12124953upfold
waffed16459793waff_ed
waffled17357523waffled
warlord1136293warlord
word89832003__word
yaffed16457323yaff_ed
zaffar21385043zaffar_
zaffars22325233zaffars
zaffer21397153zaffer_
zaffers22386773zaffers
zaffir21395513zaffir_
zaffirs22375663zaffirs
zaffre21354663zaff_re

Search took 6 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.393454684.5
2DLD Change Limit1127161704.96622697.5
3Display Results1701700.0463695.7
 (SQL Overall)1786911705.40533060.3
 
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.