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

473 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
planners1039993(None) 
lanners73618331_lanners
panners93621271p_anners
planers94517941pla_ners
planner93511621planner_
planters102915321planters
banners94018712_banners
branners104010922branners
canners93822662_canners
clangers114312342clangers
fanners103914652_fanners
flangers123311372flangers
flankers15349302flankers
flannels1134842flannels
glancers11408002glancers
glanders103811502glanders
lancers93616642_lancers
landers84026212_landers
lanner64920602_lanner_
manners93417832_manners
panders103423732p_anders
paniers94717332p_aniers
panner84224762p_anner_
pannes85522852p_anne_s
panniers10488852p_anniers
panzers184012012p_anzers
pawners124311072p_awners
penners93414182p_enners
pinners93518602p_inners
placers114515262pla_cers
plaguers11286502plaguers
plainer93811982plainer_
plainness1155182plainness
plaiters103512632plaiters
planeness1138152planeness
planer84122652pla_ner_
planes85028082pla_ne_s
planets93914082pla_nets
plankters1544582plankters
planless1036812planless
planned103810152planne_d
planter94017802planter_
plashers133813452plashers
plasters103518132plasters
platers93924092pla_ters
platters103415282platters
players124313762pla_yers
plinkers14309392plinkers
plunders11329832plunders
plungers11379402plungers
plunkers14328332plunkers
prancers123210332prancers
prawners1346002prawners
punners94114232p_unners
scanners10379702scanners
slanders94014012slanders
spanners103710772spanners
tanners74018392_tanners
uplanders1234852uplanders
vanners103612842_vanners
aginners954623aginners
alanines8314803alanine_s
alieners889823alieners
aligners9117573aligners
aliners74717723al_iners
almners9399563al_mners
almoners1068133almoners
angers75222543__angers
balancers1345063balancers
banders104324563_banders
bangers104020353_bangers
bankers133919093_bankers
banner84421503_banner_
bannets94013843_bannets
banters94623113_banters
bilanders1235963bilanders
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bla_ders
blamers115314213bla_mers
blanchers16307433blanchers
blander103715163blander_
blandness1235973blandness
blanker134612023blanker_
blankets14356503blankets
blankness1544673blankness
blarneys13183193blarneys
blasters104116143blasters
blathers134713793blathers
blatters104414093blatters
blazers184811683bla_zers
blazoners2043863blazoners
blenders115210993blenders
blinders113911143blinders
blinkers14388503blinkers
blunders113911343blunders
blungers11469843blungers
branders114313093branders
branner94212373branner_
cancers114018583_cancers
caners84629203_ca_ners
cankers134418753_cankers
cannels93413363_cannels
canner84625983_canner_
cannery123610013_cannery
canoers94318373_canoers
canters94827733_canters
chancers154313493chancers
changers144313203changers
channels13388493channels
chanters134016743chanters
clabbers14359903clabbers
clackers163911703clackers
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clampers143211893clampers
clanger104113493clanger_
clangors11417003clangors
clappers143310833clappers
claquers19226203claquers
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
claviers1367103claviers
clawers123910973cla_wers
cleaners103610543cleaners
cleanness1144973cleanness
cleansers11335073cleansers
clingers113810663clingers
clinkers14339833clinkers
cloners94514823cl_oners
clunkers14327553clunkers
colanders1238013colanders
conners94023113_conners
cunners93913473_cunners
damners104112113_damners
dancers103413093_dancers
danders93921183_danders
dangers94818213_dangers
darners83815773_darners
dinners83915443_dinners
drainers92811253drainers
earners74016453_earners
elaters74420193ela_ters
eloiners8128153eloiners
explainers1943113explainers
fanner94218183_fanner_
fawners13388493_fawners
flaggers13328073flaggers
flakers143613273fla_kers
flamers124616363fla_mers
flanes94522423fla_ne_s
flaneurs1133953flaneurs
flanger113412623flanger_
flanges113413273flange_s
flanker143911293flanker_
flannel1035423flanne_l
flappers15388383flappers
flashers143912653flashers
flatness1138153flatness
flatters113814203flatters
flaunters1234513flaunters
flayers133912033fla_yers
flensers1135463flensers
flinders12439263flinders
flingers123410193flingers
flunkers15347533flunkers
frankers15348353frankers
gainers84214593_gainers
ganders93521703_ganders
gangers94418603_gangers
gannets83811443_gannets
garners83815983_garners
ginners84314223_ginners
glaciers11277903glaciers
gladness1036153gladness
glancer103710073glancer_
glances104113143glance_s
glandes95413833glande_s
glazers174410043gla_zers
glaziers18406563glaziers
gleaners9348073gleaners
grainers93012073grainers
grangers103011973grangers
granters93614143granters
grinners9288043grinners
gunners83111733_gunners
handers114224333_handers
hangers113120813_hangers
hankers144218133_hankers
implanters1484153implanters
inlanders1036143inlanders
inners63919353__inners
islanders1035283islanders
japanners1842813japanners
joannes1436243joanne_s
laagers83411253_laagers
lacers85225253_la_cers
lackers134120543_lackers
ladders94115173_ladders
laders74927763_la_ders
ladlers84613573_ladlers
lagers74826143_la_gers
laggers94216243_laggers
lakers105225153_la_kers
lambers113817113_lambers
lampers113817333_lampers
lancer84319973_lancer_
lances84824103_lance_s
lancets93411163_lancets
lanciers10308543_lanciers
lander74028483_lander_
landlers94312833_landlers
lanes54946793_la_ne_s
langurs889103_langurs
lanker104123003_lanker_
lankness12237043_lankness
lanneret82512363_lanneret
lannerets9225483_lannerets
lantern7310013_lantern
lanterns838303_lanterns
lappers113717463_lappers
lapsers93911053_lapsers
larders83516943_larders
larkers113014513_larkers
lasers64925703_la_sers
lashers104121833_lashers
lasters75627693_lasters
lathers104321883_lathers
lauders84012893_lauders
launders9358743_launders
laveers10329363_laveers
lavers94526363_la_vers
lawyers13377153_lawyers
laxness1436043_laxness
layers93921183_la_yers
leaners73718173_leaners
leanness837373leanness
learners8398153learners
lenders84419643_lenders
limners93311563_limners
liners65428853_l_iners
lingers84223303_lingers
linkers114317713_linkers
linnets739833_linnets
linters73822633_linters
loaners73913623_loaners
loners64225813_l_oners
longers84819543_longers
lungers83817093_lungers
lunkers113414603_lunkers
malanders1237023malanders
mangers103521263_mangers
manner84020513_manner_
meanders1168833meanders
meaners94415243mea_ners
meanness1037183meanness
moaners92813553moa_ners
oleanders1035573oleanders
pacers105124543p_a_cers
packers153818893p_ackers
padders113312873p_adders
pagers94423253p_a_gers
painters103013023painters
palavers1337993palavers
paleness10312983paleness
palmers113513623p_almers
palters94021683p_alters
pampers133615933p_ampers
pander93725523p_ander_
panels84716523p_a_nels
panes76148693p_a_ne_s
pangens103112063p_angens
panier84425503p_anier_
panne76623653p_anne__
panned94123433p_anne_d
pannier93613353p_annier_
panthers13510783p_anthers
panzer174213233p_anzer_
papers105125323p_a_pers
pardners11269193pardners
parers85530743p_a_rers
parkers133816873p_arkers
parsers94118153p_arsers
partners102711133partners
passers94717753p_assers
pasters94531733p_asters
paters84935833p_a_ters
patness92912283p_atness
patters94825193p_atters
patzers184210573p_atzers
paupers114311073p_aupers
pausers94113223p_ausers
pavers115021823p_a_vers
pawers114818783p_a_wers
pawnees12298173p_awnees
pawner114212923p_awner_
pawnors12297203p_awnors
payers114621823p_a_yers
peachers153213843peachers
pearlers1039033pearlers
penner84616663p_enner_
phalangers1673763phalangers
philanders1644273philanders
piaffers16114203piaffers
piasters102912813piasters
pilasters1138223pilasters
pilseners1144943pilseners
pilsners1035533pilsners
pincers113916503p_incers
pinders103720473p_inders
pingers104020743p_ingers
pinkers134118603p_inkers
pinner84521503p_inner_
pioneers1035863pioneers
placaters1336473placaters
placer105117743pla_cer_
places104323703pla_ce_s
placets113911223pla_cets
plackets1646583plackets
plages94520153pla_ge_s
plaguer10328273plaguer_
plagues103311063plague_s
plaices11411143plaice_s
plained103812233plaine_d
plainest10313613plainest
plains85019593plain__s
plaints94012053plain_ts
plaisters1137813plaisters
plaiter93615393plaiter_
planar84212713pla_nar_
planches153111863planches
planchets16236743planchets
plane74929143pla_ne__
planed94420913pla_ne_d
planet84228353pla_ne_t
planform1544753planform
planforms1643723planforms
plangent1138803plangent
planishers1584773planishers
planked143512283planke_d
planks124116753pla_n_ks
plankter1435363plankter_
planning113610223planning
plannings12325453plannings
plans75731273pla_n__s
plantar9369993plantar_
planted103516123plante_d
plantlets1145013plantlets
plants84921803pla_n_ts
plaques18317893plaque_s
plasher124215033plasher_
plashes124417393plashe_s
plaster93318693plaster_
plastery13279703plastery
platanes102711883platane_s
platens94213983pla_tens
plater84427693pla_ter_
plates85432243pla_te_s
platier93716293platier_
platies93722543platie_s
platter93917413platter_
player115215213pla_yer_
playgoers1543193playgoers
playless1334863playless
playlets1334903playlets
playpens1534073playpens
pleaders113210183pleaders
pleasers104010293pleasers
pleaters103613793pleaters
pleathers1446453pleathers
pledgers12387643pledgers
pliantness1263643pliantness
pliers84715153pl__iers
plinker134010963plinker_
plodders1235523plodders
plotters104011553plotters
plovers123611833pl_overs
plowers123812243pl_owers
pluckers16316553pluckers
pluggers12297023pluggers
plumbers14418513plumbers
plumpers14357293plumpers
plunder103810503plunder_
plunger104211243plunger_
plunges104011613plunge_s
plunker133910653plunker_
plyers114912983pl__yers
poachers152910763poachers
pointers103013723pointers
pomanders1436223pomanders
ponders103618843p_onders
pouncers12349203pouncers
pounders113113283pounders
praisers103410833praisers
prancer113613383prancer_
prances113618773prance_s
praters94921653pra_ters
prawner1246803prawner_
prayers124212853pra_yers
preeners102712813preeners
prinkers143010383prinkers
printers103214903printers
pruners93710723p_runers
psalters10227713psalters
punkers133714853p_unkers
punner84918153p_unner_
punnets9409263p_unnets
punters93617043p_unters
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
runners74212453_runners
sanders84025943_sanders
sangers84421943_sangers
scanner94411813scanner_
scunners10357303scunners
shunners11317743shunners
sinners74019023_sinners
skankers11316483skankers
skinners12347293skinners
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slander84015443slander_
slappers123710953slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slingers93712683slingers
solanders1036963solanders
spankers14369863spankers
spanner94312563spanner_
spawners13396493spawners
spinners103810863spinners
splashers1445283splashers
splatters11327543splatters
splinters11277923splinters
stainers83212173stainers
standers93514303standers
stunners8277923stunners
swannery1433553swannery
tankers113416913_tankers
tanner63722283_tanner_
tannery10388663_tannery
tenners74014923_tenners
thankers15297833thankers
thinners11327753thinners
tinners73717313_tinners
tonners73816403_tonners
trainers83114643trainers
twangers12226063twangers
uplander1145533uplander_
vanner94215843_vanner_
wanders114221333_wanders
wankers144514713_wankers
wanner94019623_wanner_
wanness102610683_wanness
wanters104420093_wanters
warners103315563_warners
weaners104613833wea_ners
winners104316913_winners
wonners104312813_wonners
yarners104312203_yarners
yawners13367183_yawners
yearners11346373yearners
zanders173015793_zanders

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.420425454.8
2DLD Change Limit1461624736.98320931.1
3Display Results4734730.1902489.5
 (SQL Overall)1786914737.59323533.6
 
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.