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

459 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
prancers12321033(None) 
prancer113613381prancer_
prances113618771prance_s
bracers114616702bra_cers
branders114313092branders
branners104010922branners
cancers114018582_cancers
chancers154313482chancers
dancers103413092_dancers
frankers15348352frankers
glancers11408002glancers
grangers103011972grangers
granters93614132granters
lancers93616642_lancers
pacers105124542p_a_cers
panders103423732p_anders
paniers94717332p_aniers
panners93621272p_anners
panzers184012012p_anzers
pincers113916502p_incers
placers114515262pla_cers
planers94517942plan_ers
planners10399932planners
planters102915322planters
pouncers12349202pouncers
praisers103410832praisers
prance104318572prance__
pranced123714042prance_d
praters94921642pra_ters
prawners1346002prawners
prayers124212852pra_yers
precancers1645252precancers
pricers113915062pr_icers
princes113015142prince_s
princess12266802princess
prinkers143010382prinkers
printers103214902printers
pruners93710722prun_ers
racers84725432_ra_cers
rances84625442_rance_s
ranchers133311792_ranchers
rancors9811372_rancors
rangers83621042_rangers
rankers113217462_rankers
ranters73323642_ranters
tracers94917832tra_cers
trances93919642trance_s
advancers1542983advancers
angers75222543__angers
arrangers1045813arrangers
balancers1345063balancers
banders104324563_banders
bangers104020353_bangers
bankers133919093_bankers
banners94018713_banners
banters94623113_banters
blanchers16307433blanchers
bouncers12309353bouncers
bracer104620583bra_cer_
bracero11428743bra_cero
braceros12397723bra_ceros
braces108427773bra_ce_s
braggers12327903braggers
braiders114110573braiders
branches153613803branches
brander103915823brander_
branner94212373branner_
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
briners94315633brin_ers
bringers112811073bringers
bronzers19296983bronzers
brunchers16296253brunchers
cancels114113313_cancels
cancer104220923_cancer_
caners84629193_can_ers
cankers134418753_cankers
canners93822663_canners
canoers94318373_canoers
canters94827723_canters
chancels15439083chancels
chancer144215633chancer_
chancery18366653chancery
chances145218093chance_s
chancres15429363chancres
changers144313193changers
chanters134016723chanters
clangers114312343clangers
crabbers14358743crabbers
crackers164111723crackers
cradlers11309183cradlers
crafters13419943crafters
crammers14369343crammers
cranches153114543cranches
cranes84330753cran_e_s
cranker133612783cranker_
crappers144011023crappers
crashers134013223crashers
craters95021883cra_ters
cravers124416543cra_vers
crawlers13309003crawlers
cringers112511873cringers
crunchers16316243crunchers
dancer94817613_dancer_
dances95120653_dance_s
danders93921183_danders
dangers94818213_dangers
darners83815773darn_ers
derangers1136703derangers
drafters12338523drafters
draggers11357383draggers
drainers92811253drainers
drapers105313353dra_pers
drawers113610073dra_wers
drawlers12307313drawlers
drenchers15296103drenchers
drinkers13277823drinkers
droners84114383dron_ers
durances1158683durance_s
earners74016453earn_ers
enhancers1445103enhancers
erasers74413943era_sers
facers115519443_fa_cers
fanciers13358083_fanciers
fanners103914653_fanners
farcers124713443_farcers
fencers123810623_fencers
fiancees1335103fiancees
fiances12310673fiance_s
flangers123311373flangers
flankers15349303flankers
framers125113823fra_mers
francs114112193franc__s
franker143510183franker_
fraters103517203fra_ters
ganders93521703_ganders
gangers94418603_gangers
garners83815983garn_ers
glancer103710073glancer_
glances104113143glance_s
glanders103811503glanders
grabbers13337883grabbers
graces94523493gra_ce_s
graders94715993gra_ders
grafters12409183grafters
grainers93012073grainers
grandees103211283grandees
grander93315873grander_
grandeurs11335103grandeurs
granger93514213granger_
granges93516523grange_s
grantees92510973grantees
granter84117133granter_
grantors93810353grantors
graspers11338393graspers
graters85419733gra_ters
gravers114515263gra_vers
grazers175112443gra_zers
graziers18387123graziers
grinders103410423grinders
grinners9288043grinners
groaners9248493groan_ers
grocers103511253gr_ocers
grungers10298503grungers
grunters9359023grunters
hances115621283_hance_s
handers114224333_handers
hangers113120813_hangers
hankers144218133_hankers
ironers74813543iron_ers
kraters114212333kra_ters
lacers85225253_la_cers
lancer84319973_lancer_
lances84824103_lance_s
lancets93411163_lancets
lanciers10308543_lanciers
landers84026213_landers
lanners73618323_lanners
leaners73718173lean_ers
loaners73913623loan_ers
macers105321273_ma_cers
mangers103521263_mangers
manners93417833_manners
meanders1168833meanders
meaners94415243mean_ers
menacers12279303menacers
mincers113714843_mincers
moaners92813553moan_ers
nances83618643_nance_s
nuances938523nuance_s
orangery12305543orangery
oranges84215333orange_s
pacer96131613p_a_cer_
paces96741113p_a_ce_s
packers153818893p_ackers
padders113312873p_adders
pagers94423253p_a_gers
painters103013023painters
palmers113513623p_almers
palters94021683p_alters
pampers133615933p_ampers
panaceas1236763p_anaceas
pancreas1235393p_ancreas
pander93725523p_ander_
panels84716523p_an_els
panes76148693p_an_e_s
pangens103112063p_angens
panier84425503p_anier_
panner84224763p_anner_
pannes85522853p_anne_s
panniers10488853panniers
panthers13510783p_anthers
panzer174213233p_anzer_
papers105125323p_a_pers
paraders113113113paraders
paranoeas1147513paranoeas
parcels113712663p_arcels
pardners11269193pardners
parers85530743p_a_rers
parkers133816873p_arkers
parlances1348943parlance_s
parriers103612903parriers
parsers94118153p_arsers
partiers103514243partiers
partners102711133partners
partyers13277763partyers
passers94717753p_assers
pasters94531733p_asters
patchers153413303p_atchers
paters84935823p_a_ters
patters94825193p_atters
patzers184210573p_atzers
paupers114311073p_aupers
pausers94113223p_ausers
pavers115021823p_a_vers
pawers114818783p_a_wers
pawners124311073p_awners
payers114621823p_a_yers
peaces106324083pea_ce_s
peachers153213843peachers
pearlers1039023pearlers
penances12312443penance_s
pencels113610053p_encels
penners93414183p_enners
piaffers16114203piaffers
piasters102912803piasters
piecers114112253p_iecers
piercers12316723piercers
pincer104019173p_incer_
pinchers153510613p_inchers
pinders103720473p_inders
pingers104020733p_ingers
pinkers134118603p_inkers
pinners93518593p_inners
pioneers1035853pioneers
placer105117743pla_cer_
places104323703pla_ce_s
placets113911223pla_cets
plaguers11286503plaguers
plaices11411143plaice_s
plaiters103512633plaiters
planches153111863planches
planchets16236743planchets
planer84122653plan_er_
planes85028083plan_e_s
planets93914083plan_ets
plankters1544583plankters
planless1036813planless
planner93511623planner_
planter94017803planter_
plashers133813453plashers
plasters103518133plasters
platers93924083pla_ters
platters103415283platters
players124313763pla_yers
plinkers14309393plinkers
plunders11329823plunders
plungers11379393plungers
plunkers14328323plunkers
poachers152910763poachers
pointers103013723pointers
policers12259993policers
pomanders1436223pomanders
ponces104720843p_once_s
ponders103618843p_onders
portances1349833portance_s
pouncer113511233pouncer_
pounces114113893pounce_s
pounders113113263pounders
practicers1663593practicers
praetors1039833praetors
praiser93413943praiser_
praises94121103praise_s
prancing132612163prancing
pranged114512553prange_d
prangs94816233pran__gs
pranked143712093pranke_d
pranks124814723pran__ks
pranksters1653283pranksters
prases84429023pra_se_s
prater84825353pra_ter_
prates84633163pra_te_s
prattlers11195323prattlers
prawner1246803prawner_
praxes156215183pra_xe_s
prayer114815293pra_yer_
preachers16339573preachers
prealters1147773prealters
preavers13910263preavers
precancels1644063precancels
precancer1547083precancer_
precess11310863pr_ecess
preeners102712813preeners
prefacers1636293prefacers
prefers123713333pr_efers
preggers12236833preggers
premiers122911653premiers
pressers103215023pressers
presters103419003presters
preyers124412363pr_eyers
pricer103918293pr_icer_
prices104524543pr_ice_s
prickers163710673prickers
priers84521193pr__iers
primers114215673pr_imers
prince104114763prince__
princely1545143princely
princesse13264403princesse
prinker133412743prinker_
printer93917303printer_
printery13318433printery
prizers183911843pr_izers
probers113514573pr_obers
process11310403pr_ocess
prodders1237453prodders
producers1454883producers
profaners14256203profan_ers
proffers16126593proffers
proggers12258163proggers
proofers13118363proofers
propers113619033pr_opers
prosers94219643pr_osers
prospers123012253prospers
provers123817793pr_overs
prowlers13328933prowlers
pruner83413453prun_er_
prunes83419063prun_e_s
pryers115012243pr__yers
psalters10227713psalters
pumicers1434353pumicers
punchers152610073p_unchers
punkers133714853p_unkers
punners94114233p_unners
punters93617033p_unters
racer75233023_ra_cer_
races74943243_ra_ce_s
rackers134320453_rackers
rafters103715633_rafters
raiders84615143_raiders
railers74420663_railers
raisers73617393_raisers
rakers104123573_ra_kers
rammers113715043_rammers
rance75028513_rance__
rancher123013633_rancher_
ranchero13277423_ranchero
rancheros14255793_rancheros
ranches123620113_ranches
ranchos123911393_ranchos
rancor8810373_rancor_
rancours1076703_rancours
ranees64623963_ran_ees
ranger73925523_ranger_
ranges73826923_range_s
ranker105021903_ranker_
ranter63826823_ranter_
rapers84327183_ra_pers
rapiers95012873_rapiers
rappers113618443_rappers
rasers64526783_ra_sers
rashers104020903_rashers
raspers94415913_raspers
rasters74629023_rasters
raters63936573_ra_ters
ratters74422473_ratters
ravers94628183_ra_vers
razers154919613_ra_zers
renders83821673_renders
renters74224813_renters
ricers84120993_r_icers
ringers83922943_ringers
rinsers73815743_rinsers
romancers1345713romancers
runners74212453_runners
sanders84025943_sanders
sangers84421943_sangers
saucers93712133_saucers
scanners10379703scanners
seances93015343seance_s
skankers11316483skankers
slanders94014013slanders
spacers113813873spa_cers
spancels1245273spancels
spankers14369863spankers
spanners103710773spanners
spencers12269193spencers
sprawlers1433893sprawlers
sprayers13367053spra_yers
springers12309983springers
sprinters11329363sprinters
stances93715963stance_s
stanchers14206803stanchers
standers93514303standers
stranders10389923stranders
strangers104112153strangers
tankers113416913_tankers
tanners74018393_tanners
thankers15297833thankers
tracer84820233tra_cer_
tracery12399793tra_cery
traces85329933tra_ce_s
trackers143512843trackers
traders84316943tra_ders
traducers1243713traducers
trailers82912913trailers
trainers83114633trainers
tramcars1245223tramcars
trampers123210373trampers
trance84718763trance__
tranced104414173trance_d
tranches132915513tranches
transfers1238043transfers
trappers123711023trappers
trashers113013623trashers
trawlers113310193trawlers
trenchers14288073trenchers
trouncers1134793trouncers
twangers12226063twangers
uplanders1234853uplanders
upraisers11174423upraisers
usances967373usance_s
vanners103612843_vanners
wanders114221333_wanders
wankers144514713_wankers
wanters104420093_wanters
warners103315563warn_ers
weaners104613833wean_ers
wincers123415363_wincers
wranglers1344273wranglers
wrappers15306933wrappers
wrenchers17256333wrenchers
wringers123110073wringers
wrongers12327773wrongers
yarners104312203yarn_ers
zanders173015793_zanders

Search took 9 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 Limit1461624598.53017135.1
3Display Results4594590.1902415.8
 (SQL Overall)1786914598.87620131.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.