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

181 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
farceur1252527(None) 
farcer115016081farce_r
farceurs13464721farceurs
facer105525052fa_ce_r
faceup1334892fa_ceup
farce104925322farce__
farced125216532farce_d
farcers124713442farcers
farces115223322farce_s
farer86733142far_e_r
farmer115017372farme_r
forcer114917342force_r
fractur12135562fractur
arbour84211333_arbour
arced88224163_arce_d
archer115016243_archer
arcus76918863_arc_us
ardour74110903_ardour
arguer74510543_arguer
armer76924443_arme_r
armour84411853_armour
arrear6310253_arrear
auteur6107943_auteur
barber104419323barbe_r
barer74535803bar_e_r
barker124822863barke_r
barter85525373barte_r
bracer104620583brace_r
cancer104220923cance_r
carcel105018673carce_l
carcels114516063carcels
carder94524183carde_r
career85822243car_eer
carer74942333car_e_r
carper104923633carpe_r
carter84932273carte_r
carver114420143carve_r
dancer94817613dance_r
danseur833663danseur
darer65230793dar_e_r
darker114718693darke_r
darner74017303darne_r
darter75320363darte_r
douceur1043113douceur
earner63617223earne_r
fabber134814113fabbe_r
fabler116115813fable_r
face96140123fa_ce__
faced117727653fa_ce_d
facers115519443fa_cers
faces106439433fa_ce_s
facet106038523fa_ce_t
facete115014833fa_cete
facets116316653fa_cets
factor11911453fa_ctor
facture12108923fa_cture
fader94421513fa_de_r
faeces114713123faece_s
fainer94717243faine_r
fairer95212063faire_r
faitour1034883faitour
fakeer13378743fa_keer
faker124824593fa_ke_r
falces115216003falce_s
faller94621233falle_r
falser93912413false_r
falter94519053falte_r
fancier123412063fancier
fanner94218183fanne_r
farci105919313farc__i
farcie114816473farc_ie
farcies125317883farcies
farcing133514003farcing
farcy135217093farc__y
farded114518953farde_d
fardel104712593farde_l
fardels11389893fardels
fare76354463far_e__
fared95842343far_e_d
farers95924053far_ers
fares85852873far_e_s
farfel124310433farfe_l
farfels13348213farfels
farle86929243farle__
farles96025783farle_s
farmed125117653farme_d
farmers124315263farmers
farness102912203farness
farrier103514893farrier
farted105121783farte_d
farther1348343farther
fasces114914543fasce_s
faster94625773faste_r
father125116713fathe_r
fatter94523213fatte_r
fauces114916153fauce_s
faucet115816553fauce_t
faucets12578443faucets
favour12438333fa_vour
fawner125910463fawne_r
fearer94820183fear_e_r
fencer114613533fence_r
fervour1343103fervour
fiercer12356953fierce_r
firer811229253fir_e_r
firmer114712443firme_r
flaneur1034183flaneur
flareup1243173flar_eup
forbear1237523forbear
force105324273force__
forced126316523force_d
forceful1644603forceful
forceps14466983forceps
forcers124215713forcers
forces114422133force_s
forger104820773forge_r
forker134717903forke_r
former114221403forme_r
fracture13147123fracture
fracturs13146313fracturs
fractus12146593fractus
fraktur14153033fraktur
framer114817443frame_r
frater94520593frate_r
freer86021243f_r_eer
frier85225843f_rie_r
friseur1033673friseur
fryer115913433f_rye_r
furfur1235553fur_fur
furler93616403furle_r
garner73917003garne_r
garter74420513garte_r
harbour1247053harbour
harder105022403harde_r
harmer114719553harme_r
harper115018403harpe_r
hauteur1033893hauteur
lacer75833753la_ce_r
lancer84319973lance_r
larcener1036493larcener
larceny1234853larceny
larder73720973larde_r
larger74417513large_r
larker104519243larke_r
macer912126943ma_ce_r
marcel103714853marce_l
marcels113212373marcels
marcher143912973marcher
marker124420393marke_r
marrer83716673marre_r
masseur935703masseur
mercer105214203merce_r
narcein936293narcein
pacer96131613pa_ce_r
parcel103915473parce_l
parcels113712663parcels
parcener1238473parcener
parer75839903par_e_r
pareu74928743par_eu_
pareus85420743par_eus
parker124121373parke_r
parlour937263parlour
parser84822373parse_r
racer75233023ra_ce_r
rancour987133rancour
rarer54731703rar_e_r
recur74116843__recur
sarcous9312933sarcous
saucer84314103sauce_r
scarcer113911373scarce_r
tarter64023563tarte_r
tracer84820233trace_r
varier94619353varie_r
warder104020273warde_r
warier93722893warie_r
warmer113816733warme_r
warner93717223warne_r
warper114015583warpe_r
yarder103813973yarde_r
yarer84321573yar_e_r
yarner93313063yarne_r

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.1561145455.1
2DLD Change Limit1340271817.72017361.0
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.93922508.0
 
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.