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

420 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
scarfers1340846(None) 
scarers94618501scar_ers
scarfer124511081scarfer_
scarpers124712511scarpers
carders104820352_carders
careers95218782_careers
carers85133962_car_ers
carpers114521252_carpers
carters95327252_carters
carvers124817532_carvers
scalers93817262sca_lers
scalpers123710862scalpers
scammers14339772scammers
scampers143611032scampers
scanners10379702scanners
scarcer113911372scarcer_
scarer84524602scar_er_
scares85033002scar_e_s
scarfed134711182scarfe_d
scarfs114714682scarf__s
scarier94017872scarier_
scarifiers1544102scarifiers
scarless10189052scarless
scarlets10178572scarlets
scarper114814822scarper_
scarves124511622scarve_s
scatters103612752scatters
scaupers12378172scaupers
sclaffers17122522sclaffers
scoffers16286132scoffers
scorers94115312scor_ers
scorners10228492scorners
scrapers125510522scrapers
scuffers16307492scuffers
sharers104720622shar_ers
sharkers154011052sharkers
sharpers133810942sharpers
snarers74216662snar_ers
snarlers8298752snarlers
soarers74118092soar_ers
sparers94519612spar_ers
spargers11389732spargers
sparkers144111312sparkers
staffers14247082staffers
starers74522312star_ers
starkers123712392starkers
starters83714772starters
starvers11459642starvers
strafers11379912strafers
surfers103614132s_urfers
swarmers1346322swarmers
armers85520273__armers
awarders1245073awarders
barbers114317503_barbers
barkers134318513_barkers
barters94223033_barters
bearers94619593bear_ers
boarders11408623boarders
cabers105023923_ca_bers
cablers114416713_cablers
cadgers114712003_cadgers
cafes106426923_ca_fe_s
cagers95624193_ca_gers
cahiers123510673_cahiers
calkers134414693_calkers
callers94221963_callers
cambers134017443_cambers
campers134220293_campers
cancers114018583_cancers
caners84629203_ca_ners
cankers134418753_cankers
canners93822663_canners
canoers94318373_canoers
canters94827733_canters
capers105428143_ca_pers
cappers134419403_cappers
carafes125015703_carafe_s
carcels114516063_carcels
carder94524183_carder_
careens94514703_careens
career85822243_career_
carer74942333_car_er_
cares77369183_car_e_s
caress85720263_car_ess
carets85330773_car_ets
carfare12310073_carfare
carfares13310323_carfares
carfuls1249133_carfuls
caries85147623_carie_s
carles85435083_carle_s
carless95118493_carless
carnets93918403_carnets
carneys124310543_carneys
carolers103314173_carolers
carpels115315463_carpels
carper104923633_carper_
carpets113915333_carpets
carrels95117303_carrels
carriers103614203_carriers
carrs75730853_car__rs
carses85233653_carse_s
cartels94618123_cartels
carter84932273_carter_
cartes86239473_carte_s
carvels124914593_carvels
carver114420143_carver_
carves115128453_carve_s
casters94729903_casters
caters85336503_ca_ters
causers94014793_causers
cavers115026843_ca_vers
chafers154512743_chafers
chaffers19378003chaffers
chamfers18409223chamfers
chargers144011323chargers
charmers154211333charmers
charters134115583charters
chaufers16347303chaufers
coffers154112693_coffers
confers124120093_confers
corders104520883_corders
corers85231073_cor_ers
corkers134118853_corkers
corners94723313_corners
crafters13419953_crafters
craters95021893_craters
cravers124416553_cravers
criers83918583_c_riers
curbers115514383_curbers
curers84923193_cur_ers
curfews15294913_curfews
curlers94218073_curlers
cursers94317163_cursers
darers75921873_dar_ers
darners83815773_darners
darters84017603_darters
discarders1445043discarders
dwarfer1433683dwarfer_
earners74016453_earners
ecartes94212563ecarte_s
escapers12337413esca_pers
farcers124713443_farcers
farers95924053_far_ers
farfels13348213_farfels
farmers124315263_farmers
fearers104815273fear_ers
gaffers14428713_gaffers
garners83815983_garners
garters84218233_garters
guarders1035883guarders
harmers124116593_harmers
harpers124916203_harpers
hearers104319783hear_ers
hoarders12307433hoarders
larders83516943_larders
larkers113014513_larkers
learners8398153learners
loafers10349463loa_fers
markers133516103_markers
marrers93414313_marrers
parers85530743_par_ers
parkers133816873_parkers
parsers94118153_parsers
pearlers1039033pearlers
piaffers16114203piaffers
quaffers2333963quaffers
quarters173110453quarters
rearers74323563rear_ers
roarers73812743roar_ers
sabers85224733s_a_bers
sackers133820223s_ackers
safer84721813s_a_fer_
safes85226723s_a_fe_s
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sanders84025943s_anders
sangers84421943s_angers
sappers113518903s_appers
sardars83112903s_ardars
sarees65329943s_ar_ees
sarges75128593s_arge_s
sarsars73512143s_arsars
sarsens7311393s_arsens
sartors7314963s_artors
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scabies11613333scabie_s
scalares103210983scalares
scalars93711903sca_lars
scaler84321603sca_ler_
scales84529313sca_le_s
scalier94316913scalier_
scalpels12345883scalpels
scalper113912923scalper_
scammer133611973scammer_
scamper134613163scamper_
scamsters1334993scamsters
scanner94411813scanner_
scanter94215183scanter_
scapes105122263sca_pe_s
scarabs1137293scar_abs
scarce104013633scarce__
scarcely1534313scarcely
scarcest12169173scarcest
scare75334463scar_e__
scared95227293scar_e_d
scareder1135783scareder_
scarey115016983scar_e_y
scarf105427143scarf___
scarfing14309713scarfing
scarfpin1553033scarfpin
scarfpins1653043scarfpins
scariest101615943scariest
scarifier1446653scarifier_
scarifies1439603scarifies
scariness11310183scariness
scarious10610203scarious
scarlet91516943scarle_t
scarped124314403scarpe_d
scarpered1435113scarpered
scarphs14437413scar_phs
scarps104718603scar__ps
scarred104512633scarre_d
scarrier10298453scarrier_
scarry116311183scar__ry
scars75433533sca___rs
scarted104816123scarte_d
scarts85321493scar__ts
scathes124515713scathe_s
scatter93815173scatter_
scauper11379453scauper_
scaurs85512053sca__urs
scepters1237783scepters
schemers1576703schemers
schmeers1574833schmeers
sclaffer16112653sclaffer_
scoffer15317023scoffer_
scolders11288993scolders
scoopers124210193scoopers
scooters103511033scooters
scorchers16145513scorchers
scorer84818253scor_er_
scores84725923scor_e_s
scorifiers1543603scorifiers
scorner9259763scorner_
scoters93313813sc_oters
scourers10348533scourers
scourgers1234383scourgers
scouters103411323scouters
scowders14276223scowders
scowlers13257363scowlers
scraper114513413scraper_
scrapes116217663scrape_s
scrappers1545853scrappers
scrawlers1434743scrawlers
screeds106210283sc_reeds
screens95212173sc_reens
screes85023963sc_r_ees
screwers13358053screwers
screws115513883sc_r_ews
scribers12307953scribers
scries85226823sc_rie_s
scuffer15328883scuffer_
scufflers17285033scufflers
sculkers14306933sculkers
scullers103510483scullers
scummers14277783scummers
scunners10357303scunners
scuppers1446543scuppers
scurfier13267053scurfier_
scurfs113210813scurf__s
scutters103311023scutters
sealers74323553sea_lers
seamers94719433sea_mers
searchers14197353searchers
searer65432023sear_er_
seaters74028943sea_ters
securers1057153secur_ers
sergers83815633s_ergers
servers103214833s_ervers
shaders115915553sha_ders
shakers144015563sha_kers
shammers153710843shammers
shapers124016893sha_pers
sharer95025483shar_er_
shares95236413shar_e_s
sharker144313813sharker_
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shearers113911323shear_ers
shirkers15319583shirkers
skankers11316483skankers
skaters113512963ska_ters
skirters12337243skirters
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slappers123710943slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
smackers16318713smackers
smartens10286663smartens
smarter94113133smarter_
smashers13339593smashers
smatters104011713smatters
smearers10308623smear_ers
smirkers14316353smirkers
snackers143010223snackers
snappers123510173snappers
snarer64620843snar_er_
snares65329033snar_e_s
snarfed11378753snarfe_d
snarfs95113423snarf__s
snarler73610633snarler_
sniffers14257123sniffers
snorers74313803snor_ers
snorters83410583snorters
snuffers14326923snuffers
soakers114114953soa_kers
soapers93715923soa_pers
soarer64522243soar_er_
socagers1196363soca_gers
sorners73416873s_orners
sorters74221133s_orters
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammers14378693spammers
spankers14369863spankers
spanners103710773spanners
sparer84524963spar_er_
spares84834553spar_e_s
sparger103613083sparger_
sparges104016343sparge_s
sparker133914363sparker_
sparklers15315643sparklers
sparser94311483sparser_
spatters103914703spatters
spawners13396493spawners
spearers103711143spear_ers
spoofers13307323spoofers
sporters103714063sporters
sprayers13367053sprayers
spurners10288493spurners
spurrers10338463spurrers
spurters103311703spurters
squarers17338023squar_ers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffer13299093staffer_
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stammers123611523stammers
stampers124211603stampers
standers93514303standers
staplers103111203staplers
starer64027363star_er_
stares66038753star_e_s
starets73515923star_ets
starker114114693starker_
starless81610843starless
starlets81610083starlets
starter73817883starter_
startlers9236743startlers
starver104611993starver_
starves104614553starve_s
staters73922343sta_ters
stayers103813633sta_yers
stirrers8266943stirrers
storers75018683stor_ers
strafer103912463strafer_
strafes104516003strafe_s
strayers113510143strayers
stuffers14277383stuffers
suffers133113543s_uffers
sugarers936303sugar_ers
surfer93515883s_urfer_
surgers83517483s_urgers
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swampers15317473swampers
swappers15358083swappers
swarfs125612063swarf__s
swarmer1247803swarmer_
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
swearers11328583swear_ers
swervers1455213swervers
tearers75218233tear_ers
variers103712663_variers
wafers124316143_wa_fers
warders113416813_warders
warmers124514293_warmers
warners103315563_warners
warpers123413583_warpers
wearers104615903wear_ers
yarders113211593_yarders
yarners104312203_yarners
yearners11346373yearners
zaffers22386773_zaffers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461624207.01620832.7
3Display Results4204200.1562692.3
 (SQL Overall)1786914207.32824384.7
 
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.