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

216 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
favours1343709(None) 
favors124211401favo_rs
favour12438331favour_
flavours1434691flavours
savours10389341savours
amours83512662_amours
devours1166642devours
dyvours1453182dyvours
faitours1134262faitours
famous11412392famou_s
favor114712452favo_r_
favorers1465492favorers
favoured1533962favoured
favourer1443822favourer
favourers1543122favourers
favus114311732fav_u_s
fervours1453052fervours
flavors1337292flavo_rs
flavour1334632flavour_
flavoury1743062flavoury
flours94414052f_lours
fours85521492f__ours
haviours1443842haviours
labours9349892labours
paviours1343612paviours
sapours93610622sapours
saviours1154272saviours
savors95616102savo_rs
savour94110702savour_
savoury13365872savoury
tabours94110092tabours
valours10248742valours
vapours12277462vapours
amour75014853_amour_
arbours93910043arbours
ardours8368883ardours
armours9389853armours
augurs7399963_augurs
avers85127313_av_ers
avoids104410203_avoids
avos77227013_avo__s
avouch1434833_avouch
avowers1336333_avowers
avows114910983_avo_ws
bayous11411153bayou_s
bevors111610343bevo_rs
candours11408643candours
canoers94318373canoers
cavers115026843cav_ers
caviars1238623caviars
cavort11316173cavo_rt
cavorts1237933cavorts
clamours1255993clamours
clours85215093_clours
colours95913443colours
detours858043detours
devoirs1175783devoirs
devour1076703devour_
disfavours1751623disfavours
dolours8438823dolours
dyvour1393343dyvour_
enamours1044663enamours
fablers124812613fablers
facers115519443fa_cers
factors12912133factors
facture12108933facture
factures13129033factures
fadeouts1245693fadeouts
faders105117463fa_ders
fados95620733fado__s
fagoters1234863fagoters
fagots1039963fago_ts
failure1035753failure
failures1135163failures
fairs85825443fa__irs
faitour1034883faitour_
fakeers14446673fakeers
fakers134219533fa_kers
fakirs13468083fa_kirs
fallers103917993fallers
fallouts1137883fallouts
falters103916473falters
fanners103914653fanners
fanons96115213fano_ns
fanos85926503fano__s
fanums1137263fa_nums
faqirs18456033fa_qirs
faquirs1943863faquirs
farcers124713443farcers
farceurs13464723farceurs
farers95924053fa_rers
farmers124315263farmers
faros85532023faro__s
fathers133916503fathers
fatuous1037783fatuous
faubourg1461693faubourg
faubourgs1541233faubourgs
fauns84516753fa__uns
favas115618593fav__as
favelas1337023favelas
faves115331423fav__es
favisms1535443favisms
favored1455983favored
favorer1355883favorer
favouring1644023favouring
favuses1336183favuses
fawners13388493fawners
femurs1136713f_emurs
fervors1336233fervo_rs
fervour1343103fervour_
fetors91014473feto_rs
fevers125414893fev_ers
fivers124420923fiv_ers
flaneurs1133953flaneurs
flavones1435833flavones
flavor1236663flavo_r_
flavorers1563983flavorers
flavory1644743flavo_ry
flavoured1642983flavoured
floors94112353f_loors
flour84916453f_lour_
floury12449573f_loury
flouts94315273f_louts
fluors94311373fluo_rs
fouls87221433f__ouls
four76226863f__our_
fracturs13146323fracturs
frakturs15163273frakturs
fucous11399863fucou_s
fulvous1334543fulvou_s
furors9310953furo_rs
furs76735043f___urs
gators74115843gato_rs
gaurs66317993ga__urs
gavots1038113gavo_ts
giaours834573giaours
glamours1184743glamours
harbours1346923harbours
havers124721483hav_ers
haviors1347383haviors
haviour1354823haviour_
havocs1435653havo_cs
honours10339373honours
hours85422393__hours
humours1286433humours
inpours936423inpours
labors84016413labo_rs
labour84210933labour_
langurs889103langurs
laveers10329363laveers
lavers94526363lav_ers
layouts1046483layouts
lours55125293__lours
mahouts1237143mahouts
majors154511093majo_rs
manors84420883mano_rs
mayors115714193mayo_rs
navars92810573nav_ars
odours7418253_odours
ours47237563___ours
padouks1434873padouks
pandours11317993pandours
parlours1036153parlours
parous84024163parou_s
pavers115021823pav_ers
paviors1237603paviors
paviour1244623paviour_
payors114312643payo_rs
payouts1247303payouts
pours74623183__pours
ragouts838543ragouts
ramous8417113ramou_s
rancours1076713rancours
ravers94628183rav_ers
razors154711663razo_rs
repours9310233repours
rigours8207003rigours
rumours976373rumours
sajous13310583sajou_s
salvors103910913salvo_rs
samburs11369343samburs
santours837183santours
santurs7310763santurs
sapors84118813sapo_rs
sapour83812373sapour_
savers93825923sav_ers
saviors1058993saviors
saviour1035213saviour_
savor85417943savo_r_
savorers1157223savorers
savory124310563savo_ry
savoured1234793savoured
savourer1134473savourer
savourers1243833savourers
savouries1245473savouries
savoys12427893savo_ys
scours84913593_scours
sours55230503__sours
stours65015633_stours
tabors84517113tabo_rs
tabour84011323tabour_
tambours1255873tambours
tamburs11288613tamburs
tenours72610073tenours
tours55325893__tours
tumours976753tumours
valors93413773valo_rs
valour93010373valour_
vapors113812693vapo_rs
vapour11378873vapour_
vapoury15284803vapoury
vavasours15131893vavasours
velours10278083velours
vigours11285483vigours
wavers125022473wav_ers
yours85217883__yours

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 Limit1340272167.09318895.7
3Display Results2162160.0802700.0
 (SQL Overall)1786912167.57923577.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.