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

199 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
faceup133489(None) 
backup1646612backup
face96140122face__
faced117727652face_d
facer105525052face_r
facers115519442facers
faces106439432face_s
facet106038522face_t
facete115014832facete
facets116316652facets
farceur12525272farceur
flareup1243172flareup
fuckup1733962fuckup
makeup1434862makeup
takeup1234582takeup
ace59656833_ace__
aced79540883_ace_d
acerb9312763_acerb
aces67645093_ace_s
aceta74017353_aceta
acetum1038463_acetum
backups1736173backups
bicep115413543bice_p
cactus104912233cactus
caecum1238183caecum
catchup1644793catchup
catsup1036433catsup
cep75736333__ce_p
cockup1635713cockup
coup86729793__coup
crackup1743563crackup
cup76738243__c_up
dace76934923dace__
daces85030683dace_s
eyecup1344493eyecup
facade1238803facade
faceted13509563faceted
facia103218463fac_ia
faciae112913413faciae
facial113615633facial
facias113415803facias
faciend1334803faciend
facies113921593facies
facile112514883facile
facing125321573facing
fact97142543fac__t
factful1536373factful
factor11911453factor
facts107021893fac_ts
factual1246723factual
facture12108923facture
facula112912233facula
fade85736343fade__
faded105025243fade_d
fadein1068843fadein
fadeout11410193fadeout
fader94421513fade_r
faders105117463faders
fades94932863fade_s
faecal11359813faecal
faeces114713123faeces
faena85014203fa_ena
faery116015483fa_ery
fake115534943fake__
faked135225483fake_d
fakeer13378743fakeer
faker124824593fake_r
fakers134219533fakers
fakery16509263fakery
fakes126032483fake_s
fakey155515423fake_y
falces115216003falce_s
fame95639393fame__
famed115928343fame_d
fames105735923fame_s
famous11412393famous
fane75343573fane__
fanega1055783fanega
fanes84639893fane_s
fanum10313443fa_num
farce104925323farce__
farced125216533farce_d
farcer115016083farce_r
farcers124713443farcers
farces115223323farce_s
farceurs13464723farceurs
fare76354463fare__
fared95842343fare_d
farer86733143fare_r
farers95924053farers
fares85852873fare_s
fasces114914543fasce_s
fate75444283fate__
fated95632133fate_d
fateful1397513fateful
fates85139233fate_s
fauces114916153fauce_s
faucet115816553fauce_t
faucets12578443faucets
faun76226623fa__un
faux146519073fa__ux
fave105532963fave__
favela1237033favela
faves115331423fave_s
favour12438333favour
favus114311733fa_vus
faxed166220533faxe_d
faxes155726653faxe_s
fayed126422153faye_d
faze165630043faze__
fazed186222963faze_d
fazes175527213faze_s
feces105625363fece_s
feu67843663f__eu_
feud86523023f__eud
feus75830753f__eus
fice95737113fice__
fices106031163fice_s
fichu134810663fichu_
fichus14388113fichus
ficus105015493fic_us
flaneur1034183flaneur
flareups1342473flareups
focus105815883foc_us
foldup1233813foldup
fractur12135563fractur
fractus12146593fractus
fuckups1832923fuckups
fucous11399863fucous
fucus105515893fuc_us
fyce126316833fyce__
fyces139813643fyce_s
hacek145411843hace_k
haceks15447863haceks
hangup1277293hangup
hiccup1554393hiccup
jaup135316423ja__up
kickup1354133kickup
lace66848473lace__
laced87132643lace_d
lacer75833753lace_r
lacers85225253lacers
laces76141763lace_s
lacey105820913lace_y
larrup835713larrup
layup1037723la_yup
lineup835983lineup
lockup1434763lockup
lyceum1343953lyceum
mace87345793mace__
maced108528693mace_d
macer912126943mace_r
macers105321273macers
maces97139963mace_s
makeups1533603makeups
markup1436903markup
matchup1643513matchup
mockup1634073mockup
pace86345773pace__
paced106931683pace_d
pacer96131613pace_r
pacers105124543pacers
paces96741113pace_s
pacey126720283pace_y
pareu74928743pareu_
pareus85420743pareus
pasteup1134983pasteup
pickup1655633pickup
pileup10437923pileup
race66746263race__
raced87635313race_d
raceme1039733raceme
racer75233023race_r
racers84725433racers
races74943243race_s
recoup10810373recoup
sacbut10811943sacbut
sacque17107113sacque
sacrum103910143sacrum
salep77022953sale_p
sannup836563sannup
scaleup1134483scaleup
scaup95515993_scaup
scup84822383_sc_up
shakeup1632763shakeup
shapeup1443293shapeup
stackup1533743stackup
tace65342513tace__
taces76237803tace_s
tacet75840023tace_t
takeups1333403takeups
teacup1036253teac_up
tuneup835203tuneup
vacua10510463vac_ua
vacuum1334833vacuum
walkup1534193walkup
warmup1335343warmup
washup1435323washup
yaup96618483ya__up

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161996.03318683.2
3Display Results1991990.0603316.7
 (SQL Overall)1786911996.23328668.5
 
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.