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

113 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
affords143502(None) 
afford1346491afford_
accords1247242accords
affirms1534382affirms
afforded1643432afforded
afforest1446342afforest
efforts1334702efforts
fiords10498622_fiords
fjords17405352_fjords
fords95328182__fords
oxfords1842892oxfords
abfarads1443163abfarads
abhors11410623abhor_s
aborts84916183a_borts
absorbs1135613absorbs
absurds1035003absurds
accord1178843accord_
acorns85013013a_corns
actors81016763actor_s
adores74420723a_dores
adorns74212613a_dorns
adsorbs1044713adsorbs
afars85716513a_far_s
afeard1058263afeard_
affaires1444303affaires
affairs1334163affairs
affects1535393affects
affines1339483affines
affirm1435523affir_m
affixes2035503affixes
affording1744023affording
afforests1543733afforests
affray1534973aff_ray
affrays1644063affrays
affront1357963affront
affronts1444163affronts
afore85818603a_for_e
afters94717073after_s
aftosas10147153aftosas
agoras7613343a_goras
aholds10469483a_holds
alforja1782303alforja
alforjas1872363alforjas
algors7312553algor_s
allods73615083allo_ds
almonds10127953almonds
angoras8811363angoras
apods86316343a_po_ds
arbores94016033arbores
arbors84717883arbor_s
ardors74416873ardor_s
armors85017813armor_s
aroids75118223a_roids
assorts73310153assorts
attorns738443attorns
auroras7311703auroras
ausforms1343933ausforms
avoids104410203a_voids
awards107113453a_wards
bywords1634283bywords
chords125214633_chords
cords86030623__cords
deforms1337803deforms
effort1238623effor_t
enfolds11136253enfolds
fanfolds15104073fanfolds
fards96629843__fards
favors124211403favor_s
feods99516853_feo_ds
fiord94313343_fiord_
fjord16477023_fjord_
floods104511653_floods
floras94715693_floras
folds95221693__folds
fonds95824823__fonds
foods95924163__foods
forbs105720803__forbs
ford86835493__ford_
fordo97218653__fordo
fores85847103__fores
forks125324683__forks
forms105327053__forms
forts86034453__forts
fronds106412343_fronds
gaffers14428713gaffer_s
haftoros1444173haftoros
hayforks2143423hayforks
infolds11137023infolds
informs1248073informs
kaffirs17325553kaffir_s
lords64923503__lords
milords10117853milords
offends14234293offends
offers12349963offer_s
offloads1542723offloads
oxford1763663oxford_
records105213923records
refolds11298953refolds
reforms1239823reforms
rewords115413983rewords
saffrons1444303saffrons
scaffolds1841573scaffolds
sords64527803__sords
swords104510803_swords
telfords1244363telfords
unfolds11146803unfolds
upfolds13133753upfolds
warlords1245303warlords
words95425073__words
zaffars22325233zaffar_s
zaffers22386773zaffer_s
zaffirs22375663zaffir_s
zaffres22324993zaff_res

Search took 7 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 Limit1340271136.36021073.4
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.81226231.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.