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

439 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
frappes1432838(None) 
frappe13286951frappe_
frapped15318851frapped
crapes104727692cra_pes
crapped143912622crapped
crapper133913192crapper
crappers144011022crappers
crappies142911162crappies
drapes95419652dra_pes
flapped15328252flapped
flapper14359202flapper
flappers15388382flappers
fraises104215692fraises
frames115119862fra_mes
fraps105620552fra_p_s
frasses104314512frasses
grapes95123122gra_pes
grappas12357102grappas
grapples13348122grapples
grippes124810372grippes
nappes104515622_nappes
rapes75740722_ra_pes
raphes115117452_raphes
rapped114122682_rapped
rappee103618672_rappee
rappees113611452_rappees
rappel104211952_rappel
rappels11448802_rappels
rappen103512712_rappen
rapper104621572_rapper
rappers113618442_rappers
trapes85024462tra_pes
trapped124512212trapped
trapper113912802trapper
trappers123711042trappers
wrapped15338022wrapped
wrapper14368332wrapper
wrappers15306932wrappers
agapes95212413aga_pes
apes66047433__a_pes
appel94615893__appel
appels104312793__appels
apples104315763__apples
apps86319693__app_s
apres75426403__apres
apses76823913__apses
arables91814973arables
arames84622573ara_mes
braces108427773bra_ces
braches144621223braches
braes75735053bra__es
braises93818873braises
braizes183112453braizes
brakes124923123bra_kes
brashes124518463brashes
brasses93818353brasses
braves115524083bra_ves
bravoes12418533bravoes
braxies16711463braxies
brazes175522193bra_zes
capes95441923_ca_pes
capped134721853_capped
capper124421983_capper
cappers134419403_cappers
chapes135421873cha_pes
chapped172711443chapped
chappies172610103chappies
clapped143511173clapped
clapper134011863clapper
clappers143310833clappers
cradles103114133cradles
crakes124921813cra_kes
crambes1339963crambes
cramped144712183cramped
cramps125615563cramp_s
cranes84330753cra_nes
crape96128443cra_pe_
craped116120523cra_ped
crappie13298983crappie
crappier14288133crappier
crappiest15267273crappiest
crappy15446803crapp_y
craps95328643cra_p_s
crases85532313cra_ses
crashes124618403crashes
crates85736063cra_tes
craves115825393cra_ves
crazes174720133cra_zes
crazies183413853crazies
crepes105419343cr_epes
cripes105120873cr_ipes
cripples14298403cripples
cropped143812063cropped
cropper133312963cropper
croppers143311483croppers
croppies143111133croppies
croupes114613103croupes
crupper13338563crupper
cruppers14317323cruppers
dapped124516763_dapped
dapper114016633_dapper
dapples1238993_dapples
dragees9359483dragees
drakes114715863dra_kes
drape85319633dra_pe_
draped105314363dra_ped
draper94315693dra_per
drapers105313353drapers
drapey125010583dra_pey
drawees11378363drawees
dripped13408083dripped
dripper12349233dripper
drippers13327943drippers
dropped13329283dropped
dropper12329873dropper
droppers13318603droppers
drupes94912653dr_upes
elapses957663elapses
erases64425403era_ses
etapes85415293eta_pes
fables114921673f_ables
faces106439433f_a_ces
facies113921593f_acies
fades94932863f_a_des
fadges114814033f_adges
faeces114713123f_aeces
fakes126032483f_a_kes
falces115216003f_alces
fames105735923f_a_mes
fanes84639893f_a_nes
farces115223323f_arces
farcies125317883farcies
fares85852873f_a_res
farles96025783f_arles
fasces114914543f_asces
fashes124524023f_ashes
fates85139233f_a_tes
fauces114916153f_auces
fauves125610423f_auves
faves115331423f_a_ves
faxes155726653f_a_xes
fazes175527213f_a_zes
feases95422923fea_ses
feazes184514173fea_zes
fiacres1237253fiacres
fiances12310673fiances
fipples14298653fipples
flakes134118873fla_kes
flambes14419503flambes
flames114723693fla_mes
flanes94522423fla_nes
flanges113413273flanges
flapless1335343flapless
flappier1544303flappier
flappiest1644863flappiest
flappy1654483flapp_y
flaps105621383fla_p_s
flares94521703fla_res
flashes133916103flashes
flaxes165015353fla_xes
flipped15358513flipped
flipper14389143flipper
flippers15338003flippers
flippest1535183flippest
flopped15338763flopped
flopper14328473flopper
floppers15337463floppers
floppies1546823floppies
fopped144012673f_opped
forages114217283fora_ges
forcipes1535943forcipes
fracas11311993fra_cas
fracases1336993fracases
fracted1339373fracted
fractus12146593fractus
frae75330473fra__e_
fragged134010163fragged
frags96322173fra__gs
frailer10319943frailer
frailest1139493frailest
frails93716473fra_ils
fraise94214913fraise_
frame105821803fra_me_
framed125116523fra_med
framer114817443fra_mer
framers125113823framers
francs114112193fra_ncs
franked153610053franked
franker143510183franker
frankers15348353frankers
frankest1536963frankest
franks134912733fra_nks
frap95925813fra_p__
frapping16348103frapping
frass85321123fra__ss
frater94520593fra_ter
fraters103517213fraters
frats86829673fra__ts
frauds1036753fra_uds
frayed135012163fra_yed
frays116920103fra__ys
frazils1956123frazils
frazzles19284813frazzles
frees86131393fr__ees
freezes193310353freezes
freres94716173fr_eres
freshes133515823freshes
friaries11310083friaries
fridges12369483fridges
fries85535603fr__ies
friezes19418913friezes
friges104116483fr_iges
fringes113514103fringes
frippery1832953frippery
frisees104411693frisees
frises94124273fr_ises
frites94922483fr_ites
fritzes19329453fritzes
frizes184015463fr_izes
frizzes18338183frizzes
froes86126693fr__oes
frontes104214163frontes
frumps13479783frump_s
frypans1544053frypans
furanes103214863fura_nes
gapes86030823_ga_pes
gapped124217123_gapped
graces94523493gra_ces
grades84926313gra_des
grammes123611323grammes
grampas12399253grampas
gramps114114273gramp_s
grampus12356313grampus
granges93516523granges
grape84824663gra_pe_
grapey126012303gra_pey
graphed1498473graphed
graphs124510153gra_phs
grapier103712603grapier
grapiest112211933grapiest
grapnel1035603grapnel
grapnels1134393grapnels
grappa11396443grapp_a
grapple12378003grapple
grappled14336093grappled
grappler13336193grappler
grapplers14274303grapplers
grasped11409063grasped
grasper10389793grasper
graspers11338403graspers
grasps9489253grasp_s
grasses84117343grasses
grates75429893gra_tes
graupel1034133graupel
graupels1133103graupels
graves104624003gra_ves
gravies11314093gravies
grazes164519643gra_zes
gripes94619873gr_ipes
grippe115310323grippe_
gripped13419343gripped
gripper124410713gripper
grippers13358133grippers
gropes95220403gr_opes
happed144820103_happed
happen134812193_happen
happens14359173_happens
harpies123818323harpies
irades74517393ira_des
japes146322823_ja_pes
kappas144410363_kappas
knapped16397103knapped
knapper15387153knapper
knappers16315643knappers
lapped114320033_lapped
lapper104319953_lapper
lappers113717463_lappers
lappet103817733_lappet
lappets11329133_lappets
lapses85217693_lapses
maples104819423_maples
mapped134015883_mapped
mapper124516093_mapper
mappers133313783_mappers
napes74828463_na_pes
nappas105511613_nappas
nappe96114993_nappe_
napped114218163_napped
napper103718283_napper
nappers114214863_nappers
nappies114613403_nappies
oraches124216473oraches
oracles93212423oracles
oranges84215333oranges
orates64328613ora_tes
pappies103214833_pappies
pappus9408373_pappus
praises94121103praises
prances113618773prances
prases84429023pra_ses
prates84633163pra_tes
praxes156215183pra_xes
prepped11329903prepped
preppies1149693preppies
propped113311953propped
rabies85226023_rabies
races74943243_ra_ces
ragees74618663_ragees
rages64539443_ra_ges
raises64826543_raises
rajes125022783_ra_jes
rakees104516973_rakees
rakes94440353_ra_kes
rales54947493_ra_les
ralphs1135373_ralphs
ramees84620893_ramees
ramies84630463_ramies
ramped114617903_ramped
ramps96224633_ramp_s
rances84625443_rances
ranees64623963_ranees
ranges73826923_ranges
rape65041633_ra_pe_
raped85334623_ra_ped
raper74932753_ra_per
rapers84327183_rapers
raphe104916423_raphe_
raphis114014323_raphis
rapids94913893_rapids
rapier84019993_rapier
rapiers95012873_rapiers
rapines95120863_rapines
raps66247733_ra_p_s
rares55247443_ra_res
rases55447213_ra_ses
rashes95330153_rashes
rasped94715203_rasped
rasper83917333_rasper
raspers94415923_raspers
rasps74316663_rasp_s
rates55352013_ra_tes
raves85441973_ra_ves
raxes124729393_ra_xes
razees154314763_razees
razes145032703_ra_zes
razzes144910073_razzes
repped114616723_repped
repps95114343_repp_s
rhaphes1534703rhaphes
ripes75435773_r_ipes
ripped114419013_ripped
ripper103518653_ripper
rippers114115033_rippers
ripples113513293_ripples
ropes75940063_r_opes
rupees8312573_rupees
sapped114422013_sapped
sapper103822353_sapper
sappers113518903_sappers
sarapes94617753sarapes
scapes105122263sca_pes
schappes1736043schappes
scrapes116217663scra_pes
scrapies124612483scrapies
scrapped1556533scrapped
scrapper1466973scrapper
scrappers1545863scrappers
scrapples1534803scrapples
serapes95218103sera_pes
shapes115124953sha_pes
shoppes143411403shoppes
slapped123511853slapped
slapper113512473slapper
slappers123710953slappers
snapped124611203snapped
snapper113512073snapper
snappers123510173snappers
stapes85028733sta_pes
staples93617213staples
steppes113110693steppes
strapped1357823strapped
strapper1258093strapper
strappers1346743strappers
swapped15429143swapped
swapper14359703swapper
swappers15358083swappers
tapes75838603_ta_pes
tapped113820053_tapped
tapper104419613_tapper
tappers113416543_tappers
tappet103820113_tappet
tappets113610013_tappets
taupes8212673_taupes
traces85329933tra_ces
trades75724503tra_des
traipse935873traipse
traipses1036873traipses
tramped124312433tramped
tramper113812163tramper
trampers123210393trampers
tramples122610203tramples
tramps105114453tramp_s
trances93919643trances
trapans92812463trapans
trapeses1039153trapeses
trapezes1936543trapezes
trapnest10310923trapnest
trappean1244393trappean
trappose1245813trappose
trappous1246023trappous
traps75727483tra_p_s
trashes104119263trashes
trasses74819323trasses
traves94222743tra_ves
tripes85324873tr_ipes
triples94616873triples
tripped123911693tripped
tripper113711923tripper
trippers123210163trippers
trippet113714113trippet
trippets12357423trippets
trompes114111623trompes
tropes84824353tr_opes
troupes94112853troupes
urares64519093ura_res
urases63723563ura_ses
urates65027763ura_tes
wapped144416473_wapped
whapped18367573whapped
whapper17348273whapper
whappers18276743whappers
wraps105617153wra_p_s
wrasses103812593wrasses
yapped144415143_yapped
yapper133714513_yapper
yappers144012253_yappers
zapped204213523_zapped
zapper193414023_zapper
zappers203911633_zappers

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.450397091.1
2DLD Change Limit1340274397.00319138.5
3Display Results4394390.1562814.1
 (SQL Overall)1786914397.60923484.2
 
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.